Master Your PostgreSQL Skills So You Can Write Better SQL
A step-by-step program to help you take your PostgreSQL skills to the next level and become the go-to PostgreSQL expert in your team.
Before I tell you all about this program, let's make sure you're a good fit.
If you are:
- A database developer or professional who wants to improve their PostgreSQL skills so you can contribute better to your team's and company's projects.
- A data analyst who wants to better understand the PostgreSQL database, so you can write better code and make the most of your analysis.
- A software developer that works with PostgreSQL and wants to know how to write better SQL to simplify their application code.
You're in the right place!
PostgreSQL Mastery will build on your SQL knowledge and help you be more effective working with PostgreSQL.
By the end of this program,
you will…
-
Group Your Data Exactly How You Want
You'll be able to group your SELECT query results in the combinations that you want, saving time and prevent having to run multiple -
Understand the Power of Window Functions
You'll be clear on what window functions are and how they can be used in PostgreSQL to enhance your code. -
Know How to Work with JSON
You'll learn a range of features for working with JSON data within PostgreSQL. -
Understand Advanced CTE Concepts
You'll learn how to work with nested CTEs and recursive CTEs, so you can simplify your code and get the results you need in a single query. -
Get Comfortable with the Command Line
You'll learn how to use psql, the command-line tool for PostgreSQL, so you can be comfortable using it for SQL and psql-specific commands.
"Ben has simplified sub-queries for me, regex, and many other topics. I feel slow when reading a lot of explanations off the internet, but his explanations are so clear, they make these topics easy to understand."
Nancy T, Database Star Academy member
Your explanations are so clear and concise that you don’t need to go on and on and on as I have heard others do.
- Donna M
The brevity of lessons are more manageable and the progression is well designed.
- Merri H
I have learnt a lot by following your site which cannot be described in words. Examples given after each topic are very useful. The videos are simple, informative and easy to understand.
- Korlahalli S
What’s Inside PostgreSQL Mastery
Module 1
Advanced Grouping
We start with the GROUP BY keyword, reviewing what it is for, and then some advanced ways it can be used.
Module Highlights:
- Load the sample database used for this course.
- Understand how to use GROUPING SETS, CUBE, ROLLUP, and more.
- How to filter the results of an aggregate function when grouping
Module 2
Window Functions
This module will show you what a window function is, and then go deep into the advanced features such as frames and window clauses.
Module Highlights:
- Review the basics of a window function.
- Learn three ways of ranking results and how they are different
- Improve your code by using window clauses
- Why and how to refer to data in other rows
Module 3
Pivot and Unpivot
Pivoting data is a common request when working with SQL. Learn how to do it in this module.
Module Highlights:
- Creating a simple pivot output using SQL.
- Using an alternative method for pivoting.
- Reversing the pivot results, or "unpivot".
Module 4
CTEs
Common Table Expressions are a handy SQL feature, so we'll learn all about them in this module.
Module Highlights:
- Review what a CTE is and how it can help you.
- Call a CTE from within another CTE: how and why.
- What a recursive CTE is, why use one, and how to write one in PostgreSQL.
Module 5
Data Types
PostgreSQL has a range of data types, some of which are SQL standard and some are PostgreSQL specific. Learn what they are in this module.
Module Highlights:
- Learn about the different text, number, and date data types and which ones to use.
- Understand how to work with boolean data.
- Learn what "ranges" are and how they can help.
Module 6
JSON
You'll learn all about JSON (JavaScript Object Notation) and how to work with it in PostgreSQL in this module.
Module Highlights:
- How to store JSON data in a table.
- How to insert simple and complex JSON values, objects, and arrays.
- Extract and filter on attributes within JSON fields.
- Translate JSON data into multiple rows of results.
Module 7
Lateral Joins
A relatively new feature, you'll learn what Lateral Joins are and how to use them.
Module Highlights:
- What a lateral join is and how it can help.
- How a lateral join compares to other approaches.
- How to use a left join with a lateral join.
Module 8
PSQL
The command-line tool, PSQL, is simple to use and has some specific commands. Learn how to use it in this module.
Module Highlights:
- What PSQL is and how to connect to your database using PSQL.
- How to create a user-defined function.
- How to execute a user-defined function.
Module 9
Transactions
Transactions are at the core of how a database operates. Learn what they are and how to work with them in this module.
Module Highlights:
- What are transactions and how they can help.
- How to start and end a transaction in PostgreSQL.
- How locks and deadlocks work in PostgreSQL.
Module 10
Extensions
There are ways to add more functionality to PostgreSQL, and you'll learn how in this module.
Module Highlights:
- What an extension is and why use them.
- How to add and remove an extension from PostgreSQL.
- How to use your extension.
When you enroll during this special, limited time period,
you’ll get:
PostgreSQL Mastery
-
10 Modules
A step-by-step roadmap to follow to take your PostgreSQL skills to the next level and become the go-to PostgreSQL expert in your team.
-
Comments for Questions and Answers
You'll have access to the built-in comments where you can ask questions to me and other members, and provide answers on other posts.
Plus These Bonuses to Help You Improve Your PostgreSQL Skills
Bonus 1
SQL Scripts
A collection of SQL files used in the course and as extra support to help you save time.
What You’ll Get:
- SQL scripts used within each lesson, so you can save time when following along rather than typing what you see on the screen.
Bonus 2
Complete Course PDF
A PDF file with the complete course included, so you can read it offline and use as a reference.
What You’ll Get:
- A single PDF with all lessons included, so you can refer to it in the future
- PDF includes screenshots and SQL so you know what scripts and screens are being referenced
Bonus 3
Exercises PDF
A PDF file with all of the exercises in the course, so you can refer to it when practicing what you learn.
What You’ll Get:
- A single PDF with all exercises included, so you can refer to it in the future.
30-Day Money Back Guarantee
I'm very confident that this course can help you improve your PostgreSQL skills.
If you enrol in this course, and are not satisfied, let me know within 30 days of enrolling and I'll provide a refund for you.
Frequently Asked Questions
How much SQL should I know before I take this course?
Which SQL vendors/databases is this for?
What tools or software do you use in the course?
My team doesn't use PostgreSQL. Will this help me?
I don’t have the time to learn
I don’t have regular opportunities to practice this, so I forget what I need to do
Do I get access to all of the lessons at once?
What if I have questions during the course?
I have unreliable internet so it’s hard for me to watch the videos
Do you offer refunds?
Can you remind me of everything I’m getting when I sign up today?
Still thinking about it?
You should give PostgreSQL Mastery a 30-day risk-free shot if you're motivated by any of the following:
- You know the basics of SQL and want to take your PostgreSQL skills to the next level.
- You work with PostgreSQL and want to understand the features of PostgreSQL better.
- You work on an application that uses PostgreSQL and want to improve your application code and how it uses the database.
- Ready to take the actions needed to improve your PostgreSQL skills.
I can’t wait for you to join PostgreSQL Mastery
I created this course because learning the advanced PostgreSQL concepts can really help you in your career.
So much of the material out there is hard to follow and goes into more detail than you need to know.
As someone who works with PostgreSQL, improving your skills is more than just learning generic SQL. You'll be better off to learn how the advanced SQL features work in PostgreSQL, some PostgreSQL-specific features, and then practice what you have learned.
Knowing how to make the most of a PostgreSQL database will serve you for years to come.
All it takes is a small investment in your education, and practicing the strategies highlighted in the course.
You're in the right place, and this is the course for you.
There's no risk to joining, with my 30-day money back guarantee.
I hope to see you inside.
Ben Brumm
