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 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 15sDuring this video, you will learn how to list attributes of keys, super-keys, and candidate keys. FREE ACCESS
-
3. Relationships in Database Design9m 50sIn this video, you will learn how to model relationships in a real-world scenario for use in a database system. FREE ACCESS
-
4. Table Creation9m 8sAfter completing this video, you will be able to specify non-null constraints while creating tables. FREE ACCESS
-
5. Simple Queries8m 55sLearn how to run simple queries using wildcards and WHERE clauses. FREE ACCESS
-
6. Introducing SQL9m 29sAfter completing this video, you will be able to understand the need for SQL and list its important characteristics. FREE ACCESS
-
7. Specifying Uniqueness Constraints9m 8sFind out how to designate columns as unique when creating tables. FREE ACCESS
-
8. Update Operations9m 19sIn this video, learn how to perform update operations on data in a MySQL database. FREE ACCESS
-
9. Altering and Dropping Tables6m 42sDuring 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
-
10. Course Summary53sIn 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.
