MySQL Developer ( mysqldev | 21 hours )

• Basic understanding of databases

Audience

• Developers

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.

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