Quering with Microsoft SQL Server

Course Aim :

This course is designed to provide participants with the essential skills and knowledge to query and manage data using Microsoft SQL Server. It covers the fundamentals of Transact-SQL (T-SQL) and focuses on creating, modifying, and optimizing queries. Participants will learn how to retrieve, filter, and manipulate data using SQL Server.

Course Objective :

• Understand the core concepts of Microsoft SQL Server and T-SQL.
•  

  Write queries to retrieve and manipulate data from SQL Server databases.

•  

  Filter, group, and sort query results.

•  

  Use joins to retrieve data from multiple tables.

•  

  Implement subqueries and common table expressions (CTEs).

•  

  Perform data aggregation and analysis.

•  

  Optimize queries for performance improvement.

•  

  Understand data types and how to work with them in SQL Server.

•  

  Utilize SQL Server’s built-in functions for data manipulation.

Target Audience :

Pre – Requisites :

• Basic understanding of relational databases.
• Familiarity with general IT concepts is recommended.

 

Course Outline :

Introduction to Microsoft SQL Server

• Overview of SQL Server architecture
• Understanding databases and tables
• Introduction to T-SQL and SQL Server Management Studio (SSMS)

Writing Basic SQL Queries

• SELECT statements
• Filtering data with WHERE clause
• Sorting and ordering query results

Working with Data Types

• Overview of data types in SQL Server
• Implicit and explicit conversions
• Using string, numeric, and date functions

Using Joins

• Introduction to joins (INNER, OUTER, CROSS)
• Writing queries across multiple tables
• Handling null values in joins

Subqueries and Common Table Expressions (CTEs)

• Writing subqueries
• Recursive and non-recursive CTEs
• Correlated subqueries

Grouping and Aggregating Data

• Using GROUP BY and HAVING clauses
• Aggregate functions (SUM, COUNT, AVG, MIN, MAX)
• Pivoting data

Modifying Data

• Inserting, updating, and deleting data
• Managing transactions
• Understanding data integrity constraints

Working with Built-in Functions

• String functions
• Mathematical functions
• Date and time functions

Query Performance Optimization

• Understanding query execution plans
• Using indexes to improve performance
• Avoiding common query pitfalls