This five-day course provides a comprehensive understanding of SQL Server and its various components. Students will learn about the SQL Server platform, its architecture, and how to configure services, accounts, and networking. The course covers topics such as installation, upgrade strategies, and configuring databases and data files.
Students will gain knowledge about maintaining databases for long-term performance, using techniques like CHECKDB and index rebuilding. The course also delves into optimizing SQL Server performance through storage configuration, including options like fileshares, local storage, and cloud storage, along with the use of SQL Server Stretch Databases.
Additionally, the course explores cloud-based installations of SQL Server using Microsoft Azure, discussing database hosting options and migration. Students will learn how to move databases to Azure SQL Database and utilize Azure Virtual Machines for hosting SQL Server instances.
Students will gain skills in administering databases hosted in Microsoft Azure, including security, Azure Storage setup, and automating administration tasks.
Prerequisites
Basic understanding of relational databases
Basic Windows knowledge
*Course Cost listed does not include the cost of courseware $ 260. Course is subject to a minimum enrollment to run. Course may run virtually as a Virtual Instructor-Led (VILT) class if the minimum enrollment is not met. If the course is under the minimum enrollment the course may run as 4 day class (Bootcamp Style). For more information, please contact learn@vtec.org or call 207-775-0244.