SKU: sql-mega-bundle Categories: ,

Microsoft Sql Server Mega Training Series

$199.00

Microsoft has long been a leader in database technology and they continue to be a dominant choice among many companies and users alike.  This extensive training series covers Microsoft SQL Server versions 2012 through 2019, all of which are still widely in use today. In this training series, you will explore SQL Server administration, database design, analysis services, reporting services, PowerBI, and more.

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
Microsoft Sql Server Mega Training Series

The ultimate in training for Microsoft SQL Server is included in this comprehensive mega SQL bundle.