MySQL Training

MySQL Course:
Structured Query Language (SQL) is the set of statements with which all programs and users access data in a relational database. MySQL, the most popular Open Source SQL database management system. MySQL provides an easy, elegant, performant architecture for accessing, defining, and maintaining data. This MySQL training starts with the very foundation of MySQL and databases. As the course progresses it takes you through various concepts as well as the syntax of MySQL in specific and databases in general. At the end of the course, one shall have a good understanding of how to architect, build, use and maintain a database system using MySQL. This MySQL course is completely hands-on. Cloud labs will be provided for every training participants. Corporate training in MySQL is customized based on the requirement of the organisation. This training is delivered by our experts at Bangalore as well at client locations across India and South-East Asia in cities such as Bangalore, Chennai, Hyderabad, Pune, Mumbai, Delhi, Noida, Gurgaon, Singapore, Hong Kong and many more.

MySQL Course Curriculum

1. Introduction to MySQL

What is Relational Databases

MySQL Overview

Variants of SQL

Lab setup

2. MySQL Server and Client

MySQL Client/Server Model

MySQL Connectors

Installation of the MySQL server

Setting the root Password

Starting and stopping the MySQL server

Using the mysql client

MySQL Workbench

3. Database Basics

Basics of Relational Databases

Spreadsheet Versus Database

Entities and Relationships

Relationship Categories

SQL Language and MySQL

SQL data definition language

SQL data manipulation language

4. Designing Your Database

Database Modeling

Keys

Normalization

Database Design

Viewing and Evaluating a Database

5. Data Types

Data Types as Part of Database Design

Numeric Data Types

Temporal Data Types

String Data Types

Character Set and Collation Support

Data Type Considerations

The Meaning of NULL

6. Creating Databases and Tables

Creating a Database

Creating a Table

Showing How a Table Was Created

Column Options

Table Options

Indexes, Keys, and Constraints

7. Modifying Databases and Tables

Deleting databases and tables

Creating a New Table Using an Existing Table

Confirming the Creation of a New Table

Copying an Existing Table Structure

Creating a Temporary Table

Adding, removing and modifying table columns

Adding, removing and modifying Indexes

8. Querying Table Data

The SELECT Statement

Creating Views

Querying Data from an Application

Exporting and Importing a Delimited File

Troubleshooting: Authorization Levels

9. Modifying Table Data

Manipulating Data

Inserting records

Replacing existing records

Updating existing records

Deleting records

Exporting and importing a script

Multistatement Transactions

Modifying Data from an Application

10. Functions

Functions in MySQL Expressions

Using Functions

String Functions

Date and time functions

Numeric Functions

Aggregate Functions

Spaces in Function Names

11. Joining Tables

Querying Multiple Tables

Joining Tables with SELECT

Inner Joins

Outer Joins

Table Name Aliases

12. MySQL for Database Administrators

Install and configure MySQL Server and client programs

Recognize the key components of the MySQL architecture

Manage user accounts and secure your server

Troubleshoot server slowdowns and other issues

Backup and recover MySQL database

Configure and administer a variety of replication topologies

13. MySQL for Developers

Program with Connectors.

Write console and web applications.

Optimize query performance.

Write stored routines and triggers.

Use the InnoDB memcached plugin for NoSQL access to your data.

Store, access, and analyze geospatial data.

Gain an understanding of the MySQL Cloud Service.

14. Conclusion

MySQL in the industry

MySQL Resources

The way Ahead

Frequently Asked Questions

What are the modes of the MySQL training?

We provide classroom-based as well as online training. Since this is a hand-on training so batches generally does not contain more than 4 people.

Will I be provided with any study material during the MySQL training?

We will provide web services specific study material as the course progresses. You will have lifetime access to all the code and basic settings needed for these MySQL training through our github account and the study material that we share with you. You can use that for quick reference.