SQL and PostgreSQL: The Complete Developer’s Guide

SQL and PostgreSQL: The Complete Developer’s Guide
Last updated 10/2024
22h 13m | MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz, 2 Ch | 5 GB

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

What you’ll 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

Description
Who this course is for
Any developers looking to understand databases
Application engineers seeking to expand their backend skillset