PGS-01 · Advanced
PostgreSQL and MySQL in depth
Run relational databases like a database engineer: schema design, indexes, query plans, transactions, backups and replication on PostgreSQL and MySQL.
- Self-study hours
- 37
- Class hours
- 32 (12 at beginner depth)
- Lessons
- 11
- Free certifications
- 2
- Library resources
- 7
✓ All 11 lessons expert reviewed
What you will be able to do
- Design normalised schemas and write advanced SQL with joins, windows and CTEs
- Read query plans and fix slow queries with the right indexes
- Back up, restore, secure and monitor a production database
Sign up free to see the lessons, project and free certifications
It takes a minute with your email. AiTeky Pass (₹999/month or ₹9,999/year) is free for your first 30 days.