Chicago area career training

MCSA: 70-461 Querying Microsoft SQL Server 2014 Databases (20461D)

Summary

* Pricing and Logistics are subject to change without notice.
 

This 5-day instructor led course is part of the MCSA SQL Server certification track. It provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines, namely, Database Administration, Database Development and Business Intelligence. This course prepares students for exam 70-461.

MicroTrain offers Microsoft Certified instructors, in-classroom lessons and labs, supplemental training and study materials, and the MicroTrain Exam Pass Guarantee.

Who benefits from this course?

  • Anyone pursuing MCSA SQL Server certification
  • Anyone interested in learning the new features and data capabilities of SQL Server 2012 or SQL Server 2014
  • Any Database Administrators, Database Developers, and Business Intelligence professionals who wish to sharpen their skillset
  • Anyone responsible for report writing, business analysis and client application development

Prerequisites

  • Working knowledge if relational databases
  • Basic knowledge of the Microsoft Windows operating system and its core functionality

About This Course

Upon successful completion of this course, students will be able to:

  • Describe the basic architecture and concepts of Microsoft SQL Server 2014.
  • Understand the similarities and differences between Transact-SQL and other computer languages
  • Write Transact-SQL queries using the SELECT statement
  • Query multiple tables
  • Limit the rows that queries return and control the order in which the rows are displayed
  • Describe SQL Server 2014 data types
  • Use Transact-SQL functions
  • Aggregate data using Transact-SQL
  • Nest Transact-SQL queries using subqueries
  • Describe and implement table expressions
  • Compare rows between two input sets
  • Write queries that use window functions
  • Use the PIVOT operator to change the orientation of data
  • Create and execute stored procedures
  • Enhance your T-SQL code with programming elements
  • Implement error handling and transactions in Transact-SQL
  • Describe techniques to improve query performance
  • Query SQL Server metadata

Prerequisites

This course requires that you meet the following prerequisites:
  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.

Exam Details

Exam 70-461: Querying Microsoft SQL Server 2012/2014

The Logistics of Your Exam

  1. The cost of the exam is an additional $165
  2. Locate a Pearson Vue testing center near you

  3. Create a Microsoft Profile and register for your exam

  4. Review Microsoft Exam Policies prior to taking your exam

Exam Information

Exam Code 70-461
Number of Questions 40-60
Passing Score 700 (on a scale of 1-1000)
Types of Questions
  • Case Studies

  • Multiple choice

  • Multiple response

  • Active screen

  • Best answer

  • Build List

  • Drag and drop

  • Hot area

  • Repeated answer choices

  • Short answer

  • Mark review

  • Review screen

Length of Test 120 minutes
Exam Results Provided within minutes of completing exam

Course Schedule

Chicago
200 W Adams Suite 410 Chicago, IL 60606
04/27/2019 - 06/08/2019 09:00 am - 05:00 pm
S M T W T F S
Lombard
720 E Butterfield Rd Suite 100 Lombard, IL 60148
02/25/2019 - 03/01/2019 09:00 am - 05:00 pm
S M T W T F S
03/02/2019 - 03/30/2019 09:00 am - 05:00 pm
S M T W T F S
05/06/2019 - 05/10/2019 09:00 am - 05:00 pm
S M T W T F S

Exam Pass Guarantee

At Microtrain we are committed to your success!
Let us show you the return you get from great tech training. We will personally guarantee that if you take our class and follow our program you will be successfully certified!

Learn More