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 2020

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 : 96 / 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

*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

icon
Instructor Details

Will Bunker

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
Reviews

4.8

50 total reviews

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

it's a comprehensive courseI learnt a lot from itHowever, I think it could place more emphasis on the parts that we should pay special attentionand caveats on what could go wrong in day to day real applicationsomething like this link https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=2ahUKEwi8k6SGy4fnAhVEuZ4KHXu9DAgQFjAAegQIBRAB&url=https%3A%2F%2Fwiki.postgresql.org%2Fwiki%2FDon%2527t_Do_This&usg=AOvVaw38sOnVDDmB9mtMTK10hqaGand thishttp://leopard.in.ua/2016/09/20/safe-and-unsafe-operations-postgresql

This course was helpful in that I needed to learn a lot of the concepts taught in the course, for the new job that I got.

Good course, lots of coverage for PostgreSQL. Good teacher, I like all the opportunities to try each concept myself, with a walkthru guide on the answers. My only critique would be I wish there was more in depth explanations on 'why'. This course covers WHAT to do, but not a lot of WHY you do it that way. All in all a good course for sql.

Hard to see code elements such as parenthesis and brackets in the video.

The course was well structured and the examples and the exercises provided in the course were very useful. I particularly liked the presentation of syntax differences between Postgres and other databases where relevant and also the lesson on query cost computation. Great job!

By I S on

Probably the best course out there on PostgreSQL. Very detailed, engaging, and to the point! Good for both beginners and intermediate users. Highly recommended!

It is a fantastic training that covers all you need to know to start working with PostgreSQL and SQL language. Thanks

Es un buen curso, muy completo y un buen material para iniciar a utilizar postgres. Me hubiera gustado que incluyera temas sobre replicacin, tal vez ms adelante puedan incluirlos.

It was all very straight, quick, and to the point. I've been reassured by employers that it's more advanced content than most people need.

This course helped me to learn and apply knowledge to my job directly, Which helped me in my career a lot. Thanks will for this awesome course.

El Contenido del curso es muy bueno y muy completo, el Instructor me resolvi mis dudas de una una manera muy amable y una respuesta rpida y adems me incluy otros temas que necesitaba para un proyecto le agradezco mucho su atencin.

El profesor explica con buena pedagoga, de lo simple a lo complejo, felicitaciones. Buen curso.Gracias por compartir sus conocimientos.