Mysql for Software Testers - Printable Version +- Softwarez.Info - Software's World! (https://softwarez.info) +-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone) +--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials) +--- Thread: Mysql for Software Testers (/Thread-Mysql-for-Software-Testers) |
Mysql for Software Testers - nieriorefasow63 - 06-29-2023 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 DOWNLOAD |