[NEW] The Complete SQL BootCamp for Beginners 2024

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.