SQL Server 2012 Database Administration (70-462) Part 3
Pluralsight
Course Summary
Part 3 of 3 in the SQL Server 2012 Database Administration (70-462) series. This SQL Server 2012 administration course covers how to configure and maintain an enterprise data management system.
-
+
Course Description
Part 3 of 3 in the SQL Server 2012 Database Administration (70-462) series. This SQL Server 2012 administration course covers how to configure and maintain an enterprise data management system. You'll learn SQL profiler, SQL server agent, basic high availability principles, and proper management of data and log files. If you're new to SQL Server administration, you'll benefit from this introduction as it introduces you to a broad range of topics.
-
+
Course Syllabus
Backup Basics- 27m 31s
—Introduction 2m 35s
—Full Backups 9m 59s
—Log Backups 3m 59s
—Differential Backups 3m 5s
—Filegroup Backups 2m 17s
—System Backups 5m 36sRestore Basics- 32m 49s
—Introduction 1m 5s
—Simple Full Restore 3m 50s
—Restore with Move 4m 58s
—Restore Under Different Name 5m 28s
—Restoring Logs 16m 2s
—Restore Differentials 1m 26sIndexes- 35m 16sBasic Execution Plans- 29m 42sQuery Tuning- 17m 59sSQL Server Agent- 27m 30sDatabase Mail- 22m 58sImporting and Exporting Data- 25m 22sHigh Availability Basics- 35m 35sPowerShell- 37m 17s