Special, in person, One Day Sessions...
 Pinal Dave
16thand 17th May 2019
Special, in person, One Day Sessions...
 Pinal Dave
16thand 17th May 2019
Special, in person, One Day Sessions...
 Pinal Dave
16thand 17th May 2019
Special, in person, One Day Sessions...
 Pinal Dave
16thand 17th May 2019

70-762 Developing SQL Databases

4 Day Course  |  £1595.00 (+VAT)

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-Deterministic
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.
Copyright © 2018 London SQL Server Training Courses @ SQL Training | Website Design From Scott Heron