MySQL

Live Online (VILT) & Classroom Corporate Training Course

MySQL is a popular, open-source relational database management system owned by Oracle. While MySQL is often thought of as a component of the LAMP (Linux-Apache-MySQL-PHP) stack, MySQL runs on a wide array of other operating systems, including Windows, Solaris, and macOS.
MySQL Logo

How can we help you?

  • CloudLabs
    CloudLabs
  • Projects
    Projects
  • Assignments
    Assignments
  • 24x7 Support
    24x7 Support
  • Lifetime Access
    Lifetime Access
Box

Overview

MySQL training course teaches attendees how to develop SQL statements, views, stored procedures, and triggers for their MySQL databases. Participants also learn how to design and implement a database and how to work with foreign keys, transactions, and stored programs.

Box

Objectives

At the end of MySQL training course, participants will

  • Work with any database
  • Use MySQL Workbench to work with a database and run SQL statements
  • Retrieve, add, update, and delete data from a database
  • Work with summary queries, subqueries, data types, and functions
  • Use MySQL Workbench to create an EER (enhanced entity-relationship) model for their database
  • Design and implement their own databases
  • Use MySQL to create stored procedures, functions, triggers, and events
  • Manage transactions and locking
Box

Prerequisites

Experience in basic computer literacy with previous experience with command-line programs and some knowledge of database concepts is required. Some knowledge of data retrieval and reporting would be beneficial.

Box

Course Outline

  • An Introduction to Client/Server Systems
  • An Introduction to the Relational Database Model
  • An Introduction to SQL and SQL-Based Systems
  • The SQL Statements
  • How to Use SQL From An Application Program

  • An Introduction to MySQL Workbench
  • Using Workbench to Run SQL Statements
  • Using the Reference Manual
  • Command Line Client

  • An Introduction to the SELECT Statement
  • The SELECT Clause
  • The WHERE Clause
  • The ORDER BY Clause
  • The LIMIT Clause

  • Inner Joins
  • Outer Joins
  • Other Skills For Working With Joins
  • How to Work With Unions

  • Creating Test Tables
  • Inserting New Rows
  • Updating Existing Rows
  • Deleting Existing Rows

  • Aggregate Functions
  • How to Group and Summarize Data

  • An Introduction to Subqueries
  • How to Code Subqueries In the WHERE Clause
  • How to Code Subqueries In Other Clauses
  • Working With Complex Queries

  • Converting Data
  • Working With Data Types

  • String Data
  • Numeric Data
  • Date/Time Data
  • Other Functions You Should Know About

  • Design A Data Structure
  • Normalize A Data Structure
  • Using MySQL Workbench For Database Design

  • Databases
  • Tables
  • Indexes
  • A Script That Creates A Database
  • How to Use MySQL Workbench
  • Character Sets and Collations
  • Storage Engines

  • An Introduction to Views
  • How to Work With Views

  • An Introduction to Stored Programs
  • How to Write Procedural Code

  • How to Work With Transactions
  • How to Work With Concurrency and Locking

  • Coding Stored Procedures
  • Coding Stored Functions
  • How to Use Workbench With Procedures and Functions

Box

Testimonials

Shamsudeen Bawa

Synergific Software Team has been very supportive, and working with them has been a best decision that we could ever made, They are just a call away. You guys are AWESOME, Thank You, Keep up the Good Work!!!

Shamsudeen Bawa

Vice President, J.P Morgan, CIS, USA

Farhan Hafiz

Synergific Software has been of great help and I plan to continue to use your services in the future for my business needs.

Farhan Hafiz

Data Architect, Fiserv

Dr. Sahdev Singh

I think Synergific Software is great. I liked that it was hassle free and easy to set up. Again, it's a great feature for a fast and cheap set up, which gives me peace of mind, as I know have a terms of use agreement.

Dr. Sahdev Singh

Under Secretary, Ministry of Law & Justice, Govt. of India

M Chikanna Swamy

I liked using Synergific Software very much. I thought the website was easy to navigate and the instructions for generating the terms was clear. I even recommended you on a Facebook Group I am a member of.

M Chikanna Swamy

Director & Learning Head, Mindtree