SQL Server 2012 Fundamentals for the Accidental DBA

11/2013
6:52 hours

Lesson 1 SQL Server Overview
1.1 Understanding SQL Server
1.2 SQL Server Uses
Lesson 2 The Tools
2.1 SQL Server Management Studio
2.2 Configuration Manager
2.3 Profiler
2.4 SQL Server Data Tools
Lesson 3 Relational Database Basics
3.1 Tables
3.2 Relationships
Lesson 4 Understanding SQL Server Databases
4.1 Database Files
4.2 Transaction Log
4.3 Understanding System Databases
Lesson 5 Server Configuration
5.1 Basic SQL Server Configuration
Lesson 6 Backing Up SQL Server Database
6.1 Backup Types
6.2 Scheduling Backups
Lesson 7 Restoring SQL Server Databases
7.1 Restore Type
7.2 Restoring System Databases
Lesson 8 Server Security
8.1 Server Security
Lesson 9 Database Security
9.1 Users
9.2 Database Roles
9.3 Ownership Changing
Lesson 10 T-SQL
10.1 Basic Data Manipulation Language
10.2 Basic Data Definition Language
Lesson 11 Advanced Programmability
11.1 Stored Procedures
11.2 Functions
11.3 Views
11.4 Triggers
11.5 CLR Integration
Lesson 12 Indexing
12.1 Index Overview
12.2 Working with Indexes
12.3 Included Columns
Lesson 13 Application Security
13.1 How to Set Up Security
13.2 Understanding Abstraction Layers