From the makers of INSIDEIIM
Data Science - SQL
Master the art of solving business problems using the most in-demand tool - Structured Query Language.
₹1999.00 ₹3999.00 50% OFF
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
Introduction to SQL
Data Types in SQL
Types of SQL Commands
Data Worksheet
Structure of an SQL Query
Summary
Quiz
Software Familiarisation & Report Data
MySQL Workbench Setup
Server Setup & Working View
Database Import Files
Database Import
SQL Script Files
Data Retrieval with SELECT
Summary
Introduction to Report Data
Filter Results with WHERE
Sort Results with ORDER BY
Transform Results with STRING Functions
Change Result Headings with Alias
SQL WHERE with DATE Functions
Quiz
Data Aggregation & Results Manipulation
Introduction
SQL Script File
Aggregate Results with GROUP BY and Numeric Functions
Unique Values with DISTINCT
Merge Rows with GROUP BY and STRING
Window Functions
Create Custom Fields
Quiz
Merge Data From Multiple Tables
Introduction to JOINS
Excel Working of JOINS
Types of JOINS
SQL Script File
Merge Data with JOINS
Combine Rows with UNION
Return Data with IN
Select Data with SUBQUERIES
Quiz
DDL & DML Statements
Introduction to DDL Statements
SQL Script File
Create, Drop & Truncate
Import & Export of CSV Files
Alter Table Statements
DML Statements
Quiz
Feedback Form
Industry Experts As Instructor
Learn form the experts and grow in your career
/1763272-ayushman-sql.jpg)
Ayushman Dehingia
2 Courses • 1141 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
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.
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.
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 Certificate Program in Data Science
Certificate Program In Data Science
Master In-Demand Tools Like Power BI, MySQL, Excel, R, Python - NumPy, Pandas, Matplotlib/ Seaborn.
Applied Education is a passport out of poverty and low income. We want to enable India to become the human resource capital of the world
Launching Soon!
Enroll now & be the first one to upskill.
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy