Querying Microsoft SQL Server 2012/2014

Live Classroom
Duration: 5 days
Live Virtual Classroom
Duration: 5 days
Pattern figure


Microsoft SQL Server is a relational database management system that works as a database server, storing and retrieving data for multiple software applications running on a single computer or on other computers across a network.

This will equip learners with the technical skills they need to write basic Transact-SQL queries for Microsoft SQL Server 2012/2014. The course serves as a foundation to all SQL server-related fields such as Database Development, Database Administration and Business Intelligence. The course will cover all the new features in SQL Server 2014, along with the SQL Server data platform’s most important capabilities.

This course will prepare learners to take Querying Microsoft SQL Server 2012 examination conducted by Microsoft.


Why this

This course is highly recommended for current and aspiring:
  • Database Developers
  • Database Administrators
  • Business Intelligence professionals
  • SQL developers
  • Database architects
  • Programmers
  • Application developers
  • Business analysts
  • Technical writers

What You'll Learn

  • Writing SELECT queries
  • Sorting and filtering data
  • Querying multiple tables
  • Describing the applications of data types in SQL Server
  • Using built-in functions
  • Modifying data with Transact-SQL
  • Grouping and aggregating data
  • Working with set operators
  • Working with subqueries
  • Working with table expressions
  • Implementing grouping and pivoting sets
  • Working with window ranking, offset and aggregate functions
  • Programming with T-SQL
  • Executing stored procedures
  • Implementing transactions
  • Implementing error handling


  • Create and alter tables using T-SQL syntax (simple statement)
  • Create and alter views
  • Design views
  • Create and modify constraints
  • Create and alter DML triggers

  • Query data by using SELECT statements
  • Implement sub-queries
  • Implement data types
  • Implement aggregate queries
  • Query and manage XML data

  • Create and alter stored procedures
  • Modify data by using INSERT, UPDATE and DELETE statements
  • Combine datasets
  • Work with functions

  • Optimize queries
  • Manage transactions
  • Evaluate use of row-based operations vs set-based operations
  • Implement error handling
Ripple wave


Participants enrolling for this Querying Microsoft SQL Server course must possess a functional knowledge of relational databases, along with a basic understanding of the Microsoft Windows operating system and its core functionality. A minimum of two years of related professional experience is recommended.

Interested in this Course?

    Ready to recode your DNA for GenAI?
    Discover how Cognixia can help.

    Get in Touch
    Pattern figure
    Ripple wave