![]() Let's help MNG create their database using MySQL Workbench. Then they can use MySQL Workbench forward engineer feature to transform the data model into a SQL schema and implement it automatically into MySQL. They can use MySQL Workbench to create a model. MNG need to develop a basic database to maintain information about their customers and orders. In this video, you'll learn how to use MySQL Workbench and make use of the forward and reverse engineer features. Data warehouse monitoring and reporting toolsĪt this stage of the course, you understand the importance of database models, but how do you create these models? You can create database models using professional data modeling tools such as MySQL Workbench. Extract, transform and loading (ETL) techniques and methods Syntaxes used to interact with a data warehouse You’ll gain experience with the following tools and software: Demonstrate data modeling skills within a real-world project environment Develop a working knowledge of the different aspects of managing a database including administration of database operations and concerns, alongside processes and solutions for monitoring, reporting and debugging Apply planning and execution of ETL style database engineering by building upon existing MySQL skills ![]() Deploy basic data modeling skills and navigate modern storage options for a data warehouse The Professional Certificates create opportunities so that anyone regardless of education, background or experience can learn high-quality skills to land a high-growth career-no degree or experience required to get started.īy the end of this course, you’ll be able to: You must also be eager to continue your journey with coding. To take this course, you must have completed the previous Database courses. Develop a working knowledge and familiarity with advanced database concepts such as usage, modeling, automation, storage, optimization and administration.
0 Comments
Leave a Reply. |