MySQL for Developers

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Call for In Class or Live Virtual Dates5$4,000 USDPurchase


SUNMYSQLDEV

MySQL for Developers

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

Duration: 5 Days

Prerequisites

  • MySQL for Beginners or some experience with Relational Databases and SQL

Audience

  • Developers who want to create applications using MySQL
  • Students wishing to prepare for the MySQL 5.0 Developer Certification Exams

Learning Objectives

  • 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
  • Create and manage triggers
  • Use the INFORMATION_SCHEMA database to access metadata
  • Debug MySQL applications
  • Configure and Optimize MySQL

Topics

  • MySQL Client/Server Concepts
  • MySQL Clients
  • Querying for Table Data
  • Handling Errors and Warnings
  • SQL Expressions
  • Data Types
  • Obtaining Metadata
  • Databases
  • Tables
  • Manipulating Table Data
  • Transactions
  • Joins
  • Subqueries
  • Views
  • Prepared Statements
  • Exporting and Importing Data
  • Stored Routines
  • Triggers
  • Storage Engines
  • Optimization
  • Triggers and Scheduled Events
  • NoSQL
  • Spatial Data
Right Menu IconMENU