Home
Data Science
SQL for Data Science-I

SQL for Data science-Level 1

Learn the basic concepts of SQL for data Science
Covers everything from scratch
Covers theory and complete python code implementation

Created by Selva Prabhakaran

English
English captions

Validity Period: 365 days

Get Subscription

Already Subscribed? Click here to access your courses

Course Certificate
Code Walkthroughs
Practice Data
Money Back if not satisfied
Algorithms explanation
2h 26m of Self-paced videos
Downloadable resources
Q&A sessions with experts

What you will learn

Introduction to Databases
and SQL

Basic SQL Queries

Advanced Data Retrieval
Techniques

Sql functions and Data
Manipulation

Indexes and optimization

Views,stored procedures and
triggers

Advanced Sql topics

Course Curriculum

6 Modules | 28 Sessions | 2 hour 36 min Total Time

label_important

Introduction to SQL

Sessions: 3 | Time: 10 min expand_more

ondemand_video

Why you should learn SQL

7 min

description

Resources for the "SQL for Data Science - Level 1"

1 min

ondemand_video

Types of SQL Servers

2 min

label_important

Setting up Environments

Sessions: 6 | Time: 1 hour 33 min expand_more

ondemand_video

Setup Python Environment for SQL

7 min

ondemand_video

Import necessary libraries and create sample data

44 min

ondemand_video

Create DB and Run SQL in Jupyter Environment

14 min

description

Course Review

1 min

ondemand_video

Data Wrangling iin SQL vs Python

10 min

ondemand_video

Setup MySQL Workbench

17 min

label_important

Creating and Deleting Data

Sessions: 6 | Time: 21 min expand_more

ondemand_video

Create a Table Manually in DB

8 min

ondemand_video

Exercise: Create orders tables from raw data

2 min

ondemand_video

Create new table from existing table

2 min

ondemand_video

Show Table from existing database

5 min

ondemand_video

SQL DELETE - Delete rows in an existing dataset using where condition

3 min

ondemand_video

Delete a Table

1 min

label_important

Selecting Data and Update Tables

Sessions: 5 | Time: 14 min expand_more

ondemand_video

SQL Update Update rows-columns in an existing dataset

1 min

ondemand_video

Exercise 2: Updating Table

9 min

ondemand_video

SQL SELECT - Select Data required variables from a Dataset

2 min

ondemand_video

SQL Comments

1 min

ondemand_video

Limit the number of rows returned from a query

1 min

label_important

Filtering Data

Sessions: 5 | Time: 8 min expand_more

ondemand_video

Select Distinct Identify and delete duplicates in a dataset

2 min

ondemand_video

SQL Where Filtering rows

1 min

ondemand_video

Exercise 3: Filtering Data

1 min

ondemand_video

SQL order by Sort the data in ascending or descending order

2 min

ondemand_video

SQL Having Filter rows after aggregating

2 min

label_important

Merging Datasets

Sessions: 3 | Time: 10 min expand_more

ondemand_video

Joining Datasets

6 min

ondemand_video

Exercise 4: Joining Exercise

1 min

ondemand_video

SQL DateTime Operations

3 min

Requirements

Basic Maths and Logical Reasoning
Curiosity about Data Science
Learning Mindset

Who should attend this course?

Future Data Scientists and ML Engineers
Product Managers, Program Managers, Scrum Masters working in ML/Data science project
Software/Data engineers interested in quantitative analysis
Software engineers interfacing with data science team
Executives who have to lead or interact with Data Scientists

Instructor

Selva Prabhakaran Principal Data Scientist

My name is Selva, and I am super excited to mentor you on this project!

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 & 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 an on the job experience. Hope you love it!

4.5+Instructor rating
200+ reviews
10K+students
15+ Courses

Validity Period: 365 days

Get Subscription

Already Subscribed? Click here to access your courses

Workshop Certificate
Code Walkthroughs
Practice Data
Money Back if not satisfied
Algorithms explanation
2h 26m of Self-paced videos
Downloadable resources
Q&A sessions with experts

SQL for Data science-Level 1

What you will learn

Introduction to Databasesand SQL

Basic SQL Queries

Advanced Data Retrieval Techniques

Sql functions and Data Manipulation

Indexes and optimization

Views,stored procedures and triggers

Advanced Sql topics

Course Curriculum

Introduction to SQL

Setting up Environments

Creating and Deleting Data

Selecting Data and Update Tables

Filtering Data

Merging Datasets

Requirements

Who should attend this course?

Instructor

Selva Prabhakaran Principal Data Scientist

4.5+Instructor rating

200+ reviews

10K+students

15+ Courses

Book your visit now

Introduction to Databases
and SQL

Advanced Data Retrieval
Techniques

Sql functions and Data
Manipulation

Views,stored procedures and
triggers