Develop a working knowledge and familiarity with advanced database concepts such as usage, modeling, automation, storage, optimization and administration.
By the end of this course, you’ll be able to: – Deploy basic data modeling skills and navigate modern storage options for a data warehouse – Apply planning and execution of ETL style database engineering by building upon existing MySQL skills – 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 – Demonstrate data modeling skills within a real-world project environment You’ll gain experience with the following tools and software: – Workbench data modeling software – Syntaxes used to interact with a data warehouse – Extract, transform and loading (ETL) techniques and methods – MySQL data warehouse administration – Data warehouse monitoring and reporting tools – Database debugging and testing tools – Data modeling tools