Querying Microsoft SQL Server 2012/2014

Write basic Transact-SQL queries & prepare for the Querying Microsoft SQL Server 2012/2014 examination

Course Code : 5072

Overview

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.

Schedule Classes

Looking for more sessions of this class?

Course Delivery

This course is available in the following formats:

Live Classroom
Duration: 5 days

Live Virtual Classroom
Duration: 5 days

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

Outline

  • 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
View More

Prerequisites

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.

Who Should Attend

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

Interested in this course? Let’s connect!

Customer Reviews

Name
Email
Rating
Comments

No reviews yet