Skip to content
SQL Certification Course with AI & ChatGPT [English]
About the Course
Expand
About the Course
2 Topics
Welcome to TechVidvan
Important Note
Understanding SQL
Sample Lesson
Collapse
Understanding SQL
10 Topics
Introduction to SQL
Notes – Introduction to SQL
SQL Interview Questions – SQL Basic Questions
SQL Prerequisites
What is SQL and Purpose of SQL
SQL Practical – MySQL Server Installation
SQL Practical – SQLYog Installation
Difference Between DBMS and RDBMS
SQL Database and Database Server
SQL Practical – Comments Implementation
CR1
Commands in SQL
Expand
Commands in SQL
8 Topics
SQL Commands
SQL DDL Statements
SQL DML Statements
SQL TCL Command
SQL Practical – TCL Command
SQL DCL Command
SQL Practical – DCL Command
Notes – Commands in SQL
CR-2
Data Type in SQL
Expand
Data Type in SQL
4 Topics
SQL Data Type
SQL Practical – Date Data Type
Notes – Data Type in SQL
SQL Interview Qusetions – SQL Data Types
CR-3
Operators in SQL
Expand
Operators in SQL
5 Topics
SQL Operators – Arithmetic, Relational and Logical
SQL Practical – Arithmetic, Relational and Logical Operators
SQL String Operators
SQL Practical – Like and Not Like Command
Notes – Operators in SQL
CR-4
Clauses in SQL
Expand
Clauses in SQL
15 Topics
Constraints in SQL
Notes – Constraints in SQL
SQL Interview Qusetions – SQL Constraints
Order by Clause in SQL
SQL Practical – Order by Clause
Notes – Order by Clause in SQL
GROUP BY and HAVING in SQL
Notes – GROUP BY and HAVING in SQL
Like Command in SQL
Notes – Like Command in SQL
Between and In Command in SQL
SQL Practical – Between and In Command
SQL Practical – ANY and ALL Operators
Alias in SQL
Notes – Alias in SQL
CR-5
SQL Joins
Expand
SQL Joins
4 Topics
Joins in SQL
SQL Practical – Self Join
Notes – Joins in SQL
SQL Interview Questions – SQL Joins
CR-6
SQL Keys
Expand
SQL Keys
3 Topics
Primary Key and Foreign Key Constraint in SQL
SQL Practical – Primary Key and Foreign Key Constraint
SQL Interview Questions – Foreign Key & Relationships
CR-7
Advanced SQL
Expand
Advanced SQL
12 Topics
SQL Injection
SQL Practical – Implementation of Injection
SQL Practical – Null Functions
Check Constraint in SQL
SQL Practical – Check Constraint
Default Constraint in SQL
SQL Practical – Default Constraint
Null Value in SQL
Notes – Null Value in SQL
Auto Increment in SQL
Notes – Auto Increment in SQL
SQL Interview Questions – Auto Increment
CR-8
Functions in SQL
Expand
Functions in SQL
13 Topics
Aggregate Functions in SQL
SQL Practical – Aggregate Functions
Notes – Aggregate Functions in SQL
SQL Interview Question – Aggregate Functions
SQL Practical – String Functions
SQL Interview Questions – String Functions
Nested Query in SQL
Notes – Nested Query in SQL
SQL Window Function
SQL Practical – Window Function Implementation Part – 1
SQL Practical – Window Function Implementation Part – 2
SQL Practical – Bulk Insert
SQL Practical – Backup and Restore
Projects using SQL
Expand
Projects using SQL
2 Topics
SQL Library Management System Project
SQL Sales Data Analysis Project
Previous Topic
Next Topic
SQL Prerequisites
LMS
SQL Certification Course with AI & ChatGPT [English]
Understanding SQL
SQL Prerequisites
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
X
Have Questions?
Talk directly to the Instructor
Please leave this field empty.
Δ
Our executives will arrange a call with the Instructor shortly
X
Career Counselling
Please leave this field empty.
Δ
X
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