MySQL: Creating & Updating Tables

MySQL 8:0    |    Intermediate
  • 10 Videos | 1h 14m 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

COURSE SQL in FSD Development
Likes 8 Likes 8  
COURSE Data Architecture Deep Dive - Design & Implementation
Likes 13 Likes 13  
COURSE MySQL: Grouping & Aggregation Operations
Likes 22 Likes 22  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Working with Functions
Likes 32 Likes 32  
COURSE MySQL: Grouping & Aggregation Operations
Likes 22 Likes 22  
COURSE SELECT Statement & Operators
Likes 18 Likes 18