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 serverInstalling the ODBC connector to MySQL serverDevelop 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 environmentDevelop a complete process of presenting a Microsoft Excel chart using SQL queries over MySQL DB tablesAssignment: 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 ExcelWhat you will get when enrolling to this course:3 hours in 11 recorded, hands-on sessionsEach 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 QuizThe 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 AssignmentWriting 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 downloadI 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!
