O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft SQL Server 2012 Admin (Exam 70-462)

Video Description

This Course can only be played using a subscription. You can play only first 3 chapters for free. Click Here to avail a subscription 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.

Table of Contents

  1. Introduction
    1. Welcome 00:01:23
    2. Course Overview 00:04:14
    3. Understanding SQL 00:04:01
    4. Understanding TSQL 00:04:25
    5. SQL Server History 00:05:48
    6. Microsoft SQL Server Certifications 00:04:09
  2. Improvements in 2012
    1. SQL Server 2012 Enhancements 00:05:17
    2. Availability Enhancements 00:06:00
    3. Manageability Enhancements 00:05:26
    4. Programmability Enhancements 00:04:16
    5. Scalability and Performance Enhancements 00:05:11
    6. Security Enhancements 00:06:35
  3. SQL Server 2012 Essentials
    1. SQL Server 2012 Editions 00:04:53
    2. Licensing for 2012 00:04:04
    3. Hardware Requirements 00:05:08
    4. Software Requirements 00:04:07
    5. Installation Options pt. 1 00:05:53
    6. Installation Options pt. 2 00:04:38
    7. What Was Left Behind? 00:04:09
  4. Installing SQL Server 2012
    1. SQL Server Services 00:05:15
    2. SQL Reporting Services 00:04:24
    3. SQL Server Integration Services 00:04:15
    4. SQL Server Analysis Services 00:04:36
    5. Installing SQL Server 2012 00:06:57
    6. Validate a SQL Server Installation pt. 1 00:04:38
    7. Validate a SQL Server Installation pt. 2 00:02:43
    8. Uninstalling SQL Server 00:04:37
    9. SQL Server Instances 00:04:21
    10. SQL Server Configuration Manager 00:04:43
    11. SQL Server Service Accounts 00:05:15
    12. Attaching Adventureworks Sample DB 00:04:23
    13. Database Diagrams 00:05:13
  5. SQL Server Basics
    1. Understanding Databases 00:05:07
    2. Understanding Tables 00:05:53
    3. Understanding Primary Keys 00:04:29
    4. Understanding Data Types pt. 1 00:06:39
    5. Understanding Data Types pt. 2 00:07:35
    6. Understanding Normalization 00:06:58
    7. Creating a Database 00:06:18
    8. Database Types 00:06:02
    9. System Databases pt. 1 00:07:08
    10. System Databases pt. 2 00:07:06
    11. Resource Database 00:04:57
    12. Database Files 00:04:29
    13. Understanding Transaction Logs 00:05:31
    14. Understanding Schemas 00:04:10
    15. Understanding Synonyms 00:04:05
  6. Managing SQL Server 2012
    1. SSMS or TSQL 00:06:50
    2. Table Change Gotcha 00:02:52
    3. Using MMC Snap-Ins 00:05:27
    4. Graphical Queries 00:06:41
    5. Authentication Modes 00:06:12
    6. Understanding Linked Servers 00:06:35
    7. Hiding System Objects 00:03:21
  7. Automating SQL Server 2012
    1. SQL Server Agent 00:05:54
    2. Configuring SQL Server Agent 00:05:58
    3. Understanding Automated Administration 00:04:51
    4. Understanding Jobs 00:06:21
    5. Understanding Schedules 00:06:32
    6. Understanding Operators 00:06:43
    7. Understanding Alerts 00:07:03
    8. Multiserver Administration 00:06:39
    9. Using the Maintenance Plan Wizard 00:06:31
    10. Using Maintenance Plan Design 00:06:24
  8. Indexes
    1. Understanding Indexes 00:05:09
    2. Clustered Indexes 00:05:56
    3. Non-Clustered Indexes 00:05:04
    4. New Index Features in 2012 00:06:17
    5. What Should Be Indexed 00:06:10
    6. Too Much of a Good Thing 00:07:38
    7. Database Engine Tuning Advisor 00:04:28
  9. Performance and Monitoring
    1. Monitoring Basics 00:05:35
    2. Monitoring Events 00:03:10
    3. Dedicated Administrator Connection 00:05:55
    4. Using System Monitor 00:05:54
    5. What to Monitor 00:06:01
    6. Data Collector 00:06:00
    7. SQL Server Standard Reports 00:04:29
    8. SQL Server Best Practice Analyzer 00:03:15
    9. SQL Server Profiler pt. 1 00:03:35
    10. SQL Server Profiler pt. 2 00:06:48
    11. Pages and Extents 00:05:51
    12. Understanding FillFactor 00:05:44
    13. Linked Server vs. Openrowset 00:03:24
  10. SQL Server Security
    1. Principals and Securables 00:04:08
    2. Principal and Securable Hierarchy 00:03:35
    3. Securing SQL Server 00:06:29
    4. Understanding Permissions 00:03:53
    5. Understanding Roles 00:05:17
    6. Fixed Server-Level Roles 00:03:25
    7. Database Level Roles 00:03:18
  11. Backup / Recovery / Availability
    1. Backup and Recovery Planning 00:06:30
    2. Understanding Recovery Models 00:06:24
    3. Performing Backups and Restores 00:06:29
    4. Availability Options 00:06:50
  12. Scripting SQL Server 2012
    1. Using sqlcmd 00:04:13
    2. Using PowerShell 00:02:53
  13. Conclusion
    1. Course Wrap Up 00:03:42
    2. About the Author 00:02:39