Information Request










 

Online Course Registration form

Instruction Method: Instructor Led classroom, Instructor Led virtual live, Group Onsite, Group virtual live

Course Details

Part 1:Introduction

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

21 Views

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

32 Triggers

Part 6 Object Relational Concepts

33 User-Defined Data Types, Functions, and Operators

34 Inheritance, References, and Collections

 

PART II

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.

Learn To:

  • Describe the MySQL Architecture
  • Install and Upgrade MySQL
  • Configure MySQL server options at runtime
  • Evaluate data types and character sets for performance issues
  • Understand the use of the InnoDB storage engine with MySQL
  • Perform backup and restore operations

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.

Certification

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.

 

 Register Now

 

 

 

For more information on how CertFirst can assist you please Contact Us

Payment Policy | Terms & Conditions

Close [X]