Extend your Microsoft Excel VBA programs

You thought you have seen it all with Microsoft Excel

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 be Competitive: Deliver Microsoft Excel-based solutions with Database in half the time and cost compared with other technologies
• You will stand out: Very few professional VBA and SQL programmers out there. Join this elite group of professionals
• You will become a valued expert: In your company, you will become the best Excel expert people turn to for advice
• You will discover an attractive opportunity: Requires a small investment in learning with vast potential opportunities

Did you know you can

Design dashboards that refresh quickly. Store and query massive amounts of data directly from an external Database. With Microsoft Excel VBA you can connect to a standard Database product, effectively using Microsoft Excel as the application's front-end.

In this course, you will learn everything you need to know about working with a database using Excel VBA, including installing and working with the popular MySQL database and writing complex SQL queries to write and read data to/from the database.

Having completed this course in the program, you will be able to design, develop, and deliver top-notch professional business applications for your customers.

Course covered: 

• 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 10: Using SQL to create tables, indexes, and relationships
• Populating DB tables from CSV files
• The SQL Select command: Joins, scalar, aggregates, union, nested queries
• MySQL Views
• Advanced insert and update: With subqueries and joins
• Transactions, locks,  isolation, and variables
• Assignment 10: 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