Lifetime
An ITU Online Training exclusive. The only Buy Once, Never Pay for IT training again program available. Plus, get all new and updated content for life.
- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
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
Included In This Course
136 Training Hours
610 On-demand Videos
Closed Captions
134 Topics
831 Prep Questions
Certificate of Completion
Course Description
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 DisplayYour Achievement
Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Course Outline
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
Your Training Instructors
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 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.
$49.00
OR
Subscribe To All-Access
Lock In $14.99 / Month Forever
Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.
$49.00 $14.99 Monthly
Microsoft & Oracle Database SQL Power Bundle
Microsoft & Oracle Database SQL Power Bundle
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.
Monthly All-Access Subscription
7 Days Free - $39.00 / month
A great option at an affordable monthly price.
Annual All-Access Subscription
$229 / year
A discounted price when paying for your All Access library on an annual basis.
Lifetime All-Access Library
$379 One time payment
Exceptional Value. Pay once, never have to buy IT training again.
Related Courses
$49.00
Master Hyperledger blockchain development with our Certified Blockchain Developer course. Get certified as a blockchain expert today.
The Certified Blockchain Developer – Hyperledger Course is perfect for technology-centered engineers, software engineers, application developers, or anyone wishing to be certified by the Blockchain Training Alliance.
$49.00
Master data visualization with Introduction to Microsoft Power BI. Learn to create powerful business intelligence dashboards and reports. Enroll now!
This online course training will teach you how to use Power Apps visualizations, which allow your Business Analysis users to get Business Analytics and take actions from their Power BI reports in real-time. Moreover, we’ll look into the ways that Power BI and SQL Server Analysis Services can be integrated for enterprise-level data models and analysis for business decisions.
$49.00
Master JavaScript Fundamentals and build powerful web applications with our comprehensive online training. Start now!
If you’re ready to dive into Java Programming, this JavaScript Fundamentals online training course is for you! You’ll start with the basics and work your way up to advanced levels. Not only will you get a comprehensive introduction to object-oriented programming, but also learn many other core Java features in detail. Don’t miss out on this opportunity – sign up now and make strides in mastering Java today!
I’ve enjoyed the training so far. Wish it was more focused on Linux like other training, but still good.
The educators at ituonline.com are highly skilled but could improve their methods of instruction. In the CCNA 200-301 course, there’s a heavy emphasis on oral lectures, and it would be beneficial to include more in-depth visual aids. Annotating labs and graphics could also make the educational journey more effective. On the other hand, the N10-008 course instructor consistently offers top-notch material.
This course is super detailed but not boring, and they give you cool projects to actually practice what you’re learning.