CertAchiever

MySQL DBA Certification Training

contact us: +918882136965

Instructor-led live online classes

Weekday Classes | Weekend Classes |

MySQL DBA Certification Training

$329

MySQL DBA Certification 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.

Training Features

Instructor-led Sessions

Both Weekdays and Weekend batches are available.

Real-Life Case Studies

During the sessions you will be working on the case studies provided by the trainer.

Lifetime Access

You will get the life time access of training material including videos & study guides..

Assignments

Each class will be followed by practical assignments to practice the concepts covered in class

24 x 7 Expert Support

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

Certification

Towards the end of the course, you will be awarded with Training competition certification based on you performance.

Course Curriculum

Learning 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 Covered

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

Learning 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 Covered

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

Learning 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 Covered

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

Learning 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 Covered

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

Learning 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 Covered

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

Learning 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 Covered

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

Learning 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 Covered

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

Learning 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 Covered

Creating and Modifying User Accounts, Configuring Passwords, Authentication Plug-Ins, Granting Permissions & Grant Tables

Learning 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 Covered

Understanding Security Risks, Network Security & Secure Connections, Password & Operating System Security

Learning 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 Covered

Understanding Backups & Backup Techniques, Creating a Backup Strategy, MySQL Backup ToolsRaw Backup Methods

FAQ's

You will never miss a lecture at CertAchiever! You can choose either of the two options:

View the recorded session of the class available in your LMS.

·You can attend the missed session, in any other live batch."

We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrollment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in the class.

You can give us a CALL at +918882136965 (IN) OR email at admin@certachiever.com

Certification

Once your training will complete, you will be awarded with training completion certification from the Trainer.