> > D61830GC30

MySQL for Developers (D61830GC30)

Cursusbeschrijving Beschikbare data Gedetailleerde cursusinhoud
 

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.

Klassikale training
Modality: C

Duur 5 dagen

Prijs (excl. BTW)
  • Nederland: 2.250,- €
  • België: 2.250,- €
Beschikbare data
 
Beschikbare data

Op dit moment is deze training niet beschikbaar in het open rooster. De kans is echter groot dat wij u toch een passende oplossing kunnen bieden. Wij horen graag wat uw specifieke wensen zijn. U bereikt ons via 030 658 2131 of info@flane.nl. We helpen u graag!  Vraag een datum aan

 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!