Oracle Administration

• Software installation and the creation of new databases.
• An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures.
• Management of database files.
• Specialized facilities intended to maximize performance of enterprise-scale transactional applications, such as the shared SQL and PL/SQL cache, the result cache, the database buffer cache, and other similar components.
• Management of security policies and procedures, including administration of user accounts, roles, privileges and profiles.
• Utilization of advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework.
• Performance monitoring, problem troubleshooting, and resolving lock and conflict issues.
• Using the Oracle Enterprise Manager and SQL interfaces for administration tasks.
• Control over database support services, including the Database Control, Oracle Net and others.
• A primer on backup and recovery structures and strategies.
• Operating system-specific considerations for various platforms, especially Linux and MS Windows Serve

Microsoft Outlook

Oracle SQL Fundamentals Course Outline

Module 1: Relational Database Concepts

• Basic Concepts
• Different Keys and Their Functions

Module 2: Using SQL*Plus and SQL Developer

• Overview of SQL*Plus
• Working with SQL*Plus
• Introducing the SQL Developer
• Components of SQL Developer

Module 3: SQL Functions

• Retrieving Data with the Select Statement
• Using the Aggregate Functions
• Joining Tables
• Numeric Character and Date Functions
• Conversion Functions

Module 4: SQL Parameters

• Parameter Declaration
• Keyword and Parameter Descriptions

Module 5: Using Subqueries

• Subqueries
• Subqueries with the Select Statement
• Subqueries with Insert and Update

Module 6: Managing Data

• About Database Management
• Monitoring Databases
• Administering Databases

Module 7: Managing Tables

• Guidelines for Table Management
• Creating Tables
• Creating a Temporary Table
• Loading Tables
• Automatically Collecting Statistics on Tables
• Altering Tables
• Dropping/Truncating Tables
• Managing External Tables
• Creating External Tables
• Altering External Tables
• Dropping External Tables
• System and Object Privileges for External Tables
• Viewing Information About Tables

Module 8: Managing Indexes and Views

• About Indexes
• Index Management
• About Views
• Creating Views

Module 9: Managing Sequences and Synonyms

• About Sequences
• Creating Sequences
• Altering Sequences
• Dropping Sequences
• About Synonyms
• Creating Synonyms
• Dropping Synonyms

Module 10: Retrieve Data Using Subqueries

• Types of Subqueries
• IN and NOT IN Subqueries

Module 11: Hierarchical Queries, Grouping Features, and Large Data Sets

• Hierarchical Queries
• Enhanced Grouping Features
• Managing Very Large Databases

Module 12: Flashback Technology

• Overview of Oracle Flashback Technology
• Using Flashback Features in Application Development
• Using Flashback Features in Database Administration
• Configuration of Database for Flashback Technology

Module 13: Date, Time, And Time Zone Support

• Introduction to Time Zone Support
• Datetime and Interval Datatypes

Module 14: Regular Expression Support

• Introduction to Regular Expressions
• Implementation of Oracle Database Regular Expressions

Module 15: Manage Objects with the Data Dictionary

• Introduction to Data Dictionary
• Structure of Data Dictionary
• How the Data Dictionary is Used?

Module 16: Manage Schema Objects

• Introduction to Schema Objects
• Creating Multiple Tables and Views in a Single Operation
• Analysing Tables, Indexes, and Clusters
• Schema Object Management Privileges

Module 17: Access Control

• Introduction
• Access Meditation
• Understanding User Authentication
• Securable, Principals, and Permissions