From the course: Advanced SQL Project: Design and Manage a Database
Join today to access over 25,500 courses taught by industry experts.
Final project solution - SQL Tutorial
From the course: Advanced SQL Project: Design and Manage a Database
Final project solution
- [Instructor] Welcome to the walkthrough of your final project, where you were tasked with adding an additional table, the media type table to our existing structure. Now, this is a typical request that would come from management, and let's now walk through the steps that we would now have to take to apply these changes. So starting with the first step here, which is to create the media type table. We're just using the create table command and we're specifying the table columns that we were given in our assignment, and that's the media type id and the name column, integer and name respectively. We are giving the first media type id, the primary key index, and we're also setting a not null constraint on the name. Let's now run this query. With that, our media type table is now created. Now let's insert some values into our newly created media type table. And this insert query does this for us. Insert into media type the columns, and we have the values again that we've been supplied to…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.