Question: Use SQL Chinnook 1 . Create a playlist only entering data with the DB Browser user interface. Show your successful result 2 . Create another

Use SQL Chinnook
1. Create a playlist only entering data with the DB Browser user interface.
Show your successful result
2. Create another playlist only using SQL.
Show your successful result
3. Create a query to list the playlist names and track names of the playlists you just created.
Show your successful result
Index Performance
4. We would like the following query to be executed faster:
SELECT * from tracks where Composer = "Bob Dylan"
Add an index to the Composer field.
Show your successful result
5. The chinook database is small, so we might not notice the impact of this index. It should make read (SELECT) operations execute faster. What impact might this have on inserts and updates?
Type your answer here
Analize Data in Excel
6. Export the data in the TOP_5_GENRES view (you created in the guided project).
7. Import the data into Excel.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!