Post Description

0101 - Welcome
0102 - Course Overview
0103 - Understanding SQL
0104 - Understanding TSQL
0105 - SQL Server History
0106 - Microsoft SQL Server Certifications
0201 - SQL Server 2012 Enhancements
0202 - Availability Enhancements
0203 - Manageability Enhancements
0204 - Programmability Enhancements
0205 - Scalability and Performance Enhancements
0206 - Security Enhancements
0301 - SQL Server 2012 Editions
0302 - Licensing for 2012
0303 - Hardware Requirements
0304 - Software Requirements
0305 - Installation Options pt. 1
0306 - Installation Options pt. 2
0307 - What Was Left Behind 
0401 - SQL Server Services
0402 - SQL Reporting Services
0403 - SQL Server Integration Services
0404 - SQL Server Analysis Services
0405 - Installing SQL Server 2012
0406 - Validate a SQL Server Installation pt. 1
0407 - Validate a SQL Server Installation pt. 2
0408 - Uninstalling SQL Server
0409 - SQL Server Instances
0410 - SQL Server Configuration Manager
0411 - SQL Server Service Accounts
0412 - Attaching Adventureworks Sample DB
0413 - Database Diagrams
0501 - Understanding Databases
0502 - Understanding Tables
0503 - Understanding Primary Keys
0504 - Understanding Data Types pt. 1
0505 - Understanding Data Types pt. 2
0506 - Understanding Normalization
0507 - Creating a Database
0508 - Database Types
0509 - System Databases pt. 1
0510 - System Databases pt. 2
0511 - Resource Database
0512 - Database Files
0513 - Understanding Transaction Logs
0514 - Understanding Schemas
0515 - Understanding Synonyms
0601 - SSMS or TSQL
0602 - Table Change Gotcha
0603 - Using MMC Snap-Ins
0604 - Graphical Queries
0605 - Authentication Modes
0606 - Understanding Linked Servers
0607 - Hiding System Objects
0701 - SQL Server Agent
0702 - Configuring SQL Server Agent
0703 - Understanding Automated Administration
0704 - Understanding Jobs
0705 - Understanding Schedules
0706 - Understanding Operators
0707 - Understanding Alerts
0708 - Multiserver Administration
0709 - Using the Maintenance Plan Wizard
0710 - Using Maintenance Plan Design
0801 - Understanding Indexes
0802 - Clustered Indexes
0803 - Non-Clustered Indexes
0804 - New Index Features in 2012
0805 - What Should Be Indexed
0806 - Too Much of a Good Thing
0807 - Database Engine Tuning Advisor
0901 - Monitoring Basics
0902 - Monitoring Events
0903 - Dedicated Administrator Connection
0904 - Using System Monitor
0905 - What to Monitor
0906 - Data Collector
0907 - SQL Server Standard Reports
0908 - SQL Server Best Practice Analyzer
0909 - SQL Server Profiler pt. 1
0910 - SQL Server Profiler pt. 2
0911 - Pages and Extents
0912 - Understanding FillFactor
0913 - Linked Server vs. Openrowset
1001 - Principals and Securables
1002 - Principal and Securable Hierarchy
1003 - Securing SQL Server
1004 - Understanding Permissions
1005 - Understanding Roles
1006 - Fixed Server-Level Roles
1007 - Database Level Roles
1101 - Backup and Recovery Planning
1102 - Understanding Recovery Models
1103 - Performing Backups and Restores
1104 - Availability Options
1201 - Using sqlcmd
1202 - Using PowerShell
1301 - Course Wrap Up
1401 - About the Author