Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL SERVER ADMINISTRATION PART 4: PROJECTS
Rating: 4.9 out of 5(5 ratings)
115 students

SQL SERVER ADMINISTRATION PART 4: PROJECTS

SQL SERVER PROJECTS
Created byRaphael Asghar
Last updated 1/2025
English

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

Course content

1 section • 43 lectures • 5h 53m total length

  • AN INTRO TO THE COURSE6:49
  • INSTALLING SQL SERVER8:50
  • INSTALL ADVENTUREWORKS3:05
  • INSTALLING VISUAL STUDIO6:06
  • VERIFY SSRS AND SSIS EXTENSION2:41

    Verify ssrs and ssis access by opening visual studio, creating a new ssrs reporting project, connecting to adventureworks 2022, testing the connection, and previewing a sample query.

  • LEARNING OBJECTIVES3:52
  • LIBRARY SCRIPT'S PART 113:37
  • LIBRARY SCRIPT'S PART 222:24
  • ONLINE SCRIPTS PART 114:01
  • ONLINE SCRIPTS PART 212:40

    Learn cleaner sql insert syntax using insert into products values, avoiding repeated column names. Explore joins across products and orders to compute total sales with group by and having.

  • MOVIES SCRIPTS9:29
  • QUIZ 13:22

    Test your knowledge in the first quiz of sql server administration part four, covering creating databases and tables, inserting data, and joins to identify negative balances.

  • QUIZ 1 ANSWER9:11
  • MULTIPLE DATABASES14:23
  • DELETE OLD DBS9:53
  • SSRS REPORT DROP DOWN14:43
  • SOLVING PROBLEMS6:14

    Develop problem solving as a DBA by resolving the missing SQL Server Native Client 11.0 driver and validating fixes with Visual Studio for SSIS.

  • CREATING A SSIS PACKAGE AND SETTING UP A JOB15:09
  • SETTING UP A JOB FOR SSIS4:34

    Set up a SQL Server Agent job to run an SSIS package that imports Excel data into a SQL table, using truncate to prevent duplicates, with a scheduled run.

  • SHRINK OR NOT TO SHRINK A DATABASE PART 113:03

    Assess when to shrink a database, weighing free space and unused space against fragmentation (internal and external), and follow best practices: backups and off-peak downtime.

  • SHRINK OR NOT TO SHRINK A DATABASE PART 211:37

    Learn to assess database size and fragmentation, perform shrink operations, back up before changes, and apply index maintenance: reorganize, rebuild, and update statistics for space and performance.

  • EXECUTING A JOB WITH A STORED PROCEDURE FOR FRAGMENTATION17:48
  • CREATING A TRIGGER FOR AUDITING10:23
  • BRIEF INTRO TO JOINS5:21

    Explore the four primary SQL joins—inner, left, right, and full outer—through a hands-on demo with employees and department tables, illustrating matching on IDs and nulls for nonmatches.

  • QUESTIONS ABOUT BEER WITHOUT SCRIPTS PART 112:39
  • QUESTIONS ABOUT BEER WITHOUT SCRIPTS PART 25:39
  • QUESTIONS ABOUT BEER WITHOUT SCRIPTS PART 36:51
  • QUESTIONS ABOUT BEER WITHOUT SCRIPTS PART 44:22
  • QUESTIONS ABOUT BEER WITHOUT SCRIPTS PART 53:33
  • QUIZ 21:45
  • QUIZ 2 ANSWERS PART 14:03

    Learn to write a SQL query listing product names with their city and state using aliases p, c, and s, joining products, cities, and states on city_id and state_id.

  • QUIZ 2 ANSWERS PART 22:21
  • QUIZ 2 ANSWERS PART 33:41
  • QUIZ 2 ANSWERS PART 41:29
  • HOSPITAL SYSTEM PART 19:41

    Build and query a hospital SQL database by creating patient, doctor, and appointment tables, joining data to view May 2024 appointments, and updating a doctor’s specialty with a where clause.

  • HOSPITAL SYSTEM PART 26:17

    Learn to query a hospital database by retrieving doctors' names and patient counts using the count function, inner and right outer joins, group by, then delete with a where clause.

  • TRAVEL SYSTEM QUERY PART 111:06
  • TRAVEL SYSTEM QUERY PART 24:18

    Learn to extract the month from booking date and compute total revenue per month for 2024 by joining bookings with destinations and aggregating revenue.

  • TRAVEL SYSTEM QUERY PART 34:11

    Explore how to use a case statement for conditional logic in SQL to categorize destinations by price into budget, mid-range, and luxury, based on defined price ranges.

  • TRAVEL SYSTEM QUERY PART 42:12
  • QUIZ 3 ANSWERS9:01

    This quiz walkthrough guides you to create a school database, build students and courses tables with a foreign key, insert data, and apply case statement with a join and aliases.

  • ADVENTUREWORKS2022 PRODUCTS PROJECTIONS9:41
  • PREPARATION AND INTERVIEW QUESTIONS11:54

Requirements

  • 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

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

Report abuse