Introduction
- Retrieving data using the SQL select statement
- Restricting and sorting data
- Using single row functions to customize reports
- Reporting aggregated data using the group functions
- Displaying data from multiple tables
- Using sub queries to solve queries
- Using the set operators
- Manipulating data
- Using DDI statements to create and manage tables
- Creating other schema objects
- Managing objects with data dictionary views
- Controlling user access
- Generating reports by grouping related data
- Managing data in different time zones
- Searching data using advanced sub queries
- Hierarchical data retrieval
Introduction to PL/SQL objects
- Procedural language
- PL/SQL blocks, anonymous blocks and named blocks
- Creating PL/SQL procedures and functions
- Understanding triggers
- Packages
Oracle 10g-administration workshop I
Introduction
- Installing oracle database 10g software
- Create an oracle database
- Database interfaces
- Controlling the database
- Storage structures
- Administering users
- Managing schema objects
- Managing data
PL/SQL
- Oracle database security
- Oracle net services
- Oracle shared server
- Performance monitoring
Proactive maintenance
Objectives undo management
- Monitoring and resolving lock conflicts
- Backup and recovery concepts
- Database backups
- Database recovery
Oracle 10g-administration workshop II
- Using globalization support
- Securing the oracle listener
- Configuring recovery manager
- Using recovery manager
- Diagnostic sources
- Recovering from non-critical losses
- Database recovery
- Flashback database
- Recovering from user errors
- Dealing with database corruption
- Automatic database management
- Monitoring and managing storage
- Automatic storage management
- Monitoring and managing memory
- Managing resources
- Automating tasks with the scheduler
Studied or Worked here? Share Your Review
Please do not post:
Thank you once again for doing your part to keep Edarabia the most trusted education source.