6.2.Introduction to Relational Databases and Tables - sj50179/IBM-Data-Science-Professional-Certificate GitHub Wiki

Learning Objectives

  • Compose and execute CREATE TABLE, ALTER, DROP, and TRUNCATE statements hands-on on a live database.
  • Create a database instance on the Cloud
  • Describe basic relational database concepts including tables, primary keys and foreign keys.
  • Distinguish between Data Definition Language and Data Manipulation Language.
  • Explain the syntax of the ALTER, DROP and TRUNCATE statements.
  • Explain the syntax of the CREATE TABLE statement.