Mastering Postgre SQL from Scratch
Online
Practice
Community
Certificate
What is PostgreSQL for?
What you will learn on the course
PostgreSQL is in demand
Who this course is for
PostgreSQL is a powerful object-relational database management system that offers many benefits including high performance, reliability and flexibility.
Developers proficient in PostgreSQL are in high demand in the job market in a wide variety of fields, including web development, analytics, and research.
According to a StackOverFlow survey, more than 70% of developers want to use PostgreSQL in their work in 2025
According to a StackOverFlow survey, more than 50% of professional developers and engineers are already using PostgreSQL in their companies, far exceeding the adoption rates of other DBMSs
It supports complex queries, transactions, and scalability, making it an ideal choice for developing modern applications.
81%
49%
PostgreSQL DBMS is used by many large companies: Alibaba, Hitachi, Huawei, Instagram, Skype, Sony, TripAdvisor, Yahoo, etc.
∞
Those who are not familiar with this topic and want to understand it at a good level
Those who are already programmers and want to improve their professional level
PostgreSQL Scheduler Functioning
Let's consider the principles of PostgreSQL scheduler operation.
The Value of Consistent Scans
Learn to appreciate sequential scans and develop a database-like mindset.
Reading and processing data in PostgreSQL
Explore how Postgre SQL reads and processes data.
Representations and their impact on performance
Discuss views, materialized views, CTEs, and other aspects that affect performance.
Selectivity, Statistics and Indexes
Let's talk about selectivity, statistics, and indexes.
Practical SQL
Learn the basics of working with relational databases, mastering theory and practice through real-life examples and assignments
Training Program
- Basic Concepts
- Relational Model and SQL
- Why PostgreSQL
- Installing PostgreSQL
- Data Types in PostgreSQL
- Creating a Database
- Creating Tables
- One-to-Many Relationship
- One-to-One Relationship
- Many-to-Many Relationship
- Creating Northwind
- Full Selection
- Selection and Elementary Arithmetic Operations
- DISTINCT
- COUNT
- Homework "Simple Selections"
- Homework "Simple Selections" - Solution
- WHERE
- AND, OR
- BETWEEN
- IN & NOT IN
- ORDER BY
- MIN, MAX, AVG
- Homework "Simple Selections-2"
- Homework "Simple Selections-2" - Solution
- LIKE
- LIMIT
- Check on NULL
- GROUP BY
- HAVING
- UNION, INTERSECT, EXCEPT
- Homework "Grouping, Matching, Sorting"
- Homework "Grouping, Matching, Sorting" - Solution
- Introduction to Joins
- INNER JOIN
- LEFT, RIGHT JOIN
- SELF JOIN
- USING & NATURAL JOIN
- AS - Aliases
- Homework "Joins"
- Homework "Joins" - Solution
- Module 4. Subqueries
- Introduction to Subqueries
- WHERE EXISTS
- Subqueries with Quantifiers ANY, ALL
- Homework "Subqueries"
- Homework "Subqueries" - Solution
- Managing Tables
- Homework 1 on DDL
- Homework 1 on DDL - Solution
- Primary Key
- Foreign Key
- Check
- Default
- Sequences
- Sequences & Tables
- INSERT
- UPDATE, DELETE, RETURNING
- Homework 2 on DDL
- Homework 2 on DDL - Solution
- Introduction to the Design Process
- Basic Recommendations
- Normal Form (NF)
- Module 7. Views
- Introduction to Views
- Creating Views
- Updatable Views
- Check Option
- Homework "Views"
- Homework "Views" - Solution
- CASE WHEN
- Introduction to COALESCE and NULLIF
- COALESCE and NULLIF in Practice
- Homework "Logic"
- Homework "Logic" - Solution
- Introduction to Functions
- Our First Function
- Scalar Functions
- IN, OUT, DEFAULT
- Returning Data Sets
- Introduction to PL/pgSQL
- Returning and Assigning
- Variable Declarations
- IF / ELSE
- Loops
- RETURN NEXT
- Homework "Functions"
- Homework "Functions" - Solution
- Introduction
- RAISE in Practice
- Homework "Errors and Their Handling"
- Homework "Errors and Their Handling" - Solution
- Introduction to Data Type Casting
- Data Type Casting in Practice
- Introduction to Indexes. A Little "Gut Feeling"
- Scanning Methods
- Types of Indexes
- EXPLAIN, ANALYZE
- Building a Simple Index and an Index on Two Columns
- Indexes on Expressions
- "Complex" Index for Text Search
- Introduction to Arrays
- Initialization, Slices
- Arrays and Operators
- VARIADIC and FOREACH
- Homework "Arrays"
- Homework "Arrays" - Solution
- Homework "Cycles"
- Homework "Cycles" - Solution
- Domains
- Composite Types
- Enumerations
- Homework "Custom Types"
- Homework "Custom Types" - Solution
- Introduction to Grouping
- GROUPING SET, ROLLUP, CUBE
- Homework "Advanced Groupings"
- Homework "Advanced Groupings" - Solution
- Introduction to psql
- Getting to Know psql in Practice
- Importing csv. Introduction
- Importing csv in Practice
- Introduction and CTE in Practice
- Recursive CTE
- Introduction to Window Functions
- Window Functions in Practice
- Ranking
- Returning N Records
- Homework "Window Functions"
- Homework "Window Functions" - Solution
- Introduction to Transactions
- Isolation Levels
- Transactions in Practice
- Homework "Transactions"
- Homework "Transactions" - Solution
- Introduction to Triggers
- Row-Level Triggers
- Statement-Level Triggers
- Homework "Triggers"
- Homework "Triggers" - Solution
- Introduction to Security
- Creating Roles, Revoking Permissions from Public
- Permissions at the Database and Schema Level
- Permissions at the Table Level
- Permissions at the Column Level
- Permissions at the Row Level
- Revoking All Permissions and Deleting Roles
- Bonus Lecture
How the training works
Watch the lessons at a pace that suits you
✍
Do the practical assignments
💻
If you have any questions, send them to the tuto
❓
Receive an official document of course completion
📃
Author
Artem Soloviev
Developer at Data Solutions
With more than 8 years of experience with PostgreSQL, specializes in database performance optimization.
Author of articles on data management and performance analysis in various publications.
Active member of the PostgreSQL community and speaker at database conferences.
Lecturer of SQL and PostgreSQL courses in educational institutions.
Certificate of completion of the course
📃
After completing all the lessons and completing practical tasks, you will receive an official diploma, which you can indicate on your resume.
Choose the right plan
Why choose our course?
PRACTICE
During the course you will not only learn the theoretical basics, but you will also be able to immediately apply your knowledge in practice. At the end of the course you will be ready for paid projects.
COMFORT
You get 24/7 access to training materials, where you can view all video lessons, practical exercises and download useful resources at any time.
COLLABORATION
Studying alone is no fun. We've created a chat room for students and mentors where you can always share your experiences, ask questions, or learn from each other!
PORTFOLIO
During the course you will have a lot of practical work that will not only help you hone your skills to perfection, but will also become an important part of your portfolio. This will give you a significant advantage when working with clients.
Corporate
- Groups of 5-10 people
- All learning materials
- Practical assignments
- Bonus module
- Mentor support
- Access for 12 months
- General chat
- Certificate
- All learning materials
- Practical assignments
- Bonus module
- Mentor support
- Access for 12 months
- General chat
- Certificate
$500
VIP
- Curriculum - 22 modules
- Learning materials
- Practical assignments
- Bonus module
- Group chat
- Curators
- Feedback from the mentor
- Access to the course - 12 months
- Certificate
- Learning materials
- Practical assignments
- Bonus module
- Group chat
- Curators
- Feedback from the mentor
- Access to the course - 12 months
- Certificate
$60
Standard
- Curriculum consists of 22 modules
- Learning materials
- Practical assignments
- Bonus module
- Chat with curators
- Access to the course - 4 months
- Certificate
- Learning materials
- Practical assignments
- Bonus module
- Chat with curators
- Access to the course - 4 months
- Certificate
$45
Basic
- Curriculum - 14 modules
- Learning materials
- Practical exercises
- Homework checking
- Access to the course - 1 month
- No certificate
- Learning materials
- Practical exercises
- Homework checking
- Access to the course - 1 month
- No certificate
$30
Introductory
- Curriculum - 2 modules
- Learning materials
- No feedback
- Access to the course - 1 month
- No certificate
- Learning materials
- No feedback
- Access to the course - 1 month
- No certificate
$11
Zhenya V.
The course is great! I got a lot of new knowledge and skills. All assignments were interesting and useful. Now I am confident in my abilities. Thank you to the author for the quality material!
Course Reviews
Vlad V.
Great course! Very informative and accessible. I recommend it to anyone who wants to deepen their knowledge of PostgreSQL. All assignments were interesting and the notes helped further. Thank you to the author for a great job!
Timofey F.
The course exceeded all expectations! The material is presented in a clear and structured way. I am a beginner, but thanks to this course I was able to quickly learn the basics of PostgreSQL. I definitely recommend it!
Artemy S.
Great course for all levels! I was already working with PostgreSQL, but I found a lot of useful information. The assignments were helpful and the notes were a great help.
Anna G.
Very useful course! All the topics are covered in detail, and practical assignments helped to consolidate knowledge. I recommend this course to everyone who wants to become an expert in PostgreSQL.
Answers to frequently asked questions