How do I enroll for the online training?

You can enroll for the online training through our website. You can make online payment using any of the following options: Visa debit/credit card American Express and Diners Club cards Master Card PayPal Once the online payment is done, you will automatically receive payment receipt, via email.

What will I get along with this training?

In this training, you will have access to online e-learning.

Do you provide money back guarantee for the training programs?

Yes. We do offer a money-back guarantee for many of our training programs. You can refer to the Refund Policy and raise refund requests via our Help and Support portal.

Can I cancel my enrollment? Do I get a refund?

Yes! You can cancel your enrollment. We provide you complete refund after deducting the administration fee. To know more, please go through our Refund Policy.

Where and how can I access the e-learning content? Are there any limitations?

Once you register with us for a course by paying the course fee, you can have 24/7 access to the e-learning content on our website. An automated course purchase confirmation mail from our side will guide you through the process.

I am not able to access the online course. Whom should I contact for a solution?

Please raise a request via our Help and Support portal to have your issue resolved.

How do I track the hours already spent on the course?

You can track the number of hours spent on the course by accessing your LMS home.

Can I extend the access period?

Yes, you can extend the access period by paying an additional fee. Please raise a request via our Help and Support portal.

Do you provide any group discounts for online training programs?

Yes, we offer group discounts for our online training programs. Get in touch with us over the Drop us a Query/Request a Callback/Live Chat channels to find out more about our group discount packages.

How does Simplilearn assure that the material and the training delivered are effective?

Simplilearn follows a Global Learning Framework which has been proven to deliver results and has been perfected by our training experience.

Introduction to Oracle 11g Online Training Tutorial

World’s #1 Online Bootcamp

Course Overview

Key Features

12 Hrs of HQ e-learning content
139 High Quality Lectures
Topics on Amazon AWS, OEM, OLTP & DW
Covers SQL Developer, SQL *Plus
Downloadable Work Files
Course Completion Certificate

Training Options

Self-Paced Learning

$ 49

Lifetime access to high-quality self-paced e-learning content curated by industry experts
24x7 learner assistance and support

Corporate Training

Customized to your team's needs

Blended learning delivery model (self-paced eLearning and/or instructor-led options)
Flexible pricing options
Enterprise grade Learning Management System (LMS)
Enterprise dashboards for individuals and teams
24x7 learner assistance and support

Course Curriculum

Course Content

Introduction to Oracle 11g
Preview
- Module 01 - Introduction
  18:38Preview
  - 1.1 Welcome to Oracle Database
    00:42
  - 1.2 Useful Web Sites
    04:24
  - 1.3 Choosing Your Profession
    04:42
  - 1.4 About this Course
    03:53
  - 1.5 Certification
    04:57
- Module 02 - Oracle Installation and Configuration
  50:29Preview
  - 2.1 Using Amazon Web Services
    00:51
  - 2.2 Downloading Oracle Software
    03:21
  - 2.3 Preparing a Linux Server pt. 1
    05:46
  - 2.4 Preparing a Linux Server pt. 2
    06:32
  - 2.5 Install Oracle on Linux pt. 1
    05:28
  - 2.6 Install Oracle on Linux pt. 2
    05:41
  - 2.7 Install Oracle on Windows
    03:27
  - 2.8 Install Oracle Client Software
    02:26
  - 2.9 Creating an Oracle Database
    06:20
  - 2.10 Download and Install Oracle Docs
    04:41
  - 2.11 Finding Things in Oracle Docs
    05:56
- Module 03 - Tools and Configuration
  34:02Preview
  - 3.1 Deinstalling and Reinstalling Oracle
    05:40
  - 3.2 Rerunning netca/ntemgr/dbca
    06:37
  - 3.3 Oracle Enterprise Manager (OEM)
    04:11
  - 3.4 Using SQL*Plus
    06:39
  - 3.5 Download and Install SQL Developer
    04:51
  - 3.6 Using SQL Developer
    06:04
- Module 04 - The Relational Database
  35:49Preview
  - 4.1 Metadata vs. Data
    05:13
  - 4.2 Introducing Tables and Things
    05:36
  - 4.3 Sample Models Used in this Course
    01:55
  - 4.4 Relational Database Model
    06:44
  - 4.5 Types of Databases (OLTP and DW)
    05:36
  - 4.6 Normalization and Normal Forms pt. 1
    04:05
  - 4.7 Normalization and Normal Forms pt. 2
    04:12
  - 4.8 Custom vs. Off the Shelf
    02:28
- Module 05 - The Architecture of Oracle
  49:13Preview
  - 5.1 Commits and Rollbacks
    04:26
  - 5.2 Multi-User Transactions
    02:59
  - 5.3 General Oracle Architecture
    04:12
  - 5.4 Datafiles and Tablespaces pt. 1
    03:30
  - 5.5 Datafiles and Tablespaces pt. 2
    05:01
  - 5.6 Processes and Memory
    06:52
  - 5.7 Backup and Recovery
    05:38
  - 5.8 Failover with Standby
    05:09
  - 5.9 High Availability with RAC
    06:06
  - 5.10 Adding ASM to Oracle RAC
    01:45
  - 5.11 Replication
    03:35
- Module 06 - Working with Tables
  01:40:07Preview
  - 6.1 Generating Tables from a Data Model
    06:38
  - 6.2 Types of Tables
    04:59
  - 6.3 Methods of Table Creation
    02:50
  - 6.4 Simple Datatypes
    04:54
  - 6.5 Basic CREATE TABLE Syntax
    06:27
  - 6.6 Some Advanced CREATE TABLE Syntax
    05:30
  - 6.7 Inline Constraints
    06:38
  - 6.8 Out of Line Constraints
    03:24
  - 6.9 Naming Constraints and More Syntax
    04:45
  - 6.10 Primary and Foreign Key Indexing
    03:52
  - 6.11 Organizing My Data Model
    03:24
  - 6.12 Unique Constraints/Non-FK Inversions
    06:34
  - 6.13 Check Constraints and Default Values
    06:22
  - 6.14 Global Temporary/Tablespaces/Logging
    05:19
  - 6.15 Parallel Processing pt. 1
    04:04
  - 6.16 Parallel Processing pt. 2
    04:35
  - 6.17 Partitions/Externals/Compression
    03:33
  - 6.18 Basic Dropping and Altering Tables
    03:55
  - 6.19 Metadata Views pt. 1
    06:29
  - 6.20 Metadata Views pt. 2
    05:55
- Module 07 - The SELECT Statement
  01:22:22Preview
  - 7.1 Basic SELECT Statement Syntax
    06:41
  - 7.2 Updating Model and Importing Data
    05:55
  - 7.3 The SELECT and FROM Clauses
    03:36
  - 7.4 One/Many/All Columns
    03:50
  - 7.5 Rename SELECT Columns
    04:00
  - 7.6 Schema References
    04:36
  - 7.7 Aliases
    06:22
  - 7.8 Expressions
    06:10
  - 7.9 Precedence and Operators pt. 1
    06:07
  - 7.10 Precedence and Operators pt. 2
    04:20
  - 7.11 The DUAL Table/Pseudocolumns/SYSDATE
    04:55
  - 7.12 Using Functions
    06:41
  - 7.13 The DISTINCT Clause
    06:26
  - 7.14 Using NULLs in Oracle SQL
    05:50
  - 7.15 UNION/INTERSECT/MINUS/Count Function
    06:53
- Module 08 - Restricting And Filtering Data
  01:28:05Preview
  - 8.1 WHERE Clause Syntax
    05:01
  - 8.2 WHERE Clause Comparison Conditions
    03:03
  - 8.3 Equality and Inequality
    05:29
  - 8.4 IS [ NOT ] NULL
    05:37
  - 8.5 Range and BETWEEN pt. 1
    06:24
  - 8.6 Range and BETWEEN pt. 2
    05:52
  - 8.7 LIKE Pattern Match
    06:54
  - 8.8 ANY and SOME and ALL
    06:42
  - 8.9 Logical/Compound Operators pt. 1
    04:52
  - 8.10 Logical/Compound Operators pt. 2
    05:06
  - 8.11 Logical/Compound Operators pt. 3
    04:20
  - 8.12 IN List Comparisons
    06:43
  - 8.13 Making Queries Run Faster pt. 1
    06:17
  - 8.14 Making Queries Run Faster pt. 2
    06:47
  - 8.15 Making Queries Run Faster pt. 3
    03:55
  - 8.16 Making Queries Run Faster pt. 4
    05:03
- Module 09 - Sorting Data
  25:54
  - 9.1 ORDER BY Clause Syntax
    04:16
  - 9.2 Sorting by Column
    05:54
  - 9.3 Sorting by Position
    03:56
  - 9.4 Ascending and Descending Sorts
    06:26
  - 9.5 NULLS First and NULLS Last
    02:37
  - 9.6 Sorting by Expression
    02:45
- Module 10 - Single Row Functions
  51:47Preview
  - 10.1 Types of Functions
    05:39
  - 10.2 Single Rows Functions in Manuals
    06:15
  - 10.3 Using String Functions pt. 1
    03:18
  - 10.4 Using String Functions pt. 2
    05:17
  - 10.5 Using String Functions pt. 3
    04:54
  - 10.6 Using Number Functions
    06:11
  - 10.7 Using Date and Time Functions
    06:20
  - 10.8 Using Conversion Functions
    06:58
  - 10.9 Miscellaneous Functions
    06:55
- Module 11 - Joining Tables
  01:04:26Preview
  - 11.1 What is a Join?
    03:51
  - 11.2 Join Clause Syntax
    04:11
  - 11.3 Types of Joins
    03:47
  - 11.4 Cross Joins
    05:23
  - 11.5 Inner Joins pt. 1
    05:09
  - 11.6 Inner Joins pt. 2
    04:44
  - 11.7 Natural Joins
    05:35
  - 11.8 Types of Outer Joins
    05:24
  - 11.9 Left Outer Join
    03:40
  - 11.10 Right Outer Join
    04:16
  - 11.11 Full Outer Join
    06:43
  - 11.12 Self Join
    03:44
  - 11.13 Using Outer and Self Joins
    05:45
  - 11.14 ANSI and Oracle Prop. Syntax
    02:14
- Module 12 - Aggregating Using GROUP BY
  01:07:47Preview
  - 12.1 GROUP BY Clause Syntax
    03:22
  - 12.2 What GROUP BY Does
    01:46
  - 12.3 Grouping Functions
    04:03
  - 12.4 Summary Functions pt. 1
    04:47
  - 12.5 Summary Functions pt. 2
    04:11
  - 12.6 Statistical Functions
    05:41
  - 12.7 Ranking Functions
    05:02
  - 12.8 Analytic Functions
    04:16
  - 12.9 Group Functions and Null Values
    02:47
  - 12.10 Basic GROUP BY Clauses
    03:14
  - 12.11 Filter Grouped Results with HAVING
    03:55
  - 12.12 More Changes to the Shows Model
    06:40
  - 12.13 The ROLLUP Clause
    06:44
  - 12.14 The CUBE Clause
    04:29
  - 12.15 The GROUPING SETS Clause
    02:31
  - 12.16 Pivot Queries
    04:19
- Module 13 - Conclusion
  02:27
  - 13.1 Course Wrap Up
    02:27
- Module 14 - Credits
  01:07
  - 14.1 About the Author
    01:07

Why Online Bootcamp

Develop skills for real career growthCutting-edge curriculum designed in guidance with industry and academia to develop job-ready skills
Learn from experts active in their field, not out-of-touch trainersLeading practitioners who bring current best practices and case studies to sessions that fit into your work schedule.
Learn by working on real-world problemsCapstone projects involving real world data sets with virtual labs for hands-on learning
Structured guidance ensuring learning never stops24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts

FAQs

How do I enroll for the online training?
You can enroll for the online training through our website. You can make online payment using any of the following options:
- Visa debit/credit card
- American Express and Diners Club cards
- Master Card
- PayPal
Once the online payment is done, you will automatically receive payment receipt, via email.
What will I get along with this training?
In this training, you will have access to online e-learning.
Do you provide money back guarantee for the training programs?
Yes. We do offer a money-back guarantee for many of our training programs. You can refer to the Refund Policy and raise refund requests via our Help and Support portal.
Can I cancel my enrollment? Do I get a refund?
Yes! You can cancel your enrollment. We provide you complete refund after deducting the administration fee. To know more, please go through our Refund Policy.
Where and how can I access the e-learning content? Are there any limitations?
Once you register with us for a course by paying the course fee, you can have 24/7 access to the e-learning content on our website. An automated course purchase confirmation mail from our side will guide you through the process.
I am not able to access the online course. Whom should I contact for a solution?
Please raise a request via our Help and Support portal to have your issue resolved.
How do I track the hours already spent on the course?
You can track the number of hours spent on the course by accessing your LMS home.
Can I extend the access period?
Yes, you can extend the access period by paying an additional fee. Please raise a request via our Help and Support portal.
Do you provide any group discounts for online training programs?
Yes, we offer group discounts for our online training programs. Get in touch with us over the Drop us a Query/Request a Callback/Live Chat channels to find out more about our group discount packages.
How does Simplilearn assure that the material and the training delivered are effective?
Simplilearn follows a Global Learning Framework which has been proven to deliver results and has been perfected by our training experience.
Do you provide any course completion certificate?
Yes! We offer course completion certificate after you successfully complete the training program.
I want to know more about the training program. Whom do I contact?
Please join our Live Chat for instant support, call us, or Request a Call Back to have your query resolved.

Disclaimer
PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.

Introduction to Oracle 11g Online Training

World’s #1 Online Bootcamp

Course Overview

Key Features

Training Options

Self-Paced Learning

Corporate Training

Course Curriculum

Course Content

Introduction to Oracle 11g

Module 01 - Introduction

1.1 Welcome to Oracle Database

1.2 Useful Web Sites

1.3 Choosing Your Profession

1.4 About this Course

1.5 Certification

Module 02 - Oracle Installation and Configuration

2.1 Using Amazon Web Services

2.2 Downloading Oracle Software

2.3 Preparing a Linux Server pt. 1

2.4 Preparing a Linux Server pt. 2

2.5 Install Oracle on Linux pt. 1

2.6 Install Oracle on Linux pt. 2

2.7 Install Oracle on Windows

2.8 Install Oracle Client Software

2.9 Creating an Oracle Database

2.10 Download and Install Oracle Docs

2.11 Finding Things in Oracle Docs

Module 03 - Tools and Configuration

3.1 Deinstalling and Reinstalling Oracle

3.2 Rerunning netca/ntemgr/dbca

3.3 Oracle Enterprise Manager (OEM)

3.4 Using SQL*Plus

3.5 Download and Install SQL Developer

3.6 Using SQL Developer

Module 04 - The Relational Database

4.1 Metadata vs. Data

4.2 Introducing Tables and Things

4.3 Sample Models Used in this Course

4.4 Relational Database Model

4.5 Types of Databases (OLTP and DW)

4.6 Normalization and Normal Forms pt. 1

4.7 Normalization and Normal Forms pt. 2

4.8 Custom vs. Off the Shelf

Module 05 - The Architecture of Oracle

5.1 Commits and Rollbacks

5.2 Multi-User Transactions

5.3 General Oracle Architecture

5.4 Datafiles and Tablespaces pt. 1

5.5 Datafiles and Tablespaces pt. 2

5.6 Processes and Memory

5.7 Backup and Recovery

5.8 Failover with Standby

5.9 High Availability with RAC

5.10 Adding ASM to Oracle RAC

5.11 Replication

Module 06 - Working with Tables

6.1 Generating Tables from a Data Model

6.2 Types of Tables

6.3 Methods of Table Creation

6.4 Simple Datatypes

6.5 Basic CREATE TABLE Syntax

6.6 Some Advanced CREATE TABLE Syntax

6.7 Inline Constraints

6.8 Out of Line Constraints

6.9 Naming Constraints and More Syntax

6.10 Primary and Foreign Key Indexing

6.11 Organizing My Data Model

6.12 Unique Constraints/Non-FK Inversions

6.13 Check Constraints and Default Values

6.14 Global Temporary/Tablespaces/Logging

6.15 Parallel Processing pt. 1

6.16 Parallel Processing pt. 2

6.17 Partitions/Externals/Compression

6.18 Basic Dropping and Altering Tables

6.19 Metadata Views pt. 1

6.20 Metadata Views pt. 2

Module 07 - The SELECT Statement

7.1 Basic SELECT Statement Syntax

7.2 Updating Model and Importing Data