Last Updated: 2020-11-07

Why do we have to learn database

• A lot of websites are apps are using database to manage data

What you'll learn

• Understand what is data/database
• Design database
• SQL

• Data
• Databa

English

Create an Amazon databases using template.

Answer sample is here

English

1. Go to DB Fiddle website
2. Copy Database from here
3. Write the following questions using SQL:

1. /* show all data in the students table */
2. /* get a list of favorite subjects */
3. /* Get a list of students born in October */
4. /* get list of students born in either November (nov) or December (dec) */
5. /* Get the height of the shortest student */
6. /* Get the height of the tallest student */
7. /* Get the list of students that submitted the form first */

4. The answers are :

1. SELECT * FROM students
2. SELECT subject FROM students
3. SELECT name FROM students WHERE month = "oct"
4. SELECT name FROM students WHERE month = "nov" OR month = "dec";
5. SELECT MIN(height) FROM students
6. SELECT MAX(height) FROM students
7. SELECT * FROM students ORDER BY timestamp ASC;