SQL - Quick Start

Under the JSystems brand, we have been operating since 2008, offering training in databases, programming, and operating systems from the very beginning. We gather specialists with rich professional experience, enthusiasts of their technologies. We are aware of the dynamic changes occurring in the IT industry, which is why we ensure that our company stays up to date. We continuously improve our program so that the IT courses we conduct reflect the current market situation. Our training is workshop-based. Each topic discussed by the trainer is supported by live coding examples. As the trainer writes code, they explain what they are doing and why. After each topic discussed in this way, the trainer leads an exercise aimed at having participants apply the technique.

This training is a comprehensive introduction to the world of Microsoft SQL Server, aimed at individuals who want to gain knowledge about architecture, database structure, and the practical use of SQL (T-SQL) in data management.

The training has been designed for individuals who want to acquire specific, useful skills needed to work with databases in a short time. This training starts from scratch, so we also invite those who have no experience with databases.

The training is maximally practical – the emphasis is on understanding how queries work and their application in daily work. After completing the training, participants will be ready for independent data analysis and report creation in MS SQL Server. During the training, participants complete dozens of workshops with increasing difficulty, allowing them to learn this language in practice and better retain knowledge.

Participants will learn to:

• create SQL queries from scratch,
• filter, sort, and aggregate data,
• use built-in functions (numeric, text, date),
• join tables and create subqueries,
• perform operations on data sets.

1. Introduction to Microsoft SQL Server

• SQL Server Architecture
• Differences between versions
• Organizational structure of the database:
• Databases
• Schemas
• Tables
• Columns
• Rows
• Fields
• Data types
• Primary keys
• Foreign keys
• Column properties

2. SQL Server Management Studio (SSMS) Environment

• Installation and configuration
• Connecting to the server
• SSMS interface
• Creating a database (Northwind)
• Database diagrams

3. Introduction to SQL (T-SQL)

• Structure of an SQL query
• SELECT statement:
• Selecting columns and constants
• Joining columns
• Column and table aliases
• Sorting query results
• Eliminating duplicates (DISTINCT)

4. Filtering Data

• WHERE clause
• Logical conditions (AND, OR)
• Filtering NULL (IS NULL, IS NOT NULL)
• Special operators

5. Built-in functions, text functions, concatenation, extraction and modification, date and time functions, type conversion

6. Aggregate functions and data grouping

• SUM, AVG, MIN, MAX, COUNT
• GROUP BY
• Grouping by multiple columns
• HAVING vs WHERE

7. Table Joins

• Rules for joining tables
• INNER JOIN
• OUTER JOIN (LEFT, RIGHT, FULL)
• SELF JOIN
• CROSS JOIN
• Joins without keys

8. Subqueries

• Simple subqueries (WHERE)
• Complex subqueries (SELECT, FROM)
• Multi-row subqueries
• IN, ANY, ALL, NOT IN
• EXISTS and NOT EXISTS

9. Operations on Data Sets

• Requirements regarding types and number of columns

10. Operations for adding, modifying, and deleting rows

• Adding rows (INSERT)
• Updating rows (UPDATE)
• Deleting rows (DELETE)

2 days

Author's materials or an ebook related to the training topic, hosts (virtual environment) for each training participant, provision of an experienced trainer