Oracle Database 11g: Program with PL/SQL
Course
In London
Description
-
Type
Course
-
Location
London
This Oracle Database 11g Release 2 DBA - Part I course is designed to give the Oracle database administrator practical experience in setting up, administering and troubleshooting an Oracle 11g Release 1 or Release 2 database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database and perform basic backup and recovery of the database.The delegate will practise:Installing and Configuring OracleCreating and Managing an Oracle DatabaseAdministering an Oracle DatabaseConfiguring the Oracle Network EnvironmentCreating and Managing Database Storage StructuresManaging Redo Log Files and Control FilesManaging Schema ObjectsManaging Users, Profiles, Privileges and RolesManaging Undo Data and Temporary SegmentsMonitoring and Resolving Lock ConflictsMaintaining Database SecurityMonitoring the Performance of the DatabaseLoading and Unloading DataBacking Up and Recovering the Database
Facilities
Location
Start date
Start date
About this course
Please select from the dates below to make an enquiry or booking.
Pricing
Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.
Reviews
Subjects
- Network Training
- IT Auditing
- Network
- Database training
- PL/SQL
- SQL
- Database
- Server
- Auditing
- Access
Course programme
Modules
Hide all
Introduction to Oracle Database 11g (3 topics)
- Relational database concepts
- Database administration tasks
- DBA responsibilities
Oracle Database 11g Architecture (7 topics)
- Oracle database architecture
- The Oracle instance
- Memory structures
- Background processes
- Server and client processes
- The Oracle database
- Overview of Oracle ASM architecture
Installation and Configuration of an Oracle Database (12 topics)
- System Hardware Requirements
- Optimal Flexible Architecture
- Authentication methods for a database
- Oracle environment variables
- Install Oracle software using the Oracle Universal Installer (OUI)
- Silent Install
- Use the database Configuration Assistant (DBCA)
- Create a database with DBCA
- Manage a database with DBCA
- Delete a database with DBCA
- Manage Templates using DBCA
- Upgrade a database using Database Upgrade Assistant (DBUA)
Administer a Database Instance (8 topics)
- Administrative tools available to a DBA
- Using SQL*Plus in Oracle to manage a database
- Administer the database using Enterprise Manager (EM)
- Start and stop the EM Database Console
- Access EM
- EM navigation
- Grant EM administrative privileges to a user
- Overview of Oracle Restart
Configure the Oracle Network Environment (14 topics)
- Overview of network configuration
- Oracle Net Listener configuration and management
- Oracle Net Naming methods
- Tools for configuring and managing the Oracle network
- Use Enterprise Manager to create and configure the Listener
- Configure client connections with Net Manager
- View listener configuration
- Start and stop the Oracle listener
- Enable Oracle Restart to monitor the listener
- Use TNSPING to test Oracle Net connectivity
- Connect to the database
- Configure Net Services with Enterprise Manager
- Overview of Shared Server architecture
- Identify when to use Shared Servers and when to use Dedicated Servers
Manage an Oracle Instance (10 topics)
- Access an Oracle database
- Database authentication methods
- Password file
- The Startup Process
- The Shutdown Process
- Initialization parameters
- Shutdown a database and instance using SQL
- Startup a database and instance using SQL
- View alert log and trace files
- View or modify initialization parameters with EM
Tablespace and Datafile Management (13 topics)
- Overview of tablespaces and datafiles
- Use EM to view the storage structure of the database
- Create and alter tablespace commands
- Locally managed tablespaces
- Dictionary managed tablespaces
- Bigfile tablespaces
- Temporary tablespaces
- Multiple temporary tablespaces
- Create tablespaces
- Manage tablespaces
- Use standard and non-standard block sizes
- Create and manage tablespaces using OMF
- Drop tablespace command
Manage Redo Logs (12 topics)
- Redo log overview
- Plan redo logs
- Redo log data dictionary tables
- Log switches and checkpoints
- Log file maintenance
- Add and drop log file members and groups
- Clear a log file
- Move or rename an online redo log file
- Multiplex redo log files
- Use EM to manage redo logs
- Manage online redo log files with OMF
- List redo log information
Manage Control Files (8 topics)
- The usage of the control file
- The contents of a control file
- Manage control files
- Replace a lost or damaged control file
- Mirror a control file
- Standby control file
- Manage control files with OMF
- List control file information
Manage Schema Objects (9 topics)
- Create a new table
- View the attributes and contents of a table
- Understand data integrity
- Define constraints
- Alter tables
- Create indexes
- View index attributes
- Create views
- Create and use sequences
Manage Users (10 topics)
- Database administration accounts
- User accounts
- Create a user account
- Operating system authentication
- Change a user's password
- Manage a user account
- Drop a user account
- Monitor user information
- Terminate user sessions
- Product user profiles
Manage Profiles and Resources (7 topics)
- Overview of user profiles
- Profile resource parameters
- Create profile command
- Manage passwords with profiles
- Control resource usage with profiles
- Maintain profiles
- Drop profiles
Managing Privileges (11 topics)
- Database access
- Oracle supplied roles
- System level privileges
- Object level privileges
- The grant and revoke commands
- Create roles
- Modify and drop roles
- Control the availability of roles
- Use predefined roles
- Synonyms
- Listing valid grants
Database Auditing (8 topics)
- Overview of database auditing
- Auditing SYS statements
- Auditing end user sessions
- Statement auditing
- Privilege auditing
- Auditing modifications made to database objects
- Audit table relocation
- Auditing from Enterprise Manager
Undo Management (11 topics)
- Undo data overview
- Monitor and administer undo
- Configure undo retention
- Switch undo tablespaces
- Specify the retention period
- Guarantee undo retention
- Retention period for flashback queries
- View undo space information
- Use the undo advisor
- Size the undo tablespace
- Manage undo with EM
Moving Data (15 topics)
- Create directory objects
- Data Pump Export and Import
- Data Pump architecture
- Data Pump data dictionary views
- Data Pump interactive mode
- Data Pump API
- Use Data Pump to export data
- Use Data Pump to import data
- SQL Loader
- Overview of SQL Loader
- Command line parameters
Oracle Database 11g: Program with PL/SQL