DEFS.4.2.Using Relational Databases - sj50179/IBM-Data-Science-Professional-Certificate GitHub Wiki

In this module, you will learn how to use a RDBMS GUI or web interface and SQL statements to create and manage the tables in a relational database and populate them with data. You will also learn how to employ some database design techniques that help improve the integrity of your data and the performance of your queries, including the use of Primary and Foreign keys to define relationships, indexes, normalization, and relational model constraints.

Learning Objectives

  • Differentiate DML and DDL SQL statements.
  • Create and alter a simple table in Db2 on Cloud.
  • Move data to and from a database using the LOAD, BACKUP, RESTORE, IMPORT, and EXPORT utilities.
  • Modify an existing table using the ALTER TABLE, DROP TABLE, and TRUNCATE TABLE statements.
  • List the objects in a Relational Database Management System (RDBMS) hierarchy.
  • Use keys to create relationships between tables.
  • Recognize the advantages and disadvantages of using indexes.
  • Describe how to use normalization to reduce data redundancy and inconsistency in your databases.