Curriculum

11 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

9 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

11 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

11 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

12 Topics
Querying Multiple Tables
Joining Tables with SELECT
Inner Joins
Outer Joins
Table Name Aliases
Functions in MySQL Expressions
IJsing Functions
String Functions
Date and time functions
Numeric Functions
Aggregate Functions
Spaces in Function Names

5 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

7 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 IJser Activity

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

3 Topics
IJnderstanding Security Risks
Network Security & Secure Connections
Password & Operating System Security

4 Topics
Understanding Backups & Backup Techniques
Creating a Backup Strategy
MySQL Backup Tools
Raw Backup Methods

  Write a Review

MySQL DBA Certification Training

Go to Paid Course