SKU: mastering-sql-certification-series-365 Categories: ,

Mastering SQL Certification Series

$999.00

Get the Business Intelligence Skills to Deliver Breakthrough Insights with SQL Server. Prove your knowledge and skills in designing, building, and maintaining the next wave of cloud-ready database and information solutions. Mastering SQL certifications series covers the essential skills needed for administering and developing database solutions and for leveraging business intelligence (BI) tools. Whether your focus is SQL Server administration, programming or business intelligence and reporting, we help you to prepare for your SQL certification exam through these series of courses.

Course Outline

Lesson 1: Introduction to Data Warehouse
  •  Introduction
  •  Introduction To Data Warehouse-Part1
  •  Introduction To Data Warehouse-Part2
  •  Introduction To Data Warehouse-Part3
  •  Introduction To Data Warehouse-Part4
  •  Introduction To Data Warehouse-Part5
  •  Introduction To Data Warehouse-Part6
Lesson 2: Creating Dimensions and Changing Granularity of Dimensions
  •  Creating Dimensions And Changing Granularity Of Dimensions-Part1
  •  Creating Dimensions And Changing Granularity Of Dimensions-Part2
  •  Creating Dimensions And Changing Granularity Of Dimensions-Part3
  •  Creating Dimensions And Changing Granularity Of Dimensions-Part4
  •  Creating Dimensions And Changing Granularity Of Dimensions-Part5
  •  Creating Dimensions And Changing Granularity Of Dimensions-Part6
Lesson 3: Creating Fact Tables and ColumnStore Indexes
  •  Creating Fact Tables And Column Store Indexes-Part1
  •  Creating Fact Tables And Column Store Indexes-Part2
  •  Creating Fact Tables And Column Store Indexes-Part3
  •  Creating Fact Tables And Column Store Indexes-Part4
  •  Creating Fact Tables And Column Store Indexes-Part5
Lesson 4: Implementing Data Warehouse in SQL Server 2012
  •  Implementing Data Warehouse-Part1
  •  Implementing Data Warehouse-Part2
  •  Implementing Data Warehouse-Part3
  •  Implementing Data Warehouse-Part4
Lesson 5: Working with Integration Services
  •  Working With Integration Services-Part1
  •  Working With Integration Services-Part2
  •  Working With Integration Services-Part3
  •  Working With Integration Services-Part4
  •  Working With Integration Services-Part5
  •  Working With Integration Services-Part6
Lesson 6: Managing Control Flow
  •  Managing Control Flow-Part1
  •  Managing Control Flow-Part2
  •  Managing Control Flow-Part3
  •  Managing Control Flow-Part4
  •  Managing Control Flow-Part5
Lesson 7: Working with Dynamic Variables
  •  Working With Dynamic Variables-Part1
  •  Working With Dynamic Variables-Part2
  •  Working With Dynamic Variables-Part3
  •  Working With Dynamic Variables-Part4
  •  Working With Dynamic Variables-Part5
  •  Working With Dynamic Variables-Part6
  •  Working With Dynamic Variables-Part7
  •  Working With Dynamic Variables-Part8
Lesson 8: Implementing Data Flow
  •  Implementing DataFlow-Part1
  •  Implementing DataFlow-Part2
  •  Implementing DataFlow-Part3
  •  Implementing DataFlow-Part4
  •  Implementing DataFlow-Part5
  •  Implementing DataFlow-Part6
  •  Implementing DataFlow-Part7
  •  Implementing DataFlow-Part8
Lesson 9: Managing Data Flow
  •  Managing DataFlow-Part1
  •  Managing DataFlow-Part2
  •  Managing DataFlow-Part3
  •  Managing DataFlow-Part4
Lesson 10: Managing SSIS Package Execution
  •  Managing SSIS Package Execution-Part1
  •  Managing SSIS Package Execution-Part2
  •  Managing SSIS Package Execution-Part3
  •  Managing SSIS Package Execution-Part4
  •  Managing SSIS Package Execution-Part5
  •  Managing SSIS Package Execution-Part6
Lesson 11: Debugging and Troubleshooting
  •  Debugging And Troubleshooting-Part1
  •  Debugging And Troubleshooting-Part2
  •  Debugging And Troubleshooting-Part3
  •  Debugging And Troubleshooting-Part4
Lesson 12: Deploying Packages
  •  Deploying Packages-Part1
  •  Deploying Packages-Part2
  •  Deploying Packages-Part3
Lesson 13: Securing Packages and Databases
  •  Securing Packages And Databases-Part1
  •  Securing Packages And Databases-Part2
Lesson 14: Working with MDS and Windows
  •  Working With MDS And Windows Azure
Mastering SQL Certification Series

Save For Later
Add to Wishlist