Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
8 Hour(s) 41 Minute(s)
Language
English
Taught by
Harshit Bhadiyadra
Rating
Course Overview
The First ever Complete SQL Mastery Course in Hindi
It is specifically designed for Hindi Audience , means speficially designed for (Indian and Asian Audience or those who understands Hindi.)
Note: This course is in preparation phase - i will let you all know here only , once it is fully completed, but still you can take this course, as i am uploading videos on daily basis.
You will learn the SQL from 10 + years of experience in data industries. Yes, you heared it right, I have worked on serveral MNCs in SQL related projects like Google Alphabets, Capgemini, Globant, LtIMindtree, Kaseya software.
The most complete SQL course on the internet — built by a real data professional. After having this course, you don't need to take any other course related to SQL, that's my guarantee.
Course Content :
Section - 1 Introduction
Introduction to the Course Content
Install SQL Server and SSMS
More on Installation of SQL Server and SSMS
What is SQL and Database
Why SQL
Basics of Data Modeling
SQL Components
Section - 2 SQL Commands and Basics of SQL Statements
Create Databasse and Create Tables
Alter - Drop and Truncate Commands
DML - Commands - Insert - Update - Delete
Basics of Select Statements
Where Clauses in Detailed Part - 1
Where Clauses in Detailed Part - 2
Group by Clause Part - 1
Group by Clause Part - 2
Rollup and Cube
Case Statements
Section - 3 SQL Constraints
Table Creation using All the Constraints
Constraints in more Detailed Level Part - 1
Constraints in more Detailed Level Part - 2
Constraints in more Detailed Level Part - 3
Section - 4 SET OPERATORS
UNION
UNION ALL
INTERSECT
EXCEPT
Section - 5 JOINS
INNER JOIN
LEFT
RIGHT
FULL OUTER JOIN
CROSS JOIN
SELF JOIN
LEFT ANTI JOIN
RIGHT ANTI JOIN
FULL OUTER ANTI JOIN
Section - 6 IN - BUILT FUNCTIONS
STRING FUNCTIONS
NUMBER FUNCTIONS
DATE - TIME FUNCTIONS
CONVERSION FUNCTIONS
NULL FUNCTIONS
AGGREGATE FUNCTIONS
Section - 7 SUB QUERIES
SELF CONTAINED SUBQUERY
SINGLE VALUED SUBQUERY
MULTI - VALUED SUBQUERY
CORELATED SUBQUERY
DERIVED TABLES
Section - 8 COMMON TABLE EXPRESSIONS
STANDALONE CTE
MULTIPLE CTE
RECURSIVE Section
Course Content
- 8 section(s)
- 47 lecture(s)
- Section 1 Introduction
- Section 2 SQL Commands and Basics of SQL Statements
- Section 3 SQL Constraints
- Section 4 Set Operators in SQL
- Section 5 Joins in SQL
- Section 6 In Built Functions in SQL
- Section 7 Subqueries
- Section 8 Common Table Expressions
What You’ll Learn
- Introduction to SQL, Components of SQL, Types of SQL Commands, Constraints IN SQL, Query Data SELECT - ORDER BY - DISTINCT - TOP CLAUSE - OFFESET -FETCH - GROUP BY - HAVING - CUBE - ROLLUP, Filtering Data AND Operators in SQL, CASE STATEMENTS, SET Operators, SQL Joins, In-Built Functions - String, Date Functions, Special Functions, NULL, Aggregate Functions, Conversion Functions - CAST - CONVERT - TRY PARSE, Derived Tables, Subqueries and Corelated Subqueries, Common Table Expressions CTE and Multiple CTEs, Recursive CTEs
Skills covered in this course
Reviews
-
KKajal
SQL सीखने के लिए यह सबसे बेहतरीन Hindi course है। Concepts बहुत simple language में समझाए गए हैं और real-world examples ने SQL को आसान बना दिया
-
IIla Siddhpura
This course explains SQL concepts very clearly in Hindi, which makes it much easier to understand, especially for beginners. The instructor starts from basics and gradually moves to advanced queries with practical examples. I liked how complex topics like joins and subqueries were broken down simply. Definitely recommended for anyone who wants to learn SQL in Hindi.
