SQL Explained [MySQL and MS SQL Server]

preview_player
Показать описание
Download the zip file from down below, text files contains questions, do check them out
MySQL files link:
MS SQL Server files link:

00:00 Select
03:27 Data Definition Language (DDL)
10:30 Data Manipulation Language (DML)
12:38 Difference between AND OR
14:38 IN and OR
15:20 Wild Card Characters
17:50 not like
19:10 between
21:32 is not null
22:52 distinct
24:50 having
26:34 aliases AS and group by
30:04 having and group by
34:00 limit and top
37:21 JOINS
38:36 inner join
45:47 left right join
49:07 old syntax
52:34 cross join
59:57 multiple joins
1:04:24 sub queries
1:08:23 case when (if)
1:17:37 sysdate()
1:19:56 joins practice
1:27:50 union
1:31:50 union, intersect, except
1:36:20 more revision
1:41:17 over (order by) and (partition by)
1:45:00 third max salary
1:47:20 format
1:52:17 into
1:54:45 substring
1:55:30 concat
1:56:15 datename
Рекомендации по теме
join shbcf.ru