Course Content
Introduction to SQL
- Introduction
- Basic SQL statements,restricting&sorting data
- single row functions
- Joins
- Group functions,subqueries
- Isql * plus,manipulating data
- creating &managing tables
- constraints,views
- other database objects,controlling user access
- controlling user access
- Sql workshop
- Set operators,date time functions
- Advanced subqueries
- Hierarchical retrival
- Extentions to DML and DDL
ORACLE FUNDAMENTALS -1
- Introduction
- Oracle architectural components
- Oracle installation
- creation of new database
- Identifying database administrative users
- Managing an oracle instance
- Dynamic & datadictionary views
- managing the control file
- Maintaining redo log files
- Maintaining tablespaces&datafiles
- Creating and managing undo tables spaces
- Describing storage hierarchy
- Storage structures and relationships
- managing undo data, Managing tables
- Managing Indexes,Identifying unused indexes
ORACLE FUNDAMENTALS -II
- Networking overview
- server side configuration
- client side configuration
- oracle shared server
- backup & recovery overview
- Logical backups
- configuration of the database archivelog
- Instance and media recovery structures
- RMAN configuration
- user managed backups
- complete recovery
- incomplete recovery
- RMAN backups
- RMAN respiratory maintenance
- RMAN catalog creation and usage
PERFORMANCE TUNING
- introduction to PT
- Diagnostic and tuning tools
- tuning the shared pool
- tuning the DB cache
- Dynamic instance resizing
- Sizing other SGA components
- tuning the shared server
- optimizers
- sql statement tuning
- managing statistics
- using oracle block efficiency
- partitioning of tables
- materialized views
- locking mechanism
- tuning operating system