Learn SQL Using PostgreSQL: From Zero to Hero | Udemy
English | Size: 6.29 GB
Category: Tutorial
Learning SQL was one of the most valuable skills I learned while creating Match. We had one of the largest instances of Microsoft SQL Server in the 90s with millions of records to keep the site running. The better we get at SQL, the better we can make the site work for our users and answer difficult questions.
I want to teach you how to use PostgreSQL. We’ll get through
Concatenating multiple tables together
Grouping records to get aggregated data
Inserting, updating and deleting records
Creating tables and indexes
Subqueries for creating complex reports
Table Constraints to Maintain Data Purity
Sequences for creating auto-incrementing fields
CTE – common table expressions including recursive queries
Views for easy access to complex queries
Conditionals for Queries
Window functions for combining regular queries with aggregated data
How to work with date, time and intervals
Creating SQL functions to capture complex statements
Create PL / pgSQL Functions That Allow Programming With If / Then and Loops
Triggers
Array data types
Composite data types
Transaction and Concurrency Management
DURATION 16:04:40
NUMBER OF LESSONS 174 videos
TONGUE English
RELEASE DATE 13/11/2019
RAPIDGATOR
rapidgator.net/file/6caaac83721cefed76c39bfc4cdbc761/Learn_SQL_Using_PostgreSQL_From_Zero_to_Hero.part01.rar.html
rapidgator.net/file/69dd158ffe30a72a7589817ea849f344/Learn_SQL_Using_PostgreSQL_From_Zero_to_Hero.part02.rar.html
rapidgator.net/file/2d6144ee5c2d4c70fd93a1d31b77adcb/Learn_SQL_Using_PostgreSQL_From_Zero_to_Hero.part03.rar.html
rapidgator.net/file/64f9f3d0656f729c424bcdad91ab400c/Learn_SQL_Using_PostgreSQL_From_Zero_to_Hero.part04.rar.html
rapidgator.net/file/8c1307fbd68e7640fd5891114c98e198/Learn_SQL_Using_PostgreSQL_From_Zero_to_Hero.part05.rar.html
rapidgator.net/file/3756a3f43034f5689125dccc307f83ad/Learn_SQL_Using_PostgreSQL_From_Zero_to_Hero.part06.rar.html
rapidgator.net/file/ede625217e39da827ca04ef6b85d4876/Learn_SQL_Using_PostgreSQL_From_Zero_to_Hero.part07.rar.html
rapidgator.net/file/2bb5591536322946d86288e8240af711/Learn_SQL_Using_PostgreSQL_From_Zero_to_Hero.part08.rar.html
rapidgator.net/file/cb77cef92d2acff7c2fd9ecd4ff4f105/Learn_SQL_Using_PostgreSQL_From_Zero_to_Hero.part09.rar.html
rapidgator.net/file/ed3ffc1ee56ec88970df42d055f2a406/Learn_SQL_Using_PostgreSQL_From_Zero_to_Hero.part10.rar.html
NITROFLARE
nitroflare.com/view/0A3497131DE38EE/Learn_SQL_Using_PostgreSQL_From_Zero_to_Hero.part01.rar
nitroflare.com/view/4488FC4577212F4/Learn_SQL_Using_PostgreSQL_From_Zero_to_Hero.part02.rar
nitroflare.com/view/D72BE3B2E56D583/Learn_SQL_Using_PostgreSQL_From_Zero_to_Hero.part03.rar
nitroflare.com/view/D31AA9E4E2A5C81/Learn_SQL_Using_PostgreSQL_From_Zero_to_Hero.part04.rar
nitroflare.com/view/48888C84300C0C5/Learn_SQL_Using_PostgreSQL_From_Zero_to_Hero.part05.rar
nitroflare.com/view/656A1125610737F/Learn_SQL_Using_PostgreSQL_From_Zero_to_Hero.part06.rar
nitroflare.com/view/C08D59F11877C0D/Learn_SQL_Using_PostgreSQL_From_Zero_to_Hero.part07.rar
nitroflare.com/view/87442EBC267F80B/Learn_SQL_Using_PostgreSQL_From_Zero_to_Hero.part08.rar
nitroflare.com/view/72A91AF860BB348/Learn_SQL_Using_PostgreSQL_From_Zero_to_Hero.part09.rar
nitroflare.com/view/5299C4D527386A9/Learn_SQL_Using_PostgreSQL_From_Zero_to_Hero.part10.rar