Learn Bench


  • Understand the steps necessary to invoke MySQL client programs
  • Utilize the general-purpose mysql client program and the MySQL Query Browser graphical user interface (GUI) to run queries and retrieve results
  • Select the best data type for representing information in MySQL
  • Manage the structural characteristics of your databases and the tables within your databases
  • Utilize the SELECT statement to retrieve information from database tables
  • Utilize expressions in SQL statements to retrieve more detailed information
  • Utilize SQL statements to modify the contents of database tables
  • Write join expressions in your SQL statements to obtain information from multiple tables
  • Utilize subqueries in your SQL statements
  • Create views utilizing 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
  • Configure and Optimize MySQL


  • Having attended the MySQL for Beginners course or some experience with Relational Databases and SQL


  • MySQL Overview, Products and Services
  • MySQL Enterprise Services
  • Supported Operating Services
  • MySQL Certification Program
  • Training Curriculum Paths
  • MySQL Website
  • Installing MySQL and the World Database


  • The MySQL for Developers course is the foundation course for developers planning on designing and implementing applications that make use of MySQL.
  • This course covers essential SQL statements for data design, querying, and programming. In addition, it will prepare students for the MySQL Developer certification.

Students who can benefit from this course:

  • Developers who want to create applications using MySQL
  • Students wishing to prepare for the MySQL Developer Certification Ex
    MySQL Client/Server Concepts
  • MySQL General Architecture
  • How MySQL Uses Memory
  • Invoking Client Programs
  • MySQL Connectors
  • Querying for Table Data
  • The SELECT Statement
  • Aggregating Query Results
  • SQL Expressions
  • SQL Comparisons
  • Functions in SQL Expressions
  • Comments in SQL Statements
  • Data Types
  • Data Type Overview
  • Numeric Data Types
  • Binary String Data Types
  • Temporal Data Types
  • NULLs
  • Obtaining Metadata
  • Metadata Access Methods
  • The INFORMATION_SCHEMA Database/Schema
  • Using SHOW and DESCRIBE
  • Creating Tables
  • Table Properties
  • Column Options
  • Creating Tables Based on Existing Tables
  • Manipulating Table Data
  • The INSERT Statement
  • The DELETE Statement
  • The UPDATE Statement
  • Transaction Commands
  • Joins
  • Basic Join Syntax
  • Other Types of Joins
  • Views
  • What Are Views?
  • Prepared Statements
  • Why Use Prepared Statements?
  • Exporting and Importing Data
  • What are Triggers?
  • Delete Triggers
  • Restrictions on Triggers
  • Storage Engines

Certification also in

May i help u

Live Chat
We're with you 24/7

new products