Developing SQL Databases MCSA Certification Exam 70-762 Video Training Course DVD

Developing SQL Databases - Exam 70-762 Certification

Prepare to Take the Microsoft 70-762 Exam and Work Towards Your MCSA: SQL 2016 Database Development Certification

Duration: 8 hours 39 minutes

Chapter: Introduction
Welcome To The Course
Course Overview
Microsoft's SQL Server
SQL Server 2016 Certifications
Examples And Code

Chapter: SQL Server Basics
SQL Server Platform
SQL Server Editions
Understanding Databases
Database Structures
Transact-SQL

Chapter: Getting And Installing SQL Server 2016
 Getting SQL Server 2016
Installing SQL Server 2016
Installing SQL Server Management Studio
Attaching The Sample Database
Verifying The Installation

Chapter: Table Design And Implementation
 Creating The Database
Database Options
Understanding Tables
SQL Server Data Types
Choosing A Data Type
What Is Normalization?
Understanding Relationships
Schemas
Table Design Basics
Creating Tables Using T-SQL
Creating Tables Graphically
Using Identity Columns Part - 1
Using Identity Columns Part - 2
Altering Tables Part - 1
Altering Tables Part - 2

Chapter: Advanced Table Design
 Understanding Data Integrity
Constraints
Primary And Foreign Keys
Adding Constraints Part - 1
Adding Constraints Part - 2
Understanding Filegroups
Table Partitions
Temporal Tables
Working With Temporal Tables Part - 1
Working With Temporal Tables Part - 2
In-Memory Tables Part - 1
In-Memory Tables Part - 2
Generating Scripts

Chapter: Indexes
 Index Basics
Clustered Or Nonclustered Part - 1
Clustered Or Nonclustered Part - 2
Covered Indexes
Creating Indexes
Columnstore Indexes
Managing Indexes
Rebuilding And Reorganizing

Chapter: Views
View Basics
Creating A View
Updateable Views
Indexed Views

Chapter: Transactions
 Understanding Transactions Part - 1
Understanding Transactions Part - 2
Transaction Log
Using Explicit Transactions
Savepoints Part - 1
Savepoints Part - 2

Chapter: Stored Procedures
Stored Procedure Basics
Creating Stored Procedures
Using Input Parameters
Using Output Parameters
Table-Valued Parameters Part - 1
Table-Valued Parameters Part - 2
Return Status Part - 1
Return Status Part - 2
Natively Compiled Stored Procs

Chapter: Triggers
 Understanding Triggers
Instead Of Triggers
After Triggers
Inserted And Deleted Tables

Chapter: User-Defined Functions
Understanding Functions
Scalar Functions
Table-Valued Functions

Chapter: Conclusion
 Wrap Up

Buy This Course DVD Now @

​