SQL – Practical use of the SQL language and the construction of databases

Training process

Training needs analysis

If you have specific requirements regarding the training programme, we will carry out a training needs analysis for you. This will guide us on which aspects of the programme should receive greater emphasis, so that the training programme meets your specific needs.

What will you gain?

Understand relational basics - You will build solid database foundations and clearly distinguish relationships, tables, rows, columns, primary keys, and foreign keys, making data structures much easier to read and use.

Write accurate queries - You will create SELECT queries with WHERE, ORDER BY, TOP, HAVING, and subqueries on your own, so you can filter, sort, and group data quickly for a specific business need.

Combine data effectively - You will learn how to merge information from multiple tables and use set-based operations, which will help you build more complete reports and draw better conclusions from your data.

Use SQL functions - You will practice date, time, text, math, and logical functions and operators, so you can write more precise queries and transform results into a form ready for further analysis.

Work confidently in SQL Server - You will run core queries in a SQL Server environment, which will make it easier to start working with databases in everyday tasks and feel more confident in typical analytical work.

Create views and tables - You will learn how to define, modify, and query views, as well as create and alter tables, choose data types, use auto-numbering, and enforce consistency with database constraints.

Design a better database - You will learn how to prepare a database step by step and understand the pros and cons of normalization and denormalization, helping you build cleaner and easier-to-maintain solutions.

Handle full data operations - You will practice INSERT, UPDATE, and DELETE on real examples such as inventory, invoicing, and retail scenarios, making it much easier to apply SQL syntax to real job tasks.

Training programme

1. Introduction to working with data, basic concepts, and principles related to the management and processing of information in database systems

relationships,
table, row, column,
tuple,
primary and foreign key as well as relationships between tables.

2. Discussion of the Structured Query Language (SQL) language

selection statements using the SELECT keyword,
use of the WHERE clause to select the needed rows,
sorting data (ORDER BY),
selecting the first n rows (TOP),
classification of data using HAVING,
subqueries,
combining data using the apparatus of set theory.

3. Detailed overview of functions and operators available in SQL

date and time,
mathematical,
text,
logical.

4. Learning to create and execute basic queries in the SQL Server database management system

5. Overview of the concept of views in relational databases

defining,
modifications,
querying.

6. Basic principles of operation of relational databases

preparation of a database step by step,
normalization – good and bad sides,
denormalization – good and bad sides.

7. The process of creating new tables and modifying them

creating (CREATE) and deleting (DROP) tables,
auto-numbering rows,
types of data types,
joining tables,
constraints (integrity constraints).
query optimization.

8. Practical approach to performing operations on data in relational databases

inserting data – INSERT,
updating data – UPDATE,
deleting data – DELETE.

9. Sample exercises discussed during the course

telephone directory,
e-learning platform,
invoice registration,
warehouse,
store (services and products).

What are the prerequisites for participating in the training?

Basic computer skills - You should be comfortable using an operating system, opening programs, switching between windows, and saving files, so you can focus on SQL rather than basic computer use.

Basic data awareness - You should understand simple data lists, records, and fields in basic datasets, so moving to tables, rows, columns, and relationships in a database will be much easier.

Logical thinking - You should be able to analyze conditions and dependencies, because during the course you will filter data, join tables, and build queries based on specific criteria.

Readiness for practice - You should be ready to complete short hands-on tasks on your own, because the training includes writing queries and performing data operations on realistic examples.