2012
Infinite Skills
Lewis Cunningham
8:00
English
In this Oracle 11g video based training course, through the expert tutelage of Lewis Cunningham, you will learn the basics of operating an Oracle Database server and environment. You will also discover the basics of how to manage and develop for an Oracle Database, and administer one.
This tutorial is designed for the beginner. This training will teach you the basics of what it means to administer an Oracle Database. Throughout the training, you will be able to better understand the path you can continue on from here, whether that is to become a DBA, developer or administrator of Oracle Databases. You will learn about processes and architectural concepts of a database. This video training also covers topics such as storage, data modelling, basic SQL, database tasks, and how all of these apply specifically to Oracle Databases.
By the completion of this video tutorial, you will have a fundamental understanding of how an Oracle Database server and environment function, as well as how database concepts apply specifically to an Oracle Database. Working files are included to assist you as you work through this computer software training course.
01. Introduction
0101 What Is Oracle
0102 What You Should Expect From This Course
0103 Download And Install Oracle
02. The Technology - OS, Middleware, And Hardware
0201 Operating Systems
0202 Middleware
0203 Hardware
03. The Technology - Database
0301 What Is A Database?
0302 What Are The Types Of Database?
0303 MySQL
0304 TimesTen
0305 BerkleyDB
0306 NoSQL
0307 Oracle Database Server
0308 Oracle Database Server Editions
0309 Documentation And Software
04. Database Architecture
0401 Operating Systems Supported
0402 Database Server
0403 The Database
0404 Database Instance
0405 Background Memory Processes
0406 User Memory Processes
0407 System Global Area
0408 Program Global Area
0409 Networking
0410 Oracle Net Listener
0411 Real Application Clusters
05. Storage
0501 Blocks
0502 Extents
0503 Segments
0504 Tablespaces
0505 Data Files
0506 Control Files
0507 Redo Log Files
0508 Parameter File
0509 Password File
0510 Fast Recovery Area
0511 Alert Logs
0512 Trace Files
0513 ASM, Grid And Cloud
06. Database Structures
0601 The Data Dictionary
0602 Schemas And Users
0603 Tables
0604 Partitions
0605 Temp Tables
0606 B-tree Indexes
0607 Index Organized Tables (IOT)
0608 Bitmap Indexes
0609 Function Based Indexes
0610 Views
0611 Primary And Unique Keys
0612 Foreign Keys
0613 Check Constraints
0614 Synonyms
0615 Table Clusters
0616 Sequences
0617 Object Statistics
0618 Performance Views
07. Oracle IDEs
0701 Oracle SQL Plus
0702 SQL Developer
0703 Oracle Universal Installer (OUI)
0704 Oracle Enterprise Manager (OEM)
0705 Oracle Database Configuration Assistant (ODCA)
08. Structured Query Language (SQL)
0801 What Is SQL
0802 Select
0803 Insert
0804 Update
0805 Joins
0806 Deletes
0807 Merge
0808 Aggregates
0809 SQL Analytics
0810 Optimizer And Explain Plan
0811 Transactions And Concurrency
09. PL/SQL
0901 What Is PL/SQL
0902 Anonymous Blocks
0903 Procedures
0904 Functions
0905 Packages
0906 Object Types
0907 Dynamic SQL
0908 Application Express (ApEx)
10. XML
1001 What Is XML
1002 What Is XMLDB
1003 XMLType
1004 SQL/XML
1005 XQuery
1006 XML Repository
1007 XML Storage Models
11. Analysis Tasks With Oracle Data Modeler
1101 Data Modelling
1102 The Conceptual Model
1103 The Logical Model
1104 The Physical Model
1105 Deploying A Data Model
1106 Reverse Engineering
12. Database Tasks
1201 Backup And Recovery
1202 Startup And Shutdown An Instance
1203 The Listener
1204 Create And Remove Users
1205 Monitor Sessions
1206 Monitor Resources
1207 Monitoring Space Usage
1208 Adding Space
1209 Freeing Space
1210 Replication And Streams
1211 Database Scheduling
13. Data Import/Export
1301 SQL Loader
1302 External Tables
1303 Data Pump
1304 SQL Plus
1305 SQL Developer
1306 ETL Tools
14. Database Security
1401 Database Security
1402 Data Control Language (DCL)
1403 System And Object Privileges
1404 Roles
1405 DBA And Developer Access
1406 Virtual Private Database (VPD)
1407 Fine Grained Auditing (FGA)
1408 Transparent Data Encryption (TDE)
1409 SQL Injection
15. Very Large Databases (VLDB)
1501 VLDB
1502 OLAP
1503 Data Mining
16. About The Author
1601 About The Author
Download File Size:922.33 MB
|
