![]()
Syste
m (Hardware/Software)
Requirements
| Operating
Software | Windows XP or
Higher
| | Processor | Minim
um P4 or Higher
| | RAM | 1 GB or
Higher
| | Browser | Any
| | Recommended Internet
Speed | Minimum 1MBPS
| | Supported Browser
Plug-ins | * Updated
Flash Player, * Update Java
| | Other
Requirements | Speaker or
headphone | |
Prdocut DescriptionThis course is designed to give Participants a firm foundation in basic administration of Oracle Database 11g. In this class, Participants learn how to install and maintain Oracle Database 11g. Participants gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Participants learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.
Learn To:
Manage users
Manage storage structures
Backup and Recovery
Install and configure an Oracle database
Audience
Database Administrators
Database Designers
Developer
Support Engineer
Technical Administrator
Prerequisites
Required Prerequisites
Working knowledge of SQL
Oracle Database 11g: Introduction to SQL
Course Objectives
Describe Oracle Database Architecture
Install and configure Oracle Database 11g
Configure Oracle Net services
Manage the database storage structures
Create and administer user accounts
Perform basic backup and recovery of a database
Manage users and schemas
Manage data and concurrency
Monitor and administer undo data
Backup and recover a database
Monitor performance
Use the database diagnostic monitor
Course Curriculum
Section1 Introduction
Lecture1 Introduction
Section2 Oracle 11g Database Architecture
Lecture2 Oracle Archicture and process details
Lecture3 Instance, Database Buffer, Data File, Control File, Redo Log File
Lecture4 Oracle Database Architecture - Overview
Lecture5 Interacting with Oracle Database
Lecture6 Oracle Database Memory Structure
Lecture7 LGWR - LogWriter Process
Lecture8 Database Storage Architecture
Section3 Preparing Database Environment
Lecture9 Preparing Database Environment
Section4 Preparing Hardware Requirement
Lecture10 Preparing Hardware Requirement
Section5 Database creation through DBCA
Lecture11 Database creation through DBCA
Lecture12 DBCA Details
Lecture13 Database Configuration Assistant
Section6 Oracle Management Framework
Lecture14 Oracle Management Framework Part 1
Lecture15 Oracle Management Framework Part 2
Section7 Fundamentals of Sql Developer and Sqlplus Tools
Lecture16 Fundamentals of Sql Developer and Sqlplus Tools part 1
Lecture17 Fundamentals of Sql Developer and Sqlplus Tools part 2
Lecture18 Fundamentals of Sql Developer and Sqlplus Tools part 3
Section8 Shutdown and Startup Database
Lecture19 Shutdown and Startup Database Part 1
Lecture20 Shutdown and Startup Database Part 2
Lecture21 Shutdown and Startup Database Part 3
Lecture22 Shutdown and Startup Database Part 4
Lecture23 Alert log and Dictionary information
Section9 Configuring Network
Lecture24 Configuring Network Part 1
Lecture25 Configuring Network Part 2
Lecture26 Configuring Network Part 3
Lecture27 Configuring Network Part 4
Section10 Managing Database storage Structure
Lecture28 Managing Database storage Structure Part 1
Lecture29 Managing Database storage Structure Part 2
Lecture30 Managing Database storage Structure Part 3
Lecture31 Managing Database storage Structure Part 4
Lecture32 Managing Database storage Structure Part 5
Lecture33 Managing Database storage Structure Part 6
Lecture34 Managing Database storage Structure Part 7
Section11 Administering user security
Lecture35 Administering user security Part 1
Lecture36 Administering user security Part 2
Lecture37 Administering user security Part 3
Lecture38 Administering user security Part 4
Lecture39 Administering user security Part 5
Lecture40 Administering user security Part 6
Lecture41 Administering user security Part 7
Lecture42 Administering user security Part 8
Lecture43 Administering user security Part 9
Lecture44 Administering user security Part 10
Section12 Managing Schema objects
Lecture45 Managing Schema objects Part 1
Lecture46 Managing Schema objects Part 2
Lecture47 Managing Schema objects Part 3
Lecture48 Managing Schema objects Part 4
Lecture49 Managing Schema objects Part 5
Lecture50 Managing Schema objects Part 6
Lecture51 Managing Schema objects Part 7
Lecture52 Managing Schema objects Part 8
Lecture53 Managing Schema objects Part 9
Lecture54 Managing Schema objects Part 10
Lecture55 Managing Schema objects Part 11
Lecture56 Managing Schema objects Part 12
Benefits
eduCBA e-campus
Virtual campus powered by robust LMS which enables to study through internet with cutting edge features
Online Video Training Material
Presentation Slides
USP of the product
* 24 x 7 online access* Learn from tutorials curated by expert industry professionals and trainers* Certificate of Completion* Practical application oriented skillsHow to use? (Steps to use Study Material)
Step 1 - eduCBA sends the redemption coupon along with the registration link. Step 2 - Student will register with his register email id and coupon Step 3 - Student receive the course access and password on his/her email idStep 4 - Login using your email id and password and start learningTo get more information, you may want to watch the video below
Learn Everything, Anywhere, Anytime
India's Largest Online Education Marketplace
