Become an MySQL Developer under 2 Hour by writing complex database queries with full practical exercises NOT with Boring Theory

Introduction

SQL Basics2 lectures

• BASIC : SQL, DATABASE, DBMS, MySQL

  
  

• Refer Docs : SQL, DATABASE, DBMS, MySQL

  
  

Installation of MySQL WorkBench2 lectures

• Download and Install MySQL WorkBench

  
  

• Refer Docs : Installation

  
  

SQL Database Basic Operations2 lectures

• CREATE, USE, SHOW, DROP DATABASE

  
  

• CODE : CREATE, USE, SHOW, DROP DATABASE

  
  

MySQL Table Operations13 lectures

• CREATE, DROP TABLE

  
  

• CODE : CREATE DROP TABLE

  
  

• INSERT TABLE

  
  

• CODE : INSERT TABLE

  
  

• DELETE TABLE

  
  

• CODE : DELETE TABLE

  
  

• RENAME TABLE

  
  

• CODE : RENAME TABLE

  
  

• ADD COULUMN TO TABLE

  
  

• CODE : ADD COLM

  
  

• TRUNCATE TABLE

  
  

• CODE : TRUNCATE TABLE

  
  

• CODE : COMPLETE CODE

  
  

MySQL Select Statement6 lectures

• SELECT STATEMENT

  
  

• CODE : SELECT STATEMENT

  
  

• COUNT

  
  

• CODE : COUNT

  
  

• SUM

  
  

• CIDE : SUM

  
  

MySQL Clause4 lectures

• WHERE

  
  

• CODE : MySQL WHERE

  
  

• AND _ OR

  
  

• CODE : AND OR

  
  

MySQL Data Types6 lectures

• DATA TYPE Lecture -1

  
  

• DATA TYPE LECTURE 2

  
  

• MySQL String Data Types

  
  

• MySQL Numeric Data Types

  
  

• MySQL Date and Time Data Types

  
  

• Extra : Code

  
  

MySQL Order By2 lectures

• ORDER By Clause

  
  

• CODE : ORDER By Clause

  
  

MySQL Update2 lectures

• UPDATE Statement

  
  

• CODE : MySQL UPDATE

  
  

• SQL DELETE

MySQL Arithmetic Operators2 lectures

• Arithmetic Operators

  
  

• CODE : Arithmetic Operators

  
  

MySQL Join7 lectures

• SQL JOINS AND INNER JOIN

  
  

• CODE : SQL JOINS PREREQUISITES

  
  

• CODE : INNER JOIN

  
  

• LEFT JOIN

  
  

• CODE : LEFT JOIN

  
  

• RIGHT JOIN

  
  

• CODE : RIGHT JOIN

Extra1 lecture

• Thank you

SQL tutorial provides basic and advanced concepts of SQL. Our SQL tutorial is designed for both beginners and professionals.

SQL (Structured Query Language) is used to perform operations on the records stored in the database, such as updating records, inserting records, deleting records, creating and modifying database tables, views, etc.

SQL is not a database system, but it is a query language.