Courses/PostgreSQL Mastery
Beginner15 hours12 topics

PostgreSQL Mastery

Master SQL and database design with PostgreSQL. Learn from fundamentals to advanced topics including normalization, complex queries, performance optimization, and database administration through hands-on labs.

Course Content

1

Introduction to Databases

Understand what relational databases are, why they matter, and get familiar with PostgreSQL and SQL basics.

45m
1Welcome to PostgreSQL Masterypresentation5m2Database Fundamentalslesson15m3Exploring the PostgreSQL Labinteractive-workshop4Database Fundamentals Quizquiz
2

Basic SELECT Queries

Master the fundamentals of retrieving data with SELECT statements, filtering with WHERE, and sorting results.

60m
1SELECT Statement Fundamentalslesson15m2SELECT Practice Workshopinteractive-workshop
3

Filtering and Functions

Learn advanced filtering techniques with operators and explore PostgreSQL's powerful built-in functions.

60m
No content available
4

Aggregation and Grouping

Analyze data using aggregate functions and learn to group and filter aggregated results.

60m
No content available
5

Database Design Fundamentals

Learn the principles of database design including entities, relationships, and ER diagrams.

75m
No content available
6

Database Normalization

Master the art of database normalization to eliminate redundancy and ensure data integrity.

90m
No content available
7

Tables and Constraints

Learn to create database tables with proper constraints to ensure data integrity.

75m
No content available
8

Data Manipulation

Master INSERT, UPDATE, and DELETE operations to modify data in your tables.

60m
No content available
9

SQL Joins

Learn to combine data from multiple tables using INNER, LEFT, RIGHT, FULL, and CROSS joins.

90m
1Understanding SQL Joinslesson20m2SQL Joins Workshopinteractive-workshop
10

Subqueries and CTEs

Write powerful nested queries and organize complex queries with Common Table Expressions.

75m
No content available
11

Indexes and Performance

Optimize query performance using indexes and learn to analyze query execution plans.

75m
No content available
12

Advanced Features

Explore advanced PostgreSQL features including views, triggers, stored procedures, and transactions.

90m
No content available

What you'll learn

  • Understand what databases and RDBMS are
  • Learn key relational database concepts
  • Get familiar with PostgreSQL and its features
  • Connect to PostgreSQL and explore sample databases
  • Write SELECT statements to retrieve data
  • Use WHERE clauses to filter results

Tags

postgresqlsqldatabaserelational-databasenormalizationdata-modeling