Course NT-DepAdmSQL Deployment and administration of the infrastructure of SQL databases

This intensive 5-day course provides learners with the knowledge and skills to deploy a Microsoft SQL Server database server. The course covers the installation of SQL Server - both installing a new version and migrating from an existing one. The course covers topics with the knowledge and skills to administer a SQL Server database infrastructure. The course will also be useful for professionals who develop applications interacting with SQL Server databases.

After completing this course, students will be able to:

• Deploy (install) the database server;
• Update SQL Server;
• Configure SQL Server;
• Manage databases and files;
• Develop recovery models and backup strategies;
• Back up SQL Server databases;
• Restore SQL Server databases;
• Automate database management;
• Configure security for SQL Server Agent;
• Troubleshoot SQL Server infrastructure;
• Import and export data.

Audience Profile

Course audience – specialists who are responsible for the administration and support of the SQL Server database. They either set up and maintain databases as their primary occupation, or work in environments where databases play a key role in their work.

This course will also be of interest to professionals who develop applications that provide content from SQL Server databases.

Before attending this course, students must have:

• basic knowledge of the Microsoft Windows operating system and its main functions.
• practical knowledge of Transact-SQL (preferred);
• practical knowledge of relational databases;
• certain experience in designing databases.