Oracle 12c

  1. Home
  2. Oracle-database
  3. Oracle 12c

Tags: Oracle Database

A Easy To Follow Course Designed To Teach You The Core Principals Of Working With Oracle Database Technology

Last updated 2022-01-10 | 4.1

- Learn the fundamentals of working with Oracle Databases

What you'll learn

Learn the fundamentals of working with Oracle Databases

* Requirements

* PC or Mac

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.

Who this course is for:

  • Programmers and Database Administrators

Course content

16 sections • 102 lectures

Introduction 2 lectures

0101 What You Should Expect From This Course Preview 04:03

0103 What is Oracle? Preview 04:01

The Oracle Technology Family 4 lectures

0201 Hardware Preview 02:48

0202 Operating Systems Preview 04:30

0203 Virtualization Preview 05:18

0204 Middleware And Java Preview 04:41

Oracle Database Technology 8 lectures

0301 What Is A Database? Preview 06:16

0302 Oracle RDBMS Preview 05:14

0303 Oracle Database Server Editions Preview 05:38

0304 Oracle Database Server Versioning Preview 07:41

0305 Oracle Database Options Preview 07:17

0306 Software Preview 08:58

0307 Documentation Preview 06:30

0308 SQL Developer Preview 08:40

Database Architecture 9 lectures

0401 The Oracle RDBMS - Instance And Database Preview 03:49

0402 The Instance - Background Memory Processes Preview 12:09

0403 The Instance - System Global Area Preview 07:18

0404 The Instance - Program Global Area Preview 05:58

0405 The Database - Core Datafiles Preview 10:10

0406 The Redo Architecture Preview 05:50

0407 Real Application Clusters Preview 05:56

0408 Container Databases Preview 04:35

0409 Pluggable Databases Preview 05:43

Installing The Oracle Software 4 lectures

0501 Planning An Installation Preview 06:04

0502 The Oracle Universal Installer Preview 05:41

0503 Installing The Software - Part 1 Preview 06:26

0504 Installing The Software - Part 2 Preview 03:47

Creating An Oracle Database 6 lectures

0601 Planning Database Creation Preview 04:58

0602 Running NETCA And DBCA Preview 04:43

0603 Stepping Through Database Creation - Part 1 Preview 06:42

0604 Stepping Through Database Creation - Part 2 Preview 07:05

0605 Stepping Through Database Creation - Part 3 Preview 06:21

0606 Setting Up The SQL Developer Preview 04:39

Structured Query Language (SQL) 10 lectures

0701 What Is SQL? Preview 06:55

0702 Select Preview 07:03

0703 Insert Preview 06:06

0704 Update Preview 04:25

0705 Deletes Preview 05:55

0706 Joins Preview 08:58

0707 Single Row Functions Preview 09:02

0708 Data Aggregation Preview 07:04

0709 Optimizer And Execution Plans Preview 09:40

0710 Transactions And Concurrency Preview 04:50

PL And SQL 6 lectures

0801 What Is PL And SQL? Preview 05:52

0802 Anonymous Blocks Preview 06:27

0803 Procedures Preview 05:25

0804 Functions Preview 05:38

0805 Packages Preview 06:15

0806 Object Types Preview 06:38

Oracle Storage Structures 7 lectures

0901 Blocks Preview 08:19

0902 Extents Preview 07:29

0903 Segments Preview 06:55

0904 Datafiles Preview 07:46

0905 Smallfile Tablespaces Preview 06:37

0906 Bigfile Tablespaces Preview 07:43

0907 Automatic Storage Management - ASM Preview 10:01

Database Objects 13 lectures

1001 Tables Preview 07:50

1002 Partitions Preview 09:20

1003 Temporary Tables Preview 04:18

1004 B-tree Indexes Preview 07:45

1005 Bitmap Indexes Preview 05:49

1006 Index Organized Tables Preview 04:03

1007 Function Based Indexes Preview 05:08

1008 Views Preview 04:49

1009 Primary And Unique Keys Preview 06:52

1010 Foreign Keys Preview 06:40

1011 Check Constraints Preview 06:12

1012 Synonyms Preview 05:39

1013 Sequences Preview 08:31

Database Security 8 lectures

1101 Principles Of Database Security Preview 08:08

1102 Oracle Schema Based Approach Preview 04:46

1103 Creating And Dropping Users Preview 06:53

1104 System Privileges Preview 06:43

1105 Object Privileges Preview 05:53

1106 Roles Preview 10:15

1107 Profiles Preview 07:07

1108 Auditing Preview 10:15

Database Administrative Tasks 11 lectures

1201 Instance Startup Preview 06:16

1202 Instance Shutdown Preview 07:15

1203 Parameter File Preview 06:46

1204 Modifying Parameters Preview 08:18

1205 The Data Dictionary Preview 12:14

1206 Password File Preview 06:02

1207 ADRCI Preview 05:17

1208 Alert Log And Trace Files Preview 07:01

1209 Memory Management Preview 06:28

1210 Monitoring Sessions Preview 08:29

1211 Monitoring Space Usage Preview 05:17

Database Backup And Recovery 6 lectures

1301 Backup And Recovery Concepts Preview 09:48

1302 RMAN Backups Preview 04:25

1303 RMAN Incremental Backups Preview 06:56

1304 RMAN Complete Recovery Preview 04:51

1305 RMAN Incomplete Recovery Preview 07:27

1306 RMAN Backup Maintenance Preview 05:18

Data Migration 4 lectures

1401 SQL Loader Preview 08:11

1402 External Tables Preview 04:39

1403 Data Pump Export Preview 07:22

1404 Data Pump Import Preview 04:39

Oracle Networking 3 lectures

1501 Understanding Oracle Connections Preview 04:36

1502 Networking Configuration Files Preview 04:52

1503 Listener Control Preview 04:11

Conclusion 1 lectures

1601 Wrap-Up And Review Preview 03:12