Microsoft & Oracle Database SQL Power Bundle - ITU Online

Microsoft & Oracle Database SQL Power Bundle

Databases are of paramount importance in today’s business world, their utility ranging from data security to efficient design and maintenance. This 11-course bundle is designed to offer students an unparalleled set of knowledge on how to manage and effectively use both Microsoft SQL Server and Oracle databases.

Included In This Course

IT Manager’s Survival Bundle Training Series – 10 Courses
136 Hrs 14 Min
Videos
610 On-demand Videos
Closed Captions

Closed Captions

Course Topics
134  Topics
Question & Answers
831 Prep Questions
Certificate of Completion

Certificate of Completion

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

Proudly Display
Your Achievement

Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Example Certificate

Oracle 12c OCP 1Z0-062: Installation and Administration Course Content

Module 1: Database Concepts And Tools

  •    Instructor And Course Introduction
  •    Database Concepts And Tools - Part 1
  •    Database Concepts And Tools - Part 2

Module 2: Memory Structure

  •    Memory Structure - Part 1
  •    Memory Structure - Part 2

Module 3: Tables

  •    Tables - Part 1
  •    Tables - Part 2

Module 4: Indexes

  •    Indexes - Part 1
  •    Indexes - Part 2

Module 5: Constraints And Triggers

  •    Constraints And Triggers - Part 1
  •    Constraints And Triggers - Part 2

Module 6: Users

  •    Users
  •    Profiles
  •    Privileges
  •    Roles

Module 7: Internal Structures

  •    Storage Structures - Part 1
  •    Storage Structures - Part 2
  •    Internal Memory Structures - Part 1
  •    Internal Memory Structures - Part 2
  •    Background Processes - Part 1
  •    Background Processes - Part 2

Module 8: Starting Up and Shutting Down Database

  •    Starting And Stopping DataBase - Part 1
  •    Starting And Stopping DataBase - Part 2

Module 9: Critical Storage Files

  •    Critical Storage Files - Part 1
  •    Critical Storage Files - Part 2

Module 10: Data Manipulation Language

  •    DML Atomicity - Part 1
  •    DML Atomicity - Part 2
  •    DML Insert
  •    DML Update - Part 1
  •    DML Update - Part 2
  •    DML Delete And Review Of DML Statements - Part 1
  •    DML Delete And Review Of DML Statements - Part 2

Module 11: Data Concurrency

  •    Data Concurrency - Part 1
  •    Data Concurrency - Part 2

Module 12: BackUp And Recovery

  •    Back Up - Part 1
  •    Back Up - Part 2
  •    Back Up - Part 3
  •    RMAN Catalog
  •    RMAN BackUps - Part 1
  •    RMAN BackUps - Part 2
  •    Disaster Preparedness
  •    Recovery
  •    Flashback Recovery

Module 13: Installation

  •    Installation - Part 1
  •    Installation - Part 2

Module 14: Course Review

  •    Course Review - Part 1
  •    Course Review - Part 2
  •    Course Review - Part 3
  •    Course Review - Part 4
  •    Course Review - Part 5
  •    Course Outro

Oracle 12c OCP 1Z0-061: SQL Fundamentals Course Content

Module 1: Introduction To Oracle 12c SQL Fundamentals

  •    Introduction
  •    Intro To Oracle 12c-SQL Fundamentals
  •    Structure Of SQL
  •    Basic Select Statements
  •    Basic Select Statements Demo

Module 2: Retrieving Data

  •    Modifying Reported Output
  •    The Where Clause
  •    The Order By Clause
  •    Left And Right Outer Joins
  •    The Where Clause Demo
  •    Multi-Table Selection Demo

Module 3: SQL Functions

  •    Single Row Functions
  •    Aggregate Functions
  •    Single Row Functions Demo
  •    Muiltrow Functions Demo
  •    Group By
  •    Grouping Demo
  •    Conversion Functions
  •    Conversion Functions Demo
  •    Datetime Functions
  •    Datetime Functions Demo

Module 4: Subqueries

  •    Single-Row Subqueries
  •    Single-Row Subqueries Demo
  •    Multi-Row Subqueries
  •    Multi-Row Subqueries Demo
  •    Other Subquery Types
  •    Other Subquery Types Demo

Module 5: Data Manipulation Language

  •    Adding Data
  •    Changing Data
  •    Deleting Data
  •    DML Demo

Module 6: Data Control Language

  •    Security
  •    Object Privileges
  •    DCL Demo

Module 7: Data Definition Language

  •    Creating Objects In The Database
  •    Creating Objects In The Database Demo
  •    Sequences
  •    Sequenced Demo
  •    Indexes
  •    Views

Module 8: Combining Queries

  •    Combining Queries

Module 9: Oracle 12C SQL Fundamentals Review

  •    Oracle 12c SQL Fundamentals Review - Part 1
  •    Oracle 12c SQL Fundamentals Review - Part 2
  •    Oracle 12c SQL Fundamentals Review - Part 3
  •    Conclusion

Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012 Course Content

Module 1: Intro To Business Intelligence

  •    Introduction
  •    The Business Intelligence Solution
  •    Overview Of Business Intelligence
  •    BI And Power Pivot Demo
  •    ETL Intro
  •    Designing Data Warehouses
  •    Design For Speed
  •    BI Semantic Model

Module 2: Database Essentials

  •    Basic Database Objects Demo
  •    Stored Procedures And Triggers Demo
  •    Database Clusters Demo
  •    SQL Server Management
  •    Table Triggers
  •    DB Config Options
  •    DB Backup
  •    DB Files And Restore

Module 3: Business Intelligence Development

  •    Using SQL Server Data Tools Demo
  •    Building An IS Integration Services Package Demo
  •    Loading Data From Remote Sources Demo

Module 4: Business Intelligence Results

  •    Report Building Intro Setup Demo
  •    Using Report Builder Demo
  •    Processing Data From Web Service Demo
  •    Reporting From Multiple Tables Demo
  •    Report Function And Matrix Demo
  •    Interactive Reports Demo
  •    Sorting Report Data Demo

Module 5: Advanced Reporting And Development

  •    Drill Through Reports
  •    Data Visualization
  •    Creating Store Procedure From Scratch
  •    Memory Optimize Table

Module 6: SQL Server Integration Services (SSIS)

  •    Building Our First Integration Project
  •    Data Transformation
  •    Introduction To Big Data
  •    Transformation Using Store Procedure
  •    Transformation Using SSIS
  •    Building Fact Table Using Store Procedure
  •    Building Fact Table Using SSIS

Module 7: SQL Server 2014 New Features

  •    Backup Enhancements
  •    Index Enhancements
  •    Online DB Enhancements
  •    BackUp To The Cloud
  •    Partition Data

Module 8: Course Review And Exam Prep

  •    BI Review
  •    SharePoint Overview
  •    SharePoint Demo
  •    Exam Prep
  •    Before You Take The Exam
  •    Conclusion

Microsoft 70-466: Implementing Data Models & Reports with SQL Server 2012 Course Content

Module 1: Introduction To Business Intelligence And Data Modeling

  •    Introduction To Business Intelligence and Data Modeling Part1
  •    Introduction To Business Intelligence and Data Modeling Part2
  •    The Microsoft Business Intelligence Platform Part 1
  •    The Microsoft Business Intelligence Platform Part 2
  •    The Microsoft Business Intelligence Platform Part 3
  •    The Microsoft Business Intelligence Platform Part 4

Module 2: Implementing Reports The SQL Server Reporting Services

  •    Implementing Reports the SQL Server Reporting Services Part 1
  •    Implementing Reports the SQL Server Reporting Services Part 2
  •    Implementing Reports the SQL Server Reporting Services Part 3
  •    Implementing Reports the SQL Server Reporting Services Part 4
  •    Implementing Reports the SQL Server Reporting Services Part 5
  •    Implementing Reports the SQL Server Reporting Services Part 6
  •    Implementing Reports the SQL Server Reporting Services Part 7
  •    Implementing Reports the SQL Server Reporting Services Part 8

Module 3: Supporting Self Service Reporting

  •    Supporting Self Service Reporting Part 1
  •    Supporting Self Service Reporting Part 2

Module 4: Managing Report Execution And Delivery

  •    Managing Report Execution And Delivery
  •    Managing Report Execution
  •    Subscriptions And Data Alerts

Module 5: Creating Multidimensional Databases

  •    Creating Multidimensional Databases
  •    Creating Data Sources And Data Source Views
  •    Creating And Browsing a Cube

Module 6: Working With Cubes And Dimensions

  •    Working with Cubes And Dimensions
  •    Sorting And Grouping Attributes

Module 7: Working With Measures And Measure Groups

  •    Working With Measures and Measure Groups

Module 8: Introduction To MDX

  •    Introduction To MDX
  •    Adding Calculations To A Cube

Module 9: Customizing Cube Functionality

  •    Customizing Cube Functionality Part 1
  •    Customizing Cube Functionality Part 2
  •    Customizing Cube Functionality Part 3

Module 10: Implementing A Tabular Data Model

  •    Implementing A Tabular Data Model Part 1
  •    Implementing A Tabular Data Model Part 2

Module 11: Introduction To DAX

  •    Introduction to DAX
  •    Demonstration Making A Tabular Model Part 1
  •    Demonstration Making A Tabular Model Part 2
  •    Using DAX

Module 12: Implementing An Analysis Services Tabular Data Model

  •    Implementing An Analysis Services Tabular Data Model Part 1
  •    Implementing An Analysis Services Tabular Data Model Part 2
  •    Deploying A Tabular Data Model

Module 13: SQL Analysis Services

  •    SQL Analysis Services Part 1
  •    SQL Analysis Services Part 2

Module 14: Creating Data Visualizations With Power View

  •    Creating Data Visualizations With Power View

Module 15: Supporting Self Service Reporting

  •    Supporting Self Service Reporting

Module 16: Performing Predictive Analysis With Data Mining

  •    Performing Predictive Analysis With Data Mining
  •    Using The Data Mining Wizard

Module 17: Predictive Analytics

  •    Predictive Analytics Part 1
  •    Predictive Analytics Part 2

Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012 Course Content

Module 1: Designing A Database Server Infrastructure

  •    Introduction
  •    Designing A Database Server Infrastructure-Part1
  •    Designing A Database Server Infrastructure-Part2
  •    Designing A Database Server Infrastructure-Part3
  •    Designing A Database Server Infrastructure-Part4
  •    Considerations For Database Server Consolidation
  •    Managing Server Resources

Module 2: Designing A Logical Database Scheme

  •    Designing A Logical Database Scheme-Part1
  •    Designing A Logical Database Scheme-Part2
  •    Designing A Logical Database Scheme-Part3
  •    Designing A Logical Database Scheme-Part4
  •    Designing A Logical Database Scheme-Part5

Module 3: Designing A Physical Database Implementation

  •    Designing A Physical Database Implementation-Part1
  •    Designing A Physical Database Implementation-Part2
  •    Designing A Physical Database Implementation-Part3

Module 4: Incorporating Data Files Into the Database

  •    Incorporating Data Files Into The Database-Part1
  •    Incorporating Data Files Into The Database-Part2
  •    Incorporating Data Files Into The Database-Part3
  •    Incorporating Data Files Into The Database Demo
  •    Searching Data Files
  •    Searching Data Files Demo

Module 5: Tuning Database Performance

  •    Tuning Database Performance-Part1
  •    Tuning Database Performance-Part2
  •    Tuning Database Performance-Part3
  •    Working With Query Plans-Part1
  •    Working With Query Plans-Part2
  •    Working With Query Plans-Part3
  •    Working With Query Plans-Part4

Module 6: Designing Database Security

  •    Designing Database Security-Part1
  •    Designing Database Security-Part2
  •    Contained Databases
  •    Protecting Data With Encryption

Module 7: Policy Based Management

  •    Policy Based Management
  •    Policy Based Management Demo

Module 8: Monitoring Server Health

  •    Monitoring Server Health
  •    Monitoring Server Health Demo

Module 9: Designing Database Backup Solution

  •    Designing Database Backup Solution-Part1
  •    Designing Database Backup Solution-Part2
  •    Designing Database Backup Solution-Part3
  •    Designing Database Backup Solution-Part4
  •    Disaster Recovery Plan-Part1
  •    Disaster Recovery Plan-Part2

Module 10: Automating Multi Server Maintenance

  •    Automating Multi Server Maintenance
  •    Managing Multiple Servers

Module 11: Managing SQL Server With Windows Powershell

  •    Managing SQL Server WIth Windows Powershell
  •    Windows Powershell Lab

Module 12: Replicating Data

  •    Replicating Data-Part1
  •    Replicating Data-Part2
  •    Replicating Data-Part3

Module 13: Planning High Availability

  •    Planning High Availability-Part1
  •    Planning High Availability-Part2

Module 14: Review of SQL Statements

  •    Review Of SQL Statements-Part1
  •    Review Of SQL Statements-Part2
  •    Review Of SQL Statements-Part3

Module 15: Eleven Rules of Database Design

  •    Eleven Rules Of Database Design
  •    Conclusion

Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases Course Content

Module 1: SQL 2012 And The 464 Test

  •    Introduction
  •    Intro To SQL Server 2012-Part1
  •    Intro To SQL Server 2012-Part2
  •    Management Studio Demo-Part1
  •    Management Studio Demo-Part2
  •    Management Studio Demo-Part3
  •    Other SQL Server Tools

Module 2: Working With Data Types

  •    Working With Data Types-Part1
  •    Working With Data Types-Part2
  •    Working With Data Types-Part3
  •    Other Data Types

Module 3: Tables

  •    Tables
  •    Creating Tables

Module 4: Data Constraints

  •    Data Constraints-Part1
  •    Data Constraints-Part2

Module 5: Planning In Indexing

  •    Planning In Indexing-Part1
  •    Planning In Indexing-Part2
  •    Planning In Indexing-Part3
  •    Planning In Indexing-Part4

Module 6: Table Structures

  •    Table Structures
  •    Working With Clustered Indexes
  •    Clustered Indexes
  •    Designing Effective Clustered Indexes

Module 7: Improving Performance with Non-Clustered Indexes

  •    Improving Performance With Non-Clustered Indexes-Part1
  •    Improving Performance With Non-Clustered Indexes-Part2
  •    Improving Performance With Non-Clustered Indexes-Part3

Module 8: Using Indexes And Execution Plans

  •    Using Indexes
  •    Execution Plans-Part1
  •    Execution Plans Demo
  •    Execution Plans-Part2

Module 9: Working with Views

  •    Working With Views-Part1
  •    Working With Views-Part2

Module 10: Designing and Implementing Stored Procedures

  •    Designing And Implementing Stored Procedures-Part1
  •    Designing And Implementing Stored Procedures-Part2
  •    Designing And Implementing Stored Procedures-Part3

Module 11: Merging Data and Passing Tables

  •    Merging Data And Passing Tables-Part1
  •    Merging Data And Passing Tables-Part2
  •    Merging Data And Passing Tables-Part3

Module 12: Designing and Implementing User Functions

  •    Designing And Implementing User Functions

Module 13: Creating Highly Concurrent SQL Server Applications

  •    Creating Highly Concurrent SQL Server Applications-Part1
  •    Creating Highly Concurrent SQL Server Applications-Part2
  •    Creating Highly Concurrent SQL Server Applications-Part3

Module 14: Handling Errors in T-SQL

  •    Handling Error InT-SQL-Part1
  •    Handling Error InT-SQL-Part2

Module 15: Triggers

  •    Triggers

Module 16: Implementing Managed Code

  •    Implementing Managed Code-Part1
  •    Implementing Managed Code-Part2
  •    Implementing Managed Code-Part3
  •    Implementing Managed Code-Part4

Module 17: Storing XML in SQL

  •    Storing XML In SQL-Part1
  •    Storing XML In SQL-Part2

Module 18: Querying XML

  •    Querying XML-Part1
  •    Querying XML-Part2

Module 19: Working with the Spatial Data

  •    Working With Spatial Data-Part1
  •    Working With Spatial Data-Part2
  •    Working With Spatial Data-Part3

Module 20: Working With Full-Text Indexes and Queries

  •    Working With Full-Text Indexes And Queries-Part1
  •    Working With Full-Text Indexes And Queries-Part2
  •    Working With Full-Text Indexes And Queries-Part3

Microsoft 70-461: Querying SQL Server 2012 Course Content

Lesson 1: Getting Started with SQL Server 2012

  •    Course Introduction

Lesson 2: Working with T-SQL

  •    Creating Queries-Part 1
  •    Creating Queries-Part 2
  •    Creating Queries-Part 3
  •    Creating Queries-Part 4
  •    Creating Queries-Part 5
  •    Constraints-Part 1
  •    Constraints-Part 2
  •    Constraints-Part 3
  •    Constraints-Part 4
  •    Constraints-Part 5

Lesson 3: Writing SELECT Queries

  •    Select Statement-Part 1
  •    Select Statement-Part 2
  •    Select Statement-Part 3
  •    Select Statement-Part 4

Lesson 4: Working with SQL Data Types

  •    Data Types-Part 1
  •    Data Types-Part 2
  •    Data Types-Part 3
  •    Data Types-Part 4
  •    Data Types-Part 5
  •    Data Types-Part 6
  •    Data Types-Part 7
  •    Data Types-Part 8
  •    Data Types-Part 9
  •    Data Types-Part 10

Lesson 5: Sorting and Filtering Data

  •    Sorting Results-Part 1
  •    Sorting Results-Part 2
  •    Sorting Results-Part 3
  •    Sorting Results-Part 4
  •    Sorting Results-Part 5
  •    Sorting Results-Part 6

Lesson 6: Querying Data from Multiple Tables

  •    Tables Part 1
  •    Tables Part 2
  •    Tables Part 3
  •    Tables Part 4
  •    Tables Part 5
  •    Tables Part 6

Lesson 7: Modifying Data

  •    Inserting Data-Part 1
  •    Inserting Data-Part 2
  •    Inserting Data-Part 3
  •    Inserting Data-Part 4
  •    Inserting Data-Part 5
  •    Inserting Data-Part 6

Lesson 8: Working with SQL Server Built-in Functions

  •    Functions
  •    Parse
  •    Logical Functions
  •    Group By

Lesson 9: Programming in T-SQL

  •    Programming-Part 1
  •    Programming-Part 2
  •    Programming-Part 3
  •    Programming-Part 4
  •    Programming-Part 5
  •    Programming-Part 6

Lesson 10: Implementing Stored Procedures

  •    Storage Procedures-Part 1
  •    Storage Procedures-Part 2
  •    Dynamic SQL-Part 1
  •    Dynamic SQL-Part 2

Lesson 11: Working with Subqueries and Table Expressions

  •    Sub-Queries And Table Expressions-Part 1
  •    Sub-Queries And Table Expressions-Part 2
  •    Sub-Queries And Table Expressions-Part 3
  •    Sub-Queries And Table Expressions-Part 4

Lesson 12: Working with Set Operators, Conditional Operators, and Window Functions

  •    Set Operators-Part 1
  •    Set Operators-Part 2
  •    Window Functions-Part 1
  •    Window Functions-Part 2
  •    User Defined Functions-Part 1
  •    User Defined Functions-Part 2
  •    Advanced Analytical Functions

Lesson 13: Working with PIVOT, UNPIVOT, and Grouping Sets

  •    Pivot
  •    Grouping Sets

Lesson 14: Managing Error Handling and Transactions

  •    Error Handling-Part 1
  •    Error Handling-Part 2
  •    Manage Transactions-Part 1
  •    Manage Transactions-Part 2
  •    Manage Transactions-Part 3

Lesson 15: Querying SQL Server System

  •    System Databases-Part 1
  •    System Databases-Part 2
  •    System Databases-Part 3
  •    System Databases-Part 4

Lesson 16: Optimizing Query Performance

  •    Query Planning-Part 1
  •    Query Planning-Part 2
  •    Index-Part 1
  •    Index-Part 2
  •    Index-Part 3

Microsoft 70-462: Administering SQL Server 2012 Databases Course Content

Lesson 1: Identifying the SQL Server Platform

  •    Overview
  •    DataStorage-Part 1
  •    DataStorage-Part 2

Lesson 2: Deploying SQL Server

  •    Install-Part 1
  •    Install-Part 2

Lesson 3: Configuring SQL Server

  •    Configuring-Part 1
  •    Configuring-Part 2
  •    Changing Memory-Part 1
  •    Changing Memory-Part 2
  •    Email-Part 1
  •    Email-Part 2

Lesson 4: Managing Databases in SQL Server 2012

  •    User Databases-Part 1
  •    User Databases-Part 2
  •    User Databases-Part 3
  •    User Databases-Part 4
  •    User Databases-Part 5

Lesson 5: Managing SQL Server Security

  •    Setting Security-Part 1
  •    Setting Security-Part 2
  •    Server Roles-Part 1
  •    Server Roles-Part 2
  •    Setting Permissions-Part 1
  •    Setting Permissions-Part 2

Lesson 6: Implementing Advanced Security Settings

  •    Querying Data From Multiple Tables-Part 1
  •    Querying Data From Multiple Tables-Part 2
  •    Querying Data From Multiple Tables-Part 3
  •    Querying Data From Multiple Tables-Part 4
  •    Querying Data From Multiple Tables-Part 5

Lesson 7: Applying Encryption and Compression

  •    Encrypting And Compressing-Part 1
  •    Encrypting And Compressing-Part 2
  •    Encrypting And Compressing-Part 3

Lesson 8: Working with Indexes and Log Files

  •    Functions-Part 1
  •    Functions-Part 2
  •    Functions-Part 3
  •    Functions-Part 4
  •    Functions-Part 5
  •    Functions-Part 6

Lesson 9: Working with Backup and Restore

  •    Managing Backups-Part 1
  •    Managing Backups-Part 2
  •    Managing Backups-Part 3
  •    Managing Backups-Part 4
  •    Managing Backups-Part 5
  •    Managing Backups-Part 6
  •    Managing Backups-Part 7

Lesson 10: Implementing High Availability

  •    Stored Procedures-Part 1
  •    Stored Procedures-Part 2
  •    Stored Procedures-Part 3
  •    Stored Procedures-Part 4

Lesson 11: Optimizing Server Performance

  •    Managing SQL Performance-Part 1
  •    Managing SQL Performance-Part 2
  •    Managing SQL Performance-Part 3
  •    Managing SQL Performance-Part 4
  •    Managing SQL Performance-Part 5
  •    Managing SQL Performance-Part 6
  •    Managing SQL Performance-Part 7

Lesson 12: Troubleshooting Issues and Recovering Databases

  •    Set Operators-Part 1
  •    Set Operators-Part 2
  •    Set Operators-Part 3
  •    Set Operators-Part 4
  •    Set Operators-Part 5

Lesson 13: Performing Advanced Database Management Tasks

  •    Managing Database Infrastructures-Part 1
  •    Managing Database Infrastructures-Part 2
  •    Managing Database Infrastructures-Part 3

Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012 Course Content

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

Oracle Database 11g Certified Associate (OCA) Fundamentals 1Z0-051 and Admin 1z0-052 Course Content

Module 1: Database Admininstration

  •    Intro to Oracle
  •    Database Administration
  •    Installing Oracle - Part 1
  •    Installing Oracle - Part 2
  •    Post Setup Overview - Part 1
  •    Post Setup Overview - Part 2
  •    SQLplus - Part 1
  •    SQLplus - Part 2
  •    SQLplus Demo - Part 1
  •    SQLplus Demo - Part 2
  •    SQLplus Demo - Part 3
  •    Startup and Shutdown - Part 1
  •    Startup and Shutdown - Part 2

Module 2: Oracle Architecture

  •    Oracle Architecture
  •    Schema Objects
  •    Data Access
  •    Architecture

Module 3: Database Schema

  •    Database Schema
  •    Create Table & Tablespace - Part 1
  •    Create Table & Tablespace - Part 2
  •    Create View
  •    Create Index
  •    Create Sequence

Module 4: Recovery Manager

  •    Recovery Manager
  •    What is RMAN
  •    RMAN Demo
  •    Restore - Part 1
  •    Restore - Part 2

Module 5: Introduction to SQL

  •    SQL - Part 1
  •    SQL - Part 2
  •    Parts of SQL Statement
  •    Select Statement

Module 6: Filtering and Sorting Data

  •    Build ERD - Part 1
  •    Build ERD - Part 2
  •    Build ERD - Part 3

Module 7: Functions

  •    Functions
  •    More Functions
  •    Group Functions
  •    Custom Functions

Module 8: SET Operators and Subqueries

  •    SET Operations
  •    Subqueries

Module 9: Regular Expressions and SQL Loader

  •    Regular Expressions
  •    SQL Loader
Add a review
Currently, we are not accepting new reviews
4.8
Based on 81 reviews
1-5 of 81 reviews
  1. SJ

    good

  2. AA
  3. K
  4. BO
  5. A

    Smooth delivery and easy access to LMS. Good to see that the LMS offers progress tracking. Would be great if badges were offered on completion of courses to share via Credly to future employers.

Your Training Instructors

Chrys Thorsen

Chrys Thorsen

Education and Technology Expert

Chrys Thorsen is an education and technology expert who specializes in enterprise-level IT infrastructure consulting and certified training-of-trainers. In her career, she has garnered over 50 IT Certifications including CISSP, CISA, CEHv12, PenTest+, CompTIA CNVP, Cisco CCSI/CCNP, Microsoft Cloud and on-premises technologies, VMware vSphere, and many more. She has also authored 40 published certification textbooks, and over 35 full-length IT certification video courses.

When not working in the United States, Chrys spends her time abroad capacity-building IT literacy in developing nations in Sub-Saharan Africa. Her client list has included: the US Federal Government, the Republic of Zambia Ministry of Health, Cavendish University Zambia, Accenture, JP Morgan Chase, the US Centers for Disease Control and Prevention, the Elizabeth Glaser Pediatric AIDS Foundation (EGPAF), Hughes Aircraft, Microsoft, and many more.

Chrys lives by, and is fond of repeating, her professional creed:

“The only true measure of success for any project or training is results on the ground. Everything else is just noise.” “I teach what I deploy; I deploy what I teach.”

Rafiq Wayani

Rafiq Wayani

Project Management Instructor

Rafiq has extensive experience including more than 20 years in IT as a Systems Architect, Software Engineer, DBA, and Project Manager. He has instructed in a variety of technical areas and has designed and implemented network and information systems. Bringing nearly 30 years of advanced IT experience to each course and adding his unique perspective and “real world” tips, Rafiq has a knack for making complex topics easy to understand.

default-course image

Subscribe To All-Access
Lock In $16.99 / Month Forever

Gain access to this training and all our other courses with our cost-effective monthly subscription. No obligations. Cancel anytime.

$49.99 $16.99 Monthly

OR

$49.00

today Only: 1-Year For $79.00!

Get 1-year full access to every course, over 2,600 hours of focused IT training, 20,000+ practice questions at an incredible price of only $79.00

Learn CompTIA, Cisco, Microsoft, AI, Project Management & More...