Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Developing SQL Databases – Exam 70-762 Certification

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