• views: 106
• date: 29 June 2023
• posted by: voska89

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

https://www.udemy.com/course/mysql-for-software-testers/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.