From the makers of INSIDEIIM

dots bg

Data Science - SQL

Master the art of solving business problems using the most in-demand tool - Structured Query Language.


₹3999.00

About The Masterklass

The masterklass covers all you need to know about SQL. Spread over 8 hours, you will get to learn everything from installation to fundamentals of SQL commands to executing complex queries. Get access to databases and master MySQL at your own pace.

8 hours of content

Master the most in-demand tech tool

Get certified to stand out from the crowd

Masterklass Curriculum

Data Science - SQL

5 Exercises 42 Learning Materials

Fundamentals Of SQL

About the course

Video
8:58

Introduction to SQL

Video
9:31

Data Types in SQL

Video
26:5

Types of SQL Commands

Video
29:28

Data Worksheet

Audio

Structure of an SQL Query

Video
27:46

Summary

Video
4:12

Quiz

Exercise

Software Familiarisation & Report Data

MySQL Workbench Setup

Video
9:53

Server Setup & Working View

Video
6:45

Database Import Files

ZIP

Database Import

Video
11:53

SQL Script Files

ZIP

Data Retrieval with SELECT

Video
22:43

Summary

Video
1:21

Introduction to Report Data

Video
2:4

Filter Results with WHERE

Video
31:12

Sort Results with ORDER BY

Video
4:8

Transform Results with STRING Functions

Video
20:19

Change Result Headings with Alias

Video
5:29

SQL WHERE with DATE Functions

Video
5:15

Quiz

Exercise

Data Aggregation & Results Manipulation

Introduction

Video
4:55

SQL Script File

ZIP

Aggregate Results with GROUP BY and Numeric Functions

Video
18:36

Unique Values with DISTINCT

Video
4:35

Merge Rows with GROUP BY and STRING

Video
6:9

Window Functions

Video
26:21

Create Custom Fields

Video
17:31

Quiz

Exercise

Merge Data From Multiple Tables

Introduction to JOINS

Video
6:44

Excel Working of JOINS

Audio

Types of JOINS

Video
19:24

SQL Script File

ZIP

Merge Data with JOINS

Video
8:53

Combine Rows with UNION

Video
9:26

Return Data with IN

Video
14:10

Select Data with SUBQUERIES

Video
16:5

Quiz

Exercise

DDL & DML Statements

Introduction to DDL Statements

Video
4:4

SQL Script File

ZIP

Create, Drop & Truncate

Video
16:2

Import & Export of CSV Files

Video
12:59

Alter Table Statements

Video
13:29

DML Statements

Video
15:34

Quiz

Exercise

Feedback Form

Industry Experts As Instructor

Learn form the experts and grow in your career

tutor image

Ayushman Dehingia

1 Courses   •   13 Students

Sales Operations, Business Strategy Consultant - Pure Storage Inc, Data Science Coach, ex-Dell Tech, ex Mu Sigma Inc

Ayushman is a Marketing Operations and Decision Sciences professional with experience in Technology, BFSI and Retail domain. Currently, he is working as a Business Strategy Consultant at Pure Storage Inc. Prior to this, he worked at Dell Technologies.

Who Should Enroll For This Masterklass?

You should definitely enroll for this masterklass if you belong to these categories,

01.

Data Analysts & Data Scientists

02.

Business Analysts

03.

Data Analytics Skill Seekers

04.

Career Transition Seekers

05.

Software Professionals

06.

Freshers / Recent Graduates

What Our Learners Have To Say About Us

Altuni

Aditya Raj Dash

M.Sc. (SCM) - Queen Mary Uni. of London

Provided me with guidance, study material & support. Gaining wisdom & insights from practical workshops & sessions conducted by domain experts was the highlight of the program.

Altuni

Sachin Mistry

Data Analyst, Majid Al Futtaim

Helped us explore the features of Power BI. With the Capstone Projects, we got a chance to learn with real -world data. The 1:1 sessions were useful in creating a career charter.

Altuni

Chirangi R.

Software Intern, Oracle Cerner

I thoroughly enjoyed the sessions…Very impressed with the conduction of virtual classes and doubt sessions schedules. I gained a lot of a new skills & knowledge to take back home.

Looking For A More Advanced Course?

Explore Our Program on Advanced Data Analytics

Advanced Data Analytics Program

COHORT 3

Learn the in-demand skills and tools of Data Analytics & work on 3 Live & Capstone projects

Launching Soon!

Enroll now & be the first one to upskill.

Enroll before 10th October 2022 and get the course at half the price!