SQL for Data Science - Level II
Learn the intermediate concepts of SQL for Data Science. Hands on Exercises. Covers theory and complete python code implementation.
- Learn the intermediate 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
- 26, in 6 chapters
- Video
- 1 h 30 min
- Free to watch
- 1 lesson
- Certificate
- On completion
Course content
6 chapters · 26 lessons · 1 h 30 min · 1 free to preview
01Section 1: Testing the Setup3 lessons · 13 min
- Import necessary libraries and create sample data6:01
- Download Resources1:00
- SQL Null valuesPreview6:28
02Section 2: Self-Assessment Test3 lessons · 21 min
- Instructions11:58
- Questions1:00
- Solutions7:49
03Section 3: Operators Part - 110 lessons · 31 min
- Logical Operators SQL And, Or, Not3:15
- SQL mini and max2:42
- SQL, count, avg, Sum and group by Index2:02
- SQL Like and Wildcards4:36
- SQL IN and Between1:34
- Course Review1:00
- SQL Exists12:53
- SQL Aliases0:46
- SQL Case statements1:30
- SQL Operators0:51
04Section 4: Self-Assessment Test2 lessons · 17 min
- Exercise Set 25:45
- Hard Questions10:58
05Section 5: String Operations7 lessons · 6 min
- Concatenation1:32
- Substring0:34
- How to separate First name and Last name?1:13
- Length or Len0:33
- Lower and Upper0:25
- Trimming Text1:20
- Replace Occurrence0:11
06Section 6: Self-Assessment Test1 lesson · 4 min
- Exercise Set 33:52
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.
