MY SQL DBA Certification Training

MySQL DBA Certification Training trains you on the core concepts and 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. At the end of the training, you will be able to create and administer your own MySQL database and manage data.

Eligibility and Pre-requisites

• Eligibility

  This online SQL certification course is ideal for freshmen, programmers, software developers, and testing professionals who want to learn SQL. It’s also ideal for marketing professionals and salespeople who want to better understand their company’s data.

• Pre-requisites

  There are no prerequisites for this database training course. This course can be taken by anyone who wants to learn SQL.

SQL DBA Course Overview

This SQL certification course gives you all of the information you need to successfully start working with SQL databases and make use of the database in your applications. Learn how to correctly structure your database, author efficient SQL statements and clauses, and manage your SQL database for scalable growth.

Benefits

SQL, though an old language, is highly significant today as companies across the world are gathering massive amounts of data for their growth. SQL consistently ranks high in the most-requested tech skills, and learning it will add great value to your array of skills.

Section 01: Getting Started with MySQL and Installing MySQL

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

Get detailed course syllabus in your inbox Download Curriculum

Section 02: Designing Your Database and Understanding Data Types

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

Get detailed course syllabus in your inbox Download Curriculum

Section 03: Creating Databases and Tables

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

Get detailed course syllabus in your inbox Download Curriculum

Section 04: Querying and Modifying Table Data

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

Get detailed course syllabus in your inbox Download Curriculum

Section 05 Joining Tables and Functions

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

• Get detailed course syllabus in your inbox Download Curriculum

Section 06 MySQL Architecture and Administration Basics

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

• Get detailed course syllabus in your inbox