Learning Oracle 12c A Beginners Oracle Training Video

Learning Oracle 12c – A Beginners Oracle Training Video, available at $49.99, has an average rating of 4.65, with 102 lectures, based on 404 reviews, and has 2054 subscribers.

You will learn about Learn the fundamentals of working with Oracle Databases This course is ideal for individuals who are Programmers and Database Administrators It is particularly useful for Programmers and Database Administrators .

Enroll now: Learning Oracle 12c – A Beginners Oracle Training Video

Summary

Title: Learning Oracle 12c – A Beginners Oracle Training Video

Price: $49.99

Average Rating: 4.65

Number of Lectures: 102

Number of Published Lectures: 102

Number of Curriculum Items: 102

Number of Published Curriculum Objects: 102

Original Price: $39.99

Quality Status: approved

Status: Live

What You Will Learn

Learn the fundamentals of working with Oracle Databases

Who Should Attend

Programmers and Database Administrators

Target Audiences

Programmers and Database Administrators

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: 0101 What You Should Expect From This Course

Lecture 2: 0103 What is Oracle?

Chapter 2: The Oracle Technology Family

Lecture 1: 0201 Hardware

Lecture 2: 0202 Operating Systems

Lecture 3: 0203 Virtualization

Lecture 4: 0204 Middleware And Java

Chapter 3: Oracle Database Technology

Lecture 1: 0301 What Is A Database?

Lecture 2: 0302 Oracle RDBMS

Lecture 3: 0303 Oracle Database Server Editions

Lecture 4: 0304 Oracle Database Server Versioning

Lecture 5: 0305 Oracle Database Options

Lecture 6: 0306 Software

Lecture 7: 0307 Documentation

Lecture 8: 0308 SQL Developer

Chapter 4: Database Architecture

Lecture 1: 0401 The Oracle RDBMS – Instance And Database

Lecture 2: 0402 The Instance – Background Memory Processes

Lecture 3: 0403 The Instance – System Global Area

Lecture 4: 0404 The Instance – Program Global Area

Lecture 5: 0405 The Database – Core Datafiles

Lecture 6: 0406 The Redo Architecture

Lecture 7: 0407 Real Application Clusters

Lecture 8: 0408 Container Databases

Lecture 9: 0409 Pluggable Databases

Chapter 5: Installing The Oracle Software

Lecture 1: 0501 Planning An Installation

Lecture 2: 0502 The Oracle Universal Installer

Lecture 3: 0503 Installing The Software – Part 1

Lecture 4: 0504 Installing The Software – Part 2

Chapter 6: Creating An Oracle Database

Lecture 1: 0601 Planning Database Creation

Lecture 2: 0602 Running NETCA And DBCA

Lecture 3: 0603 Stepping Through Database Creation – Part 1

Lecture 4: 0604 Stepping Through Database Creation – Part 2

Lecture 5: 0605 Stepping Through Database Creation – Part 3

Lecture 6: 0606 Setting Up The SQL Developer

Chapter 7: Structured Query Language (SQL)

Lecture 1: 0701 What Is SQL?

Lecture 2: 0702 Select

Lecture 3: 0703 Insert

Lecture 4: 0704 Update

Lecture 5: 0705 Deletes

Lecture 6: 0706 Joins

Lecture 7: 0707 Single Row Functions

Lecture 8: 0708 Data Aggregation

Lecture 9: 0709 Optimizer And Execution Plans

Lecture 10: 0710 Transactions And Concurrency

Chapter 8: PL And SQL

Lecture 1: 0801 What Is PL And SQL?

Lecture 2: 0802 Anonymous Blocks

Lecture 3: 0803 Procedures

Lecture 4: 0804 Functions

Lecture 5: 0805 Packages

Lecture 6: 0806 Object Types

Chapter 9: Oracle Storage Structures

Lecture 1: 0901 Blocks

Lecture 2: 0902 Extents

Lecture 3: 0903 Segments

Lecture 4: 0904 Datafiles

Lecture 5: 0905 Smallfile Tablespaces

Lecture 6: 0906 Bigfile Tablespaces

Lecture 7: 0907 Automatic Storage Management – ASM

Chapter 10: Database Objects

Lecture 1: 1001 Tables

Lecture 2: 1002 Partitions

Lecture 3: 1003 Temporary Tables

Lecture 4: 1004 B-tree Indexes

Lecture 5: 1005 Bitmap Indexes

Lecture 6: 1006 Index Organized Tables

Lecture 7: 1007 Function Based Indexes

Lecture 8: 1008 Views

Lecture 9: 1009 Primary And Unique Keys

Lecture 10: 1010 Foreign Keys

Lecture 11: 1011 Check Constraints

Lecture 12: 1012 Synonyms

Lecture 13: 1013 Sequences

Chapter 11: Database Security

Lecture 1: 1101 Principles Of Database Security

Lecture 2: 1102 Oracle Schema Based Approach

Lecture 3: 1103 Creating And Dropping Users

Lecture 4: 1104 System Privileges

Lecture 5: 1105 Object Privileges

Lecture 6: 1106 Roles

Lecture 7: 1107 Profiles

Lecture 8: 1108 Auditing

Chapter 12: Database Administrative Tasks

Lecture 1: 1201 Instance Startup

Lecture 2: 1202 Instance Shutdown

Lecture 3: 1203 Parameter File

Lecture 4: 1204 Modifying Parameters

Lecture 5: 1205 The Data Dictionary

Lecture 6: 1206 Password File

Lecture 7: 1207 ADRCI

Lecture 8: 1208 Alert Log And Trace Files

Lecture 9: 1209 Memory Management

Lecture 10: 1210 Monitoring Sessions

Lecture 11: 1211 Monitoring Space Usage

Instructors

Infinite Skills
High Quality Training

Rating Distribution

1 stars: 4 votes

2 stars: 15 votes

3 stars: 50 votes

4 stars: 138 votes

5 stars: 197 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!