Will Bunker
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
Instructor Details
Courses : 1
Specification: Learn SQL Using PostgreSQL: From Zero to Hero
|
22 reviews for Learn SQL Using PostgreSQL: From Zero to Hero
Add a review
| Price | $14.99 |
|---|---|
| Provider | |
| Duration | 16 hours |
| Year | 2020 |
| Level | Beginner |
| Language | English |
| Certificate | Yes |
| Quizzes | No |
$14.99
I S –
Probably the best course out there on PostgreSQL. Very detailed, engaging, and to the point! Good for both beginners and intermediate users. Highly recommended!
Jair Lopes Montoia –
Excelente! Muito conte do, explicado de forma simples e did tica. Recomendo.
Faisal Kaifee –
It was awesome . Learned a lot right from the scratch till the intermediate level.
Hero –
very simple and well taught, everyone can understand. also cover 0 to 100 feature in Postgres. I will definitely turn back for course again.
Umesh Sawant –
very basic info which is same as oracle plsql
Vikas Singh Narwaria –
By far the best course for learning SQL. The depth this course covers is amazing. The course is equally good for beginners and advanced users. Highly recommended!!!
Naga Santosh Kumar Ommina –
Good
Kirill Bezzubkine –
some vids from the course are fast and complex with no details assuming a student has to have some medium background with PGSql
Ezeogu Christopher C –
very helpful material.. have a MS SQL Server background and working with postgresql in my new role .. it has extremely helped a lot. Thanks for putting this together
Ed –
Great detail! Excellent start for those who are brand new to SQL.
Deoraj Ramsaran –
very simple and well presented
Ronald Fernandez Zavala –
.
Du Jinchuan –
good
Sameer Sayed –
Yes the said course was amazing and have learnt alot of commands and knowed what basically this commands means.
Julien Thomazeau –
Started from I think I know quite a lot already to I think there is even more that what I’ve learned Excellent course, it pushed me to go deeper in Postgres documentation and underlying concepts. Lots of examples and exercices.
Kerry Benjamin –
So far this course has been super clear. The instructor knows what he’s doing. The fact that he places mini challenges at the end of each lesson helps you retain the material as well as the challenges at the end of each section. Don’t skip any of these things and keep practicing and SQL will come to you in no time.
Devin Milligan –
So Far so good
Teresa J Mayfield Meyer –
Upon initial install it would be more helpful if the instructor did not already have PostgrSQl installed. I had to work through a couple of steps that were not covered in the course.
Francis Kamuyu –
Excellent, hands on content and presentation.
Srinivasarao Uppalapati –
good
Thomas Lamping –
Guter berblick
Pawe Szczur –
The course is good. I’m just under confident in my skill.