Learn SQL Using PostgreSQL From Zero to Hero

[dkmdkm]

Free Download Learn SQL Using PostgreSQL From Zero to Hero
Last updated 9/2021
Duration: 16h 14m | Video: .MP4, 1920x1080 30 fps | Audio: AAC, 44.1kHz, 2ch | Size: 4.96 GB
Genre: eLearning | Language: English
Master PostgreSQL starting with basics to advanced features like triggers, PL/pgSQL functions, Window Functions and CTE

What you'll learn
Perform sophisticated queries
Join tables together
Use Group By to answer questions on aggregated date
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 software on system.
Computer that can run PostgreSQL ( I will show you 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 use PostgreSQL. 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
Someone wanting to master PostgreSQL and SQL query language
Anyone wanting to learn advanced query expressions
Homepage

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

No Password - Links are Interchangeable

 

[0dayddl]

Learn SQL Using PostgreSQL: From Zero to Hero
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 48000 Hz, 2ch | Size: 6.31 GB​

Genre: eLearning Video | Duration: 181 lectures (16 hour, 7 mins) | Language: English [/center]

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

What you'll learn

Perform sophisticated queries
Join tables together
Use Group By to answer questions on aggregated date
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 software on system.
Computer that can run PostgreSQL ( I will show you 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 use PostgreSQL. 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:

Someone wanting to master PostgreSQL and SQL query language
Anyone wanting to learn advanced query expressions

For More Courses Visit & Bookmark Your Preferred Language Blog
From Here: - - - - - - - -

Download Links

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

Free search engine download: postgresql-from-zero-to-hero