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