Simple SQL queries презентация в формате PowerPoint - скачать бесплатно

Скачать презентацию на тему: "Simple SQL queries" с количеством слайдов в размере 16 страниц. У нас вы найдете презентацию на любую тему и для каждого класса школьной программы. Мы уверены, что наши слайды помогут найти вам свою аудиторию. Весь материал предоставлен бесплатно, в знак благодарности мы просим Вас поделиться ссылками в социальных сетях и по возможности добавьте наш сайт MirPpt.ru в закладки.

Нажмите для просмотра
Simple SQL queries

1: Module 3 SIMPLE SQL QUERIES

2: 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 SELECT , , … FROM For example: SELECT CITY FROM DEPARTMENT SELECT ID, NAME FROM STUDENT

4: COMPANY database

5: 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

7: DISTINCT

8: WHERE The WHERE clause is used to extract only those records that fulfill a specified criterion SELECT FROM WHERE Comparison operators: , , ,

9: 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)

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

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

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

14: DEMONSTRATION Demo 4

15: Working with DATE type DATEPART(datepart, date) DAY(date) MONTH(date) YEAR(date) DATEDIFF(datepart, startdate, enddate)

16: Thank you!

Скачать презентацию


MirPpt.ru