Working with Rollups and Cubes in PostgreSQL | SQL Basics

This video is from the course "Master SQL for Data Science"
➡️ Learn MORE:
- Access all of my software development courses using the discount below: www.jobreadyprogrammer.com/p/...
- Email me if you have questions: [e-mail]
- Become Job Ready with our NEW Programming Guide (PDF): pages.jobreadyprogrammer.com/...
=========================================
➡️ Job Ready Programmer Socials:
linktr.ee/jobreadyprogrammer
=========================================
#jobreadyprogrammer #databasedeveloper #softwaredeveloper #career #sql #tableau #databases #database #webdeveloper #html #css #javascript #java #javabasics #javatutorial #javaprogramming #aws #admin #jobready #programmer

[@MonteFisto100]

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

[@nupurgautam1]

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

[@matteomarinelli3752]

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

[@afsananasrin4700]

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

[@fatenaljabaly3911]

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

[@angelopaligutan1665]

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

[@user-ko4uv6fg8w]

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

[@satyendrasingh3805]

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

[@kiararicketts2971]

Great and simple explanation, thank you!!

[@adamsleuis7794]

Man, I love your explanation. You deserve a 👍

[@demetridoes]

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

[@lenaso4555]

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

[@samyboulos4642]

I love the way you explained it.

[@buuqmarabo2778]

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

[@acleahcim]

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

[@alexbarasa3816]

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

[@ukaszkiepas57]

AWESOME !!!
FINALLY UNDERSTOOD :)

[@hiraethneko]

Thanks so much for this!

[@NirajPRoxx]

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

[@Advanced_Learner]

many thanks for making it so simple to understand

[@sravanialluri5756]

Best Explanation, Thank you so much

[@ASWood95]

Well explained thank you very much, really appreciate it!

[@aqsachappalwala4363]

best explanation ever .Thank you

[@mahdihabibi1875]

Great video. Thanks man 🙏

[@ranjithparuchuri6463]

thanks for making this video of rollup and cude.

[@paulfunigga]

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

[@Doshvari]

Thank you , that was very good

[@ramnaresh4582]

Really very awesome and useful to me . Thank you.

[@akwamfoneventus6124]

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

[@joelcampos3073]

Very interesting and very well explained!!!

[@nv9946]

Thanks for sharing this video. Very well explained.

[@Pichler96]

very helpful! Thank you :)

[@karimchennoufi698]

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

[@kamilyaka3406]

Very good explanation, thank you.

[@kelvinojeda8222]

Excellent video.

[@iaroslavd.916]

Nicely explained, very clear😊

[@oliviermesseumeni9623]

You are the best thank you so much sir!

[@ngocmainguyen521]

Thank you so much!

[@dorcasogute4192]

Very effective!!!

[@schaumaul]

this guy is a legend

[@hydronicrocker]

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?

[@aarontan5748]

Thank you!

[@Davlet]

at last someone explained it clearly)

[@SagarYadav-ch2kn]

Nicely explained

[@estleexin7584]

very nice explaination

[@sunnysingh8483]

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]

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

[@saikatde6343]

This is awesome. :)

[@oceanheadted]

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...

[@hoangphucle9347]

very useful. tks a lot

[@suhas3785]

Thanks God bless you.....

[@Citrinestones]

LIFESAVER!!!

[@pankajkharade6936]

Excellent

[@saki23_220]

Perfect

[@jordan142495]

Thanks
😀

[@akrammezrag4394]

thanks bro.

[@twinklegarg1413]

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

[@faranakyakhdani185]

amazing

[@angmathew4377]

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

[@user-kg1cg4sr2x]

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

[@montaserfadel7327]

impressiv

[@mozzjonas9292]

Where is link for script

[@medjl6083]

what is this the name of software.

[@omkarpatil9886]

Postgrass sql

[@nileshthorat2403]

Present sir

[@mohaiminulhasan252]

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.

[@vedant_10-09]

#1064 limit 0,25 error @groupby grouping sets

[@meriemtrabelsi5517]

[@mossen6225]

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;

[@bayerok1582]

Thank you so much!!!