DOWNLOAD PDFPart 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
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 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.
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.
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.
After evaluating several companies, I decided to go with CertFirst based on my research and I am so glad that I did as I was able to not only learn the subject matter but passed my exam at the first attempt. Thanks Sach for all your support.
I have been trying to pass my CompTIA Security+ exam for the past 12 months and failed it twice. I was referred by one of my colleague at work to attend your 3 day CompTIA Authorized Virtual CertCamp and I am happy to inform you that I passed my exam within one week after going through your training program. The complimentary mock exams provided by your Instructor were a great way to prepare. Thank you again for excellent training program. I am absolutely coming back for CompTIA CSA+ and CEH training soon.
I attended a 5 day EC-Council CEH Las Vegas CertCamp and I was able to take my exam on the last day and passed it with over 90%. Parm, thank you so much for excellent training and exceptional services. I am going to have few my colleagues call you up to register for your one of the upcoming sessions!”
Thank You CertFirst for a great Virtual Live EC-Council CHFI class and I am now certified.
Excellent Training and Service
Certfirst “Early Bird” Special was one of the best offer I have ever received for a great training program”
Early Bird Special:This offer is only valid for the first five candidates to register for any selected “Early Bird” Special session. Special includes Kindle Fires, Mini iPADS, Tablets and for some programs candidate may qualify for up to $500 Gift Certificate of their choice. If candidate don’t want the gift certificate they can use that toward additional discount or get a FREE Exam Voucher. All candidates must register at-least 4-6 weeks in advance based on the program in order to qualify for the special.
“Certfirst offers excellent training & certification services at hundred plus CertCamp locations world-wide directly and as well as through its affiliated partners. Currently, CertFirst can offer group training not only at the client sites but also has access to over 100 plus “A” grade training facilities world-wide.”