Getting Started with Tableau
By Jobaaj Learnings
₹6,999/-₹13,999/-
2,680 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!Complete SQL Mastery
SQL is one of the most widely learned programming languages and can help you land jobs in roles like Business Analyst, Data Scientist, Database Administrator, and many more. Join us on this 30 Hours long crash course to become a master at SQL and get one step closer to your dream job.
23 Hours 21 Mins
₹4,999/-₹9,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 ?
-
Switch/start or restart your career
-
Eligible for SQL developers/data analyst/data scientists /web-app developers
-
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
Introduction to SQL &Bascic Select & From Clause
Introduction to Data
00:04:19
What is Big Data
00:10:36
What is Database?
00:07:46
RBDMS
00:25:37
ACID Properties
00:22:30
What is SQL and Select, From clause
00:21:42
Where Clause
00:16:10
AND & OR Operator
00:12:55
IN & NOT IN Operator
00:11:53
Between & Not Between
00:04:56
Is Null & Is Not Null
00:05:42
Like & Not Like or Regular Expresessions
00:22:13
2
Data Types & All about SQL Commands
Data Types in SQL
00:23:36
Overview about DQL, DML & DDL
00:10:13
Create Clause (DDL)
00:08:00
Insert Clause (DML)
00:12:32
Alter & Update
00:16:10
Delete, Drop & Truncate
00:19:43
Difference b/w (DELETE_DROP), (ALTER_UPDATE),(DELETE_TRUNCATE),(DROP_TRUNCATE)
00:12:45
Overview about TCL & DDL Commands
00:09:58
3
Constraints & ER Model & Normalization in SQL
What is Constraint _ Why it is needed !!
00:13:30
What is NULL Constraint !!
00:20:58
What is Unique Constraint !!
00:18:27
All about Primary key !! ( Important )
00:33:49
All about the Check Constraint
00:30:16
All about the Default Constraint !!
00:11:17
4
Aggregate Functions
Intro to SUM, MIN & MAX
00:21:08
Count, Diff b/w count & Countd
00:11:31
Group BY Clause
00:20:09
Having Clause
00:10:56
Order By Clause
00:13:05
TOP Clause
00:07:05
DISTINCT Clause with multiple use cases
00:14:09
All about the OFFSET, LIMIT & FETCH Clause
00:20:18
Difference b/w Having & Where
00:03:34
5
All about JOINS & UNION
Introduction to Joins
00:21:07
Inner Join
00:28:47
Left Join
00:19:42
Right Join
00:17:37
Full Outer Join
00:16:19
Cross Joins
00:13:40
Self Join & Interview Ques of Joins
00:21:16
Union & Union All
00:19:31
Diff b/w Union & Union All or Union & Join
00:08:31
6
Sub queries and advanced functions in SQL
Overview About Sub-Queries
00:29:09
Sub Query Practical - Interview Ques
00:36:00
Diff b/w Correlated & Regular Sub-Query
00:06:41
Minus & Except Operator
00:23:07
Intersect Operator
00:07:42
Real Time Advance Interview Question
00:19:58
7
Coalesce & Null Function
Quick Recap _ NVL Function !!
00:21:10
Coalesce Function
00:16;13
Isnull & Null if function
00:15:45
Case When Statement
00:30:41
Order of Execution in SQL
00:10:50
8
STORED PROCEDURE & VIEWS IN SQL
What is stored Procedure in SQL !!
00:24:25
Examples of Stored Procedures !!
00:17:48
Merits and Demerits of Stored Procedures
00:13:15
Stored Procedure with IN Parameter
00:29:13
Stored Procedure with OUT and IN-OUT Parameter
00:19:47
What is Views in SQL
00:15:35
Examples of Views
00:26:00
Merits of Views and Key Takeaways !!
00:13:35
Simple View Vs Complex View and Overview about Materialised view
00:13:28
Difference between Stored Procedures and Views in SQL
00:04:59
9
Index and its types in SQL
What is an Index and Why its needed
00:14:42
Overview about Clustered Index
00:20:51
What Exactly is Clustered Index
00:15:46
Overview about the Non Clustered Index
00:16:49
Practical - Non Clustered Index
00:08:38
Difference between the Clustered Index and Non Clustered Index ( Important )
00:12:26
Maths about Index Interview Ques asked
00:17:25
10
Windows Functions
Aggregate Functions in SQL
00:18:25
All About Windows Functions
0:15:24
Over Clause in SQL
0:27:40
Partition By - Part 1
0:17:50
Partition By - Part 2
0:04:54
Alternative Approach to learn Windows Function
0:21:01
Row Number
0:16:46
Rank Function
0:14:16
Dense Rank Function
0:12:42
Lead lag Function
0:16:48
Aggregate Function with Knowledge Check
0:08:03
All About CTE
0:18:24
CTE Recursive
0:22:48
CTE vs VIEW
0:04:54
- Switch/start or restart your career
- Eligible for SQL developers/data analyst/data scientists /web-app developers
- 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
Introduction to SQL &Bascic Select & From Clause
Introduction to Data
00:04:19What is Big Data
00:10:36What is Database?
00:07:46RBDMS
00:25:37ACID Properties
00:22:30What is SQL and Select, From clause
00:21:42Where Clause
00:16:10AND & OR Operator
00:12:55IN & NOT IN Operator
00:11:53Between & Not Between
00:04:56Is Null & Is Not Null
00:05:42Like & Not Like or Regular Expresessions
00:22:132
Data Types & All about SQL Commands
Data Types in SQL
00:23:36Overview about DQL, DML & DDL
00:10:13Create Clause (DDL)
00:08:00Insert Clause (DML)
00:12:32Alter & Update
00:16:10Delete, Drop & Truncate
00:19:43Difference b/w (DELETE_DROP), (ALTER_UPDATE),(DELETE_TRUNCATE),(DROP_TRUNCATE)
00:12:45Overview about TCL & DDL Commands
00:09:583
Constraints & ER Model & Normalization in SQL
What is Constraint _ Why it is needed !!
00:13:30What is NULL Constraint !!
00:20:58What is Unique Constraint !!
00:18:27All about Primary key !! ( Important )
00:33:49All about the Check Constraint
00:30:16All about the Default Constraint !!
00:11:174
Aggregate Functions
Intro to SUM, MIN & MAX
00:21:08Count, Diff b/w count & Countd
00:11:31Group BY Clause
00:20:09Having Clause
00:10:56Order By Clause
00:13:05TOP Clause
00:07:05DISTINCT Clause with multiple use cases
00:14:09All about the OFFSET, LIMIT & FETCH Clause
00:20:18Difference b/w Having & Where
00:03:345
All about JOINS & UNION
Introduction to Joins
00:21:07Inner Join
00:28:47Left Join
00:19:42Right Join
00:17:37Full Outer Join
00:16:19Cross Joins
00:13:40Self Join & Interview Ques of Joins
00:21:16Union & Union All
00:19:31Diff b/w Union & Union All or Union & Join
00:08:316
Sub queries and advanced functions in SQL
Overview About Sub-Queries
00:29:09Sub Query Practical - Interview Ques
00:36:00Diff b/w Correlated & Regular Sub-Query
00:06:41Minus & Except Operator
00:23:07Intersect Operator
00:07:42Real Time Advance Interview Question
00:19:587
Coalesce & Null Function
Quick Recap _ NVL Function !!
00:21:10Coalesce Function
00:16;13Isnull & Null if function
00:15:45Case When Statement
00:30:41Order of Execution in SQL
00:10:508
STORED PROCEDURE & VIEWS IN SQL
What is stored Procedure in SQL !!
00:24:25Examples of Stored Procedures !!
00:17:48Merits and Demerits of Stored Procedures
00:13:15Stored Procedure with IN Parameter
00:29:13Stored Procedure with OUT and IN-OUT Parameter
00:19:47What is Views in SQL
00:15:35Examples of Views
00:26:00Merits of Views and Key Takeaways !!
00:13:35Simple View Vs Complex View and Overview about Materialised view
00:13:28Difference between Stored Procedures and Views in SQL
00:04:599
Index and its types in SQL
What is an Index and Why its needed
00:14:42Overview about Clustered Index
00:20:51What Exactly is Clustered Index
00:15:46Overview about the Non Clustered Index
00:16:49Practical - Non Clustered Index
00:08:38Difference between the Clustered Index and Non Clustered Index ( Important )
00:12:26Maths about Index Interview Ques asked
00:17:2510
Windows Functions
Aggregate Functions in SQL
00:18:25All About Windows Functions
0:15:24Over Clause in SQL
0:27:40Partition By - Part 1
0:17:50Partition By - Part 2
0:04:54Alternative Approach to learn Windows Function
0:21:01Row Number
0:16:46Rank Function
0:14:16Dense Rank Function
0:12:42Lead lag Function
0:16:48Aggregate Function with Knowledge Check
0:08:03All About CTE
0:18:24CTE Recursive
0:22:48CTE vs VIEW
0:04:54" Hear what our students have to say "
I really enjoyed this course. This course definitely beat my expectations. Sometimes videos are slow Read More
Juhi Punjabi
adsadasdasdsd
Mohammad Mazhar
More courses like this
Data Analytics with Numpy, Pandas & Matplotlib
By Jobaaj Learnings
₹3,499/-₹6,999/-
8,060 Enrolled Students
Pandas Data Operations Mastery
By Jobaaj Learnings
₹4,999/-₹9,999/-
4,000 Enrolled Students
