Skip to content
SQL Certification Course with AI & ChatGPT [English]
About the Course
Welcome to TechVidvan
Important Note
Understanding SQL Sample Lesson
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
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
SQL Data Type
SQL Practical – Date Data Type
Notes – Data Type in SQL
SQL Interview Qusetions – SQL Data Types
CR-3
Operators in SQL
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
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
Joins in SQL
SQL Practical – Self Join
Notes – Joins in SQL
SQL Interview Questions – SQL Joins
CR-6
SQL Keys
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
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
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
SQL Library Management System Project
SQL Sales Data Analysis Project
TechVidvan logo
Previous Topic
Next Topic

SQL Prerequisites

  1. LMS
  2. SQL Certification Course with AI & ChatGPT [English]
  3. Understanding SQL
  4. SQL Prerequisites
Previous Topic
Back to Lesson
Next Topic
Fill the form to proceed
Upskill & get ready for AI-era






    Our executives will contact you shortly

    Have Questions?
    Talk directly to the Instructor






      Our executives will arrange a call with the Instructor shortly

      talk to the instructor
      Career Counselling





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

        Signup / Login with Google
        Signup / Login with X
        Lost Your Password?
        TechVidvan logo
        Register
        Don't have an account? Register one!
        Register an Account