Working with Rollups and Cubes in PostgreSQL | SQL Basics

Описание: This video is from the course "Master SQL for Data Science"
In this lesson, you'll learn more about working with Rollups and Cubes in PostgreSQL.
=========================================
➡️ Get the complete course today from Job Ready Programmer using the link below:
https://www.jobreadyprogrammer.com/p/...
=========================================
➡️ Learn MORE:
Access all of my software development courses using the discount below: https://www.jobreadyprogrammer.com/p/...
Email me if you have questions: [email protected]
Become Job Ready with our NEW Programming Guide (PDF): https://pages.jobreadyprogrammer.com/...
=========================================
➡️ About the course: Master SQL for Data Science
This course will turn you into a SQL query wizard. You'll learn the skills you need to extract critical insight from data sitting in a database. There are over 100 puzzles scattered throughout the course with in-depth solutions providing plenty of opportunity for you to practice. After completing the course and all of it's assignments, I promise you, you'll never be afraid to look at a large SQL query again.
Just like my other courses, I follow the no-student-left behind principle; which means that I start from the very basics. You do not need any prerequisites to take this course. We move step by step into more advanced topics as we delve into the world of advanced querying techniques using subqueries, aggregations, joins, rollups and cubes, window functions, transposing & ranking data and using conditional expressions in very interesting ways.

➡️ Below are some of the topics you'll learn:
What is a Database, Installing Postgres, Creating Tables
SELECT Statement, WHERE Clause, AND & OR
Filtering Operators, ORDER BY, LIMIT, DISTINCT
Renaming Columns, Functions, GROUP BY & HAVING Clauses
Aggregation Queries, Subqueries, CASE Clause
Correlated Subqueries,
Table Joins, INNER and OUTER Joins,
UNION, UNION ALL and EXCEPT Clauses
Window Functions for Analytics
over 100 puzzles distributed throughout the course
=========================================
➡️ Connect with me:
LinkedIn:   / imtiaz-ahmad-80117324  
Twitter:   / jobreadyproinc  
=========================================
➡️ Job Ready Programmer Socials:
Job Ready Programmer Courses: https://www.jobreadyprogrammer.com/
LinkedIn Page:   / jobreadyprogrammer  
Discord Community:   / discord  
Facebook Page:   / jobreadyprogrammer  
Instagram:   / programmerready  
JRP Blog: https://www.jobreadyprogrammer.com/p/...
JRP Weekly Newsletter: https://pages.jobreadyprogrammer.com/...
Linktree: https://linktr.ee/jobreadyprogrammer
=========================================
#sql #postgresql #database #jobreadyprogrammer #databasedeveloper #softwaredeveloper #career #tableau #databases #webdeveloper #aws #admin #jobready #programmer #postgres