SQL Tutorial in Hindi for Data Analysts (Rishabh Mishra)

About this course

A practical SQL course in Hindi with PostgreSQL, from creating tables to window functions and CTEs, ending with a portfolio project and interview questions for data analysts. Who it's for: aspiring data analysts and beginners who want to learn SQL in Hindi. Taught in Hindi. These are the free, official videos of the "SQL Tutorial In Hindi" playlist from the Rishabh Mishra YouTube channel (youtube.com/@rishabhmishraofficial). All videos belong to Rishabh Mishra; Sikhami is not affiliated with Rishabh Mishra and simply arranges the public playlist into a course, so you can learn one lesson at a time and keep track of your progress.

What you will learn

• What SQL is, data types, keys and constraints • Creating databases and tables; insert, update, delete and alter • SELECT, WHERE, string and date functions • Aggregate functions, GROUP BY and HAVING • Joins, including self joins, UNION and CASE expressions • Window functions, WITH clauses and recursive CTEs • A music store analysis project and SQL interview questions

Course content

1 section · 21 lectures · 4h 11m

1. 1. SQL Tutorial In Hindi

   • What Is SQL ? | Database in SQL | SQL Introduction | SQL Tutorial In Hindi 17m
   • Data Types, Primary-Foreign Keys & Constraints in SQL | SQL Tutorial In Hindi 28m
   • how to install postgresql and pgadmin45m
   • Create Table In SQL & Create Database | SQL Tutorial In Hindi 38m
   • INSERT UPDATE, DELETE & ALTER Table in SQL With Example | SQL Tutorial in Hindi 46m
   • SELECT Statement & WHERE Clause with Example | Operators in SQL | SQL Tutorial in Hindi 57m
   • How To Import Excel File (CSV) to SQL | Import Data From File | SQL Tutorial in Hindi 63m
   • String Functions in SQL | Functions in SQL | SQL Tutorial in Hindi 77m
   • Aggregate Functions in SQL - COUNT, SUM, AVG, MAX, MIN | SQL Tutorial in Hindi 85m
   • Group By and Having Clause in SQL | SQL Tutorial in Hindi 910m
   • TimeStamp and Extract Function | Date Time Function | SQL Tutorial in Hindi 107m
   • Complete SQL JOINS For Beginners | SQL JOIN Queries with Examples | SQL Tutorial in Hindi 1120m
   • SQL SELF JOIN | UNION & UNION ALL in SQL | SQL Tutorial in Hindi 128m
   • Complete SQL Subquery Using Comparison and Logical Operators | SQL Tutorial in Hindi 1311m
   • SQL Window Function with Example- RANK, DENSE RANK, ROW NUMBER, LEAD/LAG | SQL Tutorial in Hindi 1421m
   • SQL Case Statement/Expression with Examples | WHEN THEN ELSE in sql | SQL Tutorial in Hindi 158m
   • SQL WITH Clause with examples | SQL CTE (Common Table Expression) | SQL Tutorial in Hindi 1611m
   • Recursive CTE | Recursive SQL Queries | SQL Tutorial in Hindi 1716m
   • Data Analyst Portfolio Project - Music Store Data Analysis Project using SQL45m
   • Most Asked SQL Interview Question - Solved Using 3 Methods14m
   • Solve SQL Interview Questions for Data Analyst - Product Based Company Job Interview15m