Getting Started with Tableau
By Jobaaj Learnings
₹6,999/-₹13,999/-
2,740 Enrolled Students
🎉
Expand Your Knowledge
Flat 80% off + Extra 10% Cart Discount
Flat 80% off + Extra 10% Cart Discount
🎉
🚀 FREE AI WORKSHOP! 🚀
Join us this weekend and unlock the power of AI to stay ahead in your career!
"One person using AI will replace 100 professionals not using AI" – Are you ready?
Reserve Your Spot Now!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 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
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
3
Getting Started
Create Schema
00:08:50
Data Types
00:04:27
String
00:08:06
Integer
00:05:51
Decimel
00:07:37
Date
00:09:15
Creating Table
00:12:52
Creating Table II
00:03:49
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
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 (DISTNCT)
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
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
7
Aggregate Functions
Count
00:16:25
Sum
00:06:38
AVG
00:07:34
Round
00:05:57
Min & Max
00:08:55
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
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
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
- 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:33Reading Data
00:07:03Relational Database
00:06:04Database Design
00:06:14Primary key
00:09:31Foreign Key
00:05:40Unique Key
00:04:09Relationship 1
00:07:00Relationship 2
00:07:46Relationship 3
00:07:432
SQL Concepts
Type of Statements
00:06:53DDL
00:15:14DML
00:15:34DCL
00:12:37TCL
00:07:15Database vs Schema
00:10:58Downloading & Installing on Windows
00:07:49MySQL Connection
00:03:40Workbench Walkthrough
00:06:343
Getting Started
Create Schema
00:08:50Data Types
00:04:27String
00:08:06Integer
00:05:51Decimel
00:07:37Date
00:09:15Creating Table
00:12:52Creating Table II
00:03:494
SQL Constraints
Primary key
00:10:38Foreign Key
00:11:49Unique Key
00:07:58Default
00:06:21Not Null
00:04:03Best Practices
00:08:21Loading Data
00:02:46Data
5
DML 1
Select
00:07:30Where
00:04:28And
00:08:38Or
00:06:54Operator Precedence
00:06:26In
00:04:14Like
00:07:45Between
00:05:54Is not null
00:04:19Comparison Operator
00:05:27SELECT (DISTINCT)
00:07:03COUNT (DISTNCT)
00:06:33Order By
00:06:00Group By
00:12:46Having
00:14:07Where vs Having
00:06:46Limit
00:08:486
DML II
Insert I
00:10:56Insert II
00:07:50Update I
00:06:52Update II
00:10:04Delete
00:04:26Delete vs Truncate vs Drop
00:08:307
Aggregate Functions
Count
00:16:25Sum
00:06:38AVG
00:07:34Round
00:05:57Min & Max
00:08:558
Important Functions
String Func I
00:12:34String Func II
00:14:42Date Function
00:09:56Date-Time Format
00:15:14dateformat
00:10:55str_to_date
00:09:18Coalesce
00:08:16Cast
00:02:07IFNULL
00:09:239
Joins
Why Joins
00:14:01Inner Join
00:16:12Inner Join 2
00:08:22Inner Join Example
00:06:00Join on Multiple Columns
00:08:02LEFT Join
00:10:03LEFT Join 2
00:07:25LEFT Join Example
00:03:47Right Join
00:10:28Right Join Example
00:01:52Use Case
00:04:27Join with GROUP BY
00:04:15Cross Join
00:15:00Cross & Inner Join
00:05:24Multiple Joins
00:14:53Join Example
00:06:26UNION & UNION ALL
00:12:2010
Subqueries & Views
SQL Subquery 1
00:08:26SQL Subquery 2
00:06:28Exists/Not Exists
00:08:26Problem Statement
00:14:53Self Join
00:10:38Self Join Example
00:06:35SQL View
00:13:51SQL View Example
00:13:51More courses like this
Data Analytics with Numpy, Pandas & Matplotlib
By Jobaaj Learnings
₹3,499/-₹6,999/-
8,090 Enrolled Students
Pandas Data Operations Mastery
By Jobaaj Learnings
₹4,999/-₹9,999/-
4,000 Enrolled Students
