What You Will Learn!
- What is Data? What is Database What is DBMS Types of DBMS Introduction to MySQL Database Structured Query Language (SQL) Installation of Mysql Workbench
- Create Databases IF NOT Exists command Creating Table in Mysql Datatypes in MYSQL How to use SELECT in MySQL WHERE Clause WHERE clause combined with logical op
- Wildcard in MySQL Aggregate Function in Mysql Distinct Keyword in Mysql Null as a value in Mysql Null as a keyword in Mysql Not Null in Mysql Alter Command Drop
- Super Key, Candidate Key Primary Key ALternate Key Compund/Coposite Key Unique Key Foreign Key Defining Key in SQL Server Difference Between Primary Key & Uniqu
Description
What is Data?
What is Database
What is DBMS
Types of DBMS
Introduction to MySQL Database
Structured Query Language (SQL)
Installation of Mysql Workbench
Create Databases
IF NOT Exists command
Creating Table in Mysql
Datatypes in MYSQL
How to use SELECT in MySQL
WHERE Clause
WHERE clause combined with logical operators
WHERE clause combined with comparison operators
INSERT command in MySQL
DELETE command in MySQL
ORDER BY Clause in MySQL
Sorting the data
Alias Field Names
Update Command in Mysql
Group By in Mysql
Grouping using Single Column
Grouping using Multiple Column
Grouping and Aggregate Function
Having Clause
Wildcard in MySQL
Aggregate Function in Mysql
Distinct Keywords in Mysql
Null as a value in Mysql
Null as a keyword in Mysql
Not Null in Mysql
Alter Command
Drop Command
Rename Command
Limit Keywords in Mysql
Offset in Limit query in Mysql
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Control Language (DCL)
TCL
(DML) Select, Update, Delete, and Insert Into statements
(DDL) Create, Alter, and Drop statements
Super Key, Candidate Key
Primary Key
Alternate Key
Compound/Composite Key
Unique Key
Foreign Key
Defining Key in SQL Server
Difference Between Primary Key & Unique Key
Difference Between Primary Key & Foreign Key
What are Sub Queries in Mysql
Union of tables in MySQL
Joins in MySQL
Types of Joins
Inner Join
Left Join
Right Join
Truncate Table Command
Difference between DELETE, TRUNCATE & DROP Command
Who Should Attend!
- Beginners to Backend Testing, Database learners