> > D61830GC30

MySQL for Developers (D61830GC30)

Course Description Schedule Course Outline
 

Who Should Attend

  • Database Administrators
  • Database Designers
  • Developer

Prerequisites

Required Prerequisites

  • Experience with having created tables and queries within relational Databases, and comfort with basic SQL statements and another programming language.
  • MySQL for Beginners NEW

Suggested Prerequisites

  • Experience with Java or PHP would be useful.
  • Some exposure to programming with databases.

Course Objectives

  • Configure, Monitor, and Optimize MySQL using Performance Schema and metadata queries
  • Understand the steps necessary to invoke MySQL client programs
  • Use the general-purpose mysql client program and the MySQL Workbench graphical user interface (GUI) to run queries, retrieve results, and generate diagrams
  • Understand the steps necessary to invoke MySQL client programs; Use the general-purpose mysql client program and the MySQL Workbench graphical user interface (GUI) to run queries,
  • Manage the structural characteristics of your databases and the tables within your databases
  • Use the SELECT statement to retrieve information from database tables
  • Use expressions in SQL statements to retrieve more detailed information
  • Use SQL statements to modify the contents of database tables
  • Write join expressions in your SQL statements to obtain information from multiple tables
  • Use subqueries in your SQL statements
  • Create views using SELECT statements to produce virtual tables of specific data
  • Perform bulk data import and export operations
  • Create user defined variables, prepared statements and stored routines
  • Create and manage triggers
  • Use the INFORMATION_SCHEMA database to access metadata
  • Write and debug MySQL applications

Course Content

This course teaches you the knowledge, skills, tools and issues involved in writing applications with the MySQL database server. It forms the core of the MySQL Developer learning path.

Learn To:

  • Use MySQL tools to connect to databases.
  • Examine database structure and contents.
  • Generate database structure diagrams.
  • Execute complex queries.
  • Manipulate numeric, text, spatial and temporal data.
  • Execute complex subqueries and joins.

Tools Used by MySQL Development Professionals

This course examines the tools used by MySQL development professionals. Expert instructors reference real-world examples when illustrating how to generate complex queries, and consume them in your application.

Java & PHP Lab Work

You'll perform lab work with Java and PHP, connecting to MySQL databases and executing queries and stored routines. Enrolling in this course will simultaneously help you prepare for the Oracle Certified Professional, MySQL 5 Developer certification.

Classroom Training
Modality: C

Duration 5 days

Price (VAT excl.)
  • Belgium: 2,250.- €
  • The Netherlands: 2,250.- €
Dates and Booking
 
Schedule

Currently there are no training dates scheduled for this course.  Enquire a date