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
7 сен 2024