Mastering SQL: Comprehensive Notes for Effective Data Management

WELCOME, TO SQL COURSE
STEP
BASIC BY
STEP
ADVANCE


By Rishabh Mishra

,Complete SQL With Notes
1. Introduction to SQL-What Is SQL & Database
2. Data Types, Primary-Foreign Keys & Constraints
a. Install postgresql and pgadmin4
3. Create Table In SQL & Create Database
4. INSERT UPDATE, DELETE & ALTER Table
5. SELECT Statement & WHERE Clause with Example
6. How To Import Excel File (CSV) to SQL
7. Functions in SQL & String Function
8. Aggregate Functions – Types & Syntax
9. Group By and Having Clause
10. Time Stamp and Extract Function, Date Time Function
11. SQL JOINS – Types & Syntax
12. SELF JOIN, UNION & UNION ALL
13. Subquery
14. Window Function – Types & Syntax
15. Case Statement/Expression with examples
16. CTE- Common Table Expression with examples
SQL By Rishabh Mishra

,WHAT IS SQL & DATABASE-
INTRODUCTION
SQL Tutorial In Hindi-1




SQL By Rishabh Mishra

, Introduction to SQL
• What is SQL
• It’s applications
• SQL v/s NoSQL
• Types of SQL Commands
• What is Database
• Excel v/s Database in SQL

SQL By Rishabh Mishra