- A projects done during my Full Stack Software Engineering studies at ALX Africa, a course offered by Holberton School.
- Files written in
vi,vim, andemacseditors. - SQL files executed on Ubuntu 20.04 LTS using MySQL 8.0 (version 8.0.25)
| File | Question |
|---|---|
| 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 |