The Oracle 10g for Beginners course helps you learn about the world's most popular database. Expert Oracle University instructors will teach you how to use the Oracle 10 database Server and tools, Enterprise Manager, Security tools , SQLplus and so on, while helping you develop deeper knowledge of using relational databases.

Learn To:

• Explain the relational database model.
• Describe the features and benefits of Oracle DB.
• Install and configure the Oracle 10g DB server and clients.
• Design efficient databases.
• Use Structured Query Language (SQL) to build your database and query data.
• Employ appropriate iSQL tools.

Benefits to You

This course will teach you everything you need to know to start using the incredibly popular Oracle 10g database Management system which has gained wide acceptance by every industry in recent times and is applicable to your Web, Cloud and embedded applications. In learning about Oracle, you will develop an understanding of relational databases and how to design a robust and efficient database. You will harness that power by learning Oracle SQL and use it to build databases, populate them with data and query that data through extensive hands-on practices.

Manage Your Oracle 10g Database

This course also introduces you to more advanced tools and techniques to help you manage your Oracle database and data. Some of these tools is the Enterprise Manager and command line tools. At the end of the course, you will be confident in your abilities to use the MySQL database and put your new skills to work.

Database Installation and Administration
Assessing the Oracle database architecture

Defining memory structures, processes and SGA
Establishing a storage framework

Managing Oracle databases

Configuring Oracle Database 10g
Working with Oracle SQL Developer

Accessing and Manipulating Data
Retrieving data efficiently with SQL Developer

Selecting, restricting and ordering data
Avoiding pitfalls in null values
Exploiting built-in SQL functions

Applying powerful SQL techniques

Joins, outer joins and ANSI joins
Grouping data and applying aggregate functions
Combining result sets with set operators
Comparing simple and correlated subqueries

Modifying data with SQL statements

Inserting, updating, deleting and merging data
Controlling transactions with ROLLBACK and COMMIT

Creating and Managing Database Objects
Implementing the physical design

Mapping logical model to physical design
Creating users and schemas

Constructing and maintaining tables

Altering and dropping columns
Restoring data with Flashback and the recycle bin

Building views, sequences and synonyms

Filtering data with views
Generating unique IDs with sequences
Streamlining access to objects with synonyms

Maintaining Integrity, Security and Performance
Enforcing integrity

Implementing referential integrity with primary, unique and foreign keys
Managing transactions and data with deferred and enforced constraints

Securing the data

Authenticating users with password aging
Controlling access with system and object privileges
Simplifying privilege management with roles

Improving performance

Guidelines for creating indexes
Indexing the data for optimal access
Managing unique, non unique and composite indexes

Programming with PL/SQL
Writing basic programs

Controlling logic with IF and CASE statements
Performing iterations with WHILE and FOR LOOPs
Defining and managing PL/SQL records
Trapping errors with exception handlers

Processing data with cursors

Declaring cursors to perform row-level operations
Passing parameters to cursors to increase flexibility
Simplifying cursors with FOR LOOPs
Improving performance with CURRENT OF or ROW ID

Implementing Server-Side Logic
Modularizing code

Constructing procedures and functions
Debugging programs with DBMS_OUTPUT

Creating packages and triggers

Bundling subprograms in packages
Defining statement and row-level triggers
Governing triggers with conditional predicates

Required Prerequisites:

• Familiarity with data processing concepts and techniques
• Data processing

Recommended Related Training Courses:

• Oracle Database: Program with PL/SQL

This Database Program with PL/SQL training shows you how to develop stored procedures, functions, packages and database triggers. You'll learn to manage PL/SQL program units and dependencies, and usage of some of the Oracle-supplied packages.

• Oracle Database 11g: SQL Tuning Workshop Release 2

This Database 11g SQL Tuning Workshop training teaches database developers, DBAs and SQL developers to identify and tune inefficient SQL statements. Learn how to investigative methods to reveal how the Oracle database executes the SQL statement.

• Oracle Database 11g: Performance Tuning DBA Release 2

This Oracle Database 11g Performance Tuning training is an advanced curriculum course. It builds on the Introduction to Performance Tuning in the Administration Workshop I and II courses, focusing on the tuning tasks expected of a DBA.

• Oracle SQL Tuning for Developers Workshop NEW

This SQL Tuning for Developers training assists database developers, DBAs and SQL developers to identify and tune inefficient SQL statements. You'll learn to interpret execution plans and the different ways that data can be accessed.

• Oracle Database 11g: Data Mining Techniques

In this course, students review the basic concepts of data mining and learn how leverage the predictive analytical power of the Oracle Database Data Mining option by using Oracle Data Miner 11g Release 2. The Data Miner GUI provides intuitive tools that help you to explore the data graphically, build and evaluate multiple data mining models, apply Oracle Data Mining models to new data, and deploy Oracle Data Mining's predictions and insights throughout the enterprise.