BONUS! LEXX Online Subscription Included: All LEXX Live students receive complimentary ninety (90) day access to the LEXX Online learning platform, which hosts hundreds of expert asynchronous training courses in Cybersecurity, IT, Soft Skills, and Management and more!
Course Overview
This 4-day hands-on course is designed for software developers who want to build strong, practical skills in using MySQL as a database for applications. Participants learn how to design efficient database structures, write powerful SQL queries, and use MySQL’s programming features to create and manage data-driven systems. The course balances theory with extensive labs to help developers connect database concepts to real-world coding practices. Topics include database design, data manipulation, stored routines, triggers, performance tuning, and working with MySQL from application code. At the compleiton of this course, participants will be able to:
- Understand how relational databases work and how MySQL supports application development.
- Design normalized database schemas using tables, relationships, keys, and constraints.
- Write SQL queries to retrieve, insert, update, and delete data efficiently.
- Use joins, subqueries, and aggregate functions for complex data analysis.
- Create and manage stored procedures, functions, and triggers for business logic.
- Analyze and improve query performance using the EXPLAIN tool and indexing strategies.
- Import and export data between MySQL and external systems or files.
- Connect MySQL databases to applications using APIs or programming languages such as Python.
- Apply database best practices for integrity, performance, and scalability.
Price: $1995
4-Day Course Includes:
- Class exercises in addition to training instruction
- Courseware books, notepads, pens, highlighters and other materials
- Full breakfast with variety of bagels, fruits, yogurt, doughnuts and juice
- Tea, coffee, and soda available throughout the day
- Freshly baked cookies every afternoon – *only at participating locations
For group training options please contact our Training and Certification Consultants at 301-258-8200 or email promo@lexx.com.
Schedule
Currently, there are no public classes scheduled. Please contact a LEXX LIVETraining Consultant to discuss hosting a private class at 301-258-8200.
![[image]](https://live.lexx.com/wp-content/themes/phoenixts-com-new/assets/images/temp/image-9@2x.jpg)
Not seeing a good fit?
Let us know. Our team of instructional designers, curriculum developers, and subject matter experts can create a custom course for you.
Learn more about custom training
Course Outline
Module 1: Introduction to Relational Databases
Module 2: Modeling a Relational Database
Module 3: SQL Language
Module 4: Implementing Database Design
Module 5: Data Modification
Module 6: Advanced Queries
Module 7: Data Types and Variables
Module 8: Flow Control and Iteration
Module 9: Viewing Data
Module 10: SQL Programming
Module 11: Query Optimization
Module 12: Importing and Exporting Data
BONUS! LEXX Online Subscription Included: All LEXX Live students receive complimentary ninety (90) day access to the LEXX Online learning platform, which hosts hundreds of expert asynchronous training courses in Cybersecurity, IT, Soft Skills, and Management and more!
LEXX Live is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints re-garding registered sponsors may be submitted to the National Registry of CPE Sponsors through its web site: www.nasbaregistry.org
Hubs