MySQL for Beginners Ed 3 Certification Training Course Overview

MySQL for Beginners Ed 3 training course enables you to learn about the world's most popular open source database. Koenig Solutions certified instructors will teach you how to use the MySQL Server and tools, while helping you develop deeper knowledge of using relational databases.

MySQL for Beginners Ed 3 (32 Hours) Download Course Contents

Live Virtual Classroom
Group Training 2800
08 - 11 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 09 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 3250
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1: Introduction
  • Features and Benefits of MySQL
  • MySQL Products and Service
  • Community vs. Enterprise
  • MySQL Certification Program
  • MySQL Website
  • MySQL Architecture
  • Install and Start MySQL
Module 2: Database Basics
  • SQL Language and MySQL
  • Database Design
  • Database Modeling
  • Keys
  • Normalization
  • Data Types
  • What is NULL?
  • Viewing Database Structure
Module 3: Database Creation
  • Create a New Database Structure
  • Creating a Database
  • Creating a Table
Module 4: Basic Queries
  • The SELECT Command
  • MySQL Query Browser
  • Troubleshooting
Module 5: Database Maintenance
  • Delete an Entire Database
  • Maintaining Tables
  • Maintaining Columns
  • Indexes and Constraints
  • Data Manipulation
Module 6: Delete/Modify Table row Data
  • The INSERT Command
  • The REPLACE Command
  • The UPDATE Statement
  • The DELETE Command
Module 7: Functions
  • Simple Functions
  • Grouping With Functions
Module 8: Joining Tables
  • Combining Multiple Tables
  • Inner Joins
  • Outer Joins
Module 9: Exporting/Importing Data
  • Exporting Data
  • Importing Data
Module 10: Sub queries
  • What is a Sub query?
  • Categories of Sub queries
  • Sub query Types
  • Placing Sub queries
  • Other Sub query Uses
Module 11: Supplementary Information
  • Creating VIEWs
  • Transactions
  • Storage Engines
  • Retrieving Metadata
Module 12: Conclusion
  • Course Review
  • Training and Certification Website
  • Course Evaluation
  • Thank You
  • QA Session
Download Course Contents

Request More Information

Course Prerequisites
  • Basic knowledge of database

After completion of this course; you will learn following:-

  • Explain MySQL storage engines
  • Explain database transactions
  • Obtain database metadata
  • Describe MySQL GUI tools
  • Monitor database performance
  • Perform database backup and recovery
  • Export and import database data
  • Describe the features and benefits of MySQL
  • Explain the basics of relational databases
  • Design an effective database
  • Build a database and tables by using SQL Modify or delete database entities
  • Query data with the SELECT command
  • Join data from multiple tables
  • Perform nested subqueries
  • Use built-in MySQL functions

FAQ's


Yes, fee excludes local taxes.