Querying Microsoft SQL Server

This training helps a delegate to write basic SQL queries for Microsoft SQL Server 2014.This training gives the knowledge of SQL Server Management Studio, T-SQL, SELECT statements , data manipulation language (DML), grouping and aggregating data, table expressions, set operators, window functions, T-SQL programming, error handlers, and transaction management in SQL Server.

Course Content

Introduction to Microsoft SQL Server 2014

• Basic architecture of SQL Server
• SQL Server editions and versions
• Get started with SQL Server Management Studio

Introduction to T-SQL Querying

• Introducing T-SQL
• Understanding Sets
• Predicate Logic
• Understanding Logical order of operations In SELECTstatements

Write SELECT queries

• Write simple SELECT statement
• Eliminate Duplicate records with the help of DISTINCT
• Use Column and Table Aliases
• Writing SIMPLE CASE Expressions

Querying Multiple Tables

• Understand Joins
• Query with Inner Joins, Outer Joins, Cross joins, and Self- joins

Sorting and Filtering data

• Sorting data
• Filtering data using WHERE clause
• Filter with TOP and OFFSET-FETCH options
• Work with Missing and Unknown values

Work with SQL Server 2014 Data types

• Introducing SQL Server 2014 Data Types
• Work with Character Data, Date and Time data

Using DML to modify data

• Insert data
• Modify and Delete data

Using Built-in Functions

• Write queries with built-in functions
• Using Conversion as well as Logical functions
• Using Functions to work with NULL

Grouping and Aggregating Data

• Use aggregate functions
• Use GROUP by clause
• Filtering Groups with HAVING

Using Subqueries

• Writing Self-contained subqueries
• Write Correlated subqueries
• Using EXISTS predicate along with Subqueries

Using Table Expressions

• Use Derived Tables
• Use Common Table Expressions
• Use Views
• Using Inline Table-Valued Functions

Using SET operators

• Writing Queries using UNION Operator
• Use EXCEPT, INTERSECT and APPLY

Using Window Ranking, Offset and Aggregate Functions

• Creating Windows using OVER
• Exploring Window Functions

Pivoting and Grouping Sets

• Write Queries using PIVOT and UNPIVOT
• Work with Grouping Sets

Executing stored procedures

• Query Data with Stored Procedures
• Passing Parameters to Stored Procedures
• Create Simple Stored Procedures
• Work with Dynamic SQL

Programming with T-SQL

• T-SQL Programming Elements
• Controlling Flow of Program

Implementing error handling

• Use TRY / CATCH Blocks
• Work with Error Information

Perform Transactions

• Transactions and the Database Engine
• Controlling Transactions
• Isolation Levels

Improve Query Performance

• Query Performance Factors
• Displaying Query Performance Data

Querying SQL Server Metadata

• Querying System Catalog Views and Functions
• Execute System Stored Procedures
• Querying Dynamic Management Objects

Note: Lab is provided in this course for hands-on practice and practical learning.