From the course: Advanced MySQL Database Administration
Unlock this course with a free trial
Join today to access over 25,300 courses taught by industry experts.
Review: Creating a table - MySQL Tutorial
From the course: Advanced MySQL Database Administration
Review: Creating a table
- [Instructor] All right, in this lecture, we're going to be reviewing the create table statement. This one is also review from our MySQL Database Administration for Beginners course. So if you're already a pro at creating tables, you can go ahead and skip this concept. If you're a little shakier or you haven't done this before, you're definitely going to want to watch this one. Creating tables is very important in SQL, and it's fundamental to this course. There's going to be a number of assignments down the road where you'll need to create tables. So make sure that you're comfortable doing this whether you are already or if you want to watch this video. We also do a quick review of the select statement at the end of this video. I think that's probably going to be review for everybody. But again, that's here in case you are not familiar with select yet. So if you feel comfortable that you could create a table and you can name the columns and give those different data types, then you…
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)
Overview of create, insert, and delete1m 48s
-
(Locked)
Review: Creating a schema3m 24s
-
(Locked)
Review: Creating a table7m 7s
-
Review: Inserting records into a table10m 19s
-
(Locked)
Review: Deleting records10m 40s
-
(Locked)
Importing data from a file10m 21s
-
(Locked)
Challenge: Importing order item data1m 11s
-
(Locked)
Solution: Importing order item data10m 56s
-
(Locked)
Challenge: Importing refund data1m 32s
-
(Locked)
Solution: Importing refund data5m 1s
-
(Locked)
Challenge: Deleting records1m 36s
-
(Locked)
Solution: Deleting records4m 40s
-
(Locked)
Challenge: Import remaining 2012 data45s
-
(Locked)
Solution: Import remaining 2012 data5m 37s
-
(Locked)
Bonus: Load data4m 44s
-
(Locked)
-
-
-
-
-
-
-
-
-
-