8 Lesson №57 Database development Presentation

Dauren

+7-747-885-85-85

Nur-Sultan

1/12/2019

1/12/2019 23:33

2006

175,5

Lesson topic: Database Development

Lesson objectives:
to know the different data types in MySQL;
to know the purpose of the SQL language and basic commands for executing queries.

Knowledge, understanding and applying
Students will be able to:
- name data type of MySQL DBMS
- give examples of fields and appropriate data types;
- explain the purpose of SQL
- name basic command to execute queries

Using the Internet, research data types which are used in MySQL

CHAR

VARCHAR

TEXT

BOOL

TINYINT

INTEGER

FLOAT

DOUBLE

DATE

TIME

DATETIME

ENUM

TIMESTAMP

CHAR

VARCHAR

TEXT

BOOL

TINYINT

INTEGER

FLOAT

DOUBLE

DATE

TIME

DATETIME

ENUM

TIMESTAMP

23/11/2020 11:34

544

-122

Student

0

(‘one’, ‘two’, ‘three’)

Сегодня я узнаю много полезного

2009-06-04 18:24:54 

максимальная длина 65535 символов

от 1 до 255 символов

-45.4564545346645

hello

строка фиксированной длины

-1.456454534664500443404244234343

23:12:33

2020-12-31

CHAR

VARCHAR

TEXT

BOOL

TINYINT

INTEGER

FLOAT

DOUBLE

DATE

TIME

DATETIME

ENUM

TIMESTAMP

23/11/2020 11:34

544

-122

Student

0

(‘one’, ‘two’, ‘three’)

Сегодня я узнаю много полезного

2009-06-04 18:24:54 

максимальная длина 65535 символов

от 1 до 255 символов

-45.4564545346645

hello

строка фиксированной длины

-1.456454534664500443404244234343

23:12:33

2020-12-31

Assessment criteria:
13-11 correct answers - excellent
10-8 correct answers - good enough
7-5 correct answers - I need to repeat
4 or less - there is a need to study

1. Delete all data from the table
2. Delete the existing table from the database
3. Select all data from the table.
4. Select a column with country names.
5. Sort all data by increasing population
6. Select the name of the country whose population density = 6.15
7. Add data about Kazakhstan to the table

Study the types of SQL queries and write queries to:

DELETE FROM Countries;
DROP TABLE Counties;
SELECT * FROM Counties;
SELECT Country FROM Countries;
SELECT * FROM Countries ORDER BY Population;
SELECT Country WHERE Density = 6.15;
INSERT INTO Countries VALUES (Qazaqstan, 18395660, 2724902, 6.74);

Answer

Write down in your copybooks answers to 3 questions:
1. What did I learn in class?
2. Where can I use this knowledge?
3. Do I have questions about the lesson? How do I manage with them?

Install Denwer software on your home computer using video on the video hosting. Research the purpose and facilities of the local server Denwer.