Kick Off PostgreSQL – SQL from Scratch

Learn PostgreSQL – Master SQL from Scratch

Ready to start your journey with databases and data analysis?
This beginner-level PostgreSQL course will teach you how to write precise SQL queries and extract exactly the data you need for reports, dashboards, or applications. Perfect for future analysts, developers, and anyone working with business data.

Whether you're building applications, analyzing trends, or writing reports - mastering SQL is essential.
Want to learn data analysis from scratch? Join our training!

***

### Training Format

The course is delivered through instructor-led sessions divided into modules. Each module includes:

• A short theoretical introduction
• Live demonstrations
• Practical exercises (guided and independent)
• Q&A sessions to clarify real-world applications

***

### Syllabus – PostgreSQL Basic Course

Introduction to PostgreSQL

• Training goals and scope
• Open-source licensing model
• How PostgreSQL differs from other databases
• Using pgAdmin: basic tools and interface

Relational Databases – Core Concepts

• What is a database server?
• Server objects: databases, tablespaces, schemas, roles
• Relational model fundamentals

SQL Basics – Data Selection

• Creating simple queries
• SQL syntax and keywords
• Using column and table aliases
• Sorting results
• SQL functions:
• Single-row functions
• Group (aggregate) functions
• Filtering aggregation results

Joining Tables

• Types of joins:
• Equi-joins
• Non-equi joins
• Outer joins (LEFT, RIGHT, FULL)
• Self-joins
• Practical examples and exercises

Set Operations

• UNION, INTERSECT, EXCEPT
• Bulk operations on query results

Subqueries

• Subquery logic and structure
• Simple, nested, and correlated subqueries
• Decomposing complex queries

Data Manipulation (DML)

• INSERT, UPDATE, DELETE
• DML based on SELECT results

Transactions

• ACID principles
• COMMIT, ROLLBACK, SAVEPOINT
• Ensuring data integrity

Final Review & Certification

• Summary of key SQL concepts
• Participant Q&A
• Knowledge check / test
• Feedback survey

Payment details will be provided after you enroll. Our consultant will contact you with all the necessary information.