dots bg

My Sql for Data Analytics

Course Instructor: Mahesh

₹5000.00 ₹10000.00 50% OFF

dots bg

Course Overview

📘 Course Overview – SQL for Data Analytics
This course is designed to equip you with the essential SQL skills needed to work with data effectively. Whether you’re a beginner or someone looking to strengthen your analytical skills, you’ll learn how to write queries, manipulate datasets, and extract meaningful insights from databases.

Through practical, real-world examples, you’ll understand how SQL powers data analytics in business, technology, and research. By the end of this course, you’ll be confident in retrieving, cleaning, and analyzing data to support decision-making.

What You’ll Learn:

  • Fundamentals of SQL syntax and commands

  • Filtering, sorting, and aggregating data

  • Using joins to combine datasets

  • Applying functions for analysis

  • Creating views and subqueries

  • Writing queries for reports and dashboards

  • Real-world case studies for data analytics

Who Should Join:

  • Students and freshers entering the data field

  • Professionals looking to upskill in analytics

  • Anyone curious about data-driven decision-making

By completing this course, you’ll gain the skills to handle data like a pro and take your first step towards becoming a successful Data Analyst.

Schedule of Classes

Course Curriculum

1 Subject

My Sql for Data Analytics

36 Learning Materials

My_SQL

Intro to SQL

External Link

SQL - Day1

Video
01:56:55

SQL - Day2 (Basic commands)

Video
01:14:22

SQL - Day 3 (SQL commands I)

Video
01:22:26

SQL - Day 4 (SQL Commands II)

Video
01:35:12

SQL - Day 5 (SQL Commands III)

Video
01:48:25

SQL - Day 6 (SQL constraints)

Video
01:47:49

SQL - Day 7 ( Introduction to Queries)

Video
01:49:42

SQL - Day 8 ( writing SQL queries )

Video
01:38:24

SQL - Day 9 (SQL queries)

Video
01:41:55

SQL - Day 10 (Joins I )

Video
01:43:04

SQL - Day 11 (Doubt Clarification section

Video
01:08:21

SQL - Day 12 ( SQL joins inner,left,right,full,union,union all)

Video
01:37:31

SQL - Day 13 (SQL joins- cross join, self join , joining multiple tables)

Video
01:51:43

SQL - Day 14 (subqueries, CTEs, rank,dense_rank,row_number,partition by)

Video
01:46:30

SQL - Day 15 PL/SQL (Stored Procedure)

Video
01:42:38

SQL - Day 16 PL/SQL (Functions, Views, Triggers)

Video
01:59:23

Last SQL class - Day 17 (indexes, case statement, lead and lag window functions, remove duplic

Video
02:15:03

May2023_RunningNotes

Text

Sql Session 2

External Link

Sql 3

External Link

SQL_Scripts_and_docs_for_practice

TCL

ZIP

Basicscripts_new

ZIP

Constraints

ZIP

car_data

ZIP

Car_details script

ZIP

Ele_Store1

ZIP

joinsandunion

PDF

Rank_DenseRank,Rownumber,partition_scripts

ZIP

subqueriesandctesscripts

ZIP

AlljoinsinSQL

ZIP

Procedures

ZIP

Views_updated

ZIP

TRIGGERS_updated

ZIP

Functions

ZIP

May2023_RunningNotes

Text

Course Instructor

tutor image

Mahesh

94 Courses   •   16726 Students

Mahesh Desireddy, Founder & COO of KSR Datavizon, dedicated to empowering individuals with quality tech education. With a mission to bridge the skills gap, I focus on sharing practical, industry-relevant knowledge to help learners achieve their career goals in IT and Data Analytics."