Course Code: mysqldev
Duration: 21 hours
Prerequisites:

  • Basic understanding of databases

Audience

  • Developers

Overview:

MySQL is an open-source relational database management system (RDBMS) that provides a platform for structured query language (SQL) for managing and manipulating databases.

This instructor-led, live training (online or onsite) is aimed at advanced-level developers who wish to learn and use MySQL and database technologies for building web applications.

By the end of this training, participants will be able to:

  • Write SQL queries to retrieve, filter, sort, and aggregate data.
  • Perform data manipulation operations such as inserting, updating, and deleting data.
  • Implement advanced SQL concepts such as subqueries, derived tables, and conditional logic.
  • Integrate MySQL with popular programming languages and execute queries from application code.

Format of the Course

  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.

Course Customization Options

  • To request a customized training for this course, please contact us to arrange.

Course Outline:

Introduction

  • Overview of databases and MySQL
  • Installation and setup of MySQL
  • Introduction to SQL and MySQL command-line client
  • Creating and managing databases and tables

Querying Data

  • Retrieving and filtering data
  • Sorting and limiting query results
  • Working with multiple tables
  • Using subqueries and derived tables

Data Manipulation

  • Inserting data into tables
  • Updating and deleting data
  • Using transactions for data integrity
  • Managing indexes for performance optimization

Advanced SQL Concepts

  • Aggregation functions
  • Filtering query results
  • Working with string functions, date functions, and mathematical functions
  • Handling NULL values in queries
  • Using CASE statements for conditional logic

Performance Optimization

  • Query optimization techniques
  • Indexing and optimizing table structures
  • Analyzing query performance with EXPLAIN
  • Caching strategies and query caching
  • Monitoring and profiling tools for performance tuning

Security and Administration

  • User management and access control
  • Securing MySQL server and database
  • Backup and restore operations
  • Importing and exporting data
  • MySQL Workbench and other administration tools

Application Integration

  • Connecting MySQL with popular programming languages
  • Using MySQL connectors and libraries
  • Executing queries in application code

Summary and Next Steps

Overview in Category:

This instructor-led, live training in <loc> (online or onsite) is aimed at advanced-level developers who wish to learn and use MySQL and database technologies for building web applications.

By the end of this training, participants will be able to:

  • Write SQL queries to retrieve, filter, sort, and aggregate data.
  • Perform data manipulation operations such as inserting, updating, and deleting data.
  • Implement advanced SQL concepts such as subqueries, derived tables, and conditional logic.
  • Integrate MySQL with popular programming languages and execute queries from application code.