SQL Mastery From Zero to Superstar (Updated 52019)

[Prohibitive]

Created by Will Bunker | Video: 1280x720 | Audio: AAC 48KHz 2ch | Duration: 15:15 H/M | Lec: 165 | 5.72 GB | Language: English | Sub: English [Auto-generated]

Master PostgreSQL starting with basics to advanced features like triggers, PL/pgSQL functions, Window Functions and CTE

What you'll learn
Query databases and answer business question
Perform joins across multiple tables
Use Group By to generate aggregate data
Create and modifying tables
Create indexes to improve search speed
Put in constraints to keep data clean
Use pgAdmin tool
Learn recursive queries
How views make accessing data simpler
Subqueries
Sequences to auto increment fields
Common Table Expressions
Conditional Expressions
Window Functions
How to handle date and time data
SQL Functions
Transactions and Concurrency Control
PL/pgSQL Functions
Triggers
Composite Data Types
Array Data Types

Requirements
Basic computer skills
Ability to install basic software on your system
Computer that can run PostgreSQL database (I will show how to install.)

Description
Learning SQL was one of the most valuable skills I learned while building 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 got at SQL, the better we could make the site work for our users and answers sophisticated questions about our users.

I want to teach you how to start talking to databases through SQL, the universal language of SQL databases. We will walk through

Basic selection statements

Joining multiple tables together

Grouping records to get aggregate data

Inserting, updating and deleting records

Creating tables and indexes

Subqueries to create sophisticated reports

Table constraints to keep data clean

Sequences to create auto incrementing fields

CTE - common table expressions that include recursive queries

Views to simply accessing complex queries

Conditional Expressions for queries

Window functions to combine regular queries with aggregate data

How to work with date, time and intervals

Create 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

Transactions and concurrency control

Who this course is for?
Anyone needing to talk to a database
Entrepreneurs trying to build their MVP
Anyone wanting to learn advanced query expressions
Homepage

Screenshots

Buy Premium Account for Download With Full Speed:

rapidgator_net:
https://rapidgator.net/file/0ae9ca11e54c2dc9d30797bd1742d5c7
https://rapidgator.net/file/0de027e9ec3f875ff1c4ed71a2ad2137
https://rapidgator.net/file/6db3ca7bfa49c97e4e4d9e7346988b97
https://rapidgator.net/file/cb61c7e46fa78559ff6c358948bfd3e0
https://rapidgator.net/file/d5ff8c3035134c4f13b0c0ad1b7c2a36
https://rapidgator.net/file/e32d3bc28a784442298542dc13337a25

uploadgig_com:
https://uploadgig.com/file/download/bdB32c55e52084aF/SaNet.LCSQLMasteryFromZerotoSuperstar.part1.rar
https://uploadgig.com/file/download/88d261344424029B/SaNet.LCSQLMasteryFromZerotoSuperstar.part2.rar
https://uploadgig.com/file/download/a8d7726cb846C5f8/SaNet.LCSQLMasteryFromZerotoSuperstar.part3.rar
https://uploadgig.com/file/download/310c731a492cbc99/SaNet.LCSQLMasteryFromZerotoSuperstar.part4.rar
https://uploadgig.com/file/download/5bab1b8f3aEA23bb/SaNet.LCSQLMasteryFromZerotoSuperstar.part5.rar
https://uploadgig.com/file/download/b8f4ed80179e5E5f/SaNet.LCSQLMasteryFromZerotoSuperstar.part6.rar

Links are Interchangeable - No Password - Single Extraction