From the course: MySQL Database Administration
Unlock this course with a free trial
Join today to access over 24,200 courses taught by industry experts.
Creating a schema using the MySQL Workbench UI - MySQL Tutorial
From the course: MySQL Database Administration
Creating a schema using the MySQL Workbench UI
- [Instructor] All right, we're ready to learn how to create a new Schema using Workbench's user interface tools. Like we said before, the terms Schema and database will be used interchangeably in MySQL and in this course so that we can discuss a collection of data tables which relate to one another. So anytime you hear Schema or database, we're talking about the same thing. We can create a new Schema using Workbench's user interface tools, and this only takes a few clicks, it's really easy. This next point is important. Whether we create the Schemas using the UI tools or with SQL code, it's all a matter of preference. They're going to create the same Schemas, so you should learn both ways and then decide which way you prefer, but it doesn't make a difference in terms of the Schema that gets created, whether or not you're using these UI tools or you do it with SQL code. So let's jump into Workbench and I'll walk you through an example right now. So if you've gotten through the install…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
Creating a schema using the MySQL Workbench UI2m 54s
-
(Locked)
Creating a schema using SQL code4m 27s
-
(Locked)
Creating a table using the MySQL Workbench UI6m 52s
-
(Locked)
Creating a table using SQL code6m 3s
-
(Locked)
MySQL data types5m 40s
-
(Locked)
Challenge: Creating your own schema and tables2m 28s
-
(Locked)
Solution: Creating your own schema and tables12m 1s
-
(Locked)
Adding and removing columns using the MySQL Workbench UI13m 39s
-
(Locked)
Adding and removing columns with SQL code5m 4s
-
(Locked)
Challenge: Adding and removing columns1m 25s
-
(Locked)
Solution: Adding and removing columns6m 59s
-
(Locked)
Dropping schemas and tables6m 45s
-
(Locked)
Challenge: Dropping schemas and tables1m 46s
-
(Locked)
Solution: Dropping schemas and tables2m 22s
-
(Locked)
-
-
-
-
-
-