Confident PostgreSQL work - You will learn how to connect to a PostgreSQL server, navigate a database, and work in PG Admin, so you can start handling existing structures and queries with far less hesitation.
Reliable SELECT queries - You will master SELECT statements with aliases, filtering, sorting, LIMIT, and DISTINCT, which will help you build clear, practical queries for everyday data analysis tasks.
More precise filtering - You will practice operators such as IN, BETWEEN, LIKE, and conditions with AND, OR, and NOT, so you can select records accurately and avoid mistakes with NULL-related logic.
Combining data from tables - You will understand table relationships and learn INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, and CROSS JOIN, enabling you to merge data from different tables into one result.
Practical SQL functions - You will use string, math, date, and time functions as well as type casting and conversion, so you can reshape raw data efficiently for reports, checks, and further processing.
Building summaries and analysis - You will learn GROUP BY with COUNT, SUM, AVG, MIN, and MAX, which will let you prepare your own summaries, grouped reports, and business-focused aggregations from raw datasets.
Editing data and objects - You will practice INSERT, UPDATE, DELETE, and core DDL for TABLE and VIEW objects, so you can not only read data but also maintain and extend a database in a controlled way.
More advanced query patterns - You will work with subqueries, UNION, INTERSECT, and window functions like OVER and ROW_NUMBER, helping you write more advanced SQL for realistic reporting and analysis needs.
Relational databases are introduced through PostgreSQL and the core concepts used in SQL-based systems. The section clarifies the division of SQL into DQL, DML, DDL, and DCL, and also covers connecting to the server and an existing database.
PG Admin provides the working environment for writing SQL and navigating PostgreSQL server resources. The section presents the code editor used for query creation and clarifies the role of key server objects such as tables, views, and stored procedures.
At the start of query work, attention goes to how data is requested and how query tools support that process. This section introduces DQL, the use of a query designer in applications, and the basic SQL data types needed to build correct queries.
Effective filtering in SQL depends on choosing operators that match the intended condition logic. The section covers comparison and pattern operators, combining criteria with AND, OR, and NOT, and the practical meaning of NULL versus NOT NULL in queries.
Relations between tables determine how data from separate sources can be returned as one result. This section explains the linking element between tables and compares INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN, and CROSS JOIN.
Built-in SQL functions make it possible to transform values directly inside a query. The scope includes text operations such as LEFT, RIGHT, TRIM, SUBSTRING, UPPER, LOWER, and CONCAT, along with ROUND, date and time functions, and type conversion with CAST() and CONVERT().
SELECT serves as the core mechanism for retrieving and shaping query results in SQL. The section covers column aliases with AS, expressions based on columns, sorting with ORDER BY, limiting rows with LIMIT, and removing duplicates through DISTINCT.
For reporting and summary analysis, raw rows must often be grouped into meaningful result sets. This section explains GROUP BY, the use of COUNT, MIN, MAX, SUM, and AVG, and the role of criteria when working with aggregated output.
Combining outputs from separate SQL statements is addressed through set operations rather than joins. Participants work with UNION, UNION ALL, INTERSECT, and MINUS to merge results, preserve duplicates when needed, or isolate common rows.
When filtering or building logic depends on another query, nested statements become essential. The section shows how a subquery can serve as a WHERE condition, how one query can be based on another, and where optimization matters.
Working with table contents requires precise control over inserts, updates, and removals. This part covers INSERT, UPDATE, and DELETE, and also shows how SELECT INTO can write query results into a new table for further processing.
Database structure is created here through TABLE and VIEW definitions prepared both in PG Admin and directly in SQL. The section focuses on how DDL statements translate into concrete database objects and how these objects are managed in practice.
Window functions in PostgreSQL extend classic querying with calculations performed across related rows. The section explains OVER(), ROW_NUMBER(), and the use of PARTITION BY to number records within defined groups without collapsing the result set.
Basic computer use - You should be comfortable using an operating system, launching applications, working with a keyboard, and moving around program windows so you can focus on learning SQL.
File handling basics - You should know how to save and open files and understand basic folder and document concepts, because this will help you work smoothly with database tools during training.
Logical thinking - You should feel comfortable with simple reasoning and organizing information, because filtering data, applying conditions, and joining tables all require careful thinking.
Readiness to work with data - You should be ready to work with tables and with text, numeric, and date values, because the course focuses on practical operations performed directly on data.
