SQL Server Administration training begins with an exploration of the SQL Server architecture, this covers various editions of SQL Server, before proceeding to instruction on installation. Students learn the importance of planning and then the mechanics of installing SQL Server, as well as analysis services and PowerPivot for SharePoint. Instructors explain burning in the system, post-install configuration and uninstalling SQL Server. For those considering upgrading to later versions, instructors review best practices: pre-upgrade steps and tools, backward compatibility, SQL Server components considerations and post-upgrade checks.
Students in our SQL Server Administration training course learn how to manage and troubleshoot the database engine. This includes a review of the configuration and administration tools and troubleshooting tools. Instructors describe the management studio and monitoring processes in T-SQL, before moving on to multiserver management, trace flags and getting help from support.
Another important topic in our SQL Server Administration training is automating SQL server. From maintenance plans and automating SQL Server with SQL Server agent to SQL Server agent security and configuring SQL Server agent, students learn every aspect of this important topic.
Change management. Configuring the server for optimal performance and optimizing the server also are covered in Intertech’s SQL Server Administration training. Likewise, students review all aspects of monitoring the SQL Server: choosing the appropriate tools, monitoring events with dynamic views and functions, monitoring logs, and more. They also learn about performance tuning T-SQL and physical query processing.
Indexing the database is another key topic in our SQL Server Administration training. This generally includes noteworthy index-related features in SQL Server, partitioned tables and indexes, index maintenance, improving query performance with indexes, and database tuning advisor. Intertech instructors then move on to replication models and implementation. Clustering SQL Server is given equal time, including such topics as upgrading SQL Server clustering, getting prepared for clustering, clustering Microsoft Distributed Transaction Coordinator, managing and monitoring the cluster and troubleshooting cluster problems.
No SQL Server Administration training would be complete without a thorough overview of backup and recovery. Our course covers types of failures, making plans, backup and restore, preparing for recovery, developing and executing a backup plan, managing backups, backup and restore performance, performing recovery and archiving data.
Likewise, students in our SQL Server Administration training course receive instruction in SQL Server log shipping processes: deployment scenarios, architecture, system requirements, deploying, monitoring and troubleshooting and so on. They also learn the intricacies of database mirroring. As the course progresses, there is a detailed discussion of integration services administration and performance tuning, SQL Server reporting services administration and SharePoint integration. Intertech SQL Server Administration instructors also cover SQL Azure administration and configuration, including administering SQL Azure, working with SQL Azure and what’s missing in SQL Azure.