Оцените презентацию от 1 до 5 баллов!
Тип файла:
ppt / pptx (powerpoint)
Всего слайдов:
28 слайдов
Для класса:
1,2,3,4,5,6,7,8,9,10,11
Размер файла:
1.19 MB
Просмотров:
82
Скачиваний:
0
Автор:
неизвестен
Слайды и текст к этой презентации:
№1 слайд![Data Modeling and Databases](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img0.jpg)
Содержание слайда: Data Modeling and Databases II -
The Relational Data Model and SQL
Week 3 - Tutorial
№2 слайд![In this tutorial More Complex](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img1.jpg)
Содержание слайда: In this tutorial
More Complex SQL Retrieval Queries
Specifying Constraints as Assertions and Actions as Triggers
Views (Virtual Tables) in SQL
Schema Change Statements in SQL
№3 слайд![More Complex SQL Retrieval](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img2.jpg)
Содержание слайда: More Complex SQL Retrieval Queries
Comparisons Involving NULL and Three-Valued Logic:
SQL uses a three-valued logic with values TRUE, FALSE, and
UNKNOWN instead of the standard two-valued (Boolean) logic with
values TRUE or FALSE
№4 слайд![More Complex SQL Retrieval](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img3.jpg)
Содержание слайда: More Complex SQL Retrieval Queries
Nested Queries, Tuples, and Set/Multiset Comparisons:
№5 слайд![More Complex SQL Retrieval](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img4.jpg)
Содержание слайда: More Complex SQL Retrieval Queries
How to kill the DBMS performance? You can use correlated
subqueries, i.e. when the inner query is filtered by
values from the outer query)
№6 слайд![More Complex SQL Retrieval](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img5.jpg)
Содержание слайда: More Complex SQL Retrieval Queries
How to kill the DBMS performance? You can use correlated
subqueries, i.e. when the inner query is filtered by
values from the outer query)
№7 слайд![More Complex SQL Retrieval](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img6.jpg)
Содержание слайда: More Complex SQL Retrieval Queries
The EXISTS and UNIQUE Functions in SQL
EXISTS and UNIQUE are Boolean functions that return
TRUE or FALSE; hence,
they can be used in a WHERE clause condition.
№8 слайд![More Complex SQL Retrieval](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img7.jpg)
Содержание слайда: More Complex SQL Retrieval Queries
NATURAL JOINS, INNER JOIN, OUTER JOIN, LEFT {OUTER} JOIN, RIGHT {OUTER} JOIN
№9 слайд![More Complex SQL Retrieval](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img8.jpg)
Содержание слайда: More Complex SQL Retrieval Queries
№10 слайд![More Complex SQL Retrieval](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img9.jpg)
Содержание слайда: More Complex SQL Retrieval Queries
№11 слайд![More Complex SQL Retrieval](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img10.jpg)
Содержание слайда: More Complex SQL Retrieval Queries
№12 слайд![More Complex SQL Retrieval](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img11.jpg)
Содержание слайда: More Complex SQL Retrieval Queries
№13 слайд![More Complex SQL Retrieval](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img12.jpg)
Содержание слайда: More Complex SQL Retrieval Queries
№14 слайд![More Complex SQL Retrieval](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img13.jpg)
Содержание слайда: More Complex SQL Retrieval Queries
№15 слайд![In this tutorial More Complex](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img14.jpg)
Содержание слайда: In this tutorial
More Complex SQL Retrieval Queries
Specifying Constraints as Assertions and Actions as Triggers
Views (Virtual Tables) in SQL
Schema Change Statements in SQL
№16 слайд![Specifying Constraints as](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img15.jpg)
Содержание слайда: Specifying Constraints as Assertions and Actions as Triggers
№17 слайд![Specifying Constraints as](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img16.jpg)
Содержание слайда: Specifying Constraints as Assertions and Actions as Triggers
№18 слайд![Specifying Constraints as](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img17.jpg)
Содержание слайда: Specifying Constraints as Assertions and Actions as Triggers
№19 слайд![Specifying Constraints as](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img18.jpg)
Содержание слайда: Specifying Constraints as Assertions and Actions as Triggers
№20 слайд![Specifying Constraints as](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img19.jpg)
Содержание слайда: Specifying Constraints as Assertions and Actions as Triggers
№21 слайд![In this tutorial More Complex](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img20.jpg)
Содержание слайда: In this tutorial
More Complex SQL Retrieval Queries
Specifying Constraints as Assertions and Actions as Triggers
Views (Virtual Tables)
Schema Change Statements
№22 слайд![Views Virtual Tables](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img21.jpg)
Содержание слайда: Views (Virtual Tables)
№23 слайд![Views Virtual Tables](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img22.jpg)
Содержание слайда: Views (Virtual Tables)
№24 слайд![Views Virtual Tables](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img23.jpg)
Содержание слайда: Views (Virtual Tables)
№25 слайд![In this tutorial More Complex](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img24.jpg)
Содержание слайда: In this tutorial
More Complex SQL Retrieval Queries
Specifying Constraints as Assertions and Actions as Triggers
Views (Virtual Tables)
Schema Change Statements
№26 слайд![Schema Change Statements](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img25.jpg)
Содержание слайда: Schema Change Statements
№27 слайд![In this tutorial More Complex](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img26.jpg)
Содержание слайда: In this tutorial
More Complex SQL Retrieval Queries
Specifying Constraints as Assertions and Actions as Triggers
Views (Virtual Tables)
Schema Change Statements
№28 слайд![What people are researching](/documents_6/b2e22327f1a81002ea52f888f9a54d03/img27.jpg)
Содержание слайда: What people are researching on
this domain?