Skip to content

SQL Certification Course with AI & ChatGPT [Hindi]

Getting Started

About the Course

Welcome to TechVidvan

Important Note

SQL Introduction Sample Lesson

Introduction to SQL

What is SQL?

Notes – Introduction to SQL

SQL Interview Questions – SQL Basic Questions

Difference Between DBMS and RDBMS in SQL

Database vs Database Server in SQL

SQL Practical – How to Install MySQL

SQL Practical – Implementation of Comments

CR1

SQL Study Materials

SQL Study Material Part – 1

SQL Study Material Part – 2

SQL Study Material Part – 3

CR-2

SQL Commands Part – 1 Sample Lesson

Commands in SQL

SQL DDL Command

SQL Practical – Implementation of DDL Command in SQL

SQL DML Command Statements – INSERT, SELECT Commands

SQL DML Command Statements – DELETE, UPDATE Commands

SQL Practical – Practical Implementation of DML Command in SQL

SQL Commands Part – 2

TCL Command in SQL

SQL Practical – TCL Command

DCL Command in SQL

SQL Practical – DCL Command

Notes – Commands in SQL

SQL Practical – How to Install SQLyog in SQL

SQL Practical – How We Can Use MySQL Workbench in SQL

CR-3

SQL Data Type

MySQL Data Types in SQL

MySQL String Data Type in SQL

MySQL Numeric Data Type in SQL

SQL Practical – Date Data Type

Notes – Data Type in SQL

SQL Interview Qusetions – SQL Data Types

SQL Operators

SQL Practical – Arithmetic Operator

SQL Relational Operators

SQL Practical – String Operators and Functions Part – 1

SQL Practical – String Operators and Functions Part – 2

Notes – Operators in SQL

CR-4

SQL Clauses

SQL Constraints

SQL Practical – How to Use Constraints in MySQL

Notes – Constraints in SQL

SQL Interview Qusetions – SQL Constraints

ORDER BY Clause in SQL

SQL Practical – Implementation of ORDER BY Clause in SQL

Notes – Order by Clause in SQL

GROUP BY and HAVING in SQL

SQL Practical – How to Use GROUP BY and HAVING Clause in SQL

Notes – GROUP BY and HAVING in SQL

SQL LIKE Operator

SQL Practical – Implementation of LIKE Command in SQL

Notes – Like Command in SQL

SQL Clauses Part – 2

SQL Practical – ANY, ALL Operators

SQL NULL Values | IS NULL and IS NOT NULL Values in SQL

SQL Practical – Implementation of IS NULL and IS NOT NULL Value in SQL

Notes – Null Value in SQL

Between and In Command in SQL

SQL Practical – How to Use Between and In Command in SQL

SQL Practical – Union and Union All Command

Introduction to Aliases in SQL

SQL Practical – How to Use Aliases in SQL

How to join tables in SQL

SQL Practical – Implementation of Joins

SQL Practical – Self Join

Notes – Joins in SQL

SQL Interview Questions – SQL Joins

Keys in SQL

Primary Key and Foreign Key in SQL

SQL Practical – Primary Key and Foreign Key

SQL Interview Questions – Foreign Key & Relationships

CR-6

Advance SQL

SQL Injection

SQL Practical – Injection Implementation

Null Function in SQL

SQL Practical – Null Functions

SQL CHECK Constraint

How to apply CHECK constraint in Database

SQL Default Constraint

How to apply DEFAULT constraint in Database

Auto Increment in SQL

How to apply AUTO increment constraint in Database

Notes – Auto Increment in SQL

SQL Interview Questions – Auto Increment

SQL Functions

SQL Practical – String Function

SQL Interview Questions – String Functions

SQL Aggregate Functions

SQL Practical – Implementation of SQL Aggregate Functions

Notes – Aggregate Functions in SQL

SQL Interview Question – Aggregate Functions

Nested Query in SQL

SQL Practical – How to Implement Nested Query in SQL

Notes – Nested Query in SQL

Window Function in SQL

SQL Practical – Window Function Part – 1

SQL Practical – Window Function Part – 2

SQL Practical – Case Command

SQL Practical – Implementation of Bulk Insert

SQL Practical – Backup and Restore

CR-7

SQL Projects

SQL Project – Library Management System

SQL Project – Sales Data Analysis

Get Ready for Top MNCs

SQL Quizzes

SQL Interview Questions

Get Your Dream Job in Top MNC

How to Apply for Jobs

Important Resume Tips

Create Strong Social Media Presence

CR-8

Previous Topic

Next Topic

SQL DML Command Statements – DELETE, UPDATE Commands

LMS
SQL Certification Course with AI & ChatGPT [Hindi]
SQL Commands Part – 1
SQL DML Command Statements – DELETE, UPDATE Commands

Previous Topic

Back to Lesson

Next Topic

Fill the form to proceed
Upskill & get ready for AI-era

Please leave this field empty.

Δ

Our executives will contact you shortly

Have Questions?
Talk directly to the Instructor

Please leave this field empty.

Δ

Our executives will arrange a call with the Instructor shortly

Career Counselling

Please leave this field empty.

Δ

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Signup / Login with Google

Signup / Login with X

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account