Transcript INTRODUCTION ORACLE 11g

INTRODUCTION
ORACLE 11G
By Eng:Hussein Siad
Our Agenda









Relational Database Management system?
What is Oracle?
Oracle Certification ?
What is SQL
What is Pl/SQL
IDE
Create the Demonstration Schemas
Installation oracle Database
Getting Start The Oracle Environment
Relational Database Management
system?
 Relational Database Management system
 A relational database management system (RDBMS) is a program that
lets you create, update, and administer a relational Database
 Most commercial RDBMS's use the Structured Query Language (SQL) to
access the database, although SQL was invented after the development
of the relational model and is not necessary for its use.
 The leading RDBMS products are Oracle, IBM's DB2 and Microsoft's
SQL Server.
 DBMS is a software to
 Store , Protect and Access to Data
 DB Application is a software that interacts with DB
 Example : People Software -HRM
Relational database
 Relational database
 A relational Database is a collection of Data items organized as
 a set of formally-described tables from which data can be
accessed or reassembled in many different ways without
having to reorganize the database tables.
 The relational database was invented by E.F Codd at IBM in
1970.
What is SQL
SQL (pronounced "ess-que-el") stands for Structured Query Language.
SQL is used to communicate with a database.
According to ANSI (American National Standards Institute), it is the standard
language for relational database management systems.
SQL is Not a programming language but its Data Access Language
ANSI (American National Standards Institute) is the primary organization for
fostering the development of technology standards in the United States.
ANSI works with industry groups and is the U.S. member of the
International Organization for Standardization (ISO) and the International
Electro-technical Commission (IEC).
SQL Variants
 ANSI Compliance /pro. Extensions
 Pl/Sql using by Oracle
 Transact-Sql using by Microsoft
 My Sql using by Sun Micro-system
 IBM-DB 2 using by IBM
 Postgree Sql
ANSI Common Standardization Features
What is Oracle
 Oracle says it is the world's leading supplier of software for information management but
it is best known for its sophisticated relational database products.
 Oracle DB runs on most major platforms, including Windows, UNIX, Linux and Mac OS.
Different software versions are available, based on requirements and budget. Oracle DB
editions are hierarchically broken down as follows:
 Enterprise Edition: Offers all features, including superior performance and security, and
is the most robust

Standard Edition: Contains base functionality for users that do not require Enterprise
Edition’s robust package

Express Edition (XE): The lightweight, free and limited Windows and Linux edition

Oracle Lite: For mobile devices
Oracle Certification
1.
OCA
Oracle
certified
Association
2.
OCP
Oracle
certified
Professional
3.
OCM
Oracle
certified
Mastering
What is Pl/SQL
PL/SQL is a combination of SQL along with the procedural features of
programming languages. It was developed by Oracle Corporation in the early
90's to enhance the capabilities of SQL.
PL/SQL is a completely portable, high-performance transaction-processing
language.
Features of PL/SQL
PL/SQL is tightly integrated with SQL.
It offers extensive error checking.
It offers a variety of programming structures.
It supports structured programming through functions and procedures.
It supports object-oriented programming.
It supports developing web applications and server pages.
Integrated Development Environment
(IDE)
Sql *Plus
Sql Developer TOAD
Command Line Interface
Graphic Interface
More advanced Graphic interface
SQL * PLUS ENVIRONMENT
SQL DEVELOPER ENVIRONMENT
SQL ORACLE TOAD ENVIRONMENT
Create the Demonstration Schemas
the examples use tables in two demonstration schemas provided by Oracle
HR schema
OE schema
 which simulates a more complicated
 which is sample data that simulates a
order entry application.
simple human resources application
 An earlier demonstration schema was SCOTT (password TIGER). This schema is simpler than
HR or OE. Many people with long experience of Oracle will prefer to use this. The creation script
is still supplied, it is utlsampl.sql.
Users
a database user is a person who can log on
to the database.
schema
A database schema is all the objects in the database owned by
one user.
A schema is initially created empty, when a user is created with
the CREATE USER command.
Schemas are used for storing objects.
Oracle Installation Process with Screenshot
Oracle Installation Process with Screenshot
Oracle Installation Process with Screenshot
Oracle Installation Process with Screenshot
Oracle Installation Process with Screenshot
Oracle Installation Process with Screenshot
Oracle Installation Process with Screenshot
Oracle Installation Process with Screenshot
Enterprise Manager
Getting Start and Connect The Oracle Environment
How to connect PL sql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
Sqlplus
Show user
Exit
Sqlplus hr
sqlplus hr/password@orcl
Sqlplus / as sysdba //super user
Sqlplus /nolog
Using connect and disconnect
Help
Help index
QUESTIONS
ANSWERS
End chapter one
Thanks