Course details

MySQL: Creating & Updating Tables

MySQL: Creating & Updating Tables


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Explore how tables in MySQL can be created to match entities and relationships as modeled in an E-R diagram and how MySQL allows the specification of different types of columns and column constraints.



Expected Duration (hours)
1.2

Lesson Objectives

MySQL: Creating & Updating Tables

  • discover the key concepts covered in this course
  • enumerate attributes of keys, super-keys, and candidate keys
  • model relationships in a real-world scenario for use in a database system
  • specify non-null constraints while creating tables
  • run simple queries using wildcards and where clauses
  • understand the need for SQL and enumerate its important characteristics
  • designate columns as unique while creating tables
  • perform update operations on data in a MySQL relation
  • perform DDL operations including altering tables to add primary key constraints, and dropping tables and databases
  • summarize the key concepts covered in this course
  • Course Number:
    it_aplumgdj_02_enus

    Expertise Level
    Intermediate