SKU: sql-oracle-power-bundle Category:

Microsoft & Oracle Database SQL Power Bundle

$1,089.00

Databases power in today's businesses is critical. With a heavy emphasis on database security, maintenance, design, and efficiency, they are critical in housing the data, which is one of the most valuable assets for any company. This 11-course bundle provides students with an incredible set of information required to help manage and effectively use data in both Microsoft SQL Server and Oracle databases. This bundle includes the following:

  • Microsoft 70-461: Querying SQL Server 2012
  • Microsoft 70-462: Administering SQL Server 2012 Databases
  • Microsoft 70-463: Implementing A Data Warehouse With SQL Server 2012
  • Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases
  • Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012
  • Microsoft 70-466: Implementing Data Models & Reports Server 2012
  • Microsoft 70-467: Designing Business Intelligence Solutions With SQL Server 2012
  • Oracle 12c OCP 1Z0-061: SQL Fundamentals
  • Oracle 12c OCP 1Z0-062: Installation and Administration
  • Oracle 11g Certiified Associate (OCA) - Fundamentals 1Z0-051 And Admin 1Z0-052

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 & Oracle Database SQL Power Bundle

This 11-course bundle provides students with an incredible set of information required to help manage and access data in SQL Server and Oracle databases.


Save For Later
Add to Wishlist