SQL for Data Science - Level I (Beginner)

1. 01Introduction to SQL3 lessons · 10 min

   1. Why you should learn SQLPreview6:47
   2. Resources for the "SQL for Data Science - Level 1"1:00
   3. Types of SQL Servers2:28
2. 02Setting up Environments6 lessons · 1 h 33 min

   1. Setup Python Environment for SQL7:11
   2. Import necessary libraries and create sample data43:45
   3. Create DB and Run SQL in Jupyter Environment13:55
   4. Course Review1:00
   5. Data Wrangling iin SQL vs Python10:11
   6. Setup MySQL Workbench17:01
3. 03Creating and Deleting Data6 lessons · 21 min

   1. Create a Table Manually in DB8:17
   2. Exercise: Create orders tables from raw data1:35
   3. Create new table from existing table2:09
   4. Show Table from existing database5:13
   5. SQL DELETE - Delete rows in an existing dataset using where condition2:46
   6. Delete a Table0:44
4. 04Selecting Data and Update Tables5 lessons · 13 min

   1. SQL Update Update rows-columns in an existing dataset0:50
   2. Exercise 2: Updating Table8:56
   3. SQL SELECT - Select Data required variables from a Dataset1:50
   4. SQL Comments0:35
   5. Limit the number of rows returned from a query1:16
5. 05Filtering Data5 lessons · 8 min

   1. Select Distinct Identify and delete duplicates in a dataset2:02
   2. SQL Where Filtering rows1:02
   3. Exercise 3: Filtering Data0:59
   4. SQL order by Sort the data in ascending or descending order2:04
   5. SQL Having Filter rows after aggregating1:45
6. 06Merging Datasets3 lessons · 10 min

   1. Joining Datasets5:41
   2. Exercise 4: Joining Exercise0:43
   3. SQL DateTime Operations3:08

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