Someone wanted to learn this too, so Grasp built them a personal learning path.
You can keep exploring this one or create your own
SQL: Beginner to Advanced
Recommended resources
The freely available resources this course will direct you to.
- What Is a Relational Database? | Beginner’s Guidewww.youtube.com
- Primary & Foreign Keyswww.youtube.com
- PostgreSQL: Documentation: 18: 5.1. Table Basicswww.postgresql.org
- Data Management with SQL for Social Scientists *alpha*: What is a relational database?www.datacarpentry.org
- Understanding SQL Query Execution - What Happens When You Run A SQL Commandwww.youtube.com
- PostgreSQL: Documentation: 7.3: Architecturewww.postgresql.org
Module 2
Querying and Summarizing Data
Module 3
Combining Data for Analysis
Module 4
Relational Design and Schema Definition
Module 5
Data Changes, Transactions, and Concurrency
Module 6
PostgreSQL Architecture and Configuration
Module 7
Roles, Access Control, and Secure Connections
Module 8
Backup, Restore, and Point-in-Time Recovery
Module 9
Indexes, Query Plans, and Performance Tuning
Module 10
Monitoring and Routine Maintenance
Module 11
Automation, Upgrades, and Replication
Module 12