🗊Презентация Simple SQL queries

Категория: Информатика
Нажмите для полного просмотра!
Simple SQL queries, слайд №1Simple SQL queries, слайд №2Simple SQL queries, слайд №3Simple SQL queries, слайд №4Simple SQL queries, слайд №5Simple SQL queries, слайд №6Simple SQL queries, слайд №7Simple SQL queries, слайд №8Simple SQL queries, слайд №9Simple SQL queries, слайд №10Simple SQL queries, слайд №11Simple SQL queries, слайд №12Simple SQL queries, слайд №13Simple SQL queries, слайд №14Simple SQL queries, слайд №15Simple SQL queries, слайд №16
Скачать
Вы можете ознакомиться и скачать презентацию на тему Simple SQL queries. Доклад-сообщение содержит 16 слайдов. Презентации для любого класса можно скачать бесплатно. Если материал и наш сайт презентаций Mypresentation Вам понравились – поделитесь им с друзьями с помощью социальных кнопок и добавьте в закладки в своем браузере.

Слайды и текст этой презентации

Слайд 1


Module 3 SIMPLE SQL QUERIES
Описание слайда:
Module 3 SIMPLE SQL QUERIES

Слайд 2


Agenda SELECT … FROM DISTINCT ORDER BY SELECT … FROM … WHERE IN, BETWEEN, LIKE, NOT NULL VALUE DATE AND TIME
Описание слайда:
Agenda SELECT … FROM DISTINCT ORDER BY SELECT … FROM … WHERE IN, BETWEEN, LIKE, NOT NULL VALUE DATE AND TIME

Слайд 3


SELECT … FROM Main SQL commands to extract data from database tables: SELECT * FROM <table name> SELECT <field name1>, <field name2>, … FROM <table> For example: SELECT CITY FROM DEPARTMENT SELECT ID, NAME FROM STUDENT
Описание слайда:
SELECT … FROM Main SQL commands to extract data from database tables: SELECT * FROM <table name> SELECT <field name1>, <field name2>, … FROM <table> For example: SELECT CITY FROM DEPARTMENT SELECT ID, NAME FROM STUDENT

Слайд 4


COMPANY database
Описание слайда:
COMPANY database

Слайд 5


DEMONSTRATION Demo 1
Описание слайда:
DEMONSTRATION Demo 1

Слайд 6


ORDER BY The ORDER BY keyword is used for sorting the result set by one or more columns. To sort the records in a descending order, we can use the DESC keyword. For example SELECT NAME FROM DEPARTMENT ORDER BY NAME DESC
Описание слайда:
ORDER BY The ORDER BY keyword is used for sorting the result set by one or more columns. To sort the records in a descending order, we can use the DESC keyword. For example SELECT NAME FROM DEPARTMENT ORDER BY NAME DESC

Слайд 7


DISTINCT
Описание слайда:
DISTINCT

Слайд 8


WHERE The WHERE clause is used to extract only those records that fulfill a specified criterion SELECT <LIST OF FIELDS> FROM <TABLE> WHERE <CRITERIA> Comparison operators: =, >, <, >=, <=, <> NOT AND OR
Описание слайда:
WHERE The WHERE clause is used to extract only those records that fulfill a specified criterion SELECT <LIST OF FIELDS> FROM <TABLE> WHERE <CRITERIA> Comparison operators: =, >, <, >=, <=, <> NOT AND OR

Слайд 9


DEMONSTRATION Demo 3
Описание слайда:
DEMONSTRATION Demo 3

Слайд 10


IN, BETWEEN The IN operator allows you to specify multiple values in a WHERE clause. For example SELECT FIRSTNAME, LASTNAME FROM EMPLOYEE WHERE POSITION IN ('MANAGER‘, ‘SELLER’)
Описание слайда:
IN, BETWEEN The IN operator allows you to specify multiple values in a WHERE clause. For example SELECT FIRSTNAME, LASTNAME FROM EMPLOYEE WHERE POSITION IN ('MANAGER‘, ‘SELLER’)

Слайд 11


LIKE The LIKE operator is used in a WHERE clause to search for a specified pattern in a column In SQL, wildcard characters are used with the SQL LIKE operator Wildcard characters % - a substitute for zero or more characters _ - a substitute for a single character
Описание слайда:
LIKE The LIKE operator is used in a WHERE clause to search for a specified pattern in a column In SQL, wildcard characters are used with the SQL LIKE operator Wildcard characters % - a substitute for zero or more characters _ - a substitute for a single character

Слайд 12


NOT NOT operator is used to negate a condition in a SELECT, INSERT, UPDATE, or DELETE statement. NOT CONDITION For example SELECT CITY FROM DEPARTMENT WHERE NOT CITY LIKE 'Lviv'
Описание слайда:
NOT NOT operator is used to negate a condition in a SELECT, INSERT, UPDATE, or DELETE statement. NOT CONDITION For example SELECT CITY FROM DEPARTMENT WHERE NOT CITY LIKE 'Lviv'

Слайд 13


NULL value NULL values represent missing unknown data. IS NULL IS NOT NULL For example SELECT LASTNAME, FIRSTNAME FROM EMPLOYEE WHERE BONUS IS NULL
Описание слайда:
NULL value NULL values represent missing unknown data. IS NULL IS NOT NULL For example SELECT LASTNAME, FIRSTNAME FROM EMPLOYEE WHERE BONUS IS NULL

Слайд 14


DEMONSTRATION Demo 4
Описание слайда:
DEMONSTRATION Demo 4

Слайд 15


Working with DATE type DATEPART(datepart, date) DAY(date) MONTH(date) YEAR(date) DATEDIFF(datepart, startdate, enddate)
Описание слайда:
Working with DATE type DATEPART(datepart, date) DAY(date) MONTH(date) YEAR(date) DATEDIFF(datepart, startdate, enddate)

Слайд 16


Thank you!
Описание слайда:
Thank you!

Скачать

Теги Simple SQL queries
Похожие презентации
Mypresentation.ru
Загрузить презентацию