Presentation SQL (1)
Оценка 4.6

Presentation SQL (1)

Оценка 4.6
pptx
09.05.2020
Presentation SQL (1)
Presentation SQL (1).pptx

Learning objective 10.3.3.1 to make queries using extracted data (SQL (эс кю эль))

Learning objective 10.3.3.1 to make queries using extracted data (SQL (эс кю эль))

Learning objective

10.3.3.1 to make queries using extracted data (SQL (эс кю эль))

Lesson objectives: compare the data definition language (DDL), and the data manipulation language (DML) describe the basic

Lesson objectives: compare the data definition language (DDL), and the data manipulation language (DML) describe the basic

Lesson objectives:
compare the data definition language (DDL), and the data manipulation language (DML)
describe the basic SQL queries for working with tables in a database: CREATE, ALTER and DROP

What is SQL?

What is SQL?

What is SQL?

SQL stands for Structured Query

SQL stands for Structured Query

SQL stands for Structured Query Language (Structured Query Language).
SQL allows you to work with the database.
SQL allows you to query the database.
SQL allows you to extract data from the database.
SQL allows you to insert new records in the database.
SQL allows you to delete records from the database.
SQL allows you to update records in the database.
SQL is easy to learn.

Group work DML wikibooks - Data

Group work DML wikibooks - Data

Group work

DML wikibooks - Data Manipulation Language

DDL wikibooks - Data definition language

SQL statements are divided into:

SQL statements are divided into:

SQL statements are divided into:

Operators of data definition (Data Definition Language, DDL):
CREATE creates a database object (database itself, tables, views, user, and so on. D.)
ALTER modifies the object
DROP deletes an object;
Operators of data manipulation (Data Manipulation Language, DML):
SELECT selects the data that meet certain conditions,
INSERT adds new data,
UPDATE modifies existing data,
DELETE deletes the data;

Data Manipulation Language, DML :

Data Manipulation Language, DML :

Data Manipulation Language, DML:

SELECT field_name FROM table_name WHERE condition

SELECT - defines the fields that contain the necessary data
FROM - specifies the tables that contain the fields specified in the the SELECT
WHERE - specifies the conditions of selection fields, which must comply with all the records included in the results

Data Manipulation Language, DML

Data Manipulation Language, DML

Data Manipulation Language, DML

Example:
SELECT * FROM Customers;

Output all fields and records the Customers table

Example: SELECT CustomerName, Country

Example: SELECT CustomerName, Country

Example:
SELECT CustomerName, Country FROM Customers;

Shows records CustomerName , Country fields from Customers table

Data Manipulation Language, DML

Example: SELECT CustomerName, City

Example: SELECT CustomerName, City

Example:
SELECT CustomerName, City FROM Customers
WHERE City=‘Berlin';

Shows records CustomerName, City fields, from Customers table where the City field value is equal to the word ‘Berlin

Data Manipulation Language, DML

Activity Go to this link http://sqlzoo

Activity Go to this link http://sqlzoo

Activity

Go to this link
http://sqlzoo.net/wiki/SELECT_from_Nobel_Tutorial
perform the task of 1, 2, 5, 8, 12
Show your answers for teacher

Did you learn useful information for yourself?

Did you learn useful information for yourself?

Did you learn useful information for yourself?
Where did you have difficulties?
What would like to explore in the next lesson?

Used links: sqlzoo.net https://en

Used links: sqlzoo.net https://en

Used links:

sqlzoo.net
https://en.wikibooks.org/wiki/A-level_Computing_2009/AQA/Problem_Solving,_Programming,_Operating_Systems,_Databases_and_Networking/Databases/SQL
http://articles.org.ru/cn/showdetail.php?cid=7163
http://www.w3schools.com/sql/default.asp
http://www.site-do.ru/db/sql9.php
https://ru.wikipedia.org/wiki/
AQA A2 p. 161-163

Скачать файл