Structured Query Language (SQL)

Lesson objectives:
Understand what is SQL and how it’s used.
Understand what

Success criteria

Be able to use the SELECT, UPDATE, INSERT, DELETE
Be able

Lesson 1

Discussed question «what is a query in the database?»

Research work.

Students research “Data dictionary”
Activity. Pair work.
From the table, students define

Group work. Students create a data dictionary for the database, create

lesson 2 What is SQL?

SQL stands for Structured Query Language (Structured Query Language).
SQL allows you

SQL statements are divided into:

Operators of data definition (Data Definition Language,

Data Manipulation Language, DML:

SELECT field_name FROM table_name WHERE condition
SELECT - defines the

Data Manipulation Language, DML

Example:
SELECT * FROM Customers;

Output all fields and records

Example:
SELECT CustomerName, Country FROM Customers;

Shows records CustomerName , Country fields

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

Shows records CustomerName,

Activity

Go to this link
http://sqlzoo.net/wiki/SELECT_from_Nobel_Tutorial
perform the task of 1, 2, 5, 8,

Data Manipulation Language, DML

To change the values in one or more columns

Data Manipulation Language, DML

Example:
UPDATE Customers SET ContactName=‘Student’, City=‘Taraz’ WHERE CustomerID=2;

After UPDATE statements,

Activity

Go to this link
http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all
Update London to Berlin for CustomerID =

Data Manipulation Language, DML

To add records to the table, use the INSERT

Data Manipulation Language, DML:

Example:
INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)

Activity

Go to this link
http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all
INSERT VALUES ('Bala', 'Askar Nagay', 'Abai 1',

Data Manipulation Language, DML:

To delete rows from a table, use a DELETE

Data Manipulation Language, DML

Example:
DELETE FROM Customers WHERE CustomerID=3;

After the proposal DELETE FROM,

Activity

Go to this link
http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all
Delete row where CustomerID=12
Perform the task.

Practical work

Table: actor_info

INSERT Query

INSERT INTO actor_info VALUES
(1, ’Leonardo’ , ’DiCaprio’ ,35),
(2, ’Matt’ ,

SELECT Query
SELECT * FROM actor_info;

SELECT Query
SELECT actor_id, total_films
FROM actor_info;

UPDATE Query

UPDATE actor_info
SET total_films = 36
WHERE actor_id = 1;

DELETE Query

DELETE FROM actor_info
WHERE total_films > 70

DELETE Query

DELETE FROM actor_info

Did you learn useful information for yourself?
Where did you have difficulties?
What