Learn SQL Using PostgreSQL: From Zero to Hero

Master PostgreSQL starting with basics to advanced features like triggers, PL/pgSQL functions, Window Functions and CTE
4.67 (3551 reviews)
Udemy
platform
English
language
Databases
category
instructor
Learn SQL Using PostgreSQL: From Zero to Hero
18,811
students
16 hours
content
Sep 2021
last update
$79.99
regular price

What you will 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

Screenshots

Learn SQL Using PostgreSQL: From Zero to Hero - Screenshot_01Learn SQL Using PostgreSQL: From Zero to Hero - Screenshot_02Learn SQL Using PostgreSQL: From Zero to Hero - Screenshot_03Learn SQL Using PostgreSQL: From Zero to Hero - Screenshot_04
Related Topics
1368384
udemy ID
10/2/2017
course created date
4/23/2020
course indexed date
Bot
course submited by