1_Structured_queries_lp_l1_v1

Long-term plan unit:

 10.3A Information Systems

School

Date:

Teacher name:

Grade: 10

Number present:

Grade:

The topic of the lesson:

Structured queries

Learning objectives(s) that this lesson is contributing to

  10.3.3.2 use structured query language (SQL) to select data from tables

Assessment criteria

Knowledge and understanding:

●         explains the definition and purpose of requests;

●         Knows the algorithm for creating a sample request;

●         knows the types of requests;

Application:

●        creates queries using the constructor

Success criteria

All learners will be able to know:

Know what structured queries (SQL) are,

know the syntax of an SQL query per sample,

be able to create structured queries.

Language objectives

Students can:

Explain the purpose of sample queries, the difference between SQL and a QBE query.

Vocabulary and terminology specific to the subject:

Query, structured query language, selection, DBMS, condition, SQL, QBE, SELECT, FROM, ORDER BY, WHERE.

Useful expressions for conversations and writing:

The SQL query has the following syntax ...

To fulfill this request, you must ...

The structure of ... query uses the following keywords: ...

Value links

Group work , co-operation, time management, academic integrity

Cross curricular links

English

Previous lear

 -

Course of the lesson

Planned stages of the lesson

Planned activities at the lesson

Resources

Beginning

0-2

Warm up

  Definition of the topic.

Setting lesson objectives and success criteria

Knowledge update

With what can you perform a search and select data from the database? (Answer: Request)

How do you understand these abbreviations (QBE and SQL)? (Query by Example - sample query, Structured Query Language - “structured query language”)

Middle

2-20

Explanation of the teacher

You have learned how to create QBE queries for sampling in the Access DBMS, however, if you want to work in another DBMS, you may encounter a problem that it will not have the ability to create queries on a sample or there will be a different program interface and other rules for creating this type of queries .

In order to avoid these difficulties, we will get acquainted with other types of queries, namely SQL queries.

SQL is a structured query language whose main task is to provide a simple way to read and write information to a database.

A special feature of SQL is that most of them can be fairly easily transferred from one DBMS to another.

As the name implies, requests in this language have a certain structure.

Let's consider it.

The most commonly used type of query in SQL is the sample request.

Question to the class:

And how in English will be “choice, selection”?

(Pupils make assumptions, correct answer is Select)

The English word is also used to indicate where we will make the selection, what do you think, what? Translation of the word "from". (reply from)

So let's connect these two words and get the structure of the selection command:

SELECT field list FROM table_name

For example, let's create a simple request for receiving data from the "name" and "phone" fields of the "friends" table:

SELECT name, phone FROM friends

If you need to get all the fields of the table, then it is not necessary to list them, it is enough to put an asterisk (*):

SELECT * FROM friends

In order to consolidate this knowledge, let's carry out practical work.

The teacher performs the work with the children

Presentation

https://www.youtube.com/watch?v=4xroLckwjkQ

20-25

Frontal work:

Exercise 1

There is a table "Customers". Determine what will be the result of this request?

Answer:

Task 2

There is a table "Coaches". What are the names of the trainers that will be released as a result of this request?

Answer:

25-38

1. Create a SQL query that allows you to display information about married actors. (Hint selection condition ActorMarried = true).

2. Create a SQL query that allows you to display alphabetically sorted information about actors with a rating of 9.

3. Create a SQL query that allows you to display only movies in the Action genre, sorted by year of release from the newest movie to the oldest.

End

 38-40

Reflection

The learners speak in a circle with one sentence, choosing the beginning of a phrase from the reflective screen on the board:

Today I found out ... it was interesting ...

it was hard ... I was doing the job ...

I realized that ... now I can ...

I felt that ... I acquired ...

I learned ... I did it ...

I could ... I will try ...

Cards

Differentiation – how do you plan to give more support? How do you plan to challenge the more able learners?

Assessment – how are you planning to check students’ learning?

Health and safety regulations

Additional support.

Work in pairs / groups - support for classmates.

Help the teacher, if required.

More capable learners can demonstrate aspects of their decisions that seem interesting / more complex to the other learners.

Answers questions and a session of answers.

Use questions when completing a task.

Use survey questions to understand the results / success of learners at each stage of the lesson.

Remind of some safety rules when working with computer equipment, for example, that you must be careful when installing the screen, keyboard and mouse; beware of wires, as they pose a threat to movement.