Achieve SQL Mastery - In Hindi

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