MySQL Database for Beginners Course
Why MySQL?
One of the most popular open relational database management systems is MySQL (RDBMS). This instructor-led, hands-on classroom training will teach you how to install MySQL and create a database from scratch. Our MySQL Database for Beginners course covers all of the fundamental syntax and SQL statements for creating, inserting, updating, and deleting data, as well as managing tables.
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
Final Project
- MySQL Database Management Final Project
International Student Fee : 100 USD | 375 AED | 375 SAR
Flexible Class Options
- Corporate Group Training | Fast-Track
- Week End Classes For Professionals SAT | SUN
- Online Classes – Live Virtual Class (L.V.C), Online Training
