MySQL: Creating & Updating Tables

MySQL    |    Intermediate
  • 10 videos | 1h 10m 27s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 171 users Rating 4.7 of 171 users (171)
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 1m 47s
  • 5m 15s
    During this video, you will learn how to list attributes of keys, super-keys, and candidate keys. FREE ACCESS
  • Locked
    3.  Relationships in Database Design
    9m 50s
    In this video, you will learn how to model relationships in a real-world scenario for use in a database system. FREE ACCESS
  • Locked
    4.  Table Creation
    9m 8s
    After completing this video, you will be able to specify non-null constraints while creating tables. FREE ACCESS
  • Locked
    5.  Simple Queries
    8m 55s
    Learn how to run simple queries using wildcards and WHERE clauses. FREE ACCESS
  • Locked
    6.  Introducing SQL
    9m 29s
    After completing this video, you will be able to understand the need for SQL and list its important characteristics. FREE ACCESS
  • Locked
    7.  Specifying Uniqueness Constraints
    9m 8s
    Find out how to designate columns as unique when creating tables. FREE ACCESS
  • Locked
    8.  Update Operations
    9m 19s
    In this video, learn how to perform update operations on data in a MySQL database. FREE ACCESS
  • Locked
    9.  Altering and Dropping Tables
    6m 42s
    During this video, you will learn how to perform DDL operations, including altering tables to add primary key constraints, and dropping tables and databases. FREE ACCESS
  • Locked
    10.  Course Summary
    53s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 3.9 of 267 users Rating 3.9 of 267 users (267)
Rating 4.5 of 272 users Rating 4.5 of 272 users (272)
Rating 4.8 of 80 users Rating 4.8 of 80 users (80)