Learn SQL Using PostgreSQL: From Zero to Hero [Udemy Coupon Code]

"When you purchase something through one of the links on our site, we may earn an affiliate commission at no additional cost to you."

Limited offer hurry up

Learn SQL Using PostgreSQL: From Zero to Hero is a top-rated Udemy course taught by Will Bunker — with over 18943+ students enrolled since it launched.

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

Don’t wait! This special offer won’t last long.

Click the button below to Get up to 100% OFF the regular price.

(The discount will be applied automatically at checkout — no code needed!)

Hurry — this discount on Learn SQL Using PostgreSQL: From Zero to Hero won’t be around forever. Take action now!

100% off Udemy coupon code

Why enroll in the Learn SQL Using PostgreSQL: From Zero to Hero Udemy Course?

  • Udemy gives you access to over 250,000 courses and 85,000 expert instructors worldwide.
  • Courses are led by experienced professionals dedicated to delivering a high-quality learning experience.
  • Many of Udemy’s most popular courses have hundreds of thousands of students enrolled.
  • Udemy offers online coupons, promo codes and voucher for the majority of its courses.

Learn SQL Using PostgreSQL: From Zero to Hero Udemy Promotion code

Course Sections
Introduction
Installing PostgreSQL and pgAdmin
Simple Selection of All Records
Using WHERE to Select Records
Schemas
Using psql To Connect To Postgres
Intermediate SELECT Statements
Joining multiple tables together
Grouping and Aggregation Functions
Combining Queries
Subqueries
Modifying Data In Tables: INSERT, UPDATE and DELETE
Indexes and Performance Tuning
Database Design and Normalization
Creating and Modifying Tables
Table Constraints
Sequences
CTE – Common Table Expressions
Views
Conditional Expressions
Using Date/Time In PostgreSQL
Window Functions
Composite Types
SQL Functions and Procedures
Transactions And Concurrency Control
Array Data Type
PL/pgSQL – SQL Procedural Language
Triggers
Importing CSV
JSON and JSONB Data Types
Managing Databases
Backups and Recovery
Security Using Roles, Users and Permissions
Introduction To PostGIS
Thanks and Good Luck
Course Description
Requirements
Basic computer skills.
Ability to install software on system.
Computer that can run PostgreSQL ( I will show you how to install ).

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