Category
Database
Description
Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online transaction processing, data warehousing and mixed database workloads.
Oracle 12c is a version of the Oracle Database. The "c" stands for "cloud" to indicate that 12c is "cloud enabled". It features a new multi-tenant option that will help companies to consolidate databases into private or public clouds.
Course Content
13 Modules • 6 months
Relational Database Systems and Oracle
Introduction to SQL and SQL Developer
Data Definition, Part 1
Retrieval: The Basics
Retrieval: Functions
Data Manipulation
Data Definition, Part II
Retrieval: Multiple Tables and Aggregation
Retrieval: Some Advanced Features
Views
SQL* Plus Basic and Scripting
Object-Relational Features
The Seven Case Tables
What you'll learn
Maximize the potential of SQL to formulate complex queries for Oracle databases
Employ inner joins, outer joins, cross joins, self joins and theta joins
Apply the full range of complex query types
Leverage the analytic OLAP functions of Oracle
Thoroughly test SQL queries and avoid common errors
Select the most efficient solution to complex SQL problems
