Advanced Data Modeling

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

• Deploy basic data modeling skills and navigate modern storage options for a data warehouse.

• Demonstrate data modeling skills within a real-world project environment.

Syllabus

FAQ

When will I have access to the lectures and assignments?

Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:

The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.

The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Certificate?

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

Reviews