Become a SQL query wizard and never be afraid to look at a large SQL query again!
This GitHub Repository will include the Source Code for the Master SQL For Data Science Course from JRP (Job Ready Programmer)
(Work in progress ⏳)
- 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.
- 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
Enroll today to become a Master SQL Data Science Developer. As always, I offer a 30 day money back guarantee if you're not satisfied, but you won't need it.
- Learn more: jobreadyprogrammer.com
- Email us: info@jobreadyprogrammer.com
- Follow us on Social Media: linktr.ee/jobreadyprogrammer
- Read our articles on Medium - Job Ready Programmer
- Imtiaz Ahmad is an award-winning Udemy Instructor who is highly experienced in big data technologies and enterprise software architectures.
- Imtiaz has spent a considerable amount of time building financial software on Wall St. and worked with companies like S&P, Goldman Sachs, AOL and JP Morgan along with helping various startups solve mission-critical software problems.
- In his 13+ years of experience, Imtiaz has also taught software development in programming languages like Java, C++, Python, PL/SQL, Ruby and JavaScript.
- He’s the founder of Job Ready Programmer — an online programming school that prepares students of all backgrounds to become professional job-ready software developers through real-world programming courses.
- Take the twin highway of Learning Data Analysis and Software Development on a single platform: Job Ready Programmer
