Working with Rollups and Cubes in PostgreSQL

No video

Working with Rollups and Cubes in PostgreSQL | SQL Basics

Рет қаралды 67,660

Күн бұрын

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:
www.jobreadypr...
=========================================
➡️ Learn MORE:
- Access all of my software development courses using the discount below: www.jobreadypr...
- Email me if you have questions: info@jobreadyprogrammer.com
- Become Job Ready with our NEW Programming Guide (PDF): pages.jobready...
=========================================
➡️ 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: www.jobreadypr...
LinkedIn Page: / jobreadyprogrammer
Discord Community: / discord
Facebook Page: / jobreadyprogrammer
Instagram: / programmerready
JRP Blog: www.jobreadypr...
JRP Weekly Newsletter: pages.jobready...
Linktree: linktr.ee/jobr...
=========================================
#sql #postgresql #database #jobreadyprogrammer #databasedeveloper #softwaredeveloper #career #tableau #databases #webdeveloper #aws #admin #jobready #programmer #postgres

Пікірлер: 74

@MonteFisto100 2 жыл бұрын

Finally understood it, there's so many bad and overcomplicated explainations out there, but this one is really damn good. Thank you.

@nupurgautam1 4 жыл бұрын

Thanks for sharing this video, it's just the amount of details I needed. Not sure who gave those 3 dislikes, ignore them...

@matteomarinelli3752 4 жыл бұрын

Thank you very much! You were the only one I was able to fully understand, you saved my day ahahah :)

@kiararicketts2971 3 ай бұрын

Great and simple explanation, thank you!!

@Jobreadyprogrammer 22 күн бұрын

Welcome!

@afsananasrin4700 Ай бұрын

Perfectly explained. Thanks for making me understand the concepts clearly.

@Jobreadyprogrammer 22 күн бұрын

Great to hear!

@aqsachappalwala4363 9 ай бұрын

best explanation ever .Thank you

@adamsleuis7794 9 ай бұрын

Man, I love your explanation. You deserve a 👍

@akwamfoneventus6124 6 ай бұрын

This explained it a lot better than my course videos -- some people just teach better without efforts. thank you

@fatenaljabaly3911 2 жыл бұрын

Thank you so much! You really helped me understand the difference between the two.

@user-ko4uv6fg8w 2 жыл бұрын

Thanks a lot! I didnt find appropriate information on russian resourses and decided to visit your channel. This video make cube, rollup and groupping sets more clear for me. So keep on

@acleahcim 6 ай бұрын

Amazing video. Helped me with one of my assignments. Thank you for creating an easy to understand video with real examples.

@Advanced_Learner 4 ай бұрын

many thanks for making it so simple to understand

@ukaszkiepas57 2 жыл бұрын

AWESOME !!! FINALLY UNDERSTOOD :)

@angelopaligutan1665 2 жыл бұрын

Thank you for a concise yet knowledge-packed video! It helped me a lot

@sravanialluri5756 6 ай бұрын

Best Explanation, Thank you so much

@hiraethneko Жыл бұрын

Thanks so much for this!

@Davlet Жыл бұрын

at last someone explained it clearly)

@samyboulos4642 2 жыл бұрын

I love the way you explained it.

@satyendrasingh3805 3 жыл бұрын

one video cleared all the questions that I had in my mind, Great work!

@ranjithparuchuri6463 2 жыл бұрын

thanks for making this video of rollup and cude.

@schaumaul 3 жыл бұрын

this guy is a legend

@kelvinojeda8222 Жыл бұрын

Excellent video.

@sunnysingh8483 2 жыл бұрын

Thanks a lot man. You taught me more then my teacher did in this video. She skimmed over this subject within 3-5 mins at the end of class and I know this will be on the midterm. I find it very stupid for someone to teach us but not teach us if you get what I mean. Nonetheless I'm studying up and hoping I will pass the test with an above than average grade. Thanks.

@jaybee2402 2 жыл бұрын

She possibly taught you a far bigger lesson - women aren't excited by technology, mechanics etc, and therefore don't understand them.

@mahdihabibi1875 Жыл бұрын

Great video. Thanks man 🙏

@Pichler96 9 ай бұрын

very helpful! Thank you :)

@demetridoes 2 жыл бұрын

Amazing video! So much better than my university lecturer. Made so simple to understand

@hydronicrocker 6 жыл бұрын

With GROUP BY GROUPING SETS, why does the () value at the end show first in the output when its the last item in the query?

@iaroslavd.916 2 ай бұрын

Nicely explained, very clear😊

@Jobreadyprogrammer 22 күн бұрын

Thank you 🙂

@alexbarasa3816 3 жыл бұрын

excellent explanation sir. THank you so much for this. Straightforward and educative.

@Doshvari 4 жыл бұрын

Thank you , that was very good

@lenaso4555 2 жыл бұрын

Thank you very much for explaining the topic so easily!!

@paulfunigga 2 ай бұрын

Bro, this is very good, thank you for enlightening me!

@Jobreadyprogrammer 22 күн бұрын

My pleasure!

@saki23_220 3 ай бұрын

Perfect

@estleexin7584 Жыл бұрын

very nice explaination

@kamilyaka3406 11 ай бұрын

Very good explanation, thank you.

@NirajPRoxx 6 жыл бұрын

Thank you so much, that was very detailed explanation. Got very confused when my teacher explained it.

@ASWood95 Жыл бұрын

Well explained thank you very much, really appreciate it!

@buuqmarabo2778 5 жыл бұрын

u taught me a lot through all your vids, thank!

@joelcampos3073 Жыл бұрын

Very interesting and very well explained!!!

@Citrinestones 5 ай бұрын

LIFESAVER!!!

@karimchennoufi698 3 жыл бұрын

thnx for sharing this good video !! it helps a lot for my exam preparation

@dorcasogute4192 5 жыл бұрын

Very effective!!!

@nv9946 3 жыл бұрын

Thanks for sharing this video. Very well explained.

@SagarYadav-ch2kn Жыл бұрын

Nicely explained

@aarontan5748 2 жыл бұрын

Thank you!

@ngocmainguyen521 3 жыл бұрын

Thank you so much!

@ramnaresh4582 6 жыл бұрын

Really very awesome and useful to me . Thank you.

@user-kg1cg4sr2x Жыл бұрын

Cube function is not available in google bigquery. is their any other alternative ?

@oliviermesseumeni9623 4 жыл бұрын

You are the best thank you so much sir!

@montaserfadel7327 10 ай бұрын

impressiv

@mohaiminulhasan252 3 жыл бұрын

People like you turn into Data Engineers, and people who can't get that job are assigned to teach students like me. There has to be a fix for this.

@twinklegarg1413 3 жыл бұрын

Sir group by ek se jyada columns ke base pe perform to skit hai

@suhas3785 3 жыл бұрын

Thanks God bless you.....

@oceanheadted 4 жыл бұрын

Does it work when there is no hierarchy between the dimension column? E.g. if you were analysing shoe sales data, by size, colour and style...

@saikatde6343 Жыл бұрын

This is awesome. :)

@mozzjonas9292 3 жыл бұрын

Where is link for script

@angmathew4377 3 жыл бұрын

how do we know how many rows we will get from group by cube?

@hoangphucle9347 3 жыл бұрын

very useful. tks a lot

@jordan142495 2 жыл бұрын

Thanks 😀

@pankajkharade6936 3 жыл бұрын

Excellent

@akrammezrag4394 3 жыл бұрын

thanks bro.

@vedant_10-09 10 ай бұрын

#1064 limit 0,25 error @groupby grouping sets

@faranakyakhdani185 2 жыл бұрын

amazing

@medjl6083 3 жыл бұрын

what is this the name of software.

@omkarpatil9886 2 жыл бұрын

Postgrass sql

@nileshthorat2403 3 жыл бұрын

Present sir

@meriemtrabelsi5517 2 жыл бұрын

@mossen6225 9 ай бұрын

If this can make someones life easy 😃 CREATE TABLE sales ( continent varchar(20), country varchar(20), city varchar(20), units_sold integer ); Insert INTO sales VALUES ('North America', 'Canada', 'Toronto', 10000); Insert INTO sales VALUES ('North America', 'Canada', 'Montreal', 5000); Insert INTO sales VALUES ('North America', 'Canada', 'Vancouver', 15000); Insert INTO sales VALUES ('Asia', 'China', 'Hong Kong', 7000); Insert INTO sales VALUES ('Asia', 'China', 'Shanghai', 3000); Insert INTO sales VALUES ('Asia', 'China', 'Tokyo', 5000); Insert INTO sales VALUES ('Europ', 'UK', 'London', 6000); Insert INTO sales VALUES ('Europ', 'UK', 'Manchester', 12000); Insert INTO sales VALUES ('Europ', 'France', 'Paris', 5000); select * from sales;