Master SQL For Data Science
Master SQL For Data Science, available at $149.99, has an average rating of 4.65, with 53 lectures, based on 13750 reviews, and has 58004 subscribers.
You will learn about Write complex SQL statements to query the database and gain critical insight on data Practice Every Step of the Way by Working Through 100+ Puzzles (with solutions) Transition from the Very Basics to a Point Where You can Effortlessly Work with Large SQL Queries Learn Advanced Querying Techniques Become a Master SQL Developer This course is ideal for individuals who are Anyone who wants to break into the data analyst or data scientist role or Anyone interested in become a SQL query wizard It is particularly useful for Anyone who wants to break into the data analyst or data scientist role or Anyone interested in become a SQL query wizard.
Enroll now: Master SQL For Data Science
Summary
Title: Master SQL For Data Science
Price: $149.99
Average Rating: 4.65
Number of Lectures: 53
Number of Published Lectures: 52
Number of Curriculum Items: 53
Number of Published Curriculum Objects: 52
Original Price: $199.99
Quality Status: approved
Status: Live
What You Will Learn
- Write complex SQL statements to query the database and gain critical insight on data
- Practice Every Step of the Way by Working Through 100+ Puzzles (with solutions)
- Transition from the Very Basics to a Point Where You can Effortlessly Work with Large SQL Queries
- Learn Advanced Querying Techniques
- Become a Master SQL Developer
Who Should Attend
- Anyone who wants to break into the data analyst or data scientist role
- Anyone interested in become a SQL query wizard
Target Audiences
- Anyone who wants to break into the data analyst or data scientist role
- Anyone interested in become a SQL query wizard
LAST UPDATED: November 2023
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 puzzlesscattered 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.
With over 17,000 students and a 4.6 rating, you won’t find a better source to learn SQL for Data Science elsewhere.
Don’t just take it from me, take it from other students that have taken this course.
★★★★★ Here’s reviews from real students that took this course ★★★★★
★★★★★ You really can’t beat this course for the value. The instructor is excellent (clear explanations, easy to understand, extremely knowledgeable), and his style of constantly requiring the student to apply what they’ve just learned with practice queries proves to be a very effective method of learning. He covers an amazing amount of ground in just 9 hours. It was just the refresher course I needed after not having done much SQL in the past year.
★★★★★ Just one word – Exceptional!! Don’t give a second thought, just go for it. Thanks a lot Mr.Imtiaz Ahmad. The way concepts are explained in the lectures are quite good. The assignments gave me so much confidence and I feel so happy that I am quite well versed in SQL now. Watch the videos, try out the assignments on your own and practice as much as you can with different problems.
★★★★★ It’s a brilliant course that can help to understand SQL from easy concepts to difficult tasks. Besides, the explanations are always clear, so they let me learn a lot without searching for additional information in Internet. The course contains lots of practical tasks that allowed me not only to understand queries, but to also use them correctly.
★★★★★ Great! I really like the exercises that are included. They are essential to learning the course content.
★★★★★ After attending the course and doing most of the exercises, I feel very confident in SQL world. The course is designed well and every lesson gives you good amount of knowledge. Explanation and exercises are worth learning and practicing.
Topics covered in this course:
-
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.
Course Curriculum
Chapter 1: Database Basics
Lecture 1: Course Overview
Lecture 2: What is a Database
Lecture 3: How to Proceed in this Course
Lecture 4: Dedicated TA Support
Lecture 5: Join our Online Community (Discord)
Lecture 6: Install Postgres Database on Mac
Lecture 7: Troubleshoot Connection
Lecture 8: Install Postgres on Windows
Lecture 9: Create Table and Insert Statements
Lecture 10: Data file that will be used in the course (IMPORTANT)
Lecture 11: Prepare the Database
Lecture 12: Assignment 1: Create More Tables and Populate Data
Chapter 2: SQL Query Basics
Lecture 1: Introducing the SELECT Statement
Lecture 2: Filter Data Using the WHERE Clause + AND & OR
Lecture 3: Filtering Operators – IN, NOT IN, IS NULL, BETWEEN
Lecture 4: [EXERCISES]: WHERE Clause and Operators
Lecture 5: ORDER BY, LIMIT, DISTINCT and Renaming Columns
Lecture 6: Assignment 2: Practice Writing Basic Queries (5 Problems)
Chapter 3: Using Functions
Lecture 1: UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation
Lecture 2: Career Advice
Lecture 3: String Functions: SUBSTRING(), REPLACE(), POSITION() and COALESCE()
Lecture 4: Grouping Functions: MIN(), MAX(), AVG(), SUM(), COUNT()
Lecture 5: Assignment 3: Practice with Functions, Conditional Expressions and Concatenation
Chapter 4: Grouping Data and Computing Aggregates
Lecture 1: Understanding Grouping
Lecture 2: GROUP BY & HAVING Clauses
Lecture 3: [EXERCISES]: Using GROUP BY and HAVING Clauses
Lecture 4: Assignment 4: Practice Aggregation Queries
Chapter 5: Using Subqueries
Lecture 1: Aliasing Sources of Data
Lecture 2: Introducing Subqueries
Lecture 3: Subqueries Continued + [EXERCISES]
Lecture 4: Subqueries with ANY and ALL Operators + [EXERCISES]
Lecture 5: [EXERCISES]: More Practice with Subqueries
Lecture 6: Assignment 5: Practice with Subqueries
Chapter 6: Using the CASE Clause in Interesting Ways
Lecture 1: Conditional Expressions Using CASE Clause + [EXERCISES]
Lecture 2: Transposing Data using the CASE Clause + [EXERCISES]
Lecture 3: Assignment 6: Practice Using Case and Transposing Data
Chapter 7: Advanced Query Techniques using Correlated Subqueries
Lecture 1: Understanding Correlated Subqueries
Lecture 2: [EXERCISES]: Correlated Subqueries Continued
Chapter 8: Working with Multiple Tables
Lecture 1: Introducing Table Joins
Lecture 2: INNER and OUTER Joins + [EXERCISES]
Lecture 3: Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES]
Lecture 4: Cartesian Product with the CROSS JOIN
Lecture 5: [EXERCISES]: Joins and Subqueries Continued
Lecture 6: Creating Views vs. Inline Views
Lecture 7: Assignment 7: ADVANCED Problems using Joins, Grouping and Subqueries
Chapter 9: Window Functions for Analytics
Lecture 1: Window Functions using the OVER() Clause
Lecture 2: Ordering Data in Window Frames
Lecture 3: RANK, FIRST_VALUE and NTILE Functions
Lecture 4: Working with LEAD and LAG Functions
Lecture 5: Working with Rollups and Cubes
Chapter 10: Difficult Query Challenges
Lecture 1: Challenging Puzzles For the Brave
Chapter 11: Course Extras!
Lecture 1: Bonus Lecture
Instructors
-
Job Ready Programmer
Senior Software Engineers and Trainers
Rating Distribution
- 1 stars: 42 votes
- 2 stars: 117 votes
- 3 stars: 905 votes
- 4 stars: 4559 votes
- 5 stars: 8127 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024