MCSA SQL 2016 Database Development Training & Certification Boot Camp

5 Days

Description

The Microsoft Official MCSA SQL 2016 Database Development certification boot camp is a 5 day comprehensive deep dive into the SQL Server developer topics such as writing queries, subqueries, expressions, operators, stored procedures, functions and XML data.  This instructor led face to face training program will teach you the skills needed to support SQL 2016 developer task.

The SQL Database Development boot camp incorporates Microsoft Official Courses -

20761 Querying Data with Transact-SQL
20762 Developing SQL Databases

While attending this training program - you take two exams to test and certify for the Microsoft Certified Solutions Associate (MCSA) SQL 2016 Database Development official Microsoft certification. If your goal is to learn how to use SQL Server 2016 and pass the certification exams (70-761 / 70-762) - you've found the right place. This course is a hybrid of actual hands on learning combined with focused materials mapped to exam objectives.

Upcoming Classes

Classroom Live
November 06, 2017

Sarasota, FL or Virtual LIVE
$4,995.00
5 Days    9:00am - 5:00pm
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

  • Topics covered in this boot camp:
    • Describe the basic architecture and concepts of Microsoft SQL Server 2016.
    • Understand the similarities and differences between Transact-SQL and other computer languages.
    • Write SELECT queries
    • Query multiple tables
    • Sort and filter data
    • Describe the use of data types in SQL Server
    • Modify data using Transact-SQL
    • Use built-in functions
    • Group and aggregate data
    • Use subqueries
    • Use table expressions
    • Use set operators
    • Use window ranking, offset and aggregate functions
    • Implement pivoting and grouping sets
    • Execute stored procedures
    • Program with T-SQL
    • Implement error handling
    • Implement transactions
    • Design and Implement Tables.
    • Describe advanced table designs
    • Ensure Data Integrity through Constraints.
    • Describe indexes, including Optimized and Columnstore indexes
    • Design and Implement Views.
    • Design and Implement Stored Procedures.
    • Design and Implement User Defined Functions.
    • Respond to data manipulation using triggers.
    • Design and Implement In-Memory Tables.
    • Implement Managed Code in SQL Server.
    • Store and Query XML Data.
    • Work with Spatial Data.
    • Store and Query Blobs and Text Documents.

Upcoming Classes

Classroom Live
November 06, 2017

Sarasota, FL or Virtual LIVE
$4,995.00
5 Days    9:00am - 5:00pm
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

None 

Upcoming Classes

Classroom Live
November 06, 2017

Sarasota, FL or Virtual LIVE
$4,995.00
5 Days    9:00am - 5:00pm
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date