SQL for Data Science - Level III
Learn the advanced concepts of SQL for Data Science. Hands on Exercises. Covers theory and complete python code implementation.
- Learn the advanced concepts of SQL for Data Science
- Hands on Exercises
- Covers theory and complete python code implementation
Prabhakaran SPrincipal Data Scientist
Included in All-Access, one membership for every course.
- Lessons
- 13, in 6 chapters
- Video
- 1 h 15 min
- Free to watch
- 1 lesson
- Certificate
- On completion
Course content
6 chapters · 13 lessons · 1 h 15 min · 1 free to preview
01Testing the Setup2 lessons · 2 min
- Import necessary libraries and create sample dataPreview0:45
- Download Resources1:00
02Section 1: Sub Queries3 lessons · 41 min
- Sub Queries13:49
- Sub Queries – Tougher example 116:22
- Sub Queries – Tougher example 210:36
03Section 2: Self-Assessment Set 14 lessons · 12 min
- Instructions0:59
- Questions2:39
- Solutions7:24
- Course Review1:00
04Section 3: SQL Indexing1 lesson · 6 min
- SQL - Indexing5:33
05Section 4: SQL Views1 lesson · 9 min
- Understanding SQL Views9:00
06Section 5: Stored Procedure and Functions2 lessons · 7 min
- Stored Procedures4:37
- Loadable Functions2:46
What you need
- Basics of Python
- Foundational knowledge of Data Science
- High school maths
Who this course is for
- Data Science Aspirants
- Data Science Professionals
- Software/Data engineers interested in quantitative analysis
- Professionals working with large datasets
- Data analysts, economists, researchers
Your instructor
Prabhakaran S
Principal Data Scientist
My name is Selva, and I am super excited to mentor you on this course!
I head the Data Science team for a global Fortune 500 company and over the last 10 years of my data science experience I've deployed 20+ global products. I'm also the Founder and Chief Author of Machine Learning Plus, which has over 4M annual readers.
I specialize in covering the in-depth intuition and maths of any concept or algorithm. And based on my existing student requests, I've put up the series of courses and projects with detailed explanations, just like on-the-job experience. Hope you love it!
- from 3,965 ratings
- 4.92
- learners
- 57K+
- courses
- 85
Questions
How do I get this course?
It is part of All-Access: one membership that opens all 85 courses. The plans and prices are on our course site. You can watch the free preview lessons before you join.
Can I get a refund?
Yes. If the membership is not right for you, ask for a refund within 30 days of your first payment.
Can I learn on my phone?
Yes. Lessons play in the browser on any phone, tablet or computer, and your place is saved for the next device.
I am already a member. Where are my courses?
On our course site, edu.machinelearningplus.com. Sign in there with the email you joined with. The courses move to this site later, with your access, and you will not pay again.
