Professional SQL

[LeeAndro]

MP4 | Video: h264, 864x472 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 7h 54m | Size: 3.9 GB

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

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

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- 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



DOWNLOAD
uploadgig

https://uploadgig.com/file/download/A97e8d233c193e5c/69bRGbkJ__Profession.part1.rar
https://uploadgig.com/file/download/15c5Def601a77915/69bRGbkJ__Profession.part2.rar
https://uploadgig.com/file/download/bb11108fef7dB305/69bRGbkJ__Profession.part3.rar
https://uploadgig.com/file/download/Ba615b69bf09777B/69bRGbkJ__Profession.part4.rar
https://uploadgig.com/file/download/b86539061a8e4237/69bRGbkJ__Profession.part5.rar

rapidgator

https://rapidgator.net/file/3b8a854b68259bb49d112768ca76ce0e/69bRGbkJ__Profession.part1.rar
https://rapidgator.net/file/c2dbd3ee39c7759608a54c7b823eea3b/69bRGbkJ__Profession.part2.rar
https://rapidgator.net/file/3d0964ea376317a2c8396454c51c9f6a/69bRGbkJ__Profession.part3.rar
https://rapidgator.net/file/8ea8e5f6bba888999550acf8e0234418/69bRGbkJ__Profession.part4.rar
https://rapidgator.net/file/901599bc5da7031afc99645713bd84a8/69bRGbkJ__Profession.part5.rar

nitroflare

http://nitroflare.com/view/CE09CBD0ABEE367/69bRGbkJ__Profession.part1.rar
http://nitroflare.com/view/7FDCE1788952686/69bRGbkJ__Profession.part2.rar
http://nitroflare.com/view/0117B621C348E8E/69bRGbkJ__Profession.part3.rar
http://nitroflare.com/view/B0C8EEB7B577B4E/69bRGbkJ__Profession.part4.rar
http://nitroflare.com/view/79F5762DC40F2A5/69bRGbkJ__Profession.part5.rar