MySQL Developer

Course Description

MySQL is one of the most widely used database platforms in the world, and almosr certainly the most widely used in web development. However, many applications and sites that use MySQL are based on configurations and SQL syntax that can lead to serious issues with security and performance.

This course covers concepts such as MySQL configuration and account management, stored procedures, custom functions, views and SQL query caching and optimisation that will ensure that your MySQL based applications are secure and perform as efficiently as possible.

Audience

This course is highly recommended for any developer that wil be using MySQL as an integral part of any software application development. It is not specific to the use of MySQL in any particular environment but is relevant to all MySQL based development.

Objectives

At the end of this course attendees will:

  • Understand the components of MySQL and how it is configured
  • Be able to create and configure MySQL user accounts
  • Be able to identify the most appropriate data and storage engine types
  • Be able to work with MySQL and the SQL language as efficiently as possible

Pre Requisites

There are no specific prerequisites for this course, but a basic undersatnding of data processing would be useful.

Key Topics

  • Introduction to the MySQL Server
  • MySQL Storage Engines
  • Introduction to MySQL client programs
  • User accounts and connections
  • Structured Query Language (SQL
  • Databases, Tables and data types
  • Indexes and keys
  • Efficient use of multiple tables
  • MySQL Data Types
  • Using SQL Expressions
  • Aggregating, summarising and sorting data
  • Prepared statements
  • Stored procedures and custom functions
  • Query analysis and optimisation
  • MySQL Query caching

Resources & Materials

  • Tuition by an expert instructor
  • Access to a live server for practice
  • Full documentation in PDF format
  • Exercises and solutions
  • Example files
  • Recordings of sessions (online only)
  • Access to dedicated training forums

Course Schedules

Course schedule Duration Sessions Session times Format Price Credits
TBA10 hrs4 x 2.5hrsTBAOnline£4254

Reserve my place now