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.
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
AI-POWERED
This course includes
This course includes
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...
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
What You'll Learn
Hands-on experience of database administration, replication, backup, and recovery
Show more
Course Content
Introduction to Database Management System
SQL Basics
Advanced SQL
Administration
Security
Replication
5 Lessons
Performance Tuning
6 Lessons
Backup and Recovery
5 Lessons
Upgrade and Migration
3 Lessons
Course Author
Trusted by 1.4 million developers working at companies
Anthony Walker
@_webarchitect_
Evan Dunbar
ML Engineer
Carlos Matias La Borde
Software Developer
Souvik Kundu
Front-end Developer
Vinay Krishnaiah
Software Developer
Eric Downs
Musician/Entrepeneur
Kenan Eyvazov
DevOps Engineer
Souvik Kundu
Front-end Developer
Eric Downs
Musician/Entrepeneur
Anthony Walker
@_webarchitect_
Evan Dunbar
ML Engineer
See how Educative uses AI to make your learning more immersive than ever before.
Instant Code Feedback
AI-Powered Mock Interviews
Adaptive Learning
Explain with AI
AI Code Mentor