Course details
The overall objective of this course is to allow the participant to gain the skills necessary for basic day-to-day administration of an Oracle10g database. This course is the starting for Oracle database administrators and also sets the foundation for advanced administrator training and certification.
Prerequisites:
Mandatory prerequisites for this course: ORACLE DATABASE 10G: INTRODUCTION TO SQL – COMPLETE LIBRARY,ORACLE DATABASE 10G: PROGRAM WITH PL/SQL – PART II
INSTALLING ORACLE 10G DATABASE SOFTWARE :
- Identify database system requirements
- The optimal flexible architecture (ofa)
- Configure the installation environment
- Installation using the universal installer
- More about enterprise manager
EXPLORING THE ORACLE DATABASE ARCHITECTURE :
- General database architecture
- Database instance memory architecture
DATABASE INSTANCE PROCESS ARCHITECTURE :
- About the instance process architecture
- Instance background processes
- Sql execution processes
CREATING AN ORACLE DATABASE :
- Create a database
- Configure & drop a database
- Manage dbca templates
- Manually creating a database
CONTROLLING THE DATABASE ENVIRONMENT :
- Starting & stopping database control
- Starting & stopping isql*plus
- Starting & stopping the database listener
- Starting & stopping the database
- More about the database files
- Handling parameter files & parameter settings
STORAGE STRUCTURES: TABLESPACES :
- About tablespaces
- Tablespace management
STORAGE STRUCTURES: ADVANCED TABLESPACES :
- More about temporary tablespaces
- About temporary tablespace groups
- More about permanent tablespaces
- More about bigfile tablespaces
- More about the sysaux tablespace
STORAGE STRUCTURES: DATA FILES & TEMP FILES :
- Managing data files
- Managing temp files
- About oracle-managed files (omf)
UNDO MANAGEMENT :
- About undo space management
- Configure undo management
- Guarantee undo retention
- Monitor undo space
- Use the undo advisor
DATABASE SECURITY :
- Database system privileges
- Database object privileges
- Audit database activity
- Register for security updates
ADMINISTERING USERS :
- Create & manage database accounts
- Grant & revoke database privileges
- Resource limits via profiles
- Password management via profiles
- About role-based security
MANAGING DATA: LOADING DATA WITH SQL LOADER :
- About the database utilities
- Using the loader
- Understanding the loader process
- Control file options • direct path loads
MANAGING DATA: EXPORTING & IMPORTING DATA :
- Create directory objects
- Expdp
- Impdp oracle net services
- What is oracle net services?
- Oracle net manager
- Listener configuration
- Listener administration
- Lsnrctl commands
- Configuring client parameters
- Isolating the problem
- Oracle trace assistant
- Network troubleshooting utilities
ORACLE SHARED SERVERS :
- Shared servers architecture
- Configuration of shared server mode
MONITORING & RESOLVING LOCK CONFLICTS :
- About latches & locks
- More about latches
- More about locks
BACKUP & RECOVERY CONCEPTS :
- About database backup & recovery
- About redo data
- Redo log file maintenance
- Managing the archive options
- More about the control file
Course Location
About Professional Training Solutions Ltd
Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.
they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.
their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:
restructuring for competitiveness
productivity improvements through updating work processes to match new technology
managing outstheircing
strategic financial planning and engineering
their methodology is to:
Work closely with clients to understand and help them prioritise their needs
Design and deliver the best mix of training activities and consultancy to establish the competencies required
Provide ongoing coaching to sustain the improved practices and processes
they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.
their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.
See all Professional Training Solutions Ltd coursesOracle Related Questions
Are you from Professional Training Solutions Ltd ? Claim your course!
Courses you can instantly connect with... Do an online course on Oracle starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Practical Database Design – Blog Schema Course LineAED 89Duration: Upto 6 Hours
- Managing People Courses Distance Learning Ltd.AED 184
AED 367Duration: Upto 2 Hours
