We will dispatch the device containing course content within 72 Hrs of purchase. This DVD may be used to get started and continue with the course.
Duration: 11.25 hours - 104 tutorial videos
Table of Contents Course
01. Introduction
What You Should Expect From This Course
About The Author
What is Oracle?
0104 How To Access Your Working Files
02. The Oracle Technology Family
Hardware
Operating Systems
Virtualization
Middleware And Java
03. Oracle Database Technology
What Is A Database?
Oracle RDBMS
Oracle Database Server Editions
Oracle Database Server Versioning
Oracle Database Options
Software
Documentation
SQL Developer
04. Database Architecture
0401 The Oracle RDBMS - Instance And Database
0402 The Instance - Background Memory Processes
0403 The Instance - System Global Area
0404 The Instance - Program Global Area
0405 The Database - Core Datafiles
0406 The Redo Architecture
0407 Real Application Clusters
0408 Container Databases
0409 Pluggable Databases
05. Installing The Oracle Software
0501 Planning An Installation
0502 The Oracle Universal Installer
0503 Installing The Software - Part 1
0504 Installing The Software - Part 2
06. Creating An Oracle Database
0601 Planning Database Creation
0602 Running NETCA And DBCA
0603 Stepping Through Database Creation - Part 1
0604 Stepping Through Database Creation - Part 2
0605 Stepping Through Database Creation - Part 3
0606 Setting Up The SQL Developer
07. Structured Query Language (SQL)
0701 What Is SQL?
0702 Select
0703 Insert
0704 Update
0705 Deletes
0706 Joins
0707 Single Row Functions
0708 Data Aggregation
0709 Optimizer And Execution Plans
0710 Transactions And Concurrency
08. PL And SQL
0801 What Is PL And SQL?
0802 Anonymous Blocks
0803 Procedures
0804 Functions
0805 Packages
0806 Object Types
09. Oracle Storage Structures
0901 Blocks
0902 Extents
0903 Segments
0904 Datafiles
0905 Smallfile Tablespaces
0906 Bigfile Tablespaces
0907 Automatic Storage Management - ASM
10. Database Objects
1001 Tables
1002 Partitions
1003 Temporary Tables
1004 B-tree Indexes
1005 Bitmap Indexes
1006 Index Organized Tables
1007 Function Based Indexes
1008 Views
1009 Primary And Unique Keys
1010 Foreign Keys
1011 Check Constraints
1012 Synonyms
1013 Sequences
11. Database Security
1101 Principles Of Database Security
1102 Oracle Schema Based Approach
1103 Creating And Dropping Users
1104 System Privileges
1105 Object Privileges
1106 Roles
1107 Profiles
1108 Auditing
12. Database Administrative Tasks
1201 Instance Startup
1202 Instance Shutdown
1203 Parameter File
1204 Modifying Parameters
1205 The Data Dictionary
1206 Password File
1207 ADRCI
1208 Alert Log And Trace Files
1209 Memory Management
1210 Monitoring Sessions
1211 Monitoring Space Usage
13. Database Backup And Recovery
1301 Backup And Recovery Concepts
1302 RMAN Backups
1303 RMAN Incremental Backups
1304 RMAN Complete Recovery
1305 RMAN Incomplete Recovery
1306 RMAN Backup Maintenance
14. Data Migration
1401 SQL Loader
1402 External Tables
1403 Data Pump Export
1404 Data Pump Import
15. Oracle Networking
1501 Understanding Oracle Connections
1502 Networking Configuration Files
1503 Listener Control
16. Conclusion
1601 Wrap-Up And Review
Learn Everything, Anywhere, Anytime
India's Largest Online Education Marketplace
