SQL Server 70-762: Developing SQL Databases: Required Knowledge for SQL Server 2012 and 2014

Lesson DescriptionsIn Lesson 1, you learn how to design tables and schemas based on business requirements

We use normalization to improve the design of tables

Next, we create tables and determine the most efficient data types to use

Finally, we extend security to data types by using dynamic data masking

Design and improve tables and schemas based on business requirements

Determine the most efficient data types to use and how to secure them

Design, implement, and improve indexes using best practices

Design and implement view structures and configure partitioned and indexed views

Design and implement clustered and nonclustered columnstore indexes

Create and manage table and foreign key constraints, learn how they interact with Transact-SQL and DML statements, and create and manage PRIMARY KEY constraints

Create, implement, and manage stored procedures

Create, implement, and manage DML, DDL, Logon, AFTER, and INSTEAD OF triggers

Create and implement scalar-valued and table-valued user-defined functions as well as deterministic and nondeterministic functions

Manage database concurrency by understanding and implementing transactions, isolation levels, locking behavior, memory-optimized tables, and native stored procedures

Increase SQL Server database performance through optimized statistics and indexes

Troubleshoot query plans using extended events and traces, SQL Server Profiler, Query Store, and Azure SQL Database Performance Insight

Monitor and optimize database performance through a variety of best practices and available tools

Course RequirementsRequires a basic working knowledge of databases