Mysql for Software Testers

Learn Backend Testing using MySQL

4.75 (2 reviews)
Udemy
platform
English
language
Other
category
instructor
Mysql for Software Testers
8
students
5.5 hours
content
Jun 2023
last update
$44.99
regular price

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

Why take this course?

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


Charts

Price

Mysql for Software Testers - Price chart

Rating

Mysql for Software Testers - Ratings chart

Enrollment distribution

Mysql for Software Testers - Distribution chart
5248576
udemy ID
4/2/2023
course created date
7/5/2023
course indexed date
Bot
course submited by