MySql DB Certification Training

MySQL DBA Solutions Architect Training

MySQL DBA Certification Training trains you on the core concepts & advanced tools and techniques to manage data and administer the MySQL Database. It includes hands-on learning on concepts like MySQL Workbench, MySQL Server, Data Modeling, MySQL Connector, Database Design, MySQL Command line, MySQL Functions etc. End of the training you will be able to create and administer your own MySQL Database and manage data.

Sports, Citrix, UST Global, Mindtree, TCS, Wipro, Infosys & other MNC's use Azure across industries.

Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Mysql Dba Certification Training UpComing Batches

Nov-04 - Dec-16

Weekend
SOLD OUT

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Oct-28 - Dec-09

Weekday
SOLD OUT

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Nov-16 - Dec-28

Weekend
FILLING FAST

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Nov-23 - Jan-04

Weekday
FILLING FAST

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Nov-30 - Jan-11

Weekend

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Dec-07 - Jan-18

Weekday

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now
Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Course Curriculum

MySQL DBA Certification Training

SELF PACED

OL Tech Edu's MySQL DBA Certification Training trains you on the core concepts & advanced tools and techniques to manage data and administer the MySQL Database. It includes hands-on learning on concepts like MySQL Workbench, MySQL Server, Data Modeling, MySQL Connector, Database Design, MySQL Command line, MySQL Functions etc. End of the training you will be able to create and administer your own MySQL Database and manage data.

  • WEEK 5-6
  • 10 Modules
  • 6 Hours
MySql DB Certification Training Trains

Objectives: 

At the end of this module, you will be able to:

Understand MySQL products, professional services and support for your operating system.

Define a relational database management system (RDBMS) and describe its structure.

Explain the use of SQL and MySQL with relational databases.

Define data definition language (DDL) and data manipulation language (DML).

Understand MySQL client/server model and work with MySQL connectors.

Install the MySQL server on Linux, start and stop MySQL server.

Interact with the server using the MySQL command-line client. 

Log your MySQL command-line client session to a text file.

Use MySQL Workbench to interact with the server.


Topics:

MySQL Overview.

Basics of Relational Databases.

Entities and Relationships.

SQL Language and MySQL.

SQL data definition language and data manipulation language.

MySQL Client/Server Model.

MySQL Connectors.

Installation of the MySQL server.

Starting and stopping MySQL server.

Using the MySQL client.

MySQL Workbench.


Hands On

Install and Configure MySQL Server.

Client and MySQL workbench.

Using MySQL Workbench.

Creating the ‘world’ Database & Explore the Schema.


Objectives:

At the end of this module, you will be able to:

Describe database modeling.

Use primary keys and foreign keys to achieve referential integrity.

Normalize your data model.

Design your new database.

Model a database using MySQL workbench and view the structure.

Evaluate a database design.

Explain the use of different data types in database design.

Choose the correct data types while modeling data.

Describe the considerations for selecting data types.

Topics:

Database Modeling.

Keys and Normalization.

Database Design.

Viewing and Evaluating a Database.

Data Types and Database Design.

Numeric, Temporal and String Data Types.

Character Set and Collation Support.

Data Type Considerations.

Meaning of NULL.

Hands On:

Explore an Existing Database.

Designing a New Database.

Selecting Data Types for your New Database.


Objectives:

At the end of this module, you will be able to:

Create a database and add tables.

Use the SHOW CREATE TABLE statement.

Set column and table options.

Create indexes, keys, and constraints.

Delete a database.

Create and delete a table.

Add and remove table columns.

Modify table columns.

Topics:

Creating a Database.

Creating a Table.

Showing How a Table Was Created.

Table Options.

Column Options.

Indexes, Keys, and Constraints.

Deleting database and tables.

Creating New Table Using an Existing Table.

Creating a Temporary Table.

Copying an Existing Table Structure.

Adding, removing and modifying table columns and indexes.

Hands On:

Creating a Database.

Deleting a Database.

Creating and Deleting a Table.

Altering Table Columns.


Objectives:

At the end of this module, you will be able to:

Retrieve database data using the SELECT statement from your database.

Use the SELECT statement clauses: FROM, DISTINCT, WHERE, ORDER BY, and LIMIT.

Create Views.

Query data from application code.

Export and import a delimited file.

Topics:

The SELECT Statement.

Creating Views.

Querying Data from an Application.

Exporting and Importing a Delimited File.

Troubleshooting: Authorization Levels.

Manipulating Data and inserting records.

Replacing and updating existing records.

Deleting Records.

Exporting and importing a script.

Multistatement Transactions.

Modifying Data from an Application.

Hands On:

Executing Basic Queries.

Importing a Delimited File.

Performing Basic Queries on Imported Data.

Performing Basic Queries from a PHP Application.

Exporting Table Data for MySQL Database.

Inserting, Modifying and Deleting Data.

Exporting a Script.



Objectives: 

At the end of this module, you will be able to:

Explain the concept of a join.

Use the JOIN keyword to query multiple tables.

Execute inner and outer joins.

Use the UNION keyword to combine multiple queries.

Use built-in functions in MySQL.

Describe and use: string functions, Date and time functions, Numeric functions.

Use aggregate functions with the SELECT statement.

Topics:

Querying Multiple Tables.

Joining Tables with SELECT.

Inner Joins.

Outer Joins.

Table Name Aliases.

Functions in MySQL Expressions.

Using Functions.

String Functions.

Date and Time Functions.

Numeric Functions.

Aggregate Functions.

Spaces in Function Names.

Hands On:

Using Joins in Queries.

Using Unions in Queries.

Using Built-In, String, and Date and Time Functions.

Using Numeric Functions.

Using Aggregate Functions.



Objectives:

At the end of this module, you will be able to:

Explain how MySQL processes, stores, and transmits data.

Configure InnoDB tablespaces.

Explain how MySQL uses memory.

Configure the InnoDB buffer pool. 

List some of the available plug-ins.

Topics:

Architectural Overview.

Understand how MySQL Transmits Data and Processes Requests.

Understand how MySQL Stores Data and Uses Memory.

Tablespaces, Redo and Undo Logs.

Plug-in Interface.

Hands On:

Configuring Tablespaces.

Configuring the Buffer Pool.



Objectives:

At the end of this module, you will be able to:

Describe database modelling.

Use primary and foreign keys to achieve referential integrity.

Normalize your data model.

Design your new database.

Model a database using MySQL workbench and view the structure.

Evaluate a database design.

Explain the use of different data types in database design.

Choose the correct data types while modelling data.

Topics:

Server Configuration Options.

Option Files and System Variables.

Launching Multiple Servers on the Same Host.

Monitoring Tools & Techniques.

MySQL Enterprise Audit.

MySQL Enterprise Monitor.

Monitoring User Activity.

Hands On:

Modifying the Configuration File. 

Changing Dynamic Settings.

Configuring the Slow Query Log.

Using Performance Schema.



Objectives:

At the end of this module, you will be able to:

Create user accounts.

Design a permission structure.

Control user permissions

Grant access to system operations

Authenticate by using plug-ins

Expire accounts manually and automatically.

Reset a forgotten root password.

Topics:

Creating and Modifying User Accounts.

Configuring Passwords.

Authentication Plug-Ins.

Granting Permissions & Grant Tables.

Hands On:

Creating Users.  

Granting Permissions.



Objectives:

At the end of this module, you will be able to:

Recognize common security risks. 

List security problems and counter-measures for networks, passwords, operating systems, file systems and applications.

Protect your data from interception and access.

Use SSL for secure MySQL server connections. 

Use SSH to create a secure remote connection to MySQL.

Topics:

Understanding Security Risks.

Network Security & Secure Connections.

Password & Operating System Security.

Hands On:

Enable SSL Connections on the MySQL Server.



Objectives:

At the end of this module, you will be able to:

Distinguish between the different types of backup.

State advantages and disadvantages of the various backup techniques.

Implement a backup strategy.

Use MySQL Enterprise Backup to perform consistent backups. 

Use the mysqldump and mysqlpump utilities to perform logical backups.

Understand when and how to use raw file backups.

Back up the binary log.

Topics:

Understanding Backups & Backup Techniques.

Creating a Backup Strategy.

MySQL Backup Tools.

Raw Backup Methods.

Hands On:

Backing up using mysqldump and mysqlpump.


Program Syllabus

Curriculum

You can also view the program syllabus by downloading this program Curriculum.

Projects

What are the system requirements for this course?

You should have a minimum of 4 GB RAM and processor i3 or above.

How will I execute the Practicals

We will help you to setup Virtual Machine in your System with local access. The detailed installation guides are provided in the LMS for setting up the environment. For any doubt, the 24*7 support team will promptly assist you.

Which Case-Studies will be part of the course?

Employee list to be maintained having id, name, designation, Salary details having employee id, current salary. Salary increment to be given by next year if any depending upon constraints.

Course Description

Course Certification

OL Tech Edu’s Certificate Holders work at top 500s of companies like

certificate

Features

Explore step by step paths to get started on your journey to Jobs of Today and Tomorrow.

Instructor-led Sessions

30 Hours of Online Live Instructor-Led Classes.
Weekend Class : 10 sessions of 3 hours each.

Real Life Case Studies

Real-life Case Studies

Live project based on any of the selected use cases, involving implementation of the various real life solutions / services.

Assignments

Assignments

Each class will be followed by practical assignments.

24 x 7 Expert Support

24 x 7 Expert Support

We have 24x7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.

Certification

Certification

Towards the end of the course, OL Tech Edu certifies you for the course you had enrolled for based on the project you submit.

Course FAQ's

Enroll, Learn, Grow, Repeat! Get ready to achieve your learning goals with OL Tech Edu View All Courses

© 2015 - 2024 OL Tech Edu. All Rights Reserved.
Designed, Developed & Powered by MNJ SOFTWARE

The website is best experienced on the following version (or higher) of Chrome 31, Firefox 26, Safari 6 and Internet Explorer 9 browsers