Course Code: 1258

20461 Querying Microsoft SQL Server® 2014

Class Dates:
5 Days
Class Time:


  • Course Overview
  • This course provides students with the technical skills required to write Transact-SQL queries for MS SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; Database Administration, Database Development & Business Intelligence.

    At Course Completion
    • Describe the basic architecture and concepts of Microsoft SQL Server 2014.
    • Understand the similarities & differences between Transact-SQL & other computer languages.
    • Write SELECT queries
    • Query multiple tables
    • Sort & filter data
    • Describe the use of data types in SQL Server
    • Modify data using Transact-SQL
    • Use built-in functions
    • Group & aggregate data
    • Use subqueries
    • Use table expressions
    • Use set operators
    • Use window ranking, offset & aggregate functions
    • Implement pivoting and grouping sets
    • Execute stored procedures
    • Program with T-SQL
    • Implement error handling
    • Implement transactions.

  • Audience
  • This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals.

    The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts & client app developers..


  • This course requires that you meet the following prerequisites:
    • Basic knowledge of the Microsoft Windows operating system and its core functionality.
    • Working knowledge of Transact-SQL.
    • Working knowledge of relational databases.
    • Some experience with database design.
  • Recommended Courses:

  • 55119 - SQL Server 2012 Reporting Services

Course Details