MySQL – database design using SQL – entry level

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?

Understanding relational databases - You will build a solid grasp of relational databases and SQL, so you can clearly identify tables, views, procedures, and relationships between objects in a real database.

Writing queries on your own - You will learn how to create correct SELECT queries, use aliases, data types, and Query Designer, so you can retrieve the information you need without guessing the syntax.

Precise data filtering - You will master operators, conditions, and NULL handling, which will let you build queries with AND, OR, NOT, IN, BETWEEN, and LIKE to return exactly the right records.

Combining data from tables - You will understand relationships and joins such as INNER JOIN, LEFT, RIGHT, FULL, and CROSS JOIN, so you can merge data from multiple tables into one consistent result.

Using SQL functions in practice - You will use text, math, date, and type conversion functions to clean data, transform values, sort results, and limit returned rows in practical day-to-day SQL work.

Building summaries and analyses - You will learn to aggregate data with GROUP BY, COUNT, SUM, AVG, and apply WHERE and HAVING, so you can prepare summaries, reports, and simple business analyses faster.

Working with complex queries - You will explore UNION, UNION ALL, INTERSECT, EXCEPT, and subqueries, so you can combine results from different queries and create more advanced search logic for data.

Modifying and organizing data - You will practice INSERT, UPDATE, DELETE, SELECT INTO, and window functions with OVER and ROW_NUMBER, so you can not only read data but also change and structure it.

Training programme

1. Introduction to the basic concepts of relational databases

basic concepts related to SQL databases and examples of SQL databases,
division of the SQL language into DQL, DML, DDL, DCL,
SQL code editor - Microsoft SQL Server Management Studio,
server objects: tables, views and stored procedures.

2. Detailed discussion of queries used to retrieve data from the database using the DQL language

Query Designer in applications and creating a query to the database,
basic data types in SQL.

3. Operators and criteria in SQL queries

operators in SQL =, <>, >=, <=, IN, BETWEEN, AND, LIKE,
criteria in queries, combining multiple criteria using AND, OR, NOT,
the concept and application of NULL and NOT NULL.

4. Discussion of techniques for combining data from multiple tables using joins

relationships between tables and defining the element connecting the tables,
the INNER JOIN, RIGHT OUTER JOIN and LEFT OUTER JOIN join,
the full FULL OUTER JOIN and cross CROSS JOIN join.

5. Overview of various functions and expressions available in SQL

retrieving records using SELECT and the use of the column alias AS,
operations on character strings: LEN, LEFT, RIGHT, MID, REPLACE, TRIM,
joining and splitting text strings: CONCAT, TRIM,
mathematical functions: ROUND, ABS, FLOOR, SQUARE,
time and date functions: DATE, DATEADD, DATEDIFF, MONTH, YEAR, DAY,
type conversion and casting: CAST(), CONVERT(),
operations on table columns and sorting the query result ORDER BY,
limiting the number of returned records: TOP, TOP PERCENT / LIMIT,
removing duplicate values: DISTINCT, DISTINCTROW.

6. Detailed explanation of the operation of aggregate queries

aggregation of results in queries using GROUP BY,
functions COUNT, MIN, MAX, SUM, AVG and the use of WHERE and HAVING.

7. Discussion of techniques for combining the results of multiple queries using statements

combining tables using: UNION, UNION ALL,
common parts and INTERSECT, EXCEPT / MINUS.

8. Explanation of complex nested queries

the result of a query as a WHERE condition in a query,
a query based on another query and the use of nested queries.

9. Discussion of queries and operations modifying data in databases

updating data using UPDATE,
adding records to a table using the INSERT command,
deleting data using the DELETE command,
outputting the query result to a table: SELECT INTO.

10. Detailed overview of database objects – DDL (Data Definition Language)

building tables using using Microsoft SQL Management Studio.

11. Discussion of more complex and advanced queries in SQL Server

window functions OVER() and numbering records using ROW_NUMBER(),
partitioning records by category using PARTITION BY.

What are the prerequisites for participating in the training?

Basic computer skills - You should be comfortable working in Windows, launching applications, saving files, and moving through folders so you can use the SQL tool without difficulty.

Basics of working with data - You should understand what rows, columns, and tables are, and be able to read simple data sets, so the examples and exercises during the course are easy to follow.

Logical thinking - You should be able to analyze conditions and relationships, because during the course you will combine criteria, filter records, and build correct SQL query logic.

Readiness for hands-on work - You should be ready to type queries yourself and test their results, because the course includes practical exercises focused on retrieving and modifying data.