Section 1 : Become a Production SQL Server Database Administrator
|
Lecture 1 | SQL SERVER 2019 PART 1 | 00:13:32 Duration |
|
Lecture 2 | SQL SERVER 2019 PART 2 | 00:12:15 Duration |
|
Lecture 3 | SQL SERVER 2019 PART 3 | 00:06:13 Duration |
|
Lecture 4 | SQL SERVER 2019 PART 4 | 00:12:32 Duration |
|
Lecture 5 | SQL SERVER 2019 PART 5 | |
|
Lecture 6 | SQL SERVER 2019 PART 6 | |
|
Lecture 7 | INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM | |
|
Lecture 8 | Introduction to Becoming a Production SQL Server Administrator | 00:07:49 Duration |
|
Lecture 9 | What is TSQL | 00:03:31 Duration |
|
Lecture 10 | POST ADDENDUM | 00:08:12 Duration |
|
Lecture 11 | APPLICATIONS NEEDED | 00:07:34 Duration |
|
Lecture 12 | CREATE A VIRTUAL MACHINE | 00:18:23 Duration |
|
Lecture 13 | INSTALL SQL SERVER 2017 | 00:09:43 Duration |
|
Lecture 14 | ADD ADVENTUREWORKS2017 DATABASE | 00:08:13 Duration |
|
Lecture 15 | SQL SERVER 2014 AND 2017 COMPARISON | 00:02:39 Duration |
|
Lecture 16 | SQL Express 2012 Install | 00:10:30 Duration |
|
Lecture 17 | SQL AdventureWorks2012 Database | 00:04:13 Duration |
|
Lecture 18 | What is Database and a Table | 00:11:52 Duration |
|
Lecture 19 | Select | 00:08:37 Duration |
|
Lecture 20 | Where | 00:09:05 Duration |
|
Lecture 21 | Where With Like | 00:08:23 Duration |
|
Lecture 22 | Order By | 00:06:48 Duration |
|
Lecture 23 | Quiz 1 | |
|
Lecture 24 | Insert Into | 00:09:34 Duration |
|
Lecture 25 | Update | 00:09:00 Duration |
|
Lecture 26 | Delete | 00:08:02 Duration |
|
Lecture 27 | IN Operator | 00:02:43 Duration |
|
Lecture 28 | Between | 00:08:55 Duration |
|
Lecture 29 | Quiz 2 | |
|
Lecture 30 | Create Database | 00:05:54 Duration |
|
Lecture 31 | Create Table | |
|
Lecture 32 | Create Temp Table | 00:15:13 Duration |
|
Lecture 33 | Constraints Part 1 | |
|
Lecture 34 | Constraints Part 2 | 00:11:00 Duration |
|
Lecture 35 | Aliases | 00:06:55 Duration |
|
Lecture 36 | Quiz 3 | |
|
Lecture 37 | Joins | 00:17:42 Duration |
|
Lecture 38 | Quiz 4 | |
|
Lecture 39 | Union | 00:09:01 Duration |
|
Lecture 40 | Union | |
|
Lecture 41 | Aggregates | 00:16:20 Duration |
|
Lecture 42 | Group By and Having | 00:13:18 Duration |
|
Lecture 43 | Alter | 00:10:10 Duration |
|
Lecture 44 | Null | 00:05:18 Duration |
|
Lecture 45 | ISNULL | 00:03:07 Duration |
|
Lecture 46 | Quiz 5 | |
|
Lecture 47 | Select Into | 00:07:04 Duration |
|
Lecture 48 | Subquery | 00:08:41 Duration |
|
Lecture 49 | Data Type | 00:11:50 Duration |
|
Lecture 50 | Cast and Convert | 00:10:45 Duration |
|
Lecture 51 | String Function | 00:19:50 Duration |
|
Lecture 52 | Numeric and Date Function | 00:15:16 Duration |
|
Lecture 53 | Quiz 6 | |
|
Lecture 54 | Views | 00:11:50 Duration |
|
Lecture 55 | Case | 00:11:21 Duration |
|
Lecture 56 | Indexes | 00:16:05 Duration |
|
Lecture 57 | Stored Procedure | 00:16:18 Duration |
|
Lecture 58 | Quiz 7 | |
|
Lecture 59 | Triggers | 00:13:33 Duration |
|
Lecture 60 | Design Query Editor | 00:07:13 Duration |
|
Lecture 61 | Rank | 00:08:41 Duration |
|
Lecture 62 | Extra Quiz with answers | |
|
Lecture 63 | SQL Server Administration Part 1 | 00:02:18 Duration |
|
Lecture 64 | About Certification |