SQL SERVER ADMINISTRATION PART 4: PROJECTS

Focused View

Raphael Asghar

6:00:51

0 View

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

Description

SQL SERVER PROJECTS

What You'll Learn?

Students will learn how to design and develop SQL projects from the ground up, gaining hands-on experience in creating database schemas
The course will focus on scripting SQL projects, teaching students how to automate processes and enhance functionality through T-SQL.
Students will explore the objectives behind various SQL projects, understanding how data manipulation and analysis contribute to business decision-making
Through structured exercises and projects, students will deepen their understanding of T-SQL, enhancing their ability to write robust queries

Who is this for?

This course is designed with the understanding that the student has good knowledge in Learn T-SQL and SQL Server Administration part 1 course at minimum

What You Need to Know?

The prerequisites are that the student has taken Learn T-SQL and SQL Server Administration part 1 courses

SQL server 2022 and access to Excel application

More details

Description
In the SQL Server Administration Part 4 Projects course, students will engage in hands-on projects that reinforce their learning and application of SQL Server management concepts. These projects will involve creating databases, defining tables and columns, defining datatypes and lengths and writing queries to interact with the database effectively. Students will learn to insert data, use Excel worksheets as data sources, and prepare data for upper management by creating graphs and charts for effective data visualization. SQL scripts will be employed to manage databases, implement security measures, and optimize performance. Moreover, students will have the opportunity to collaborate with their peers, sharing insights and troubleshooting challenges together, which mirrors real-world database administration scenarios.
A key focus of the course will be on performance optimization techniques. Students will learn why shrinking a database is generally not recommended, as it can lead to fragmentation and adversely affect performance. They will explore effective strategies for managing fragmentation of indexes and data, including regular maintenance tasks like rebuilding and reorganizing indexes to ensure efficient query performance. To succeed in this course, a solid understanding of T-SQL and completion of SQL Administration Part 1 are essential, as these foundational skills are crucial for tackling more advanced topics.
Who this course is for:
This course is designed with the understanding that the student has good knowledge in Learn T-SQL and SQL Server Administration part 1 course at minimum

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Raphael Asghar

Instructor's Courses

Worked as a Production SQL Database Administrator and developer for over 15 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA. I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.