MP4 | Video: h264, 864x472 | Audio: AAC, 44.1 KHz, 2 Ch

Genre: eLearning | Language: English | Duration: 7h 54m | Size: 3.9 GB

By coding along with us in the Workshop, you'll:

Programming our database to take action in response to new record insertions automatically.

Building a dashboard that requires some expensive queries, and then use a materialized view to cache the query result for a performance boost.

Creating prepared statements in our database to avoid the overhead of parsing and analyzing statements on a per-query basis.

Storing collections as values with array and JSON column types

Subscribing to notifications about updates through a pubsub system

Using full-text search to obtain a weighted set of relevant query results based on values in multiple columns

Using simple CLI tools to backup and restore your database remotely

Summary

If you’re interested in building soft-real-time apps, optimizing for database performance, taking extra steps to ensure data integrity, or if you’re responsible for managing and monitoring your company’s databases — this course is for you!

Any Prerequisites?

Completion of SQL Fundamentals course

Students with basic level of comfort and familiarity building a system involving components hosted on different machines will benefit even more than others

Students should have a free Heroku account, or should be prepared to setup their own PostgreSQL database on their local machine