YoVDO

Learn SQL Using PostgreSQL: From Zero to Hero

Offered By: Udemy

Tags

PostgreSQL Courses SQL Courses Table Joins Courses

Course Description

Overview

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

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


Taught by

Will Bunker

Related Courses

Achieving Advanced Insights with BigQuery - Français
Google Cloud via Coursera
Database Administration and SQL Language Basics
A Cloud Guru
SQL Deep Dive
A Cloud Guru
Using Python for Data Management and Reporting
A Cloud Guru
نمذجة البيانات المتقدمة
Meta via Coursera