MySQL for Beginners Ed 3 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.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

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
  • SQL Language and MySQL
  • Database Design
  • Database Modeling
  • Keys
  • Normalization
  • Data Types
  • What is NULL?
  • Viewing Database Structure
  • Create a New Database Structure
  • Creating a Database
  • Creating a Table
  • The SELECT Command
  • MySQL Query Browser
  • Troubleshooting
  • Delete an Entire Database
  • Maintaining Tables
  • Maintaining Columns
  • Indexes and Constraints
  • Data Manipulation
  • The INSERT Command
  • The REPLACE Command
  • The UPDATE Statement
  • The DELETE Command
  • Simple Functions
  • Grouping With Functions
  • Combining Multiple Tables
  • Inner Joins
  • Outer Joins
  • Exporting Data
  • Importing Data
  • What is a Sub query?
  • Categories of Sub queries
  • Sub query Types
  • Placing Sub queries
  • Other Sub query Uses
  • Creating VIEWs
  • Transactions
  • Storage Engines
  • Retrieving Metadata
  • Course Review
  • Training and Certification Website
  • Course Evaluation
  • Thank You
  • QA Session
Live Online Training (Duration : 32 Hours)
Group Training 3050 Per Participant Incl. Official Courseware
30 May - 02 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
06 - 09 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 07 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training 6100 3500 + If you accept merging of other students. Incl. Official Courseware
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Ultra-Fast Track

If you can't spare 32 hours. We can offer you an Ultra-Fast Track for 16 hours for only USD 2,800

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

Request More Information

Add Name and Email Address of participant (If different from you)

FAQ's


No, the published fee includes all applicable taxes.
The Fee includes:
  • Official courseware
Yes, Koenig Solutions is a Oracle Learning Partner