SQL Server Administration: (SQL Server Integration Services)
Master SSIS data migration! Build powerful packages to move data between systems. Learn ETL techniques for efficient data transfer.
Course Content
SQL Server Administration: (SQL Server Integration Services) is a beginner-level Udemy course taught by Raphael Asghar. It runs 5h 39m, is taught in English, and includes a certificate of completion. Learners rate it 4.4 out of 5 from 1,166 reviews, with 6,611 students enrolled. It is a paid course, last updated August 2018.
Learn to build robust SQL Server Integration Services (SSIS) packages for efficient data migration! This course empowers you to extract, transform, and load (ETL) data from a wide range of heterogeneous data sources into a centralized location. You'll master the creation of SSIS packages to seamlessly move data to various destinations.
This training covers essential data transformation tasks, including:
- Data Conversion: Manipulating data types for compatibility.
- Term Extraction: Pulling specific information from data.
- Migration to Flat Files: Exporting data into common file formats.
- Working with various database sources (e.g., Oracle, MySQL, etc.)
- Connecting to various database destinations.
- Automating FTP site tasks for data transfer.
- Utilizing the Foreach Loop Container to process multiple files from source to destination.
Prerequisites: A strong foundation in SQL Server Administration is highly recommended. We strongly suggest completing SQL Administration Part 1, 2, and 3, as well as Learn T-SQL and SSRS courses before enrolling. This course is not suitable for those new to SQL Server Administration.
Upon completion, you'll gain the in-demand skills that recruiters actively seek for SQL Server Administration jobs. Become proficient in SSIS development and boost your career prospects!
Hire the developers behind TutorialSearch.io
We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.