Mastering PostgreSQL: Learning By Real Examples

This is a course intended for software engineers and data analysts that want to learn more about Relational Databases and SQL It covers both basic and advanced SQL concepts and theories. The course is intended for both Junior and Senior Level Engineers and is purely focused on SQL and writing queries.

PostgreSQL will be used in this course. But the theories you learn can be applied in any Relational Database such as SQL Server or MySql

All the sections are explained by one or more examples. I used a sample database that had students, courses, registrations and instructors records. Learning by doing examples is a much better technique than just studying a theory.

This course contains lectures and exercises. You'll get immediate practice on all of the different topics and features that you learn!

You will learn about:

• Selecting Data

• Aggregate Functions

• Built in Functions

• Joins

• Dates

• Schema and Data

• CRUD Operations

• Transactions

• Arrays in Postgres

• JSONs in Postgres

• And More!

Data is the core of an application. Any application that you see on your phone or on your website uses some storage somewhere. Having a good database design and queries is very crucial for any application. This course focuses mainly on the querying part.

At the end of the course, you should be able to:

1. Master basic query syntax and functionality: Students will learn the syntax of basic SQL queries, including SELECT, FROM, WHERE, GROUP BY, and ORDER BY. They will also gain an understanding of how to filter and sort data, and how to use basic functions and operators.

2. Develop proficiency in advanced querying techniques: Students will learn how to write more complex queries, including subqueries, inner and outer joins, and aggregations. They will also learn how to use advanced functions and operators such as CASE statements, window functions, and regular expressions.

3. Optimize queries for performance: Students will learn how to optimize queries for faster execution, including indexing strategies, query planning and execution, and common performance issues to avoid.

4. Apply queries to real-world scenarios: Students will learn how to apply their query skills to solve real-world problems. They will also explore best practices for data modeling and query design to ensure their queries are accurate and efficient.