The SQL SELECT Statement

preview_player
Показать описание
This video explains how to use the SELECT statement of the Structured Query Language (SQL). It is the first in a series about a subset of SQL known as the Data Manipulation Language (DML), which is used to work with the data in database tables. It includes examples of the use of a column aliases, the WHERE clause, including relational and logical operators, and fuzzy matching with the wildcard operator Like and the percentage symbol %. It also explains how to use the order by clause to sort the results of a query, including the keywords asc and desc.
Рекомендации по теме
Комментарии
Автор

Doing a good job, m8. :)
0:04 SELECT
0:50 SELECT example
1:07 column ordering
1:48 handling spaces in column names
2:07 column alias
2:20 SELECT *
2:39 WHERE example
2:47 Syntax
3:32 WHERE on a non-selected column
3:53 Logical and relational operators
4:19 Order or precedence for logical operators
5:20 Date format
6:02 Fuzzy matching (Like, %)
6:52 ORDER BY
7:57 DISTINCT
8:29 Summary


Here's some community service. :>

Lammot
Автор

Best explanation of normalization on the internet till today.

WakattA-
Автор

Awesome! Technically elaborative with mesmerizing voice of BBC's David Attenborough

JustTruthleft
Автор

Guido van Rossum is rather old in this video XD

truthmatters