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

11.3 Views

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