1 - AN INTRO TO THE COURSE
1 - AN-INTRO-TO-THE-COURSE
2 - INSTALLING SQL SERVER
3 - INSTALL ADVENTUREWORKS
4 - INSTALLING VISUAL STUDIO
5 - VERIFY SSRS AND SSIS EXTENSION
6 - LEARNING OBJECTIVES
7 - LIBRARY SCRIPTS PART 1
8 - LIBRARY SCRIPTS PART 2
9 - ONLINE SCRIPTS PART 1
10 - ONLINE SCRIPTS PART 2
11 - MOVIES SCRIPTS
12 - QUIZ 1
13 - QUIZ 1 ANSWER
14 - MULTIPLE DATABASES
15 - DELETE OLD DBS
16 - SSRS REPORT DROP DOWN
17 - SOLVING PROBLEMS
18 - CREATING A SSIS PACKAGE AND SETTING UP A JOB
19 - SETTING UP A JOB FOR SSIS
20 - SHRINK OR NOT TO SHRINK A DATABASE PART 1
21 - SHRINK OR NOT TO SHRINK A DATABASE PART 2
22 - EXECUTING A JOB WITH A STORED PROCEDURE FOR FRAGMENTATION
23 - CREATING A TRIGGER FOR AUDITING
24 - BRIEF INTRO TO JOINS
25 - QUESTIONS ABOUT BEER WITHOUT SCRIPTS PART 1
26 - QUESTIONS ABOUT BEER WITHOUT SCRIPTS PART 2
27 - QUESTIONS ABOUT BEER WITHOUT SCRIPTS PART 3
28 - QUESTIONS ABOUT BEER WITHOUT SCRIPTS PART 4
29 - QUESTIONS ABOUT BEER WITHOUT SCRIPTS PART 5
30 - QUIZ 2
31 - QUIZ 2 ANSWERS PART 1
32 - QUIZ 2 ANSWERS PART 2
33 - QUIZ 2 ANSWERS PART 3
34 - QUIZ 2 ANSWERS PART 4
35 - HOSPITAL SYSTEM PART 1
36 - HOSPITAL SYSTEM PART 2
37 - TRAVEL SYSTEM QUERY PART 1
38 - TRAVEL SYSTEM QUERY PART 2
39 - TRAVEL SYSTEM QUERY PART 3
40 - TRAVEL SYSTEM QUERY PART 4
41 - QUIZ 3 ANSWERS
42 - ADVENTUREWORKS2022 PRODUCTS PROJECTIONS
43 - PREPARATION AND INTERVIEW QUESTIONS