| 0-privileges.sql |
Write a script that lists all privileges of the MySQL users user_0d_1 and user_0d_2 on your server (in localhost). |
| 1-create_user.sql |
Write a script that creates the MySQL server user user_0d_1. |
| 2-create_read_user.sql |
Write a script that creates the database hbtn_0d_2 and the user user_0d_2. |
| 3-force_name.sql |
Write a script that creates the table force_name on your MySQL server. |
| 4-never_empty.sql |
Write a script that creates the table id_not_null on your MySQL server. |
| 5-unique_id.sql |
Write a script that creates the table unique_id on your MySQL server. |
| 6-states.sql |
Write a script that creates the database hbtn_0d_usa and the table states (in the database hbtn_0d_usa) on your MySQL server. |
| 7-cities.sql |
Write a script that creates the database hbtn_0d_usa and the table cities (in the database hbtn_0d_usa) on your MySQL server. |
| 8-cities_of_california_subquery.sql |
Write a script that lists all the cities of California that can be found in the database hbtn_0d_usa. |
| 9-cities_by_state_join.sql |
Write a script that lists all cities contained in the database hbtn_0d_usa. |
| 10-genre_id_by_show.sql |
Import the database dump from hbtn_0d_tvshows to your MySQL server: download |
| 11-genre_id_all_shows.sql |
Import the database dump of hbtn_0d_tvshows to your MySQL server: download |
| 12-no_genre.sql |
Import the database dump from hbtn_0d_tvshows to your MySQL server: download |
| 13-count_shows_by_genre.sql |
Import the database dump from hbtn_0d_tvshows to your MySQL server:download |
| 14-my_genres.sql |
Import the database dump from hbtn_0d_tvshows to your MySQL server:download |
| 15-comedy_only.sql |
Import the database dump from hbtn_0d_tvshows to your MySQL server: download |
| 16-shows_by_genre.sql |
Import the database dump from hbtn_0d_tvshows to your MySQL server: download |
| 100-not_my_genres.sql |
Import the database dump from hbtn_0d_tvshows to your MySQL server: download |
| 101-not_a_comedy.sql |
Import the database dump from hbtn_0d_tvshows to your MySQL server: download |
| 102-rating_shows.sql |
Import the database hbtn_0d_tvshows_rate dump to your MySQL server:download |
| 103-rating_genres.sql |
Import the database hbtn_0d_tvshows_rate dump to your MySQL server:download |