However, if you are going to go for the official Microsoft exam, the equivalent knowledge as per my first two courses in 70-461 T-SQL is essential.Īt the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and continue your preparations for the official Microsoft certifications. No knowledge of T-SQL is required, as I’ll demonstrate everything I can through the GUI (Graphical User Interface) as well as T-SQL. The course will take around 10 hours to complete, but completing this will enable you to versed in Database Administration tasks, giving you hands-on experience. We’ll look at managing SQL Server Agent, so you can automate routine tasks, and also be alerted to problems, we’ll manage and configure databases, and look at compression, both of which aids with administrating big databases.
We’ll manage logins and server roles, so you can control who gets access to what data, implement and maintain indexes, so you can speed up searches, and import and export data.
We’ll start by downloading a demonstration database, and learning how to backup and restore this database, and what recovery models are appropriate for other databases, to enable you to offer Point in Time recovery.
We’ll download and install for free SQL Server Developer, which gives you all of the capabilities of the full-cost Enterprise edition (though without being able to use it for commercial purposes). SQL Server is one of the main database tools that is requested in the job market, and the ability to being able to do DBA for SQL Server could be very useful for your current work, and your next job hunt. In this course, learn some of the skills that Microsoft want you to know, and add another tool to your CV or resume, and even go for the official Microsoft certification.