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...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
What You'll Learn
Hands-on experience of database administration, replication, backup, and recovery
See more
Course Content
Introduction to Database Management System
SQL Basics
Personal Expense Tracker Database
Project
Advanced SQL
Administration
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
Trusted by 1.4 million developers working at companies
Anthony Walker
@_webarchitect_
Emma Bostian 🐞
@EmmaBostian
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
Anthony Walker
@_webarchitect_
Emma Bostian 🐞
@EmmaBostian
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