Type
Virtual
Classroom ILT
Skill Level

Available dates
Learning Path
Virtual
Duration
1 Day

TYPE
Virtual
Classroom ILT
LEARNING PATH
SKILL LEVEL

DURATION
AVAILABLE DATES
Choose date
From: R14 999,00
Price excluding VAT
Introduction:
This five day instructor led course teaches developers how to plan, design and implement applications using MySQL. Expert Oracle University instructors will teach you through realistic examples, interactive instruction and hands-on exercises using Java and PHP languages. After taking this course, you will be able to write programs that take advantage of the power and flexibility of MySQL. You will have developed the skills to build a database that’s optimal for your application, while creating fast and effective querie.
Audience profile:
Database Administrators, Developers, Web Administrators
Pre-requisites:
Before attending this course, students must have:
- Basic knowledge of SQL
- Experience of Java, PHP or another programming or scripting language
- Experience of creating tables and queries in a relational database Oracle requires and recommends that delegates have attended the following course prior to attending this course.
- D61918GC30 MySQL for Beginners
Course objectives:
After completing this course, students will be able to:
- Use client programs and options
- Access the database from program code
- Build “NoSQL” applications.
- Write effective queries and stored routines
- Inspect database metadata
- Respond to database events with triggers
- Handle errors and exceptions
- Optimize SQL statements
Lesson 1: Introduction to MySQL
This lesson describes the goals of the course and the classroom learning environment. Lessons: |
|
|
|
|
|
|
|
|
|
Lesson 2: MySQL Client and Server Concepts
This lesson describes the nature and architecture of the MySQL Server/Client model, communication protocols, connectors, API’s and storage engines. Lessons: |
|
|
|
|
|
|
Lab: |
|
|
|
|
|
|
|
|
Lesson 3: MySQL Clients
This lesson explains the usage and configuration of MySQL client applications. Lessons: |
|
|
Lab: |
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 4: MySQL Connectors and API’s
This lesson describes the available MySQL connectors and API’s and demonstrates how to connect to MySQL through Java and PHP. Lessons: |
|
|
|
|
Lab: |
|
|
|
|
|
|
|
|
Lesson 5: Data Types
This lesson describes the available data types and their implementation within table design. Lessons: |
|
|
Lab: |
|
|
|
|
|
|
|
|
|
|
Lesson 6: SQL Expressions
This lesson explains the use of expressions in calculations, manipulations, combination of and commenting on data. Lessons: |
|
|
|
|
|
|
Lab: |
|
|
|
|
|
|
Lesson 7: Obtaining Metadata
This lesson describes the nature and usage of metadata within a MySQL database. Lessons: |
|
|
Lab: |
|
|
|
|
|
|
Lesson 8: Databases
This lesson explores the topics around databases creation such as normalisation and data file storage. Lessons: |
|
|
|
|
Lab: |
|
|
|
|
|
|
|
|
|
|
Lesson 9: Tables
This lesson describes the creation and maintenance of database tables. Lessons: |
|
|
Lab: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 10: Manipulating Table Data
This lesson describes the use of DML (Data Manipulation Language) to manage table data. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 11: Transactions
This lesson describes transactions within the MySQL database. Lessons: |
|
|
Lab: |
|
|
|
|
|
|
Lesson 12: Joining Tables
This lesson describes the different join types and their usage within the MySQL database. Lessons: |
|
|
Lab: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 13: Table Subqueries
This lesson describes the nature and usages of subqueries within a MySQL Database. Lessons: |
|
|
Lab: |
|
|
|
|
|
|
|
|
Lesson 14: Views
This lesson describes the nature, creation and usage of MySQL database views. Lessons: |
|
|
Lab: |
|
|
|
|
|
|
|
|
|
|
Lesson 15: Prepared Statements
This lesson explores the nature of prepared statements and discusses the need and usage thereof. Lessons: |
|
|
|
|
Lab: |
|
|
|
|
Lesson 16: Stored Routines
This lesson explains the use of stored routines within the MySQL database environment. Lessons: |
|
|
Lab: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 17: Triggers
This lesson describes the nature and implementation of MySQL database triggers. Lessons: |
|
|
|
|
Lab: |
|
|
|
|
Lesson 18: Handling Errors and Warnings
This lesson describes the nature of MySQL database errors and warnings and demonstrates how to deal with them programmatically. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 19: Optimisation and Monitoring
This lesson explores the functionality of the MySQL query optimiser and describes techniques that can be used to affect query performance. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 20: Conclusion
This lesson provides a summary of all the concepts covered within the preceding lessons. Lessons: |
|
|
|
|
Torque IT specializes in providing our Clients with Vendor authorized instructor-led training, enablement IT courses, and certification solutions.
Associated certifications and exam:
This course prepares students to write Exam (None). On successful completion of this course students will receive an Oracle University attendance certificate.

Oracle Overview
Torque IT considers authorized Oracle training to be an integral part of any Oracle Solaris, Oracle Enterprise Linux, Oracle Applications, Java development, or Oracle Database implementation. Oracle authorized training, and associated certification, ensures that you get the most from your technology investment and that you are able to operate above the technology curve.
Our instructor led training provides customers with a hands-on experience to match job role requirements and prepares delegates for Oracle Certification exams. From in-class demonstrations to hands-on-labs, Torque IT’s authorized Oracle instructor led training provides our customers with a comprehensive and dynamic learning experience.
Oracle certifications are universally recognized as demonstrating a high level of expertise and credibility for individuals and the organizations that employ them. Authorized Oracle training and certification is the industry standard for any solution that includes designing, selling, implementing, upgrading, developing and managing Solaris, Java, and Oracle Database solutions.
Torque IT is recognized by Oracle as an Oracle University Training Centre which means that we offer our clients internationally recognized and globally accredited Oracle training and certification. These achievements reflect our commitment to providing our customers with quality skills development, enablement, training, and certification solutions that demonstrate exceptional depth, breadth, and expertise.
Torque is recognized by Oracle, and the industry, as having met rigorous standards for educational competency, service, customer satisfaction and investment in technology that will prepare the next generation of IT industry professionals to exploit Oracle Solutions.