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 Practical – MySQL Server Installation

  1. LMS
  2. SQL Certification Course with AI & ChatGPT [English]
  3. Understanding SQL
  4. SQL Practical – MySQL Server Installation
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