Querying SQL Server 2019,

About Education

Querying SQL Server 2019,This is a practical training course designed for individuals who want to learn database query languages and write effective queries in the Microsoft SQL Server environment. Throughout the training, participants will become proficient in using SQL Server Management Studio (SSMS), writing basic and advanced T-SQL queries, data grouping, multi-table queries (JOIN), data sorting and filtering.

The training is conducted using examples supported by real-world scenarios and aims to improve participants' query writing skills in SQL Server.

Prerequisites

• Basic knowledge of computer and office software
• No prior knowledge of SQL or databases is required.
• Familiarity with working with data and basic algorithm logic is beneficial.
• Those who have previously used Excel, data analysis or reporting tools may adapt more quickly.

Duration of Training

Total Duration: 5 Days (6 hours per day)
Total Training Hours: 30 hours
Training Format: Practical and interactive classroom/online environment

Who Should Participate?

• Data analysts, reporting specialists, and BI developers who want to learn SQL
• Software developers who want to acquire basic data querying skills
• System administrators and technical team members working with SQL Server
• All professionals who work with data but want to strengthen their technical infrastructure
• University students, those who want to start their career in a data-driven field

Educational Content

Introduction and Basic Concepts

• What are data, databases and DBMS?
• Relational database structure and table logic
• SQL language and areas of use
• Introduction to SQL Server and SSMS interface
• Query execution methods

Quick Start to T-SQL

• What can be done with SQL?
• Basic T-SQL components and command classification
• Retrieving data with the SELECT command
• Listing tables and columns

Data Query with SELECT

• Simple SELECT queries
• DISTINCT and SELECT COUNT (DISTINCT)
• Column and table aliases

Operators and Filtering

• Arithmetic operators
• Comparison and logical operators with WHERE condition
• AND – OR, IN, LIKE, BETWEEN, IS NULL
• Wildcards in the LIKE operator

Sorting and Result Limitation

• ORDER BY
• OFFSET – FETCH
• TOP command usage

Grouping and Working with Grouped Data

• Aggregation functions: SUM, COUNT, MIN, MAX, AVG
• DISTINCT ile aggregate fonksiyonlar
• Using GROUP BY and HAVING
• Difference between HAVING and WHERE
• GROUPING SETS, CUBE ve ROLLUP
• SQL query processing order

Query with Multiple Tables (JOIN)

• Database schema and table relationships
• Primary key (PK) and foreign key (FK)
• JOIN types and usage logic
  • INNER JOIN
  • LEFT / RIGHT JOIN
  • FULL JOIN
  • CROSS JOIN
  • SELF JOIN and advanced JOIN structures

SET Operators and PIVOT Operations

• UNION and UNION ALL
• EXCEPT and INTERSECT
• Data transformation operations with PIVOT and UNPIVOT

What You Will Gain at the End of Training

• Ability to write queries confidently in an SQL Server environment
• Proficiency in basic and intermediate T-SQL commands
• Practical experience that meets real-life data query needs
• Ability to apply JOINs, grouping, filtering and data sorting techniques
• Ability to work with PIVOT and other advanced query techniques
• Strong foundation in data analysis, reporting, BI, and software development