We may earn an affiliate commission when you visit our partners.
Course image
Udacity logo

Data Modeling

Sean Murdock, Matt Swaffer, Ben Goldberg, Amanda Moran, and Valerie Scarlata

Enroll in our online data modeling course for expert training. Learn to create relational and NoSQL models tailored to meet the diverse needs of data consumers.

Prerequisite details

Read more

Enroll in our online data modeling course for expert training. Learn to create relational and NoSQL models tailored to meet the diverse needs of data consumers.

Prerequisite details

To optimize your success in this program, we've created a list of prerequisites and recommendations to help you prepare for the curriculum. Prior to enrolling, you should have the following knowledge:

  • Intermediate Python
  • Intermediate SQL

You will also need to be able to communicate fluently and professionally in written and spoken English.

What's inside

Syllabus

In this lesson, students will learn the basic difference between relational and non-relational databases, and how each type of database fits the diverse needs of data consumers.
Read more
In this lesson, students understand the purpose of data modeling, the strengths and weaknesses of relational databases, and create schemas and tables in Postgres
Students will understand when to use non-relational databases based on the data business needs, their strengths and weaknesses, and how to creates tables in Apache Cassandra.
Students will model event data to create a non-relational database and ETL pipeline for a music streaming app. They will define queries and tables for a database built using Apache Cassandra.

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Examines the core differences between relational and NoSQL databases, which is essential knowledge for data architects and engineers
Develops relational database schemas and tables using Postgres, a popular open-source database management system
Provides hands-on experience with Apache Cassandra, a renowned NoSQL database, by creating tables and modeling event data
Enhances learners' understanding of data modeling, an indispensable skill for data professionals
Builds a strong foundation in data modeling concepts, making it suitable for beginners

Save this course

Save Data Modeling to your list so you can find it easily later:
Save

Activities

Coming soon We're preparing activities for Data Modeling. These are activities you can do either before, during, or after a course.

Career center

Learners who complete Data Modeling will develop knowledge and skills that may be useful to these careers:
Data Architect
Data Architects design the architecture, structure, and organization of data assets. They work alongside Data Engineers, Database Administrators, and Data Scientists to ensure the organization's databases and data warehouses are structured logically and consistently. This course will teach you the fundamentals of data modeling and help you build a solid foundation for a career as a Data Architect.
Data Engineer
Data Engineers build and maintain the infrastructure that stores and processes data. They work closely with Data Architects and Data Scientists to ensure that data is reliable, accessible, and secure. This course will teach you the fundamentals of data modeling and help you build a solid foundation for a career as a Data Engineer.
Database Administrator
Database Administrators are responsible for the day-to-day management and maintenance of databases. They ensure that databases are running smoothly, that data is backed up regularly, and that security is maintained. This course will teach you the fundamentals of data modeling and help you build a solid foundation for a career as a Database Administrator.
Data Scientist
Data Scientists use data to solve problems and make predictions. They work with Data Engineers and Data Architects to gather, clean, and analyze data. This course will teach you the fundamentals of data modeling and help you build a solid foundation for a career as a Data Scientist.
Business Intelligence Analyst
Business Intelligence Analysts use data to help businesses make better decisions. They work with Data Engineers and Data Scientists to gather, clean, and analyze data. This course will teach you the fundamentals of data modeling and help you build a solid foundation for a career as a Business Intelligence Analyst.
Data Analyst
Data Analysts use data to identify trends and patterns. They work with Data Engineers and Data Scientists to gather, clean, and analyze data. This course will teach you the fundamentals of data modeling and help you build a solid foundation for a career as a Data Analyst.
Software Engineer
Software Engineers design, develop, and maintain software applications. They work with Data Engineers and Data Scientists to build and maintain the software that stores and processes data. This course may be useful for Software Engineers who want to learn more about data modeling and how it can be used to improve the performance and scalability of software applications.
Data Warehouse Architect
Data Warehouse Architects design and build data warehouses. They work with Data Engineers and Data Scientists to ensure that data warehouses are structured logically and consistently. This course will teach you the fundamentals of data modeling and help you build a solid foundation for a career as a Data Warehouse Architect.
Database Designer
Database Designers design and build databases. They work with Data Engineers and Data Scientists to ensure that databases are structured logically and consistently. This course will teach you the fundamentals of data modeling and help you build a solid foundation for a career as a Database Designer.
Data Governance Analyst
Data Governance Analysts develop and implement policies and procedures to ensure that data is used ethically and responsibly. They work with Data Engineers and Data Scientists to ensure that data is accurate, complete, and consistent. This course may be useful for Data Governance Analysts who want to learn more about data modeling and how it can be used to improve the quality of data.
Privacy Analyst
Privacy Analysts develop and implement policies and procedures to protect the privacy of individuals. They work with Data Engineers and Data Scientists to ensure that data is collected, used, and stored in a compliant manner. This course may be useful for Privacy Analysts who want to learn more about data modeling and how it can be used to improve the security of data.
Information Security Analyst
Information Security Analysts develop and implement policies and procedures to protect the security of information systems. They work with Data Engineers and Data Scientists to ensure that data is protected from unauthorized access, use, disclosure, disruption, modification, or destruction. This course may be useful for Information Security Analysts who want to learn more about data modeling and how it can be used to improve the security of data.
Compliance Analyst
Compliance Analysts develop and implement policies and procedures to ensure that organizations comply with applicable laws and regulations. They work with Data Engineers and Data Scientists to ensure that data is collected, used, and stored in a compliant manner. This course may be useful for Compliance Analysts who want to learn more about data modeling and how it can be used to improve compliance with applicable laws and regulations.
Project Manager
Project Managers plan, execute, and close projects. They work with Data Engineers and Data Scientists to ensure that data projects are completed on time, within budget, and to the required quality standards. This course may be useful for Project Managers who want to learn more about data modeling and how it can be used to improve the planning and execution of data projects.
Business Analyst
Business Analysts gather and analyze data to help businesses make better decisions. They work with Data Engineers and Data Scientists to identify opportunities for improvement and develop solutions to business problems. This course may be useful for Business Analysts who want to learn more about data modeling and how it can be used to improve the quality of business decisions.

Reading list

We've selected five books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Data Modeling.
Must-read for anyone who is interested in designing data-intensive applications. It covers a wide range of topics, from the basics of data modeling to more advanced topics such as data consistency and data partitioning.
Provides a comprehensive overview of HBase. It covers a wide range of topics, from the basics of HBase to more advanced topics such as data modeling and querying.
Provides a comprehensive overview of MongoDB. It covers a wide range of topics, from the basics of MongoDB to more advanced topics such as data modeling and querying.
Provides a comprehensive overview of Elasticsearch. It covers a wide range of topics, from the basics of Elasticsearch to more advanced topics such as data modeling and querying.
Provides a comprehensive overview of machine learning. It covers a wide range of topics, from the basics of machine learning to more advanced topics such as machine learning algorithms and machine learning applications.

Share

Help others find this course page by sharing it with your friends and followers:
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser