MTA Database SQL Server

5  Days

The MTA Database SQL Server certification boot camp is a 5 day comprehensive deep dive into the SQL Server covering topics such as fundamentals and querying. This instructor led face to face training camp will teach you the skills needed to gain knowledge to learning the basics of SQL Server.



Course Description

This MTA Database SQL Server boot camp incorporates Microsoft Official Courses –

98364 Database Fundamentals
20461 Querying Microsoft SQL Server 2012

While attending this training program – you take two exams to test and certify for the Microsoft Technology Associate (MTA): Database SQL Server official certification. If your goal is to learn how to use fundamentals of SQL Server and pass the certification exams (98-364 / 70-461) – you’ve found the right place. This course is a hybrid of actual hands on learning combined with focused materials mapped to exam objectives. Click MTA Database to download the course outline.

Topics covered in this boot camp:

Understand Core Database Concepts

Create Database Objects

Manipulate Data

Understand Data Storage

Administer a Database

Describe the basic architecture and concepts of Microsoft SQL Server 2014

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