2022-Basics of SQL using PostgreSQL

Become an expert with SQL and PostgreSQL! Store and fetch data, tune queries, and design efficient database structures!

Created by: Stephen Grider
Engineering Architect

What Will I Learn?

• Master the fundamentals of relational databases
• Acquire the skills necessary to obtain a database administrator (DBA) or database developer job
• Design fast and efficient databases using the latest technologies
• Practice your skills with many quizzes, projects, and built-in exercises
• Learn and apply multiple database design patterns
• Optimize queries for superb read and write efficiency
• Understand how PostgreSQL stores information at the hardware level
• Connect PostgreSQL to front-end apps using an API
• Build common app features, such as a 'like' and 'mention' systems
• Handle complex concurrency issues and race conditions
• Advance your database designs using schema migrations
• See how to use PostgreSQL to speed up automated tests

Requirements

• A Mac, PC, or Linux-based Computer

Target audience

• Any developers looking to understand databases
• Application engineers seeking to expand their backend skillset