Course Details

Previous Page


Developing SQL Databases Expert Live with Encore


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number


Overview/Description
Developing SQL Databases covers best practices for implementing database and programmability objects in SQL Server 2016. Upon completion of this course, students will be able to configure, manage, and troubleshoot database objects. This course covers the objectives for the 70-762: Developing SQL Databases exam.
Prerequisites
Candidates should have one to two years of experience using SQL Server, any version. Students who are not taking the exam but are interested in learning about SQL Server should have previous experience in database environments.
Certification
Microsoft SQL Server 2016 MCSA/MCP
Exams
70-762: Developing SQL Databases
Outline
Developing SQL Databases
SQL Server 2016 Database Objects, Indexes, and Views
Columnstore Indexes and Programmability Objects
Triggers, Functions, Transactions, and Isolation Levels
Managing Database Concurrency
Optimize SQL Database Objects and Infrastructure
Database Instances and Performance Tuning


Target Audience
Database professionals responsible for implementing and maintaining SQL Server 2016.

Expected Duration (hours)
32.0

Lesson Objectives

Developing SQL Databases Expert Live with Encore

  • Design and implement a relational database schema
  • Design and implement indexes
  • Design and implement views
  • Implement columnstore indexes
  • Ensure data integrity with constraints
  • Create stored procedures
  • Create triggers and user-defined functions
  • Implement transactions
  • Manage isolation levels
  • Optimize concurrency and locking behavior
  • Implement memory-optimized tables and native stored procedures
  • Optimize statistics and indexes
  • Analyze and troubleshoot query plans
  • Manage performance for database instances
  • Monitor and trace SQL Server baseline performance metrics
  • Course Number:
    LLMS0071