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 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!

Raves & Praise

Connect with MicroTrain

Begin building a successful long-term career pathway.

(630) 981-0200

Back to Top