1 Lesson №58 Database development Presentation

Local server

Lesson topic: Database Development

Lesson Objectives:
create a single-table database using SQL queries and a constructor

Knowledge and understanding:
- to know queries for creating and working with single-table database;
- to know what a local server is, its purpose and composition;
Applying:
- write a query to create a single-table database;
- create a single-table database, in constructor mode;
Analysis:
- explain the structure of the created database, according to the SQL query.

Local server is a hosting emulator.
We need it to be able to create a website on your computer, and then transfer it to hosting.

WAMP

XAMPP

DENWER

=

+

+

Local Server

+

There are several ways you can access and work with the MySQL database.1 way. Using a command prompt.2 way. Using web applications that allow you to work with a database through a graphical interface.phpMyAdmin — open source web application, which is a web interface for administering MySQL DBMS. 

Division into pairs

Go to web site

Database «Qazaqstan» consists of one table «Regions»

Table «Regions»

Which field will be primary key?
How many fields in the table “Regions”?
Which data type is necessary to develop structure the table “Regions”?

1. Using the proposed resources, research the process of writing a query to create a single-table database2. Write queries for: :1. Creating a DB “Qazaqstan”2. Creating a table “Regions”3. Adding data to the table “Regions” (You must add at least 5 regions)4. Delete the record where the population is less than 2000005. Update of data (increase population in Nur-Sultan per 1000 people)

Pair work:

1. A query to create a DB «Qazaqstan» :
CREATE DATABASE Qazaqstan;

2. A query to create a table «Regions» :
CREATE TABLE Regions (
ID CHAR(2) NOT NULL Primary key,
Region VARCHAR(30) NOT NULL,
Population INTEGER NULL);

3. A query to insert data into table «Regions» :
INSERT INTO Regions (ID, Region, Population) VALUES (1,"Нур-Султан",1070196);

4. A query to delete a record by condition :
DELETE FROM Regions WHERE Population < 200000;

5. A query to update a record by condition :
UPDATE Regions SET Population = Population + 1000 WHERE Region = "Нур-Султан";

Differentiation task1. Develop a DB “Mobile_store” and a table “Clients” by using the interface phpMyAdmin.2. Add the fields Id, Name, Surname, Gender, Phonein the table “Clients”https://metanit.com/web/php/7.1.php

1. What difficulties did you face during the lesson?
2. What did you learn in the lesson?
3. Where can you apply this knowledge in real life?