Skip to content
Data

Zero to Hero in SQL

This program is designed to build a strong foundation in the most in demand data creation, retrieval and manipulation language i.e., SQL using an open source software MySQL. It also includes Relational Database Management concepts which will help the new learners have a strong hold right from the beginning.

(13 reviews)
13 Hours 27 Mins
₹9,999/-₹12,999/-
Join the course
Created by
Jobaaj Learnings

Course description

Reason why you should enroll in this course?

  • SQL is the most in-demand language and dominate in managing data in Relational Database
  • Even if you have zero programming experience, this course will take you from beginner to professional.
  • SQL knowledge caters massive job openings in the market
  • The program is updated as per 2022 SQL standards
  • Our learning methodology progresses gradually from essential to advanced concepts & follows the right mix of practical & theoretical concepts.
  • All your work will be documented and will help in building your portfolio.

 

What makes us qualified to Upskill you?

Having taught more than 1000 professions, your trainer caters an experience of 8 years. He is 98-381 Python certified from Microsoft and a SQL gold badge holder on hackerrank. Be assured that you are learning from the best in the market and your future is in the right hands.

Who is this program for?

All the learners, career upskilled, career switchers, students, freelancers & professionals are the right fit for the program.

How is this course different from similar products on the market?

  • No software download required
  • This program will build your personal profile that you can embed in your resume
  • 24x7 support through our Discord Community
  • Weekly Q&A sessions directly with the trainer
  • Lifetime access to material & updates

Prerequisite

  • No Prerquestics

What you will learn

  • Eligible for SQL developers/data analyst/data scientists /web-app developers
  • Switch/start or restart your career
  • Personal portfolio will give you an edge over the competition
  • A zero to hero in programming concepts using SQL
  • With programming getting penetrated in every domain of industry, this course will make you future ready

Lesson List

1

Database Literacy

Why SQL
00:04:33
Reading Data
00:07:03
Relational Database
00:06:04
Database Design
00:06:14
Primary key
00:09:31
Foreign Key
00:05:40
Unique Key
00:04:09
Relationship 1
00:07:00
Relationship 2
00:07:46
Relationship 3
00:07:43
Quiz
2

SQL Concepts

Type of Statements
00:06:53
DDL
00:15:14
DML
00:15:34
DCL
00:12:37
TCL
00:07:15
Database vs Schema
00:10:58
Downloading & Installing on Windows
00:07:49
MySQL Connection
00:03:40
Workbench Walkthrough
00:06:34
Quiz
3

Getting Started

Create Schema
00:08:50
Data Types
00:04:27
String
00:08:06
Integer
00:05:51
Decimal
00:07:37
Date
00:09:15
Creating Table
00:12:52
Creating Table II
00:03:49
Quiz
4

SQL Constraints

Primary key
00:10:38
Foreign Key
00:11:49
Unique Key
00:07:58
Default
00:06:21
Not Null
00:04:03
Best Practices
00:08:21
Loading Data
00:02:46
Data
Quiz
5

DML 1

Select
00:07:30
Where
00:04:28
And
00:08:38
Or
00:06:54
Operator Precedence
00:06:26
In
00:04:14
Like
00:07:45
Between
00:05:54
Is not null
00:04:19
Comparison Operator
00:05:27
SELECT (DISTINCT)
00:07:03
COUNT (DISTINCT)
00:06:33
Order By
00:06:00
Group By
00:12:46
Having
00:14:07
Where vs Having
00:06:46
Limit
00:08:48
Quiz
6

DML II

Insert I
00:10:56
Insert II
00:07:50
Update I
00:06:52
Update II
00:10:04
Delete
00:04:26
Delete vs Truncate vs Drop
00:08:30
Quiz
7

Aggregate Functions

Count
00:16:25
Sum
00:06:38
AVG
00:07:34
Round
00:05:57
Min & Max
00:08:55
Quiz
8

Important Functions

String Func I
00:12:34
String Func II
00:14:42
Date Function
00:09:56
Date-Time Format
00:15:14
dateformat
00:10:55
str_to_date
00:09:18
Coalesce
00:08:16
Cast
00:02:07
IFNULL
00:09:23
Quiz
9

Joins

Why Joins
00:14:01
Inner Join
00:16:12
Inner Join 2
00:08:22
Inner Join Example
00:06:00
Join on Multiple Columns
00:08:02
LEFT Join
00:10:03
LEFT Join 2
00:07:25
LEFT Join Example
00:03:47
Right Join
00:10:28
Right Join Example
00:01:52
Use Case
00:04:27
Join with GROUP BY
00:04:15
Cross Join
00:15:00
Cross & Inner Join
00:05:24
Multiple Joins
00:14:53
Join Example
00:06:26
UNION & UNION ALL
00:12:20
Quiz
10

Subqueries & Views

SQL Subquery 1
00:08:26
SQL Subquery 2
00:06:28
Exists/Not Exists
00:08:26
Problem Statement
00:14:53
Self Join
00:10:38
Self Join Example
00:06:35
SQL View
00:13:51
SQL View Example
00:13:51
Quiz
11

Final Quiz

Quiz
12

SQL Practice Queries

SQL Practice Queries

More courses like this

All trademarks are the property of their respective owners

All rights reserved @ 2026 Nishtya Infotech (India) Ltd.

Having an Issue!!

Please tells us more about it!

Help