MySQL Database for Beginners🏷️

MySQL Course Key Learning 

Module-o1 MySQL Introduction

• MySQL Introduction
• What is SQL?
• Installing MySQL on Mac
• Installing MySQL on Windows
• Creating the Databases for this Course

Module-o2 Working with My SQL Statements and Operators

• The SELECT Statement
• The SELECT Clause
• The WHERE Clause
• The AND, OR, and NOT Operators
• The IN Operator
• The BETWEEN Operator
• The LIKE Operator
• The REGEXP Operator
• The IS NULL Operator
• The ORDER BY Operator
• The LIMIT Operator

Module-o3 Working with Joins

• Inner Joins
• Joining Across Databases
• Self Joins
• Joining Multiple Tables

Module-o4 Using Joins and Unions

• Compound Join Conditions
• Implicit Join Syntax
• Outer Joins
• Outer Join Between Multiple Tables
• Self Outer Joins
• The USING Clause
• Natural Joins
• Cross Joins
• Unions

Module-o5  Using Joins and Unions

• Column Attributes
• Inserting a Single Row
• Inserting Multiple Rows
• Inserting Hierarchical Rows
• Creating a Copy of a Table

Module-o6  Using Joins and Unions

• Updating a Single Row
• Updating Multiple Rows
• Using Subqueries in Updates
• Deleting Rows
• Restoring Course Databases

Flexible Class Options

• Week End Classes For Professionals  SAT | SUN
• Corporate Group Trainings Available
• Online Classes – Live Virtual Class (L.V.C), Online Training