Mysql for Software Testers

[nieriorefasow63]

Mysql for Software Testers

Published 6/2023
Created by Kiran Sahu
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 11 Lectures ( 5h 27m ) | Size: 4.8 GB


Learn Backend Testing using MySQL

What you'll 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

Requirements
No Backend experience needed, You will learn everything you need

Description
What is Data?What is Database What is DBMSTypes of DBMSIntroduction to MySQL Database Structured Query Language (SQL) Installation of Mysql WorkbenchCreate DatabasesIF NOT Exists commandCreating Table in MysqlDatatypes in MYSQLHow to use SELECT in MySQLWHERE ClauseWHERE clause combined with  logical operatorsWHERE clause combined with comparison operatorsINSERT command in MySQLDELETE command in MySQLORDER BY Clause in MySQLSorting the dataAlias Field NamesUpdate Command in MysqlGroup By in MysqlGrouping using Single ColumnGrouping using Multiple ColumnGrouping and Aggregate FunctionHaving ClauseWildcard in MySQLAggregate Function in MysqlDistinct Keywords in MysqlNull as a value in MysqlNull as a keyword in MysqlNot Null in MysqlAlter CommandDrop CommandRename Command Limit Keywords in MysqlOffset in Limit query in MysqlData 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 KeyPrimary KeyAlternate KeyCompound/Composite KeyUnique KeyForeign KeyDefining Key in SQL ServerDifference Between Primary Key & Unique KeyDifference Between Primary Key & Foreign KeyWhat are Sub Queries in MysqlUnion of tables in MySQLJoins in MySQLTypes of JoinsInner JoinLeft Join Right JoinTruncate Table CommandDifference between DELETE, TRUNCATE & DROP Command

Who this course is for
Beginners to Backend Testing, Database learners

HOMEPAGE

[To see links please register or login]

DOWNLOAD

[To see links please register or login]