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
Take your data analysis skills to the next level with ITU Online’s Microsoft SQL Server Analysis Services (SSAS) course.
With this course, you will be able to become an expert in employing both engines within a company’s infrastructure. Analysis Services is composed of two powerful applications – VertiPaq and Data Mining for multidimensional cubes, as well as xVelocity for Tabular Data Models. It provides enterprise-level semantic data modeling abilities to construct business intelligence systems such as Power BI, Excel Reporting Services and other information visualization tools that can make your organization even more successful!
$49.00
Enhance your career as a SQL Server administrator with our Microsoft SQL Server Administration training series. Enroll today and become an expert!
This sql server administration course offers students a comprehensive understanding of how to maintain and optimize a Microsoft SQL Server database. It is specifically tailored towards individuals who want to gain knowledge features in numerous versions of SQL server as well as learn about essential capabilities throughout the entire data platform. Students will emerge from this training with an extensive set of skills for managing their own MS SQL Server environment along with its databases!
$49.00
Take the Microsoft 70-480: Programming in HTML5, JavaScript and CSS3 course and become a skilled web developer. Enroll now!
In this Microsoft 70-480 course you will learn how to implement and manipulate document structures and objects, implement program flow, access and secure data, and use CSS3 in applications. This course will teach you HTML5, CSS3, Javascript and jQuery.
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.