SSIS Database Maintenance Playbook from Pluralsight

Database maintenance is an inescapable part of a database administrator's life. This course teaches you how to use SQL Server Integration Services (SSIS) to automate that work and save time.

Every database administrator needs to have a database maintenance plan, whether they're looking after one database or 1000s of servers. Those plans can be split into regular, scheduled maintenance and on-demand operations for unscheduled requirements.

In this tutorial,

, you'll learn how to use the power of SQL Server Integration Services to get the job done and explore many related operations that will save you from searching for solutions or writing your own from scratch.

, you'll discover how to plan a maintenance schedule and the pillars that support that work.

, you'll delve into the operations that you can use for work that come up less frequently, but still need to be done efficiently and correctly.

, you'll explore how to parameterize these operations as well as powerful methods for run-time control.

When you're finished with this SSIS tutorial, you'll have a great tool set that will save you time and get your database maintenance on a solid footing.

What's inside

Syllabus

Course Overview

Introduction

Basic Database Maintenance with SSIS

Performing Other Database Maintenance Tasks

Course Summary

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Teaches database maintenance skills and best practices, which are standard in industry

Taught by Gerald Britton, recognized for their work in SQL Server and database administration

Develops database maintenance skills and expertise for SQL Server administrators

Covers a comprehensive range of database maintenance tasks, providing a strong foundation for learners

Teaches essential database maintenance concepts and skills

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in SSIS Database Maintenance Playbook with these activities:

Follow online tutorials on SSIS

Show steps

Supplement your learning with interactive tutorials that provide step-by-step guidance on specific SSIS techniques.

Show steps

Identify a specific SSIS concept or task you want to learn.
Search for and select a reputable online tutorial that covers the topic.
Follow the tutorial instructions carefully and complete the exercises or examples.

Practice writing SSIS packages

Show steps

Reinforce your understanding of SSIS concepts and syntax by writing practice packages.

Show steps

Identify a simple database maintenance task.
Design and implement an SSIS package to perform the task.
Test and refine your package to ensure it runs efficiently and error-free.

Participate in peer study groups

Show steps

Engage with fellow learners to discuss SSIS concepts, share knowledge, and reinforce your understanding.

Show steps

Find or form a study group with individuals who share similar interests or skill levels.
Establish regular meeting times to discuss course materials, work on projects, and provide mutual support.
Actively participate in discussions, ask questions, and contribute your own insights.

Two other activities

Expand to see all activities and additional details

Show all five activities

Contribute to online SSIS forums

Show steps

Engage with the broader SSIS community by answering questions, sharing solutions, and contributing to ongoing discussions.

Show steps

Join online SSIS forums or communities.
Actively participate in discussions by providing helpful answers and sharing your knowledge.
Contribute to the community by posting questions, sharing resources, or writing articles.

Create an SSIS package for a real-world project

Show steps

Apply your SSIS skills to a practical project, solidifying your understanding and building a valuable portfolio piece.

Show steps

Identify a business need or problem that can be solved using SSIS.
Design and develop an SSIS package to address the need or solve the problem.
Deploy and maintain the SSIS package in a production environment.

Career center

Learners who complete SSIS Database Maintenance Playbook will develop knowledge and skills that may be useful to these careers:

Database Administrator

A Database Administrator is a skilled professional who ensures that an organization's databases are operating at peak performance. They implement and maintain database systems, ensuring data integrity and security, and they may also be responsible for developing and implementing database maintenance plans. This course can help you become a Database Administrator by teaching you how to use SQL Server Integration Services (SSIS) to automate database maintenance tasks. By learning how to use SSIS, you'll be able to save time and improve the efficiency of your database maintenance work.

See salaries and explore the career path for Database Administrator

Data Analyst

A Data Analyst collects, analyzes, and interprets data to help businesses make informed decisions. They use their skills in data mining, statistics, and programming to identify trends and patterns in data. This course can help you become a Data Analyst by teaching you how to use SSIS to automate the process of gathering and analyzing data. By learning how to use SSIS, you'll be able to save time and improve the accuracy of your data analysis work.

See salaries and explore the career path for Data Analyst

Business Intelligence Analyst

A Business Intelligence Analyst uses data to help businesses make better decisions. They use their skills in data analysis, visualization, and reporting to identify opportunities and risks. This course can help you become a Business Intelligence Analyst by teaching you how to use SSIS to automate the process of gathering, analyzing, and visualizing data. By learning how to use SSIS, you'll be able to save time and improve the quality of your business intelligence work.

See salaries and explore the career path for Business Intelligence Analyst

Data Scientist

A Data Scientist uses data to solve business problems. They use their skills in machine learning, artificial intelligence, and statistics to develop models that can predict future trends and identify new opportunities. This course can help you become a Data Scientist by teaching you how to use SSIS to automate the process of gathering, analyzing, and modeling data. By learning how to use SSIS, you'll be able to save time and improve the accuracy of your data science work.

See salaries and explore the career path for Data Scientist

Software Engineer

A Software Engineer designs, develops, and maintains software applications. They use their skills in programming, software architecture, and testing to create high-quality software that meets the needs of users. This course can help you become a Software Engineer by teaching you how to use SSIS to automate the process of testing and deploying software applications. By learning how to use SSIS, you'll be able to save time and improve the quality of your software engineering work.

See salaries and explore the career path for Software Engineer

Systems Administrator

A Systems Administrator manages and maintains computer systems and networks. They use their skills in hardware, software, and networking to ensure that systems are running smoothly and securely. This course can help you become a Systems Administrator by teaching you how to use SSIS to automate the process of managing and maintaining computer systems and networks. By learning how to use SSIS, you'll be able to save time and improve the efficiency of your systems administration work.

See salaries and explore the career path for Systems Administrator

Database Developer

A Database Developer designs, develops, and maintains databases. They use their skills in database design, SQL, and programming to create databases that meet the needs of users. This course can help you become a Database Developer by teaching you how to use SSIS to automate the process of designing, developing, and maintaining databases. By learning how to use SSIS, you'll be able to save time and improve the quality of your database development work.

See salaries and explore the career path for Database Developer

Data Engineer

A Data Engineer builds and maintains the infrastructure that supports data analysis and data science. They use their skills in data engineering, cloud computing, and big data to create scalable and reliable data pipelines. This course can help you become a Data Engineer by teaching you how to use SSIS to automate the process of building and maintaining data pipelines. By learning how to use SSIS, you'll be able to save time and improve the efficiency of your data engineering work.

See salaries and explore the career path for Data Engineer

Cloud Engineer

A Cloud Engineer designs, develops, and manages cloud computing systems. They use their skills in cloud computing, DevOps, and infrastructure as code to create cloud-based solutions that meet the needs of users. This course can help you become a Cloud Engineer by teaching you how to use SSIS to automate the process of designing, developing, and managing cloud computing systems. By learning how to use SSIS, you'll be able to save time and improve the efficiency of your cloud engineering work.

See salaries and explore the career path for Cloud Engineer

DevOps Engineer

A DevOps Engineer combines the skills of a software engineer and a systems administrator. They use their skills in software development, systems administration, and automation to create and maintain software systems that are reliable, scalable, and secure. This course can help you become a DevOps Engineer by teaching you how to use SSIS to automate the process of building, deploying, and maintaining software systems. By learning how to use SSIS, you'll be able to save time and improve the efficiency of your DevOps engineering work.

See salaries and explore the career path for DevOps Engineer

IT Manager

An IT Manager plans, directs, and coordinates the activities of an organization's IT department. They use their skills in IT management, leadership, and communication to ensure that the IT department is meeting the needs of the organization. This course can help you become an IT Manager by teaching you how to use SSIS to automate the process of managing an IT department. By learning how to use SSIS, you'll be able to save time and improve the efficiency of your IT management work.

See salaries and explore the career path for IT Manager

Chief Information Officer (CIO)

A Chief Information Officer (CIO) is responsible for the overall IT strategy and operations of an organization. They use their skills in IT leadership, business strategy, and technology to ensure that the organization's IT systems are aligned with the organization's business goals. This course can help you become a CIO by teaching you how to use SSIS to automate the process of managing an organization's IT systems. By learning how to use SSIS, you'll be able to save time and improve the efficiency of your CIO work.

See salaries and explore the career path for Chief Information Officer (CIO)

Chief Technology Officer (CTO)

A Chief Technology Officer (CTO) is responsible for the overall technology strategy and operations of an organization. They use their skills in technology leadership, business strategy, and innovation to ensure that the organization's technology systems are aligned with the organization's business goals. This course can help you become a CTO by teaching you how to use SSIS to automate the process of managing an organization's technology systems. By learning how to use SSIS, you'll be able to save time and improve the efficiency of your CTO work.

See salaries and explore the career path for Chief Technology Officer (CTO)

Data Architect

A Data Architect designs and manages the architecture of an organization's data systems. They use their skills in data architecture, data modeling, and data integration to create data systems that meet the needs of the organization. This course may be useful for you if you want to become a Data Architect, as it can help you learn how to use SSIS to automate the process of designing and managing data systems.

See salaries and explore the career path for Data Architect

Systems Analyst

A Systems Analyst analyzes and designs business systems. They use their skills in systems analysis, business process modeling, and technology to create systems that meet the needs of the organization. This course may be useful for you if you want to become a Systems Analyst, as it can help you learn how to use SSIS to automate the process of analyzing and designing business systems.

See salaries and explore the career path for Systems Analyst