DEFS.4.1.Relational Database Concepts - sj50179/IBM-Data-Science-Professional-Certificate GitHub Wiki
A relational database organizes data into tables that can be linked—or related—based on data common to each. By storing your business data in a relational database, you can retrieve and analyze the data to make important business decisions. There are many companies that offer relational database systems and, regardless of which one you use, they all share a common set of characteristics that you must be familiar with before you can move on to more advanced operations with databases. In this module, you will learn some basic relational database concepts and how to diagram and describe the relationships between tables in a database. You will also learn the different deployment topologies and architectures that are commonly used, who the typical users of databases are, and some of the features and benefits of some common relational database management systems including Db2, MySQL, and PostgreSQL.
Learning Objectives
- Define relational databases and their supporting systems.
- Describe relational model concepts, including entities, attributes, and entity-relationship models.
- Describe the types of relationships in a relational database.
- Describe commonly used data types and formats and their role in a relational database.
- Differentiate the database deployment topologies (single tier, 2-tier, 3-tier, and Cloud).
- Explain the reasons why and how different categories of users need access to databases.
- Explain the features and benefits of Db2, MySQL, and PostgreSQL.