Developing SQL Databases - Exam 70-762 Certification

Table of Contents

Introduction

Welcome To The Course 00:01:25

About The Author 00:03:43

Course Overview 00:06:34

Microsoft’s SQL Server 00:05:51

SQL Server 2016 Certifications 00:04:35

Examples And Code 00:03:57

SQL Server Basics

SQL Server Platform 00:08:39

SQL Server Editions 00:04:52

Understanding Databases 00:05:42

Database Structures 00:06:52

Transact-SQL 00:06:09

Getting And Installing SQL Server 2016

Getting SQL Server 2016 00:06:55

Installing SQL Server 2016 00:09:31

Installing SQL Server Management Studio 00:03:44

Attaching The Sample Database 00:06:22

Verifying The Installation 00:05:17

Table Design And Implementation

Creating The Database 00:08:24

Database Options 00:09:40

Understanding Tables 00:06:05

SQL Server Data Types 00:09:07

Choosing A Data Type 00:05:23

What Is Normalization? 00:10:10

Understanding Relationships 00:06:50

Schemas 00:09:34

Table Design Basics 00:06:49

Creating Tables Using T-SQL 00:07:37

Creating Tables Graphically 00:06:30

Using Identity Columns Part - 1 00:06:27

Using Identity Columns Part - 2 00:04:35

Altering Tables Part - 1 00:08:41

Altering Tables Part - 2 00:03:20

Advanced Table Design

Understanding Data Integrity 00:06:47

Constraints 00:09:11

Primary And Foreign Keys 00:05:59

Adding Constraints Part - 1 00:06:56

Adding Constraints Part - 2 00:05:09

Understanding Filegroups 00:07:37

Table Partitions 00:08:01

Temporal Tables 00:07:35

Working With Temporal Tables Part - 1 00:07:47

Working With Temporal Tables Part - 2 00:04:55

In-Memory Tables Part - 1 00:08:29

In-Memory Tables Part - 2 00:03:03

Generating Scripts 00:07:28

Indexes

Index Basics 00:08:24

Clustered Or Nonclustered Part - 1 00:08:28

Clustered Or Nonclustered Part - 2 00:04:39

Covered Indexes 00:05:06

Creating Indexes 00:05:23

Columnstore Indexes 00:08:29

Managing Indexes 00:05:52

Rebuilding And Reorganizing 00:05:09

Views

View Basics 00:08:40

Creating A View 00:06:26

Updateable Views 00:04:09

Indexed Views 00:06:39

Transactions

Understanding Transactions Part - 1 00:09:01

Understanding Transactions Part - 2 00:04:48

Transaction Log 00:09:21

Using Explicit Transactions 00:06:26

Savepoints Part - 1 00:07:26

Savepoints Part - 2 00:02:49

Stored Procedures

Stored Procedure Basics 00:07:35

Creating Stored Procedures 00:05:53

Using Input Parameters 00:05:27

Using Output Parameters 00:07:15

Table-Valued Parameters Part - 1 00:07:53

Table-Valued Parameters Part - 2 00:06:40

Return Status Part - 1 00:07:44

Return Status Part - 2 00:04:06

Natively Compiled Stored Procs 00:06:46

Triggers

Understanding Triggers 00:07:11

Instead Of Triggers 00:06:49

After Triggers 00:06:42

Inserted And Deleted Tables 00:05:52

User-Defined Functions

Understanding Functions 00:07:19

Scalar Functions 00:07:35

Table-Valued Functions 00:07:16

Conclusion

Wrap Up 00:06:07