SQL and PostgreSQL: The Complete Developer's Guide
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
Who this course is for
- Any developers looking to understand databases
- Application engineers seeking to expand their backend skillset
Download Links
6.85 GB Total Size