Course details



Course Overview
(PL/SQL, Workshop I & Workshop II)
Oracle 10g- Introduction to SQL and PL/SQL
Course Contents:
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 DDL 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
Oracle 10g-Administration Workshop I
Course Contents:
Installing Oracle Database 10g Software
Create an Oracle Database
Database interfaces
Controlling the database
Storage Structures
Administering users
Managing Schema Objects
Managing Data
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
Course Contents:
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 Updated on 25 November, 2019

About Informatics

INFORMATICS is the only institute where you get real valuable coaching. INFORMATICS stands unique from the rest of the institutes by evidently giving you return on your investment in terms of performance improvement.

INFORMATICS seeks to improve the human condition by advancing knowledge and fostering creativity. It does so through research and education and a commitment to social justice, human rights and a sustainable environment. It values: excellence in research and scholarship, excellence in education, excellence in management, international focus, innovation and creativity, diversity, fairness, engagement, integrity, and self-reliance.

See all Informatics courses
Courses you can instantly connect with... Do an online course on Oracle starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?