SQL language for Azure SQL – working with analysis and reporting

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?

Solid SQL and Azure SQL basics - You will organize the core concepts behind databases, SQL, and Azure SQL, so it becomes much easier for you to understand how the server, database, and key objects work together.

Confident SELECT queries - You will learn how to write correct SELECT statements and understand their execution order, helping you retrieve the right data faster and avoid common logical mistakes in queries.

Accurate data filtering - You will master operators such as IN, BETWEEN, LIKE, AND, OR, NOT, along with NULL handling and date operations, so you can narrow results precisely and build more useful reports.

Practical SQL functions - You will use text, numeric, date and time functions, plus type conversions, to clean data, reshape values, and prepare query results in a form that is easier to analyze and reuse.

Data analysis with aggregates - You will apply COUNT, SUM, AVG, MIN, MAX, as well as OVER and PARTITION BY, so you can create summaries, compare groups, and prepare more advanced analytical result sets.

Combining tables and results - You will practice JOINs, UNION, UNION ALL, and EXCEPT, enabling you to merge data from multiple sources, compare sets, and build complete outputs for everyday analytical tasks.

Creating and changing objects - You will work with CREATE TABLE, CREATE VIEW, temporary tables, ALTER, and DROP, which will help you build your own data structures and supporting objects for real SQL work.

Better tool integration - You will understand how a database can work with other databases as well as Excel and Access, making data exchange, reporting, and practical SQL use much easier in business tasks.

Training programme

1. Discussion of basic database concepts and software

introduction to databases – basic concepts,
division of the SQL language,
connecting the database to the SQL server,
server objects.

2. Detailed discussion of processes and techniques used for effective data retrieval

SELECT – syntax,
order of SELECT statements.

3. Overview of operators used in the SQL language

IN,
BETWEEN AND,
LIKE,
=,
<>,
>=
<=,
combining query criteria: AND, OR, NOT,
operations on dates,
sorting ORDER BY,
NULL.

4. Discussion of basic and advanced queries in SQL and built-in functions

LEFT strings,
RIGHT,
REPLACE,
UPPER,
LOWER,
ROUND,
date and time functions,
conversion functions,
data type casting.

5. Introduction to processing aggregated data in SQL

COUNT,
MIN,
MAX,
SUM,
AVG,
OVER,
PARTITION BY.

6. Tables and operations on them

INNER JOIN – inner join,
RIGHT OUTER JOIN – right outer join,
LEFT OUTER JOIN – left outer join,
CROSS JOIN – cross join,
FULL OUTER JOIN – full join.

7. Overview of techniques for combining query results in SQL

combining tables – UNION,
combining tables – UNION ALL,
common parts
EXCEPT/MINUS.

8. Introduction to nested queries (subqueries) in SQL

9. Discussion of various objects in SQL

creating tables – CREATE TABLE,
temporary tables,
views and their structure – CREATE VIEW,
clean SQL code – creating objects,
modifying objects – ALTER,
deleting objects – DROP.

10. Database – communication

cooperation between databases,
cooperation with MS Excel,
cooperation with Access.

What are the prerequisites for participating in the training?

Basic computer skills - You should be comfortable using an operating system, opening applications, working with files, and copying data, so you can focus on exercises instead of basic computer handling.

Understanding tabular data - You should understand what rows, columns, and values in a table mean, because this will make it easier for you to work with records, filters, sorting, and data joins in class.

Basic Excel experience - You should have basic experience with spreadsheets and tables in Excel, as this will help you relate database concepts to familiar data structures and ways of organizing information.

Readiness to write commands - You should be ready to type commands on your own and review query results, because the training is hands-on and expects you to actively work with SQL code during exercises.