MySQL: Creating & Updating Tables
MySQL 8:0
| Intermediate
- 10 Videos | 1h 10m 27s
- Includes Assessment
- Earns a Badge
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 courseenumerate attributes of keys, super-keys, and candidate keysmodel relationships in a real-world scenario for use in a database systemspecify non-null constraints while creating tablesrun simple queries using wildcards and where clauses
-
understand the need for SQL and enumerate its important characteristicsdesignate columns as unique while creating tablesperform update operations on data in a MySQL relationperform DDL operations including altering tables to add primary key constraints, and dropping tables and databasessummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview1m 47sUP NEXT
-
2.Keys in Table Design5m 15s
-
3.Relationships in Database Design9m 50s
-
4.Table Creation9m 8s
-
5.Simple Queries8m 55s
-
6.Introducing SQL9m 29s
-
7.Specifying Uniqueness Constraints9m 8s
-
8.Update Operations9m 19s
-
9.Altering and Dropping Tables6m 42s
-
10.Course Summary53s
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.