Name		Name	Last commit message	Last commit date
parent directory ..
0-list_databases.sql		0-list_databases.sql
1-create_database_if_missing.sql		1-create_database_if_missing.sql
10-top_score.sql		10-top_score.sql
100-move_to_utf8.sql		100-move_to_utf8.sql
101-avg_temperatures.sql		101-avg_temperatures.sql
102-top_city.sql		102-top_city.sql
103-max_state.sql		103-max_state.sql
11-best_score.sql		11-best_score.sql
12-no_cheating.sql		12-no_cheating.sql
13-change_class.sql		13-change_class.sql
14-average.sql		14-average.sql
15-groups.sql		15-groups.sql
16-no_link.sql		16-no_link.sql
2-remove_database.sql		2-remove_database.sql
3-list_tables.sql		3-list_tables.sql
4-first_table.sql		4-first_table.sql
5-full_table.sql		5-full_table.sql
6-list_values.sql		6-list_values.sql
7-insert_value.sql		7-insert_value.sql
8-count_89.sql		8-count_89.sql
9-full_creation.sql		9-full_creation.sql
README.md		README.md

README.md

0x0D. SQL - Introduction

Description

What you should learn from this project:

What’s a database
What’s a relational database
What does SQL stand for
What’s MySQL
How to create a database in MySQL
What does DDL and DML stand for
How to CREATE or ALTER a table
How to SELECT data from a table
How to INSERT, UPDATE or DELETE data
What are subqueries
How to use MySQL functions

0. List databases

Write a script that lists all databases of your MySQL server.

1. Create a database

Write a script that creates the database hbtn_0c_0 in your MySQL server.

2. Delete a database

Write a script that deletes the database hbtn_0c_0 in your MySQL server.

3. List tables

Write a script that lists all the tables of a database in your MySQL server.

4. First table

Write a script that creates a table called first_table in the current database in your MySQL server.

5. Full description

Write a script that prints the full description of the table first_table from the database hbtn_0c_0 in your MySQL server.

6. List all in table

Write a script that lists all rows of the table first_table from the database hbtn_0c_0 in your MySQL server.

7. First add

Write a script that inserts a new row in the table first_table (database hbtn_0c_0) in your MySQL server.

8. Count 89

Write a script that displays the number of records with id = 89 in the table first_table of the database hbtn_0c_0 in your MySQL server.

9. Full creation

Write a script that creates a table second_table in the database hbtn_0c_0 in your MySQL server and add multiples rows.

10. List by best

Write a script that lists all records of the table second_table of the database hbtn_0c_0 in your MySQL server.

11. Select the best

Write a script that lists all records with a score >= 10 in the table second_table of the database hbtn_0c_0 in your MySQL server.

12. Cheating is bad

Write a script that updates the score of Bob to 10 in the table second_table.

13. Score too low

Write a script that removes all records with a score <= 5 in the table second_table of the database hbtn_0c_0 in your MySQL server.

14. Average

Write a script that computes the score average of all records in the table second_table of the database hbtn_0c_0 in your MySQL server.

15. Number by score

Write a script that lists the number of records with the same score in the table second_table of the database hbtn_0c_0 in your MySQL server.

16. Say my name

Write a script that lists all records of the table second_table of the database hbtn_0c_0 in your MySQL server.

Author

Geoffrey Zoref - Gzoref