MTA Database SQL Server Foundations Introduction Certification Camp

$4,495.00

The Microsoft Technology Associate (MTA) is Microsoft’s newest suite of technology certification exams that validate fundamental knowledge needed to begin building a career using Microsoft technologies. The MTA certification is intended as an “entry-level” certification to build foundational skills and knowledge on database fundamentals. MTA exams are not a prerequisit to the MCP program (MCSA, MCSE, etc). CompuDev Training provides these courses to prepare individuals for more advanced MCSA camps.

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.

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

98364 Database Fundamentals
20461 Querying Microsoft SQL Server 2012

Clear

Description

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.

  • Class Dates
  • 18/12/2017 – 22/12/2017Punta Gorda, FL

  • What Is Included
  • transportation,plane,half,user,airplane,transport,account,profile,people,human Airfare to/from Punta Gorda, FL
    lodging 12 Nights of Lodging
    transportation,bus,automobile,vehicle,car,transport Shuttle Transportation from the Airport/Hotel/Facility
    restaurant Breakfast Served at the Hotel and Lunch is Provided by the Facility
    address,book,reading,read Authorized Course Materials, Study Guides, Classroom Handouts. Test Preps
    exam 3 Microsoft Exam Vouchers
    exam 3 Retake Vouchers (if needed)
    Onsite Pearson Vue Testing Center
    exam 180 Days Post Class Virtual Lab Access
    exam 90 Days eLearning Access

Class 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

Reviews

There are no reviews yet.

Be the first to review “MTA Database SQL Server Foundations Introduction Certification Camp”

Your email address will not be published. Required fields are marked *