This Jump Start helps current and aspiring data professionals understand the process of administering SQL Server 2012 databases. It helps you prepare for Exam 70-462, a component of the MCSA: SQL Server certification, and it is the prerequisite for the Implementing a Data Warehouse with SQL Server Jump Start course. These SQL Server 2012 training videos focus on security, data management, and disaster recovery/high availability, along with their implications for the configuration of the enterprise. The course includes demos on storage design and capacity configuration, security configuration, optimization of the instance, and automation.Instructors | Rich Currey - Microsoft Certified Trainer; George Squillace - Microsoft Certified TrainerAssociated Exam(s) | 70-462: Administering Microsoft SQL Server 2012 Databases Related Certification | MCSA: SQL Server
This module discusses issues and the major decisions involved in installing and initially configuring SQL Server. The information provided will help you to avoid making mistakes that are difficult to reverse and could require reinstallation.
In this module you will learn about some of the frequently used instance-level and database-level options. Implementing the primary automation features of jobs and alerts is discussed and demonstrated thoroughly.
SQL Servers operate in a dynamic environment; conditions change moment by moment. This module discusses and demonstrates primary diagnostic and performance enhancement tools such as the Profiler, the Database Engine Tuning Advisor, the Management Data Warehouse, and Catalog and Dynamic Management Views.
Protection and stewardship of data is one of the database administrator’s first orders of business. In this module you’ll gain an understanding of tasks and strategies that are related to backup and restore operations and investigating database integrity with DBCC commands. Maintenance of indexes, which are vitally important to the performance of queries, will also be discussed and demonstrated.
“When in doubt, it’s my fault” is what the DBA must live by, and this is definitely true regarding the stewardship of security. Instance, database, and object security strategies are examined as well as the implementation of logins and server roles, user and database roles, and leveraging schema objects.
Some of the planet’s heaviest database workloads sit on SQL Server, and the loss of availability could be catastrophic. SQL Server offers a number of high availability technologies that can be used alone, or in some cases, together. The high availability technologies of failover clustering, replication, log shipping, database mirroring, and AlwaysOn are examined and compared.
Please peruse this section for additional information that supports this Jump Start event. This is an opportunity for you to dive deeper into Administering Microsoft SQL Server 2012 at your own pace.