Mastering PostgreSQL Databases: From Basics to Advanced

Beginner

56 Lessons

11h

Certificate of Completion

This course is designed for beginners with little or no knowledge of databases or SQL. It will provide them with a solid foundation to start using PostgreSQL.

AI-POWERED

Explanations

This course includes

2 Projects

1 Assessment

172 Playgrounds

8 Quizzes

84 Illustrations

This course includes

2 Projects

1 Assessment

172 Playgrounds

8 Quizzes

84 Illustrations

Course Overview

PostgreSQL is a popular relational database management system. This course offers many features—from fundamental commands to advanced functionalities within PostgreSQL. You will learn simple queries, data definition, and data manipulation through SQL. You’ll be taught how to work with complex data types, regular expressions, views, indexing, and stored procedures. You’ll also learn about transaction control, administration, security, replication, and performance tuning. Following that, you’ll gain insight...Show More

TAKEAWAY SKILLS

Sql

Database

What You'll Learn

Hands-on experience of database administration, replication, backup, and recovery

An understanding of SQL queries to retrieve and manipulate data

A working knowledge of performance tuning, security, and migration in PostgreSQL

An understanding of query performance and improvement through indexing

Familiarity with advanced features like JSON data types and GIS functionality

The ability to perform upgrade and patching of PostgreSQL databases

Course Content

Introduction to Database Management System

Introduction to the Course Overview of Databases Types of Databases Relational Databases What is PostgreSQL?Quiz on Introduction to DBMS

SQL Basics

Overview of SQL

Basic Data Definition Commands Advanced Data Definition Commands to Alter Tables Advanced Data Definition Commands to Alter Columns Data Types in SQL Retrieving Data from Tables Arithmetic and Comparison Operators in SQL Logical Operators in SQL Data Manipulation Commands Data Presentation Using Indexes to Improve Query Performance Quiz on SQL Basics

Personal Expense Tracker Database

Project

Advanced SQL

Working with Complex Data Types Regular Expressions in SQL Working with Views in PostgreSQL Stored Procedures and Functions Triggers Sequences Transactions, Locks, and Deadlocks Quiz on Advanced SQL

Administration

Architecture of PostgreSQL Configuring the PostgreSQL Server Routine Database Maintenance in PostgreSQL Quiz on PostgreSQL Administration

Security

Overview of PostgreSQL Database Security Securing PostgreSQL Installation Granting and Revoking Privileges Using Data Encryption Quiz on PostgreSQL Security

Replication

5 Lessons

Performance Tuning

6 Lessons

Designing an Online Retail Store

Project

Backup and Recovery

5 Lessons

Upgrade and Migration

3 Lessons

PostgreSQL Assessment

Assessment

Appendix

2 Lessons

COURSE AUTHOR

How You'll Learn

You don’t get better at swimming by watching others. Coding is no different. Practice as you learn with live code environments inside your browser.

Videos are holding you back. Educative‘s interactive, text-based lessons accelerate learning — no setup, downloads, or alt-tabbing required.

Learn faster and smarter with adaptive AI tools embedded in every Educative course.

Built-in assessments let you test your skills. Completion certificates let you show them off.

Recommended Courses

BEFORE STARTING THIS COURSE

AFTER FINISHING THIS COURSE

FOR TEAMS

Interested in this course for your business or team?

Unlock this course (and 1,000+ more) for your entire org with DevPath