Students will learn how to :
- Deploy and Configure SSIS packages.
- Download and installing SQL Server 2014
- Download and attaching Adventureworks2014 database
- Download and installing SSDT
- Download and installing Visual studio
- Describe data warehouse concepts and architecture considerations.
- Select an appropriate hardware platform for a data warehouse.
- Design and implement a data warehouse.
- Implement Data Flow in an SSIS Package.
- Implement Control Flow in an SSIS Package.
- Debug and Troubleshoot SSIS packages.
- Implement an ETL solution that supports incremental data extraction.
- Implement an ETL solution that supports incremental data loading.
- Implement data cleansing by using Microsoft Data Quality Services.
- Implement Master Data Services to enforce data integrity.
- Extend SSIS with custom scripts and components.
- Databases vs. Data warehouses
- Choose between star and snowflake design schemas
- Explore source data
- Implement data flow
- Debug an SSIS package
- Extract and load modified data
- Enforce data quality
- Consume data in a data warehouse
After completing this course you will be able to :
- Understand the components of a data warehousing solution
- Implement a logical and physical design to create a data warehouse
- Implement a physical design for a data warehouse
- Understand SSIS for implementing data flows
- Create dynamic packages using parameters and variables
- Implement Data Quality Services and Master Data Services
Implement custom components for extending SSIS
Who this course is for:
- Beginner DBA
- Beginner Data Analyst
- Beginners to Data Warehouse
- Beginners to SSIS
Can I download Introduction to Data Warehouse and SSIS for Beginners course?
You can download videos for offline viewing in the Android/iOS app. When course instructors enable the downloading feature for lectures of the course, then it can be downloaded for offline viewing on a desktop.Can I get a certificate after completing the course?
Yes, upon successful completion of the course, learners will get the course e-Certification from the course provider. The Introduction to Data Warehouse and SSIS for Beginners course certification is a proof that you completed and passed the course. You can download it, attach it to your resume, share it through social media.Are there any other coupons available for this course?
You can check out for more Udemy coupons @ www.coursecouponclub.com
Note: 100% OFF Udemy coupon codes are valid for maximum 3 days only. Look for "ENROLL NOW" button at the end of the post.
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.