This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database. Also this course helps you prepare for the Exam 70-462 The Beta version of this course (10775AB) utilizes pre-release software in the virtual machine for the labs. Microsoft SQL Server 2012 Release Candidate 0 (RC0) is used in this course. Some of the exercises in this course are SQL Azure enabled.
Ace your preparation for the skills measured by Exam 70-462—and on the job—with this official Microsoft study guide. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises.
This exam is intended for Database Professionals who perform installation, maintenance, and configuration tasks as their primary areas of responsibility. They will often set up database systems and are responsible for making sure those systems operate efficiently. They also make sure that the data they store is backed up regularly, stored effectively, and that the data is secure from unauthorized access. Primary responsibilities may include but are not limited to: •Audit SQL Server instances. •Back up databases. •Configure additional SQL Server components. •Configure SQL Server instances. •Configure SQL Server services. •Deploy SQL Server. •Implement a migration strategy. •Implement columnstore indexes. •Implement contained databases. •Implement HADR (High-Availability and Disaster Recovery solution). •Import and export data. •Install SQL Server and related services. •Maintain a database. •Maintain indexes. •Manage and configure databases. •Manage data partitions. •Manage database permissions. •Manage database snapshots. •Manage logins and server roles. •Manage SQL Server Agent alerts. •Manage SQL Server Agent jobs. •Manage SQL Server Agent operators. •Manage SQL Server instances. •Manage users and database roles. •Manage, create, and design log files. •Optimize queries. •Plan installation. •Restore databases. •Troubleshoot security
Saving please wait...