We may earn an affiliate commission when you visit our partners.
Mastering ETL
Data Cleansing with SQL Server Integration Services
Ana Voicu
Ana Voicu
The integrity of the data used for analysis is a major step in any data-related project. This course will teach you how to develop SQL Server Integration Services (SSIS) packages, used for data cleansing activities, to ensure data integrity.
Read more
The integrity of the data used for analysis is a major step in any data-related project. This course will teach you how to develop SQL Server Integration Services (SSIS) packages, used for data cleansing activities, to ensure data integrity.
Read more
The integrity of the data used for analysis is a major step in any data-related project. This course will teach you how to develop SQL Server Integration Services (SSIS) packages, used for data cleansing activities, to ensure data integrity.
Data cleansing is a major part of every project that uses data to create information.
In this course, Mastering ETL: Data Cleansing Techniques for SQL Server Databases, you’ll gain the ability to create SQL Server Integration Services (SSIS) packages specifically tailored for data cleansing tasks.
First, you’ll explore how to integrate data coming from different sources and identify possible data cleansing tasks, like handling duplicate data, dealing with missing values (delete, ignore, or fill-in data), fixing up formats, and correcting errors.
Next, you’ll discover several ways in which SSIS packages can help you clean your data, using derived columns, fuzzy grouping / fuzzy lookup, and data conversions.
Finally, you’ll learn techniques to maintain and verify data integrity after the cleansing process in SSIS.
When you’re finished with this course, you’ll have the skills and knowledge of various data cleansing techniques, performed in SSIS, needed to ensure the integrity of your data.
Register for this course and see more details by visiting:
OpenCourser.com/course/21f5kn/mastering
What's inside
Syllabus
Course Overview
Load and Cleanse Data with SSIS Packages
Handle Complex Data Transformations in SSIS
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Provides a solid foundation by teaching SSIS packages, a core skill for cleansing data
Ideal for learners seeking to ensure data integrity, as it teaches techniques for handling errors and missing values
Save this course
Save Mastering ETL: Data Cleansing with SQL Server Integration Services to your list so you can find it easily later:
Save
Save
Activities
Coming soon
We're preparing activities for
Mastering ETL: Data Cleansing with SQL Server Integration Services.
These are activities you can do either before, during, or after a course.
Career center
Learners who complete Mastering ETL: Data Cleansing with SQL Server Integration Services will develop knowledge and skills
that may be useful to these careers:
Data Integration Specialist
Data Integration Specialist
A Data Integration Specialist is an IT professional who specializes in integrating data from multiple sources into a single, cohesive data warehouse. They use tools such as SSIS to extract, transform, and load data from source systems into the data warehouse. This course can help you build a strong foundation in SSIS, which is essential for success as a Data Integration Specialist.
ETL Developer
ETL Developer
An ETL Developer is an IT professional responsible for designing, developing, and maintaining data integration and transformation processes. They use tools such as SSIS to extract data from source systems, transform it, and load it into target systems. This course can help you build a strong foundation in SSIS, which is essential for success as an ETL Developer.
Data Analyst
Data Analyst
A Data Analyst is an IT professional responsible for analyzing data to extract meaningful insights. They use data visualization tools to present their findings to stakeholders. This course can help you build a foundation in SSIS, which is a valuable tool for data analysts who need to cleanse and transform data before analysis.
Data Engineer
Data Engineer
A Data Engineer is an IT professional responsible for designing, constructing, and maintaining data architectures, including databases and data warehouses. They also develop and maintain data integration and transformation processes, using tools such as SQL Server Integration Services (SSIS). This course can help you build a foundation in SSIS, which is essential for success as a Data Engineer.
Business Intelligence Analyst
Business Intelligence Analyst
A Business Intelligence Analyst is an IT professional responsible for providing data-driven insights to businesses. They use data analysis and visualization tools to help businesses make informed decisions. This course can help you build a foundation in SSIS, which is a valuable tool for business intelligence analysts who need to cleanse and transform data before analysis.
Database Administrator
Database Administrator
A Database Administrator is responsible for managing and maintaining databases. They ensure that databases are running smoothly and that data is protected. This course can help you build a foundation in SSIS, which can be useful for database administrators who need to cleanse and transform data before loading it into a database.
Data Scientist
Data Scientist
A Data Scientist is responsible for using data to solve business problems. They use data analysis and machine learning techniques to extract insights from data. This course can help you build a foundation in SSIS, which may be useful for data scientists who need to cleanse and transform data before analysis.
Software Engineer
Software Engineer
A Software Engineer is responsible for designing, developing, and maintaining software applications. They may use tools such as SSIS to integrate data from multiple sources into a single application. This course can help you build a foundation in SSIS, which may be useful for software engineers who need to work with data integration.
Information Systems Manager
Information Systems Manager
An Information Systems Manager is responsible for planning, implementing, and managing information systems. They may use tools such as SSIS to integrate data from multiple sources into a single system. This course can help you build a foundation in SSIS, which may be useful for information systems managers who need to work with data integration.
Business Analyst
Business Analyst
A Business Analyst is responsible for analyzing business processes and recommending improvements. They may use tools such as SSIS to integrate data from multiple sources into a single system. This course can help you build a foundation in SSIS, which may be useful for business analysts who need to work with data integration.
Database Designer
Database Designer
A Database Designer is responsible for designing and developing databases. They may use tools such as SSIS to integrate data from multiple sources into a single system. This course can help you build a foundation in SSIS, which may be useful for database designers who need to work with data integration.
Data Architect
Data Architect
A Data Architect is responsible for designing and developing data architectures. They may use tools such as SSIS to integrate data from multiple sources into a single system. This course can help you build a foundation in SSIS, which may be useful for data architects who need to work with data integration.
IT Manager
IT Manager
An IT Manager is responsible for planning, implementing, and managing IT systems. They may use tools such as SSIS to integrate data from multiple sources into a single system. This course can help you build a foundation in SSIS, which may be useful for IT managers who need to work with data integration.
Data Governance Analyst
Data Governance Analyst
A Data Governance Analyst is responsible for developing and implementing data governance policies and procedures. They may use tools such as SSIS to integrate data from multiple sources into a single system. This course can help you build a foundation in SSIS, which may be useful for data governance analysts who need to work with data integration.
Project Manager
Project Manager
A Project Manager is responsible for planning, executing, and closing projects. They may use tools such as SSIS to integrate data from multiple sources into a single system. This course can help you build a foundation in SSIS, which may be useful for project managers who need to work with data integration.
For more career information including salaries, visit:
OpenCourser.com/course/21f5kn/mastering
Reading list
We've selected nine books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Mastering ETL: Data Cleansing with SQL Server Integration Services.
Provides a comprehensive guide to database design for data warehousing. It valuable resource for those who want to learn more about database design and its role in data cleansing.
Provides a comprehensive overview of data governance, including information on how to use data governance to improve data quality. It valuable resource for those who want to learn more about data governance and its role in data cleansing.
Save
Serves as a comprehensive guide to data cleansing principles and best practices. It complements the course by providing a broader perspective on data cleansing beyond SSIS.
Focuses on data preparation techniques for data mining, including data cleansing. It provides practical guidance on how to handle common data quality issues.
Provides a comprehensive understanding of data warehousing concepts, including data modeling and data cleansing. It offers a theoretical foundation for the data cleansing practices covered in the course.
Explores data quality from a holistic perspective, encompassing data cleansing as a key component. It provides a broader understanding of the role of data cleansing in data governance.
Provides in-depth coverage of SSIS 2012, including advanced data cleansing techniques. While it may be geared towards an older version of SSIS, it offers valuable insights applicable to the topics covered in the course.
Provides a comprehensive overview of data warehousing, including data cleansing techniques. It valuable resource for those who want to learn more about data warehousing and its role in data cleansing.
Focuses on data cleaning using the R programming language. While it's not directly related to SSIS, it provides alternative insights and techniques for data cleansing, expanding the scope of the course.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/21f5kn/mastering
Share
Similar courses
Here are nine courses similar to
Mastering ETL: Data Cleansing with SQL Server Integration Services.
Designing SSIS Integration Solutions
OpenCourser.com/course/pjo9qy/designing
Designing SSIS Integration Solutions
Most relevant
Microsoft SQL Server Integration Services (SSIS) Training
OpenCourser.com/course/cfg6tq/microsoft
Microsoft SQL Server Integration Services (SSIS) Training
Most relevant
Mastering SQL Server 2016 Integration Services (SSIS)-Part 1
OpenCourser.com/course/a6c5a6/mastering
Mastering SQL Server 2016 Integration Services (SSIS)...
Most relevant
Automating Data Cleansing in SQL Server
OpenCourser.com/course/ebjnb9/automating
Automating Data Cleansing in SQL Server
Most relevant
Extracting and Transforming Data in SSIS
OpenCourser.com/course/0msa6d/extracting
Extracting and Transforming Data in SSIS
Most relevant
SQL Server Administration: (SQL Server Integration Services)
OpenCourser.com/course/bo4rtq/sql
SQL Server Administration: (SQL Server Integration...
Most relevant
Data Cleansing 101: SQL Server Essentials
OpenCourser.com/course/sgwlr7/data
Data Cleansing 101: SQL Server Essentials
Most relevant
Dimensional Modeling on the Microsoft SQL Server Platform
OpenCourser.com/course/8cewvf/dimensional
Dimensional Modeling on the Microsoft SQL Server Platform
Most relevant
Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW)
OpenCourser.com/course/m4fmto/become
Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL...
Most relevant
Time
32 hours
Level
Introductory
Via
Pluralsight
Instructor
Ana Voicu
Language
English
Good to know
Provides a solid foundation by teaching SSIS packages, a core skill for cleansing data
Ideal for learners seeking to ensure data integrity, as it teaches techniques for handling errors and missing values
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser