Online
Can be taken anytime
Professional Training Course
Yes (Details)
English
$376
Course Overview
Microsoft 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012
Expand and prove your ability to work with Microsoft SQL Server 2012 with our engaging, tutor-led course.
Microsoft Implementing a Data Warehouse with SQL Server 2012 70-463 exam is part three of a three part series of courses to validate your skills and knowledge essential to implement a Data Warehouse with Microsoft SQL Server 2012.
Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012
What will I learn?
- Designing and implementing dimensions
- Designing and implementing fact tables
- Defining connection managers
- Designing and implementing data flow
- Managing SSIS package execution
- Implementing script tasks in SSIS
- Designing and implementing control flow
- Implementing package logic using SSIS variables and parameters
- Implementing data load options
- Implementing script components in SSIS
- Troubleshooting data integration issues
- Installing and maintaining SSIS components
- Implementing auditing, logging, and event handling
- Deploying SSIS solutions
- Configuring SSIS security settings
- Installing and maintaining Data Quality Services
- Implementing master data management solutions
- Creating a data quality project to clean data
What do I Get?
- Expert Instructor led training delivered via video streaming
- Extensive Demonstrations and presentations delivered in a multimedia format
- Practice Tests and full exam simulators
- Unlimited access to the course for 1 year
Who should take this course
Anyone interested to learn this course.
Accreditation
Implementing a Data Warehouse with Microsoft SQL Server 2012, Accredited by Microsoft
Course content
Course Outline
- Module 1 - Introduction to Data Warehousing
- Module 2 - Designing a Data Warehouse
- Module 3 - ETL with SSIS
- Module 4 - SSIS Control Flow
- Module 5 - Troubleshooting Packages
- Module 6 - Advanced Packages
- Module 7 - Data Quality Services
- Module 8 - Master Data Services
- Module 9 - Deployment and Security
About Course Provider
Located in Sittingbourne, Kent in the United Kingdom, ITonlinelearning was founded by Jeremy Dargie in 2009. Our aim is to help both aspiring and seasoned professionals gain internationally recognised, accredited certifications that enable them to begin and develop their careers and develop into sought after and well-versed professionals.
We are able to tailor your courses to your specific needs, giving you the opportunity to study courses on offer from world-leading companies such as Microsoft, Cisco, CompTIA, PRINCE2, Adobe, NEBOSH and CIW, to name but a few. These certifications will help you, like thousands others, reach your certification goals and beyond, ensuring that you develop your chosen career into a lucrative and rewarding profession.