Содержание
- 3. Декартово произведение
- 4. Предикат
- 5. Домен Домен имеет уникальное имя (в пределах базы данных). Домен определен на некотором простом типе данных
- 6. Отношения, атрибуты, кортежи
- 7. Основные компоненты реляционного отношения
- 8. Основные компоненты реляционного отношения
- 9. Свойства отношений Отсутствие кортежей-дубликатов Отсутствие упорядоченности кортежей Отсутствие упорядоченности атрибутов Атомарность значений атрибутов
- 10. Structured Query Language Data Definition Language (DDL) – язык определения данных Data Manipulition Language (DML) –
- 11. Select SELECT [ALL | DISTINCT] FROM , ... [ WHERE ] [ GROUP BY ,... ]
- 12. Select SELECT [ALL | DISTINCT] FROM , ... [ WHERE ] [ GROUP BY ,... ]
- 13. SELECT * FROM Employees
- 14. SELECT POST FROM Employees SELECT DISTINCT POST FROM Employees
- 15. Select SELECT [ALL | DISTINCT] FROM , ... [ WHERE ] [ GROUP BY ,... ]
- 16. Логические операции и Операторы сравнения = Равно > Больше чем >= Больше или равно Не равно
- 17. SELECT EMP_ID, MANAGER_ID, LAST_NAME, FIRST_NAME FROM Employees WHERE MANAGER_ID = 10;
- 18. SELECT EMP_ID, MANAGER_ID, LAST_NAME, FIRST_NAME FROM Employees WHERE MANAGER_ID = 10 OR EMP_ID = 10;
- 19. SELECT EMP_ID, MANAGER_ID, LAST_NAME, FIRST_NAME FROM Employees WHERE MANAGER_ID = 10 OR EMP_ID = 10;
- 20. SELECT PRODUCT_ID, PRODUCT_NAME, PRICE FROM PRODUCTS WHERE PRODUCT_ID IN (1,10,11,8); SELECT PRODUCT_ID, PRODUCT_NAME, PRICE FROM PRODUCTS
- 21. Поиск по шаблону (LIKE) % - любое количество символов (в том числе и 0) подряд _
- 22. SELECT EMPLOYEE_ID, LAST_NAME FROM EMPLOYEES WHERE LAST_NAME LIKE '%бе%‘; SELECT EMPLOYEE_ID, LAST_NAME FROM EMPLOYEES WHERE LAST_NAME
- 23. NULL SELECT EMPLOYEE_ID, LAST_NAME, POST FROM EMPLOYEES WHERE MANAGER_ID IS NULL; Сравнение: IS [NOT] NULL
- 24. NULL SELECT EMPLOYEE_ID, LAST_NAME, POST FROM EMPLOYEES WHERE MANAGER_ID IS NULL; Сравнение: IS [NOT] NULL В
- 25. NULL SELECT EMPLOYEE_ID, LAST_NAME, POST FROM EMPLOYEES WHERE MANAGER_ID IS NULL; Сравнение: IS [NOT] NULL В
- 26. Связи N
- 27. JOIN CROSS JOIN B A C B A C B A C 3 3 3 1
- 28. JOIN B A C CROSS JOIN 2 3 1 =
- 30. INNER JOIN
- 31. A 2 B 3 C 2 INNER JOIN B A C B A C 3 3
- 32. C 2 INNER JOIN B A C B A C 3 3 1 1 1 2
- 33. LEFT JOIN
- 34. LEFT JOIN
- 35. 2 LEFT JOIN 3 1
- 36. C B A C B A C 2 LEFT JOIN A B 3 1
- 37. C B A C B A C 2 LEFT JOIN A B 3 1
- 38. C B A C B A C 2 LEFT JOIN A B 3 1
- 39. RIGHT JOIN
- 40. 3 RIGHT JOIN B A C A B 3 1 2 3 1 2 2 3
- 41. 3 RIGHT JOIN B A C A B 3 1 2 3 1 2 2 3
- 42. 3 1 3 1 2 1 2 3 RIGHT JOIN B A C A B 2
- 43. JOIN INNER JOIN = A B C 1 2 3 2 3 A B RIGHT JOIN
- 44. JOIN INNER JOIN = A B C 1 2 3 2 3 A B RIGHT JOIN
- 45. INNER JOIN B A C
- 46. INNER JOIN B A C 2 3 3 1 1 2 C B A C B
- 47. INNER JOIN B A C 3 3 1 1 2 B A C B A C
- 48. INNER JOIN A B C 1 2 3 D
- 49. INNER JOIN = A B C 1 2 3 2 2 A C 3 B D
- 50. INNER JOIN = A B C 1 2 3 2 2 A C LEFT JOIN A
- 51. INNER JOIN = A B C 1 2 3 2 2 A C LEFT JOIN 3
- 52. INNER JOIN = A B C 1 2 3 2 2 A C LEFT JOIN 3
- 53. INNER JOIN = A B C 1 2 3 2 2 A C LEFT JOIN 3
- 54. INNER JOIN = A B C 1 2 3 2 2 A C LEFT JOIN 3
- 55. INNER JOIN = A B C 1 2 3 2 2 A C LEFT JOIN =
- 56. INNER JOIN = A B C 1 2 3 2 2 A C RIGHT JOIN A
- 57. INNER JOIN = A B C 1 2 3 2 2 A C RIGHT JOIN =
- 58. INNER JOIN = A B C 1 2 3 2 2 A C RIGHT JOIN =
- 59. INNER JOIN = A B C 1 2 3 2 2 A C RIGHT JOIN =
- 60. Синтаксис JOIN SELECT [ALL | DISTINCT] FROM , ... [ WHERE ] [ GROUP BY ,...
- 61. Синтаксис JOIN SELECT [ALL | DISTINCT] FROM , ... JOIN ON [ WHERE ] [ GROUP
- 62. SELECT CATEGORY_NAME, PRODUCT_NAME, PRICE FROM PRODUCTS INNER JOIN CATEGORIES ON CATEGORIES. CATEGORY_ID = PRODUCTS. CATEGORY_ID;
- 63. SELECT CATEGORY_NAME, PRODUCT_NAME, PRICE FROM PRODUCTS INNER JOIN CATEGORIES ON CATEGORIES. CATEGORY_ID = PRODUCTS. CATEGORY_ID;
- 64. SELECT CATEGORY_NAME, PRODUCT_NAME, PRICE FROM PRODUCTS LEFT JOIN CATEGORIES ON CATEGORIES. CATEGORY_ID = PRODUCTS. CATEGORY_ID;
- 65. SELECT CATEGORY_NAME, PRODUCT_NAME, PRICE FROM PRODUCTS RIGHT JOIN CATEGORIES ON CATEGORIES. CATEGORY_ID = PRODUCTS. CATEGORY_ID;
- 66. SELECT CATEGORY_NAME, PRODUCT_NAME, PRICE FROM PRODUCTS FULL JOIN CATEGORIES ON CATEGORIES. CATEGORY_ID = PRODUCTS. CATEGORY_ID;
- 67. SELECT CATEGORY_NAME, PRODUCT_NAME, PRICE FROM PRODUCTS CROSS JOIN CATEGORIES;
- 69. Скачать презентацию