Implementing a Data Warehouse with Microsoft SQL Server 2012 (Exam 70-463)
by Mark Long
Start the free chapterBusiness data analysis becomes more important as the amount of data involved in the analysis grows. This data is in various database management products, spreadsheets, and documents. A data warehouse collects needed data and organizes the data in a form that solves the complexities and performance issues that line-of-business applications present. In this VTC course, author Mark Long walks you through the information you need to get prepared to take Microsoft\'s 70-463 certification exam: Implementing a Data Warehouse with Microsoft SQL Server 2012. This exam is part of Microsoft\'s MCSA: SQL Server Certification. To begin learning today, simply click on the movie links.
Course content
Welcome7 lessons
Getting Set Up12 lessons
- System Hardware Requirements4:191 credit or ad
- System Software Requirements3:321 credit or ad
- Getting the Software4:091 credit or ad
- Installing SQL Server 2012 pt. 15:521 credit or ad
- Installing SQL Server 2012 pt. 26:011 credit or ad
- Installing SQL Server 2012 pt. 34:101 credit or ad
- Verifying the Installation3:561 credit or ad
- Attaching the Sample Database pt. 12:551 credit or ad
- Attaching the Sample Database pt. 24:001 credit or ad
- Exploring the Sample Database4:531 credit or ad
- Downloading Books Online4:241 credit or ad
- TechNet and MSDN4:251 credit or ad
Data Warehouse Basics8 lessons
- Data Usage Challenges4:181 credit or ad
- Understanding Normalization4:201 credit or ad
- Normalized Structure Challenges5:321 credit or ad
- Star Schema Basics4:311 credit or ad
- Snowflake Schema Basics5:371 credit or ad
- Understanding Granularity4:271 credit or ad
- Auditing and Lineage5:081 credit or ad
- Simple DW Example6:181 credit or ad
Creating a Data Warehouse21 lessons
- Understanding Fact Tables2:521 credit or ad
- Understanding Dimensions pt. 16:211 credit or ad
- Understanding Dimensions pt. 23:471 credit or ad
- Dimension Column Types5:151 credit or ad
- Understanding SCDs pt. 15:301 credit or ad
- Understanding SCDs pt. 26:241 credit or ad
- Understanding SCDs pt. 35:371 credit or ad
- Creating Our DW Database5:111 credit or ad
- Identifying Our Dimensions3:161 credit or ad
- Identifying Our Fact Table3:131 credit or ad
- Understanding Indexes6:281 credit or ad
- Indexing the Data Warehouse4:591 credit or ad
- Understanding Indexed Views4:301 credit or ad
- Creating an Indexed View6:321 credit or ad
- Understanding Data Compression5:281 credit or ad
- Using Partitions6:151 credit or ad
- Data Lineage pt. 14:401 credit or ad
- Data Lineage pt. 24:591 credit or ad
- Creating Our Dimensions5:521 credit or ad
- Creating Our Fact Table1:551 credit or ad
- Creating Our Relationships5:391 credit or ad
Data Flow Using SSIS19 lessons
- SSIS Basics6:041 credit or ad
- Getting SQL Server Data Tools5:421 credit or ad
- Getting Visual Studio6:351 credit or ad
- Using the Import Export Wizard5:231 credit or ad
- SSIS Development Overview5:461 credit or ad
- Data Movement Planning3:561 credit or ad
- Simple SSIS Example pt. 16:091 credit or ad
- Simple SSIS Example pt. 25:481 credit or ad
- Using Connection Managers6:421 credit or ad
- Data and Control Flow4:011 credit or ad
- Understanding Containers6:431 credit or ad
- Understanding Groups4:421 credit or ad
- Data Conversion Task5:021 credit or ad
- Customer Dimension Load Considerations4:031 credit or ad
- Loading the Customer Dimension pt. 16:501 credit or ad
- Loading the Customer Dimension pt. 26:101 credit or ad
- Loading the Customer Dimension pt. 36:071 credit or ad
- Loading the FactInternetSales Table pt. 16:161 credit or ad
- Loading the FactInternetSales Table pt. 26:151 credit or ad
Design and Implement Data Flow4 lessons
Advanced Control Flow10 lessons
- Using Variables pt. 15:591 credit or ad
- Using Variables pt. 24:191 credit or ad
- Understanding Variable Scope3:201 credit or ad
- Property Parameterization pt. 16:111 credit or ad
- Property Parameterization pt. 24:331 credit or ad
- Parameters vs. Variables3:141 credit or ad
- Understanding Expressions pt. 15:321 credit or ad
- Understanding Expressions pt. 26:231 credit or ad
- Package and Task Transactions pt. 16:201 credit or ad
- Package and Task Transactions pt. 26:121 credit or ad