Learning Oracle 12c - A Beginners Oracle Training Video

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

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.

Who this course is for:

  • Programmers and Database Administrators

Instructor

High Quality Training
  • 4.3 Instructor Rating
  • 120,188 Reviews
  • 1,254,531 Students
  • 327 Courses

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.

Expected Outcomes

  1. Learn the fundamentals of working with Oracle Databases Course content 16 sections • 102 lectures • 11h 3m total length Expand all sections Introduction 2 lectures • 8min 0101 What You Should Expect From This Course Preview 04:03 0103 What is Oracle? Preview 04:01 The Oracle Technology Family 4 lectures • 17min 0201 Hardware Preview 02:48 0202 Operating Systems 04:30 0203 Virtualization 05:18 0204 Middleware And Java 04:41 Oracle Database Technology 8 lectures • 56min 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 Database Architecture 9 lectures • 1hr 1min 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 Installing The Oracle Software 4 lectures • 22min 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 Creating An Oracle Database 6 lectures • 34min 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 Structured Query Language (SQL) 10 lectures • 1hr 10min 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 PL And SQL 6 lectures • 36min 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 Oracle Storage Structures 7 lectures • 55min 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 Database Objects 13 lectures • 1hr 23min 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 6 more sections 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 Show more Show less Featured review Rogers Titi 24 courses 12 reviews Rating: 5.0 out of 5 2 years ago awesome , gave it 5 star coz he break the whole oracle down to the simplest form. with this lectures you can be ready for 12c oca and ocp . i enjoythe leactures. thanks. i wish you come out with some quizz as well. Show more Show less Instructor Infinite Skills High Quality Training 4.3 Instructor Rating 120,188 Reviews 1,254,531 Students 327 Courses 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6777abddfd76e5f4',m:'60812f933544d53db35ff959c94e3b6f394dc69b-1627743365-1800-Aahj+DQsMDYOuxYWXJJxYUypOQe9Q8jvUQoVfyG0ZC2R01smPUtpahQ0NgPwGGZSxH0vir/UgwhCm5iRwEddqKhXBGHUc98yQJc5I9qNIqLMKXhhvDYrIss0Hk4HF9kPtw97JRlBJjyvxHslOO5su28=',s:[0x49e64e845a,0x6ecc5ccbd6],}})();