MySQL Lectures

• What is Database
  
• What is Relational Database
• What is SQL
• What is MySQL
• Install MySQL in Windows OS
• What is MySQL Workbench
• How to Configure MySQL Command and Set Environment Variable in Windows OS
• How to Log in to MySQL Database through Command Line and MySQL Workbench
  
• What is Database Schema
• Creating a MySQL Database Using Command Line and MySQL Workbench
  
• View a List of All Databases in MySQL: Command Line and MySQL Workbench
  
• Check the Currently Selected MySQL Database via Command Line and MySQL Workbench
  
• Selecting MySQL Database Through Command Line and MySQL Workbench
  
• Deleting a MySQL Database: Command Line and MySQL Workbench
• What is Signed and Unsigned Integers
  
• What is DataType in MySQL Database
  
• Number Datatype in MySQL
  
• Strings Datatype in MySQL
  
• Binary Datatype in MySQL
  
• SET Datatype in MySQL
  
• ENUM Datatype in MySQL
  
• What is Database Table
• Creating a Table in MySQL Workbench
  
• Alter Command in MySQL Workbench
• TRUNCATE Command in MySQL Workbench
  
• Drop Command in MySQL Workbench
  
• Inserting Data into Table Using MySQL Workbench
  
• Table's Records Update Query in MySQL Workbench
  
• Delete Table's Record in MySQL Workbench
• SELECT Query: Retrieving Data in MySQL Workbench
  
• How can we use alias name in mysql workbench
  
• WHERE clause in MySQL Workbench
  
• Constraints in MySQL Workbench
  
• Aggregate Functions in MySQL Workbench
• IS NULL and IS NOT NULL Operators in MySQL Workbench
• LIKE operator in mysql workbench
  
• DISTINCT Clause in MySQL Workbench
• LIMIT and OFFSET in MySQL Workbench
  
• What is Primary Key in MySQL Workbench
  
• What is Foreign Key in MySQL Workbench
  
• What is Database Transaction
  
• Commit and Rollback Operation in MySQL
  
• SQL Injection
  
• MySQL SubQueries
• EXIST and NOT EXIST Clause in MySQL
  
• Use Variables in MySQL Workbench
• UNION and UNION ALL in MySQL Workbench
• IF ELSE and CASE Conditional Statements in MySQL Workbench
• JOIN Operations in MySQL Workbench
  
• INNER JOINs in MySQL Workbench
  
• LEFT JOIN in MySQL Workbench
  
• RIGHT JOIN in MySQL Workbench
  
• CROSS JOIN in MySQL Workbench
• GROUP BY and HAVING Clause in MySQL Workbench