Learn SQL Using PostgreSQL
From Zero to Hero
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
Get a Reminder
| Rating | 4.3★ based on 139 ratings |
|---|---|
| Length | 16 total hours |
| Starts | On Demand (Start anytime) |
| Cost | $15 |
| From | Udemy |
| Instructor | Will Bunker |
| Download Videos | Only via the Udemy mobile app |
| Language | English |
| Subjects | Data Science Programming |
| Tags | Databases Development Database Design & Development |
Get a Reminder
Similar Courses
What people are saying
easy to follow
Easy to follow, with enough exercises that retention is a breeze.
OK yes it was match for me easy to follow You can try to bring all concepts that we can found in MS SQL SERVER /ORACLE like stored procedures, functions etcs.
Recommended for beginners Excelent Well explained, well paced, and very easy to follow.
Really great and easy to follow.
Good practical examples are present in the course Was a good course it very detailed and focuses a lot on code for creating stuff and data base setups step by step is good for beginners Ciekawe acz proste informacje Very easy to follow along.
Read more
zero to hero
In a nutshell, in terms of the title 'From Zero to Hero', there must be a way to gradually change a student from amateur to professional, not suddenly make a student a master instead.
The presentation is good but does not make you zero to hero.
Course is to the point and as advertised, zero to hero, to intermediate level, then you can progress from here to more advanced topics such as table partitioning, clustering, etc.
Read more
for beginners
The course is equally good for beginners and advanced users.
Best for beginners.
by the end of the course i had a good understanding on whats going on and what to do Great course for beginners, a important foundation I recommend.
Read more
really good course
very basic info which is same as oracle plsql Very structured and in-depth course Really good course to build your knowledge from absolutely scratch to proficiency Not really a Postgres course as mush as a general database course with a Postgres focus.
Really good course for anyone wanting to learn how to use PostgreSQL.
Read more
recommend this course
I would recommend this course to anyone wanting to learn PSQL.
I recommend this course to anyone who wants to learn SQL/ PostgreSQL.
Read more
so far
The course has focused on exactly what's been promised so far.
I'm more than happy with the quality so far.
But so far this course is beyond impressive!
So far very good.
So far so good!
The course is clear yes a good match super good Because the course is very good I like it so far NA I love the course There were several missing pieces with the ubuntu installation it seems...
Read more
more advanced
I've been reassured by employers that it's more advanced content than most people need.
It introduces the basics and then builds on them once you get to the more advanced stuff.
Hope for some more Advanced topic as Tiggers and stored procedure.
Read more
very clear
Good Very clear, quite well made videos.
Very clear and polished presentation.
I know SQL Server and I haven't learned anything new yet I think the lecturer is very good.. very clear and comprehensive Very Complete!
Read more
anyone wanting
This course is great for anyone wanting to get familiar with basic SQL queries, regardless of the platform.
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Learning Analyst (Learning and Development) $53k
Learning and Development Specialist, Learning and Development $61k
SQL Deveoloper $63k
Learning Chair $78k
SQL Specialist $81k
T-SQL Programmer $83k
SQL/T-SQL Developer - Investment Firm $84k
SQL Technician $86k
Learning Specialist-Learning and Development Consultant 3 $92k
SQL Administrator $100k
Senior Learning Specialist, Learning and Development $102k
SQL Server | BI SQL Server developer $108k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
| Rating | 4.3★ based on 139 ratings |
|---|---|
| Length | 16 total hours |
| Starts | On Demand (Start anytime) |
| Cost | $15 |
| From | Udemy |
| Instructor | Will Bunker |
| Download Videos | Only via the Udemy mobile app |
| Language | English |
| Subjects | Data Science Programming |
| Tags | Databases Development Database Design & Development |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course
