Course details

MySQL: Creating & Updating Tables

MySQL: Creating & Updating Tables


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

In this 10-video course, learners can 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. Key concepts covered in this course include attributes of keys, super keys, and candidate keys; learning how to model relationships in a real-world scenario for use in a database system; and learning how to specify non-null constraints while creating tables. You will learn how to run simple queries by using wildcards and where clauses; learn about the need for SQL and its important characteristics, SQL-based technologies also known as relational databases; and learn how to designate columns as unique while creating tables. Continue by learning how to perform update operations on data updating the structure of tables as well as the data contained within them in a MySQL relation; and learning how to perform DDL operations, including altering tables to add primary key constraints and dropping tables and databases.



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