课程: Advanced SQL Project: Design and Manage a Database

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Final project

Final project - SQL教程

课程: Advanced SQL Project: Design and Manage a Database

开始一个月试用 购买团队方案

Final project

“

- [Instructor] Welcome to your last stop in this course where you will integrate all the skills you've learned in this final project. You'll modify your current music database schema to include a new table and create new queries to accommodate this addition. At this point, navigate to your exercise files area and locate the file Final Project Template. Open that file and follow along on the screen here. So let's take a look at what our final project consists of, starting with the objective. The goal is to enhance the music database by adding a new media type table, integrating it with the existing schema. You'll need to create queries to accommodate these changes. Now let's take a look at the media type table. We see here that it has two columns, a media type ID, which is of type integer, and a name column, which is of type text. The values within these two columns are as follows, one, two, three, four, five, and the associated media type for each one of these media type IDs. All…

内容