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

( 285 Reviews )

Created by: Will Bunker

Produced in 2021

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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 90 / 100

Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a postgresql course? Or looking for more detail on Will Bunker's Learn SQL Using PostgreSQL: From Zero to Hero? Feel free to chat below.

Join CourseDuck's Online Learning Discord Community

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

Time: 16h

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

Instructor Details

Will Bunker

4.5 Rating
285 Reviews

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

error finding courses_global jsonerror finding courses_global jsonerror finding courses_global json