Easy Learning Developing SQL Databases MCSA Certification Exam 70-762 Video Training Course DVD(DVD)

Description

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