MySQL: Creating & Updating Tables

MySQL 8:0    |    Intermediate
  • 10 Videos | 1h 10m 27s
  • Includes Assessment
  • Earns a Badge
Likes 179 Likes 179
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 PHP 8 Solutions
COURSE Database Fundamentals: Working with SQL Commands
BOOK Database-Driven Web Development: Learn to Operate at a Professional Level with PERL and MySQL

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

BOOK Beginning SQL
COURSE MySQL: Querying Data
Likes 38 Likes 38  
COURSE Architecture Concepts
Likes 194 Likes 194