Learn SQL Using PostgreSQL: From Zero to Hero (Udemy.com)

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

Created by: Will Bunker

Produced in 2021

icon
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

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100

icon
Course 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

icon
Instructor Details

placeholder

Dave Kennedy and I started what became the largest dating site of the 90's, from a telephone closet at an insurance company. I taught myself from the ground up how to build a site that became one of the top 100 visited sites by 1999. Since then, I have helped found several more businesses and invested in over 160 tech companies.
I love to learn new stuff and have a found a way to reach my dreams by learning the latest technologies. You can too. I've helped dozens of others learn how to build their own companies by learning to code and deploy technologies to solve real problems.
I am going to put together a series of courses that will cover everything from prototyping, then building an MVP, and finally scaling into the cloud when your company takes off.
Every piece that you master becomes one more tool in your toolkit to make that idea a reality. Even better, every skill gives you a new way to earn money in the workplace.
Getting certification was my path into a lifelong career in tech startups. I had a job running a gold mine in Nicaragua. This position involved my physically carrying huge amounts of gold from Managua to Miami every two weeks. I wanted to find another way to make a living ( I had panic attacks from the stress.) I would pick up a Novell Network Certification book in Miami, study every day in the jungle back in Nicaragua. Then I would take the certification test next trip stateside. After receiving my certification as a Novell Network engineer, I q

icon
More postgresql courses

Rock the JVM! Akka Persistence with Scala

$11.99

Practical SQL Bootcamp for Data Analysts and Data Scientists

$11.99

The Complete SQL Bootcamp: Go from Zero to Hero

$159.99

SQL for NEWBS: Weekender Crash Course

$139.99

SQL and PostgreSQL: The Complete Developer's Guide

$139.99

Python Django Dev To Deployment

$74.99

icon
Reviews

4.5

285 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Venkata Bollimuntha on 11/14/2020

Its really well detailed and well explained.

By Pritam Chatterjee on 11/14/2020

ok

By Mariska Marnane on 11/14/2020

easy to follow

By Wiktor Gonczaronek on 11/14/2020

I came here knowing "something" about SQL, but mostly working on ORMs in my job. I wanted to enhance my knowledge and understand better what does the ORM hide from me and how to use it better. This course has fullfilled my expectations.
There are a few drabacks. Some are minor, like audio quality (the sound of hitting keys may be annoying), some are more serious like the fact that sometimes the course is a bit like documentation - topic 1, topic 2, topic n. Sometimes I had a feeling that my knowledge doesn't build up and I'm about to forget previous lessons. The difficulty was rather steady.
However, I must say that topics that did interest me most like optimization were well explained. I learned how to read plans, how to use indexes etc. I had a feeling that Will really has decent experience with what he does.
To sum up, I do recommend this course. One just needs to keep in mind that some topics will need a lot of own work outside of it. So to answer the "hope you enjoyed it" - yes Will I did. Thank you ;-)

By Oyesh Mann Singh on 11/7/2020

pgadmin installation took me a while

By Maksym Dukov on 11/7/2020

Invaluable course. Lots of material in a nice and structured form.
Nitpicks:
1. I wish example tables were smaller and had fewer columns. That would spare us from typing lots of fields.
2. It would be nice to see a bit more detailed explanations on some hard topics such as recursion.

By Frank van der Pluijm on 10/26/2020

Although one might wonder how an SQL course be really entertaining, I feel in this course there is no effort to make that any better. The repetitiveness is really bothering me, the examples too dry and uninspiring. Will not follow through here.

By George Phillip Scott on 10/24/2020

The explanations are clear and it is easy to follow

By Marlene Dennison on 10/22/2020

Good info.

By Rakesh Yadav Thati on 10/19/2020

Good Examples
Included all basic concepts for better understanding

By Emmanuel GUERIN on 10/9/2020

J'ai appris beaucoup de choses que je ne connaissais pas en SQL et dcouvert Postgresql que je ne connaissais pas. Je peux dire qu'avec ce cours je suis l'aise pour envisager d'utiliser Postgresql . Les cours sont clairs, dtaills avec beaucoup de pratique et d'exemples. Je suis trs satisfait de ce cours!

By Trevor J Nelson on 10/5/2020

The instructor reminds me of every teacher and professor that enjoyed having during my school career. He is smooth, concise, and adds just enough relevant information at the right time to constantly be growing in knowledge. The learning path so far has been building great and I expect the rest of the course will be wonderful as well. I really enjoy this dude. This probably goes for other SQL courses, but I also have to say, that this is one of the easiest courses Ive taken in udemy. Not in terms of the level of challenge, but the ease of crushing sections and not getting ADHD. This course works like constant conversation. You have multiple wins in every single video. This feel like I've picked up a book that is truly addictive and I cant put it down.