Storing and Managing Data with Postgres on Heroku
This course will teach you to set up Postgres on Heroku efficiently, so you can build robust data-driven applications.
What you'll learn
Setting up a safe, secure, and fast database is critical for any application. In this course, Storing and Managing data with Postgres on Heroku, you’ll learn how to efficiently store your data so it remains available for growing applications. You will begin this course with an introduction to Heroku Postgres. Following that, you’ll explore setting up a database for Heroku App. Next, you’ll discover managing backup, restore, and high availability of Postgres Database. Finally, you’ll learn how to manage and upgrade Heroku Postgres. By the end of this course, you'll have the skills and knowledge of postgres needed to build a database application on the Heroku platorm.
Table of contents
- Introduction 1m
- What Is Heroku? 2m
- What Is Postgres? 2m
- Heroku Postgres 3m
- Setup DVD Store Database Online 2m
- Demo: Installing Heroku CLI 3m
- Demo: Set up Postgres on local OS 4m
- Demo: Set up pgAdmin on local OS 3m
- Demo: Creating New App on Heroku Portal 2m
- Demo: Configuring Postgres Plugin 2m
- Demo: Connecting to Heroku Postgres 7m
- Demo: Setup Sample Database Pagila 3m
- Summary 1m
- Introduction 2m
- Real-world Scenario 1m
- Types of Backup on Heroku Postgres 2m
- Demo: Database Backup 6m
- Demo: Database Restore and PGBackups Commands 9m
- Choosing the Right Heroku Postgres Plan 5m
- Demo: Migrate/upgrade Database Plans 4m
- Demo: Physical Backup - Fork Command 7m
- Demo: Physical Backup - Follow Command 8m
- Postgres High Availability 3m
- Summary 2m
About the author
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 81 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.