DEFS.4.0.Course Introduction - sj50179/IBM-Data-Science-Professional-Certificate GitHub Wiki

Every good relational database solution begins with a solid design and implementation strategy. A well-designed relational database ensures that the users and applications that depend on the data will know that it is:

• Accurate. Can you rely on the accuracy of the data as new information is added or it is modified?
• Easy to access. Is the data organized in a way that makes it fast, easy, and predictable to query and maintain?
• Reliable. Can your database design ensure data integrity and maintain consistent and reliable data?
• Flexible. Can you update or expand on the design to meet future data requirements?

In this course, you will learn some basic relational database concepts and learn to think about data in terms of relationships and how information can be best organized to produce the results you want to achieve. You will also learn about different deployment topologies options and the tradeoffs that impact your design decisions. You will then move onto relational database design, creating an Entity Relationship Diagram for a specific use case that serves as the blueprint for the implementation of your database. You will also learn about the role of relational model constraints in ensuring that your data maintains its integrity and achieves a level of performance that meets the needs of the users of the data.

With a solid plan, you will then learn how to use SQL statements and several Relational Database Management Systems (RDBMS) tools to transform a relational database design into a physical database and its objects, such as tables, keys, indexes, and constraints.

You will build hands-on experience by developing an Entity Relationship Diagram to map out the data model of a relational database, applying techniques that help improve the integrity of your data and the performance of your queries, and then implement the design in IBM Db2 on Cloud.