• 70-762 Developing SQL Databases

  • 4 Day Course | £1595.00 (+VAT) | 9am-5pm

  • On demand, please enquire

Target Audience

This exam is intended for database professionals who build and implement databases across organisations and who ensure high levels of data availability.  Their responsibilities include creating database files, data types and tables; planning, creating and optimising indexes; ensuring data integrity; implementing views, stored procedures and functions; and managing transactions and locks.

Required Knowledge

  • Good understanding of t-SQL
  • Ability to create database objects using t-SQL alone
  • Understand basic optimisation and analysis

Purpose of the Course

This training provides focusses on the requirements for the 70-762 Developing SQL Databases exam.

This is one half of the Microsoft Certified Solutions Associate SQL 2016 Database Development certification.

Topics Covered

  • Design and implement database schemas, indexes, and views
  • Understand Columnstore indexes
  • Data Integrity and constraints
  • Create stored procedures, triggers, and functions
  • Transactions, isolation levels, concurrency, and locking
  • Understand indexes and statistics
  • Monitor and translate performance metrics

Course Modules

Module 1: Tables and Schemas

  • Table creation
  • Data types
  • Normalisation
  • Schemas

Module 2: Indexing

  • Types of Index
  • Key and Included columns
  • Plan analysis for indexing
  • Columnstore indexes

Module 3: Views

  • Creating views
  • Updateable views
  • Indexes views
  • Partitioned views

Module 4: Programmable Objects

  • Primary and Foreign keys
  • Creating stored procedures
    • Input and output parameters
    • Table valued parameters
    • Return codes
    • Error handling
  • Triggers
    • Types of trigger
    • Internal tables
    • Effective level
  • User defined functions
    • Scalar and table valued
    • Deterministic and non-

Module 5: Database Concurrency

  • Transactions
    • Savepoints
    • Blocking
  • Isolation levels
  • Locking and blocking
  • In memory tables
  • Natively compiled stored

Module 6: Optimise Database Objects

  • Statistics
  • Index maintenance
  • Execution plan analysis
  • Query store

Module 7: SQL Infrastructure

  • Database files and tempDB
  • SQL Server editions
  • Wait statistics
  • Extended Events
  • Would you like to discuss your training requirements with me?

    I'm always happy to help so, whatever your question, simply give me a call or send me a message and I'll get back to you as quickly as possible.