Data Analysis Using SQL

Using SQL we will learn Data Manipulation, Data Retrieval & Data Analysis

Created byMohammed Abdul Rafay Imran Khan

Last updated 6/2025

English

What you'll learn

SQL courses can support you learn how to manage and query structured data in relational databases to support analysis, reporting, and application development.
SQL's structure offers a straightforward framework for data analysis.
SQL is flexible and can be optimized by developers to run any query and derive results.
SQL language can be adapted and extended with new calculations, thus resulting in interesting results beneficial for business across different domains.

Course content

1 section • 11 lectures • 3h 50m total length

Installing MySQL Workbench, Creating Database & Table33:20
a) Learning to install MySQL Workbench
b) Learning to create a Database
c) Learning to create a simple table
d) Learning to create a table as per csv file and importing data from csv file
Learning SQL Operators21:12
Exploring the SQL Operators
a) Where
b) In
c) Not in
d) And
e) Or
f) Comparative Operators
Exploring Aggregate Functions25:55
Exploring Aggregate Functions and necessary clauses
a) Count
b) Sum
c) Average
d) Minimum
e) Maximum
f) Group by
g) Having
TYPES OF JOINS28:33
Types of Joins is a concept that allows us to connect multiple tables
a) Inner Join
b) Left Join
c) Right Join
d) Natural Join
e) Self Join
g) Union
h) Union All
EXPLORING SUB-QUERIES23:45
A subquery is essentially a query nested within another query, allowing users to perform operations that depend on the results of another query. The examples done will give lot of clarity on how to extract meaningful data with subquery.
CONDITIONAL STATEMENTS10:30
Conditional statements are used to manipulate data and transform data.
CONCEPT OF WINDOWS FUNCTIONS23:10
Windows functions is useful for ranking, calculating cumulative totals without affecting the structure of original data.
EXPLORING COMMON TABLE EXPRESSION(CTE)17:40
CTE are defined using the WITH keyword, and allows the analyst to transform complex queries into simpler forms.
CONCEPT OF VIEWS AND STORED PROCEDURES8:42
VIEW is a virtual table based on the result of an sql query.
STORED PROCEDURE is a prepared sql code that can be reused several times.
TYPES OF CONSTRAINTS23:42
Constraints are the key part in the structure of the table
a) Unique Constraint
b) Default Constraint
c) Check Constraint
d) Nulls
e) Auto-increment
f) Primary Key
g) Foreign Key
Data Transformation13:34
Data Transformation is part of ETL process that allows for cleaning , reshaping the structure and content of the table for data analysis.

Requirements

The course is designed in way that the students will learn everything from scratch, so the only prerequisite is effort from student.

Description

The SQL course is designed to teach individuals how to interact with and manage data stored in relational databases using the Structured Query Language (SQL). This course cover various aspects, from basic syntax and database design to advanced concepts like joins, subqueries, common table expression, windows function, conditional statements , views and stored procedures. These concepts are critical for an individual who wants to master data manipulation, retrieval and analysis using SQL.

Learning SQL offers numerous benefits, including career advancement, enhanced data analysis capabilities, and improved understanding of databases. It's a valuable skill for professionals in various fields, especially those dealing with data in any capacity. We are living in a data-driven world, with 90% of the world's data created in the last two years. As such, businesses are heavily investing in data, with over 97% of organizations doing so. SQL (Structured Query Language) is the second most popular programming language used to manage data in databases, making it a vital skill in the job market. Learning SQL can increase your marketability as a developer, leading to potential jobs like SQL Developer, Software Engineer, Data Scientist, and Database Administrator.

Expertise of SQL Makes it Easy to Learn Other Software Languages

SQL's structure offers a straightforward framework for data analysis.
SQL is flexible and can be optimized by developers to run any query and derive results.
SQL language can be adapted and extended with new calculations, thus resulting in interesting results beneficial for business across different domains.

Who this course is for:

Students who aspire to join industries related to but not limited to such as Software Engineering, Data Architecture, Data Analysis, Data Science are few popular areas where SQL has huge scope.