Oracle SQL Resource

Integrated Languages Curriculum
Introduction to Oracle9i: SQL consists of two modules, SQL1 and Extended Data Retrieval with SQL.
SQL1 covers creating database structures and storing, retrieving, and manipulating data in a relational
database. Extended Data Retrieval with SQL covers advanced SELECT statements, Oracle SQL, and
iSQL*Plus Reporting.
For people who have worked with other relational databases and have knowledge of SQL, another course,
called Introduction to Oracle9i for Experienced SQL Users is offered. This course covers the SQL
statements that are not part of ANSI SQL but are specific to Oracle.
Introduction to Oracle9i: PL/SQL consists of two modules, PL/SQL Fundamentals and Develop PL/SQL
Program Units. PL/SQL Fundamentals covers PL/SQL basics including the PL/SQL language structure,
flow of execution and interface with SQL. Develop PL/SQL Program Units covers how to create stored
procedures, functions, packages, and triggers as well as maintaining and debugging program code.
SQL for End Users is geared towards individuals with little programming background and covers the basic
SQL statements. This course is for end users that need to know some basic SQL programming.
Advanced PL/SQL is appropriate individuals who have experience in PL/SQL programming. and covers
coding efficiency topics, object-oriented programming, working with external code, and the advanced
features of Oracle-supplied packages.
----------------

Oracle9i Features
Oracle offers a comprehensive high-performance infrastructure for e-business. It is called Oracle9i.
Oracle9i includes everything needed to develop, deploy, and manage Internet applications.
Benefits include:
• Scalability from departments to enterprise e-business sites
• Robust reliable, available, secure architecture
• One development model, easy deployment options
• Leverage an organization’s current skillset throughout the Oracle platform (including SQL, PL/SQL,
Java, and XML)
• One management interface for all applications
• Industry standard technologies, no proprietary lock-in

------------------
Oracle9i Application Server
The Oracle9i Application Server (Oracle9iAS) runs all your applications. The Oracle9i Database stores all
your data.
Oracle9i Application Server is the only application server to include services for all the different server
applications you’ll want to run. Oracle9iAS can run your:
• Portals or Web sites
• Java transactional applications
• Business intelligence applications
It also provides integration between users, applications, and data throughout your organization.



Oracle9i Database
The roles of the two products are very straightforward. Oracle9i Database manages all your data. This is not
just the object relational data that you expect an enterprise database to manage. It can also be unstructured
data like:
• Spreadsheets
• Word documents
• Powerpoint presentations
• XML
• Multimedia data types like MP3, graphics, video, and more
The data does not even have to be in the database. Oracle9i Database has services through which you can
store metadata about information stored in file systems. You can use the database server to manage and
serve information wherever it is located.