Online Course Registration form
Instruction Method: Instructor Led classroom, Instructor Led virtual live, Group Onsite, Group virtual live
1 Introduction to SQL
2 The Tennis Club Sample Database
3 Installing the Software
4 SQL in a Nutshell
Part 2 Querying and Updating Data
5 SELECT Statement: Common Elements
6 SELECT Statements, Table Expressions, and Subqueries
7 SELECT Statement: The FROM Clause
8 SELECT Statement: The WHERE Clause
9 SELECT Statement: SELECT Clause and Aggregation Functions
10 SELECT Statement: The GROUP BY Clause
11 SELECT Statement: The HAVING Clause
12 SELECT Statement: The ORDER BY Clause
13 Combining Table Expressions
14 Updating Tables
Part 3 Creating Database Objects
15 Creating Tables
16 Specifying Integrity Constraints
17 Character Sets and Collating Sequences
18 Changing and Dropping Tables
19 Designing Tables
20 Using Indexes
22 Creating Databases
23 Users and Data Security
24 Creating Sequences
25 Creating Schemas
Part 4 Programming with SQL
26 Introduction to Embedded SQL
27 Transactions and Multi-User Usage
28 Introduction to ODBC
29 Optimization of Statements
Part 5 Procedural Database Objects
30 Stored Procedures
31 Stored Functions
Part 6 Object Relational Concepts
33 User-Defined Data Types, Functions, and Operators
34 Inheritance, References, and Collections
The MySQL for Database Administrators course is for DBAs and other database professionals who want to install the MySQL Server, set up replication and security, perform database backups and performance tuning, and protect MySQL databases.
Benefits to You
Database administrators will learn how new enhancements made available in MySQL will increase performance, scalability, reliability and manageability for their Web, Cloud and embedded application requirements. You will be able to install, configure, maintain and tune databases for a wide variety of workloads and environments.
Setting up the Server and Databases
This course teaches you how to install, configure, maintain, and tune databases for a wide variety of workloads and environments. You will install and configure MySQL, and set appropriate configuration options. You will connect to the server, using both graphical and command-line clients, and create and populate databases.
Maintaining and Securing Data
In this course, you will examine the structure of tables, their columns and data types, and the different ways to check and repair tables. You will program MySQL stored routines, events, and triggers to process data in complex and automated ways. You will partition tables, work with locking and transactions, and explore the key features of InnoDB and other storage engines to understand how data is processed, stored, and retrieved.
Configuring for Performance and High Availability
To help avoid and deal with failures, this course teaches you to tune databases by choosing and setting the most appropriate options, perform logical and physical backups, configure replication between multiple instances, recover from network or hardware failure, or between replicated systems.
Learn by Doing
Extensive hands-on practices guide you through each concept. You will install MySQL products, partition data, check and repair tables, perform backups and configure replication, create secured users and enable SSL security, and much more. Explore real-world problems and discover best practices as you work with the tools and techniques used by professional MySQL database administrators.
This course fulfils the training requirements for the Oracle Certified Professional, MySQL 5 Database Administrator certification.
DISCLAIMER: The above course can be customized according to the client needs for a group of 2 or more candidates.
For more information on how CertFirst can assist you please Contact Us