Mysql for Software Testers

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

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

Who Should Attend!

• Beginners to Backend Testing, Database learners

TAKE THIS COURSE