
Microsoft SQL Server 2012 Admin (Exam 70-462)
Microsoft SQL Server 2012 is a cloud-ready information platform that will help organizations unlock breakthrough insights and quickly build solutions to extend data across on-premises and public clouds, backed by mission critical confidence. SQL Server 2012 continues the evolution and maturity of a trusted platform that continuously leads in industry-relevant and real-world application performance benchmarks. It still includes many of the same capabilities and characteristics that administrators have come to trust for over 10 years while also launching some new features that change how databases make data available across the enterprise. In this VTC course, author Mark Long will introduce you to SQL Server 2012 from an administrative viewpoint and helps prepare you for the Microsoft 70-462 Administration certification exam. To begin learning today, simply click on the movie links.
Course content
Introduction6 lessons
Improvements in 20126 lessons
SQL Server 2012 Essentials7 lessons
Installing SQL Server 201213 lessons
- SQL Server Services5:151 credit or ad
- SQL Reporting Services4:241 credit or ad
- SQL Server Integration Services4:151 credit or ad
- SQL Server Analysis Services4:361 credit or ad
- Installing SQL Server 20126:571 credit or ad
- Validate a SQL Server Installation pt. 14:381 credit or ad
- Validate a SQL Server Installation pt. 22:431 credit or ad
- Uninstalling SQL Server4:371 credit or ad
- SQL Server Instances4:211 credit or ad
- SQL Server Configuration Manager4:431 credit or ad
- SQL Server Service Accounts5:151 credit or ad
- Attaching Adventureworks Sample DB4:231 credit or ad
- Database Diagrams5:131 credit or ad
SQL Server Basics15 lessons
- Understanding Databases5:071 credit or ad
- Understanding Tables5:531 credit or ad
- Understanding Primary Keys4:291 credit or ad
- Understanding Data Types pt. 16:391 credit or ad
- Understanding Data Types pt. 27:351 credit or ad
- Understanding Normalization6:581 credit or ad
- Creating a Database6:181 credit or ad
- Database Types6:021 credit or ad
- System Databases pt. 17:081 credit or ad
- System Databases pt. 27:061 credit or ad
- Resource Database4:571 credit or ad
- Database Files4:291 credit or ad
- Understanding Transaction Logs5:311 credit or ad
- Understanding Schemas4:101 credit or ad
- Understanding Synonyms4:051 credit or ad
Managing SQL Server 20127 lessons
Automating SQL Server 201210 lessons
- SQL Server Agent5:541 credit or ad
- Configuring SQL Server Agent5:581 credit or ad
- Understanding Automated Administration4:511 credit or ad
- Understanding Jobs6:211 credit or ad
- Understanding Schedules6:321 credit or ad
- Understanding Operators6:431 credit or ad
- Understanding Alerts7:031 credit or ad
- Multiserver Administration6:391 credit or ad
- Using the Maintenance Plan Wizard6:311 credit or ad
- Using Maintenance Plan Design6:241 credit or ad
Indexes7 lessons
Performance and Monitoring13 lessons
- Monitoring Basics5:351 credit or ad
- Monitoring Events3:101 credit or ad
- Dedicated Administrator Connection5:551 credit or ad
- Using System Monitor5:541 credit or ad
- What to Monitor6:011 credit or ad
- Data Collector6:001 credit or ad
- SQL Server Standard Reports4:291 credit or ad
- SQL Server Best Practice Analyzer3:151 credit or ad
- SQL Server Profiler pt. 13:351 credit or ad
- SQL Server Profiler pt. 26:481 credit or ad
- Pages and Extents5:511 credit or ad
- Understanding FillFactor5:441 credit or ad
- Linked Server vs. Openrowset3:241 credit or ad