Learn Oracle 11g - A Comprehensive Training Course

A Comprehensive Oracle 11g Course Taught By Infinite Skills
4.5 (23 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
791 students enrolled
$50
Take This Course
  • Lectures 124
  • Contents Video: 8 hours
    Other: 1 min
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2013 English

Course Description

This Oracle 11g video based training course from Infinite Skills will teach you the basics of operating an Oracle Database server and environment. You will also discover the basics of how to manage and develop for an Oracle Database, and administer one.


This tutorial is designed for the beginner. This training will teach you the basics of what it means to administer an Oracle Database. Throughout the training, you will be able to better understand the path you can continue on from here, whether that is to become a DBA, developer or administrator of Oracle Databases. You will learn about processes and architectural concepts of a database. This video training also covers topics such as storage, data modelling, basic SQL, database tasks, and how all of these apply specifically to Oracle Databases.

By the completion of this video tutorial, you will have a fundamental understanding of how an Oracle Database server and environment function, as well as how database concepts apply specifically to an Oracle Database. Working files are included to assist you as you work through this computer software training course.

What are the requirements?

  • Just a desire to learn

What am I going to get from this course?

  • Learn Oracle 11g At Your Own Pace From A Leading Expert

What is the target audience?

  • Users of all levels

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Important - Working Files - Download These First
Preview
Article
0101 What Is Oracle
Preview
02:42
0102 What You Should Expect From This Course
Preview
02:01
0103 Download And Install Oracle
Preview
04:51
Section 2: The Technology - OS, Middleware, And Hardware
0201 Operating Systems
04:56
0202 Middleware
03:37
0203 Hardware
08:30
Section 3: The Technology - Database
0301 What Is A Database?
03:10
0302 What Are The Types Of Database?
02:29
0303 MySQL
01:39
0304 TimesTen
01:51
0305 BerkleyDB
01:04
0306 NoSQL
01:25
0307 Oracle Database Server
01:17
0308 Oracle Database Server Editions
07:17
0309 Documentation And Software
03:24
Section 4: Database Architecture
0401 Operating Systems Supported
01:20
0402 Database Server
01:29
0403 The Database
01:11
0404 Database Instance
01:24
0405 Background Memory Processes
04:31
0406 User Memory Processes
01:24
0407 System Global Area
02:25
0408 Program Global Area
01:44
0409 Networking
01:13
0410 Oracle Net Listener
02:22
0411 Real Application Clusters
04:22
Section 5: Storage
0501 Blocks
02:27
0502 Extents
01:34
0503 Segments
01:49
0504 Tablespaces
02:31
0505 Data Files
01:17
0506 Control Files
01:23
0507 Redo Log Files
02:50
0508 Parameter File
01:07
0509 Password File
01:00
0510 Fast Recovery Area
01:05
0511 Alert Logs
02:05
0512 Trace Files
01:54
0513 ASM, Grid And Cloud
03:33
Section 6: Database Structures
0601 The Data Dictionary
06:28
0602 Schemas And Users
03:06
0603 Tables
07:14
0604 Partitions
07:23
0605 Temp Tables
03:27
0606 B-tree Indexes
08:08
0607 Index Organized Tables (IOT)
03:06
0608 Bitmap Indexes
04:13
0609 Function Based Indexes
05:17
0610 Views
03:39
0611 Primary And Unique Keys
05:05
0612 Foreign Keys
04:40
0613 Check Constraints
03:24
0614 Synonyms
02:21
0615 Table Clusters
01:26
0616 Sequences
03:08
0617 Object Statistics
01:40
0618 Performance Views
03:40
Section 7: Oracle IDEs
0701 Oracle SQL Plus
03:24
0702 SQL Developer
06:50
0703 Oracle Universal Installer (OUI)
02:06
0704 Oracle Enterprise Manager (OEM)
03:45
0705 Oracle Database Configuration Assistant (ODCA)
06:30
Section 8: Structured Query Language (SQL)
0801 What Is SQL
05:53
0802 Select
05:17
0803 Insert
05:27
0804 Update
03:46
0805 Joins
05:04
0806 Deletes
02:17
0807 Merge
03:34
0808 Aggregates
02:21
0809 SQL Analytics
05:45
0810 Optimizer And Explain Plan
05:39
0811 Transactions And Concurrency
06:19
Section 9: PL/SQL
0901 What Is PL/SQL
08:00
0902 Anonymous Blocks
01:18
0903 Procedures
04:46
0904 Functions
05:40
0905 Packages
07:35
0906 Object Types
08:48
0907 Dynamic SQL
07:07
0908 Application Express (ApEx)
06:54
Section 10: XML
1001 What Is XML
01:43
1002 What Is XMLDB
01:17
1003 XMLType
02:44
1004 SQL/XML
05:25
1005 XQuery
02:46
1006 XML Repository
03:14
1007 XML Storage Models
01:59
Section 11: Analysis Tasks With Oracle Data Modeler

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Ready to start learning?
Take This Course