Business Applications with Excel and MySQL Database

Deliver high-performing, scalable and robust business-grade applications with Microsoft Excel VBA and MySQL Database

What you'll learn:
Take your Microsoft Excel VBA skills to the next level: design, develop and deliver highly scalable, performant, multi-user, professional applications
Develop a rich library of generic, robust VBA functions for working with the MySQL DB Server: All CRUD operations and more!

Requirements
You should have fair VBA programming skills (see my Computer Programming with Excel VBA course)
The SQL language is not covered in this course (see my Databases and SQL Mastery course)

Description
I'm excited to invite you to take the Business Applications with Excel and MySQL Database course.

If you're skilled in Microsoft Excel you know you can achieve a lot. However, the problem is that Excel cannot handle large tables very efficiently, does not allow for multiple users to work concurrently, and poorly joins data from many tables to answer sophisticated business questions.

The bomb game-changer here is working with an external high-end database for storing, manipulating, and querying data.

This course will take your Microsoft Excel VBA skills to the next level by allowing you to discover the wonders of relational databases, design a proper schema for your business needs, develop and deliver highly scalable, performant, multi-user, professional applications.

You will discover:

Connecting Microsoft Excel to MySQL DB server

Installing the ODBC connector to MySQL server

Develop a rich library of generic, robust VBA functions for working with the MySQL DB Server: All CRUD operations and more.

Sanitize and adjust data as it travels between the MySQL DB Server and the Microsoft Excel environment

Develop a complete process of presenting a Microsoft Excel chart using SQL queries over MySQL DB tables

Assignment: Enrich your VBA to MySQL DB server functions library and develop a customers management system allowing adding, updating and deleting customers maintained in the DB Server from Microsoft Excel

What you will get when enrolling to this course:

3 hours in 11 recorded, hands-on sessions

Each session was carefully planned, its code was written and verified and the video was edited to reflect a balanced blend of slides lecture with hands-on demo.

The course is structured to build a gradual learning curve. With each session you conquer another goal, expand your skills and experience.

1 Quiz

The course closes with a quiz. The quiz is designed to measure your deep understanding of the material. Repeating a sentence you heard in the course is not enough to pass the quiz.

Only true understanding gained through practice leads to successful professionals - and that is what I aim for you!

1 Assignment

Writing code that works for real business needs will earn you the practice and skill you need. The assignments are engineered to confront you with real business challenges and are considered an important part of your training.

I always say: an assignment is your opportunity to express yourself!

Assignment's complete solution: SQL code for download

I explain my solution for each and every assignment in a dedicated, detailed session, so these are important lessons in and of themselves - don't skip those sessions!

Who this course is for
VBA developers