[Udemy] Become a Production SQL Server Administrator [2015, ENG]

Содержание

Section 1: Become a Production SQL Server Database Administrator
Lecture 1
Introduction to Becoming a Production SQL Server Administrator
07:49
Lecture 2
What is TSQL
03:30
Lecture 3
SQL Express 2012 Install
10:30
Lecture 4
SQL AdventureWorks2012 Database
04:13
Lecture 5
What is Database and a Table
11:52
Lecture 6
Select
08:36
Lecture 7
Where
09:05
Lecture 8
Where With Like
08:23
Lecture 9
Order By
06:48
Lecture 10
Quiz 1
Text
Lecture 11
Insert Into
09:33
Lecture 12
Update
09:00
Lecture 13
Delete
08:02
Lecture 14
IN Operator
02:43
Lecture 15
Between
08:55
Lecture 16
Quiz 2
Text
Lecture 17
Create Database
05:53
Lecture 18
Create Table
08:40
Lecture 19
Create Temp Table
15:12
Lecture 20
Constraints Part 1
10:46
Lecture 21
Constraints Part 2
11:00
Lecture 22
Aliases
06:55
Lecture 23
Quiz 3
Text
Lecture 24
Joins
17:42
Lecture 25
Quiz 4
Text
Lecture 26
Union
09:00
Lecture 27
Aggregates
16:19
Lecture 28
Group By and Having
13:17
Lecture 29
Alter
10:10
Lecture 30
Null
05:18
Lecture 31
ISNULL
03:07
Lecture 32
Quiz 5
Text
Lecture 33
Select Into
07:04
Lecture 34
Subquery
08:41
Lecture 35
Data Type
11:50
Lecture 36
Cast and Convert
10:44
Lecture 37
String Function
19:50
Lecture 38
Numeric and Date Function
15:15
Lecture 39
Quiz 6
Text
Lecture 40
Views
11:43
Lecture 41
Case
11:20
Lecture 42
Indexes
16:04
Lecture 43
Stored Procedure
16:18
Lecture 44
Quiz 7
Text
Lecture 45
Triggers
13:33
Lecture 46
Design Query Editor
07:12
Lecture 47
Rank
08:41
Lecture 48
Extra Quiz with answers
Tex

Скриншоты

later