Adding Value Consulting
MySQL for Developers - 5 days Online Classroom
IT Service & Architecture

MySQL for Developers - 5 days Online Classroom

2.650,00 EUR

  • 5 days
Live Virtual Classroom
Classroom
In House / In Company

Develop high-performance, data-driven applications with MySQL for Developers. This practical course is designed for software developers who want to build, query, and manage MySQL databases efficiently while following industry best practices. Through hands-on exercises, you'll learn how to design relational databases, write optimized SQL queries, create tables and relationships, work with indexes, transactions, stored procedures, views, and triggers, and integrate MySQL into modern applications. You'll also explore techniques for improving query performance, maintaining data integrity, and troubleshooting common database issues. By the end of the course, you'll have the skills to confidently design and develop MySQL-backed applications that are scalable, secure, and easy to maintain.

Key Features

Language

Course and materials are in English

Level

Beginner - Intermediate level

5 days (40 hours) live classroom

with accredited trainers

60+ recommended study hours

Exercises and solutions

Downloadable PDF documents with detailed content (slides, explanations)

Certificate

Certificate of completion available

Hero

Learning Outcomes

At the end of this course, you will be able to:

Maintain

Use MySQL triggers to automate data validation, enforce business rules, and maintain data consistency with real-time database events.

Utilize

Leverage MySQL window functions for advanced reporting, ranking, trend analysis, and time-based data comparisons.

Improve

Improve database performance using EXPLAIN, indexing, normalization, storage engine selection, and query optimization techniques.

Manage

Manage bulk data transfers with MySQL tools and integrate MySQL with other data platforms to support modern application environments.

Hero

Course timeline

  1. Day 1: MySQL Fundamentals & Querying

    Lesson 01

    • Understand MySQL client/server architecture and client tools
    • Work with the MySQL command-line client and utilities
    • Explore MySQL data types and identifier conventions
    • Query data using SELECT, sorting, grouping, filtering, and aggregation

  2. Day 2: Data Management & Database Tools

    Lesson 02

    • Use SQL expressions and built-in functions
    • Insert, update, replace, and delete data
    • Connect applications to MySQL using connectors
    • Retrieve database metadata and troubleshoot SQL errors

  3. Day 3: Advanced SQL Development

    Lesson 03

    • Import and export data with SQL and command-line tools
    • Build advanced queries using subqueries and Common Table Expressions (CTEs)
    • Create and manage views
    • Use window functions and regular expressions for advanced data analysis

  4. Day 4: Stored Routines & Programming

    Lesson 04

    • Work with user variables and prepared statements
    • Create stored procedures and functions
    • Implement program logic with conditions, loops, and parameters
    • Manage stored routine security and metadata

  5. Day 5: Advanced Database Programming & Optimization

    Lesson 05

    • Handle exceptions and use cursors in stored routines
    • Create and manage database functions and triggers
    • Optimize databases with normalization, indexing, and query analysis
    • Improve query performance using EXPLAIN, storage engine selection, and indexing best practices
MySQL for Developers

Who Should Enroll in this Program?

Software developers

Backend and full-stack developers

Web application developers

Database application developers

Technical professionals working with MySQL

Anyone looking to strengthen their SQL and MySQL development skills

Start course now

Prerequisites

  • Basic programming knowledge
  • Familiarity with relational database concepts
  • Basic understanding of SQL is recommended
  • Experience with any programming language is beneficial

Licensing

and equality policy

Licensing and accreditation

This course is offered according to Partner Program Agreement and complies with the License Agreement requirements.

Equity Policy

AVCdoes not provide accommodations due to a disability or medical condition of any students. Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.

Frequently Asked Questions

Contact background

Need a Custom In-company or Group Training?

Request for in-company training program tailored specifically to your team. We offer flexible customization options to align with your business goals, alongside competitive group rates for larger teams. Fill out the form below, and our corporate training experts will design the perfect solution for you.