Working with Rollups and Cubes in PostgreSQL | SQL Basics
Вставка
- Опубліковано 27 сер 2024
- 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
Finally understood it, there's so many bad and overcomplicated explainations out there, but this one is really damn good. Thank you.
Thanks for sharing this video, it's just the amount of details I needed. Not sure who gave those 3 dislikes, ignore them...
Thank you very much!
You were the only one I was able to fully understand, you saved my day ahahah :)
Perfectly explained. Thanks for making me understand the concepts clearly.
Great to hear!
Great and simple explanation, thank you!!
Welcome!
Man, I love your explanation. You deserve a 👍
Thank you so much!
You really helped me understand the difference between the two.
best explanation ever .Thank you
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
This explained it a lot better than my course videos -- some people just teach better without efforts. thank you
Amazing video. Helped me with one of my assignments. Thank you for creating an easy to understand video with real examples.
many thanks for making it so simple to understand
Thank you for a concise yet knowledge-packed video! It helped me a lot
AWESOME !!!
FINALLY UNDERSTOOD :)
Best Explanation, Thank you so much
I love the way you explained it.
one video cleared all the questions that I had in my mind, Great work!
Thanks so much for this!
thanks for making this video of rollup and cude.
Nicely explained, very clear😊
Thank you 🙂
Excellent video.
Great video. Thanks man 🙏
Thank you , that was very good
Thank you very much for explaining the topic so easily!!
Amazing video! So much better than my university lecturer. Made so simple to understand
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?
excellent explanation sir. THank you so much for this. Straightforward and educative.
very helpful! Thank you :)
at last someone explained it clearly)
Very good explanation, thank you.
Bro, this is very good, thank you for enlightening me!
My pleasure!
this guy is a legend
Very interesting and very well explained!!!
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.
She possibly taught you a far bigger lesson - women aren't excited by technology, mechanics etc, and therefore don't understand them.
Well explained thank you very much, really appreciate it!
Thank you so much, that was very detailed explanation. Got very confused when my teacher explained it.
very nice explaination
u taught me a lot through all your vids, thank!
thnx for sharing this good video !! it helps a lot for my exam preparation
Cube function is not available in google bigquery. is their any other alternative ?
Thanks for sharing this video. Very well explained.
Perfect
Very effective!!!
Really very awesome and useful to me . Thank you.
Nicely explained
Thank you so much!
LIFESAVER!!!
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.
Thank you!
how do we know how many rows we will get from group by cube?
Sir group by ek se jyada columns ke base pe perform to skit hai
You are the best thank you so much sir!
Where is link for script
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...
Thanks God bless you.....
#1064 limit 0,25 error @groupby grouping sets
very useful. tks a lot
Thanks
😀
This is awesome. :)
Excellent
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;
what is this the name of software.
Postgrass sql
thanks bro.
impressiv
amazing
Present sir
Thank you so much!!!