Master SQL Server Projects: Hands-On 2024 Administration
Focused View
6:00:51
1 - AN INTRO TO THE COURSE.mp4
06:49
1 - AN-INTRO-TO-THE-COURSE.mp4
06:49
2 - INSTALLING SQL SERVER.mp4
08:50
3 - INSTALL ADVENTUREWORKS.mp4
03:05
4 - INSTALLING VISUAL STUDIO.mp4
06:06
5 - VERIFY SSRS AND SSIS EXTENSION.mp4
02:41
6 - LEARNING OBJECTIVES.mp4
03:52
7 - LIBRARY SCRIPTS PART 1.mp4
13:37
8 - LIBRARY SCRIPTS PART 2.mp4
22:24
9 - ONLINE SCRIPTS PART 1.mp4
14:01
10 - ONLINE SCRIPTS PART 2.mp4
12:40
11 - MOVIES SCRIPTS.mp4
09:29
12 - QUIZ 1.mp4
03:22
13 - QUIZ 1 ANSWER.mp4
09:11
14 - MULTIPLE DATABASES.mp4
14:23
15 - DELETE OLD DBS.mp4
09:54
16 - SSRS REPORT DROP DOWN.mp4
14:43
17 - SOLVING PROBLEMS.mp4
06:14
18 - CREATING A SSIS PACKAGE AND SETTING UP A JOB.mp4
15:09
19 - SETTING UP A JOB FOR SSIS.mp4
04:34
20 - SHRINK OR NOT TO SHRINK A DATABASE PART 1.mp4
13:03
21 - SHRINK OR NOT TO SHRINK A DATABASE PART 2.mp4
11:37
22 - EXECUTING A JOB WITH A STORED PROCEDURE FOR FRAGMENTATION.mp4
17:48
23 - CREATING A TRIGGER FOR AUDITING.mp4
10:23
24 - BRIEF INTRO TO JOINS.mp4
05:21
25 - QUESTIONS ABOUT BEER WITHOUT SCRIPTS PART 1.mp4
12:39
26 - QUESTIONS ABOUT BEER WITHOUT SCRIPTS PART 2.mp4
05:39
27 - QUESTIONS ABOUT BEER WITHOUT SCRIPTS PART 3.mp4
06:51
28 - QUESTIONS ABOUT BEER WITHOUT SCRIPTS PART 4.mp4
04:22
29 - QUESTIONS ABOUT BEER WITHOUT SCRIPTS PART 5.mp4
03:33
30 - QUIZ 2.mp4
01:45
31 - QUIZ 2 ANSWERS PART 1.mp4
04:03
32 - QUIZ 2 ANSWERS PART 2.mp4
02:21
33 - QUIZ 2 ANSWERS PART 3.mp4
03:41
34 - QUIZ 2 ANSWERS PART 4.mp4
01:29
35 - HOSPITAL SYSTEM PART 1.mp4
09:41
36 - HOSPITAL SYSTEM PART 2.mp4
06:17
37 - TRAVEL SYSTEM QUERY PART 1.mp4
11:06
38 - TRAVEL SYSTEM QUERY PART 2.mp4
04:18
39 - TRAVEL SYSTEM QUERY PART 3.mp4
04:12
40 - TRAVEL SYSTEM QUERY PART 4.mp4
02:12
41 - QUIZ 3 ANSWERS.mp4
09:02
42 - ADVENTUREWORKS2022 PRODUCTS PROJECTIONS.mp4
09:41
43 - PREPARATION AND INTERVIEW QUESTIONS.mp4
11:54
More details
Course Overview
Advance your SQL Server skills with this project-based course, where you'll design databases, automate processes with T-SQL, and apply your knowledge to real-world data scenarios.
What You'll Learn
- Design and develop SQL projects from scratch, including database schemas
- Script and automate processes using advanced T-SQL techniques
- Apply data manipulation and analysis to support business decisions
Who This Is For
- SQL Server administrators looking to enhance their project skills
- Database professionals seeking hands-on T-SQL experience
- IT professionals who've completed foundational SQL Server courses
Key Benefits
- Practical, project-based learning with real-world applications
- Enhanced T-SQL scripting and automation capabilities
- Deeper understanding of database design principles
Curriculum Highlights
- SQL Project Design and Development
- T-SQL Scripting and Automation
- Data Analysis for Business Decisions
Focused display
Category
- language english
- Training sessions 44
- duration 6:00:51
- Release Date 2025/04/15
