MySQL: Creating & Updating Tables

MySQL 8:0    |    Intermediate
  • 10 Videos | 1h 10m 27s
  • Includes Assessment
  • Earns a Badge
Likes 25 Likes 25
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

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

BOOK Database-Driven Web Development: Learn to Operate at a Professional Level with PERL and MySQL
BOOK Learn SQL with MySQL: Retrieve and Manipulate Data Using SQL Commands with Ease
BOOK MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE MySQL: Querying Data
Likes 38 Likes 38  
COURSE MySQL Database Development: Working with Functions
Likes 32 Likes 32  
COURSE MySQL: Getting Started
Likes 61 Likes 61