Books & Videos

Table of Contents

Chapter: Introduction

Introduction to SQL Server 2012 Fundamentals for the Accidental DBA LiveLessons

05m 8s

Chapter: Lesson 1 SQL Server Overview

Learning objectives

00m 37s

1.1 Understanding SQL Server

08m 45s

1.2 SQL Server Uses

05m 7s

Chapter: Lesson 2 The Tools

Learning objectives

00m 32s

2.1 SQL Server Management Studio

09m 55s

2.2 Configuration Manager

11m 53s

2.3 Profiler

12m 31s

2.4 SQL Server Data Tools

06m 35s

Chapter: Lesson 3 Relational Database Basics

Learning objectives

00m 42s

3.1 Tables

15m 29s

3.2 Relationships

19m 8s

Chapter: Lesson 4 Understanding SQL Server Databases

Learning objectives

00m 35s

4.1 Database Files

14m 50s

4.2 Transaction Log

11m 2s

4.3 Understanding System Databases

11m 37s

Chapter: Lesson 5 Server Configuration

Learning objectives

00m 42s

5.1 Basic SQL Server Configuration

10m 9s

Chapter: Lesson 6 Backing Up SQL Server Database

Learning objectives

00m 44s

6.1 Backup Types

20m 18s

6.2 Scheduling Backups

17m 48s

Chapter: Lesson 7 Restoring SQL Server Databases

Learning objectives

00m 28s

7.1 Restore Type

14m 28s

7.2 Restoring System Databases

11m 42s

Chapter: Lesson 8 Server Security

Learning objectives

00m 38s

8.1 Server Security

11m 42s

Chapter: Lesson 9 Database Security

Learning objectives

00m 54s

9.1 Users

07m 7s

9.2 Database Roles

09m 34s

9.3 Ownership Changing

18m 42s

Chapter: Lesson 10 T-SQL

Learning objectives

00m 40s

10.1 Basic Data Manipulation Language

23m 2s

10.2 Basic Data Definition Language

13m 33s

Chapter: Lesson 11 Advanced Programmability

Learning objectives

00m 39s

11.1 Stored Procedures

11m 11s

11.2 Functions

12m 32s


09m 25s

11.4 Triggers

17m 33s

11.5 CLR Integration

07m 11s

Chapter: Lesson 12 Indexing

Learning objectives

00m 44s

12.1 Index Overview

07m 59s

12.2 Working with Indexes

14m 15s

12.3 Included Columns

05m 11s

Chapter: Lesson 13 Application Security

Learning objectives

00m 52s

13.1 How to Set Up Security

12m 55s

13.2 Understanding Abstraction Layers

12m 52s

Chapter: Summary

Summary of SQL Server 2012 Fundamentals for the Accidental DBA LiveLessons

02m 10s