---

Oracle 10g DBA Free Training We are excited to let you know that we will be starting Oracle 10g DBA training course shortly. We will provide code samples along with the screen shots and step by step instructions for you to learn and practice on your own. All these tutorials are prepared exclusively for Exforsys.com by Oracle Professionals and Certified...
Oracle 10g Free Training Oracle Database Installation This document describes the step by step procedure of Oracle 10g Installation on Windows XP testing the Database installation making the test connection and frequently asked questions.Download Oracle 10g for Windows Oracle software is fee for evaluation and educational purpose. If you don t...
Oracle 10g Free training- Database Introduction This tutorial covers the basics of Database Management Systems Various types of Databases The Relational Model Benefits of RDBMS and Oracle Database along with Frequently Asked Questions. Database Management Systems A database can be regarded as having two major components and these are the data...
Oracle 10g Free Training Oracle Concepts and  Database Architecture This tutorial provides a brief overview of Architecture of Oracle database. It also gives an introduction to the concept of instance. The document discusses the structures that are used to define the physical and logical representations if Oracle Database.Oracle Database Architecture Oracle...
Oracle 10g Free Training Creating Database Using Database Configuration Assistant DBCA This tutorial explains how you can Create Database Using Database Configuration Assistant DBCA . To create database by using database configuration go to start button and click on programs -> oracle -> configuration and migration tools -> database configuration...
Oracle 10g Free Training- Administering and Managing Users This tutorial explains the ways and steps of creating and managing database accounts Creating Users through Sql Plus Creating User through iSQL PLUS Creating Users through EM Manager Users Managing Users through sqlplus and Managing Users through EM.Create Users There are few ways of...
Oracle 10g Free Training - Defining and Creating Tablespaces This tutorial provides detailed steps with introduction to tablespaces Datafiles and Creating Tablespaces using three ways via SQL Plus iSQL Plus and Enterprise Manager and also demonstrates the differences in creating the tablespaces using these 3 methods.Defining Tablespaces Each Oracle...
Oracle 10g Free Training - Managing Tablespaces This tutorial provides detailed steps about Managing Tablespaces Altering Tablespace Creating an Undo’ tablespace and Renaming a Tablespace using SQL Plus Using iSQL Plus and Enterprise Manager.Oracle 10g Free Training - Managing Tablespaces Altering Tablespace Availability a Using...
Oracle 10g Free Training Starting and Stopping the Agent This tutorials explains  Starting and Stopping the agent through Enterprise Manager command-line utility and Enterprise Manager.Starting and Stopping the Oracle Management agent When you install the Oracle Management Agent on a Windows system the installation procedure creates...
Oracle 10g Free Training Starting and Stopping the listener This tutorials explains Starting and Stopping the listener through Enterprise Manager.Startup listener through EM Open EM using following URL http 5500 em You will see the following screen Figure 7. EM Home Window Click on the Listener link Shown highlighted in the screen...
Oracle 10g Free Training Oracle Database Startup using SQL Plus and Enterprise Manager This tutorial explains how you can start the Database using SQL Plus and Enterprise Manager along with step by step screen shots.Startup database through SQL Plus Connect to an Idle instance using as sysdba command. Figure 15. Sqlplus Database login window Execute...
Oracle 10g Free Training Oracle Database Shutdown using SQL Plus and Enterprise Manager. This tutorial explains how you can shutdown the Database using SQL Plus and Enterprise Manager along with step by step screen shots. At the end of this tutorial you will find the FAQ s on Controlling the Database.Shutdown database through SQL Plus Please connect...
Oracle 10g Free Training - Creating Roles and Granting Privileges This tutorial provides the ways and steps of creating and managing database roles and privileges using three ways via SQL Plus iSQL Plus and Enterprise Manager .Create Roles There could be two ways of creating users account in oracle10g. You can directly create the users account...
Oracle 10g Free Training - Managing Roles and Privileges This tutorial provides the ways and steps of managing database roles and privileges using SQL Plus and Enterprise Manager .Managing Roles Similar to creating users user accounts can be managed either through EM or directly through sqlplus. Managing Roles through sqlplus You can use following...
Oracle 10g Free Training Overview of Schemas and Common Schema Objects In this tutorial you will learn about Overview of Schemas and Common Schema Objects - What is a Schema Schema Objects - Tables Indexes Views Clusters and Synonyms. Overview of Schemas and Common Schema Objects A schema is a collection of database objects. A schema is...
Oracle 10g Free Training Tables In this tutorial you will learn about Tables Summary of Oracle Built-In Datatypes Types of tables Restrictions to consider when Creating Tables along with logical databse limits. Tables Tables are the basic unit of data storage in an Oracle Database. A table consists of columns and rows. Data is stored in these...
Oracle 10g Free Training Creating Tables In this training you will learn about Creating Tables and Parallelizing Table Creation. Creating Tables To create a new table in your schema you must have the CREATE TABLE system privilege. To create a table in another user s schema you must have the CREATE ANY TABLE system privilege. Additionally the...
Oracle 10g Free Training - Dropping Tables In this training you will learn about Dropping Tables Consequences of Dropping a Table CASCADE Clause and the PURGE Clause. Dropping Tables To drop a table that you no longer need use the DROP TABLE statement. The table must be contained in your schema or you must have the DROP ANY TABLE system privilege. Caution Before...
Oracle 10g Free Training Altering Tables In this training you will learn about Altering Tables - Modifying an Existing Column Definition Adding Table Columns Renaming Table Columns Dropping Table Columns Removing Columns from Tables Marking Columns Unused and Removing Unused Columns.Oracle 10g Free Training Altering Tables Altering Tables You...
.Oracle 10g Free Training - Creating Index-Organized Tables Let us learn about Creating Index-Organized Tables by Creating an Index-Organized Table further by Creating Index-Organized Tables that Contain Object Types and also you will learn how to View Information about Tables. Creating Index-Organized Tables You use the CREATE TABLE statement...
.Oracle 10g Free Training - Creating Views Altering Dropping and Replacing Views In this training session you will learn about Views. This section describes aspects about Views Creating Views - Join Views Expansion of Defining Queries at View Creation Time and Creating Views with errors. Altering Views and Dropping Views. Replacing Views and...
Oracle 10g Free Training - Updating Views This tutorial teachs you how to use Views in Queries along with Restrictions on DML operations for Views. how to update a join View along with rules for updatable join views. how to use DML Statements on Join Views how to Update Views that Involve Outer Joins Using Views in...
Oracle 10g Free Training - Sequences In this tutorial you will learn about Sequences Creating Sequences Altering Sequences Using Sequences and Dropping Sequences Referencing a Sequence Generating Sequence Numbers with NEXTVAL and Using Sequence Numbers with CURRVAL. Caching Sequence Numbers the Number of Entries in the Sequence Cache...
Oracle 10g Free Training - Manipulating data through SQL This tutorial will teach users how to manipulate data using the DMLs Data Manipulation Languages through SQL through 4 types of DML statements Insert statement Update statement Delete statement and the Merge statement. Manipulating data through SQL Insert statements There could...
Oracle 10g Free Training - Data Pump Components In this tutorial let us learn about Data Pump Components viz. Import Export New Features In Data Pump Export and Import and learn how the original Import and Export utilities differ from Data Pump Import and Data Pump Export respectively. Data Pump Components Oracle Data Pump is made up of three...
Oracle 10g Free Training - Using Data Pump Import In this tutorial we shall learn about using Data Pump Import - Invoking Data Pump Import Data Pump Import Interfaces Data Pump Import Modes like Full Import Mode Schema Mode Table Mode Tablespace Mode and Transportable Tablespace Mode. Using Data Pump Import Oracle export and import utilities...
Oracle 10g Free Training - Using Data Pump Export In this tutorial we shall learn about using Data Pump Export - Invoking Data Pump Export Data Pump Export Interfaces Data Pump Export Modes like Full Export Mode Schema Mode Table Mode Tablespace Mode and Transportable Tablespace Mode. Using Data Pump Export Data Pump Export invoked with the...
Oracle 10g Free Training - SQL Loader In this tutorial we will be learning about SQL Loader How to make use of SQL Loader SQL Loader Parameters and SQL Loader Control File along with syntax considerations. SQL Loader SQL Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little...
Oracle 10g Free Training - SQL Loader - Input Data and Datafiles In this tutorial you will learn about SQL Loader - Input Data and Datafiles Fixed Record Format Variable Record Format and Stream Record Format. SQL Loader - Input Data and Datafiles SQL Loader reads data from one or more files or operating system equivalents of files specified...
Oracle 10g Free Training - SQL Loader Discarded and Rejected Records In this tutorial you will learn about Discarded and Rejected Records - The Bad File SQL Loader Rejects Oracle Database Rejects The Discard File and Log File and Logging Information Discarded and Rejected Records Records read from the input file might not be inserted into the...
Oracle 10g Tutorials - Identifying PL SQL Objects In this tutorial you will learn about indentifying PL SQL Objects like Packages Procedures and Functions using SQL Plus based examples and illustrations. Document Summary This document is a simple guide to understanding PL SQL objects such as stored procedures functions triggers etc. This...
Oracle 10g Training - Triggers And Triggering Events In this tutorial you will learn about Triggers Triggering Events Types of Triggers - DML Triggers System Triggers Instead-of Triggers and Syntax for Trigger Creation. Triggers Triggers are named PL SQL blocks that get executed implicitly when a triggering event occurs. Rather that being executed...
Oracle 10g Free Training - Synonyms In this tutorial you will learn about Synonyms Creating Synonyms Using Synonyms in DML Statements Dropping Synonyms and viewing Information About Views Synonyms and Sequences. Synonyms This section describes aspects of managing synonyms and contains the following topics About Synonyms Creating...
Oracle 10g Tutorials Oracle Net Services In this tutorial you will learn Oracle Net Services - An Overview Using Oracle Net Manager Creating Listeners Choosing General Parameters enable the tracing and logging for the database transactions. We will also learn how to use TNSPING to test Oracle Net connectivity. Document Summary This document...