Learning Oracle 12c - A Beginners Oracle Training Video

A Easy To Follow Course Designed To Teach You The Core Principals Of Working With Oracle Database Technology
4.0 (37 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.
619 students enrolled
$50
Take This Course
  • Lectures 102
  • Contents Video: 11 hours
  • 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 5/2014 English

Course Description

This Oracle 12c training course from Infinite Skills will teach you how to everything you need to know about the newest version of the Oracle database system. This course is designed for the absolute beginner, meaning no prior knowledge of Oracle is needed.


You will start by learning about the Oracle database technology, including learning the database architecture of Oracle and how to install the software on your computer. This video tutorial will cover topics such as how to create an Oracle database, basic SQL and PL/SQL, storage structures, database objects, security, backup and recovery, and Oracle administration tasks. Finally, you will learn about data migration and Oracle networking.

Once you have completed this computer based training course, you will have a fundamental understanding of how an Oracle database functions, and how database concepts apply to the latest version of Oracle. Working files are included, allowing you to follow along with the author throughout the lessons.

What are the requirements?

  • PC or Mac

What am I going to get from this course?

  • Learn the fundamentals of working with Oracle Databases

What is the target audience?

  • Programmers and Database Administrators

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
0101 What You Should Expect From This Course
Preview
04:03
0103 What is Oracle?
Preview
04:01
Section 2: The Oracle Technology Family
0201 Hardware
Preview
02:48
0202 Operating Systems
04:30
0203 Virtualization
05:18
0204 Middleware And Java
04:41
Section 3: Oracle Database Technology
0301 What Is A Database?
06:16
0302 Oracle RDBMS
05:14
0303 Oracle Database Server Editions
05:38
0304 Oracle Database Server Versioning
07:41
0305 Oracle Database Options
07:17
0306 Software
08:58
0307 Documentation
06:30
0308 SQL Developer
08:40
Section 4: Database Architecture
0401 The Oracle RDBMS - Instance And Database
03:49
0402 The Instance - Background Memory Processes
12:09
0403 The Instance - System Global Area
07:18
0404 The Instance - Program Global Area
05:58
0405 The Database - Core Datafiles
10:10
0406 The Redo Architecture
05:50
0407 Real Application Clusters
05:56
0408 Container Databases
04:35
0409 Pluggable Databases
05:43
Section 5: Installing The Oracle Software
0501 Planning An Installation
06:04
0502 The Oracle Universal Installer
05:41
0503 Installing The Software - Part 1
06:26
0504 Installing The Software - Part 2
03:47
Section 6: Creating An Oracle Database
0601 Planning Database Creation
04:58
0602 Running NETCA And DBCA
04:43
0603 Stepping Through Database Creation - Part 1
06:42
0604 Stepping Through Database Creation - Part 2
07:05
0605 Stepping Through Database Creation - Part 3
06:21
0606 Setting Up The SQL Developer
04:39
Section 7: Structured Query Language (SQL)
0701 What Is SQL?
06:55
0702 Select
07:03
0703 Insert
06:06
0704 Update
04:25
0705 Deletes
05:55
0706 Joins
08:58
0707 Single Row Functions
09:02
0708 Data Aggregation
07:04
0709 Optimizer And Execution Plans
09:40
0710 Transactions And Concurrency
04:50
Section 8: PL And SQL
0801 What Is PL And SQL?
05:52
0802 Anonymous Blocks
06:27
0803 Procedures
05:25
0804 Functions
05:38
0805 Packages
06:15
0806 Object Types
06:38
Section 9: Oracle Storage Structures
0901 Blocks
08:19
0902 Extents
07:29
0903 Segments
06:55
0904 Datafiles
07:46
0905 Smallfile Tablespaces
06:37
0906 Bigfile Tablespaces
07:43
0907 Automatic Storage Management - ASM
10:01
Section 10: Database Objects
1001 Tables
07:50
1002 Partitions
09:20
1003 Temporary Tables
04:18
1004 B-tree Indexes
07:45
1005 Bitmap Indexes
05:49
1006 Index Organized Tables
04:03
1007 Function Based Indexes
05:08
1008 Views
04:49
1009 Primary And Unique Keys
06:52
1010 Foreign Keys
06:40
1011 Check Constraints
06:12
1012 Synonyms
05:39
1013 Sequences
08:31
Section 11: Database Security
1101 Principles Of Database Security
08:08
1102 Oracle Schema Based Approach
04:46
1103 Creating And Dropping Users
06:53
1104 System Privileges
06:43
1105 Object Privileges
05:53
1106 Roles
10:15
1107 Profiles
07:07
1108 Auditing
10:15
Section 12: Database Administrative Tasks
1201 Instance Startup
06:16
1202 Instance Shutdown
07:15
1203 Parameter File
06:46
1204 Modifying Parameters
08:18
1205 The Data Dictionary
12:14
1206 Password File
06:02
1207 ADRCI
05:17
1208 Alert Log And Trace Files
07:01
1209 Memory Management
06:28
1210 Monitoring Sessions
08:29
1211 Monitoring Space Usage
05:17

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