Oracle 10g and SQL Training

Introduction to Oracle 10g for Developers - 35 Hour Online Class or 5 Day Classroom

For experienced developers and DBAs who are new to Oracle, this class provides a hands-on overview of Oracle 10g, focusing on Oracle’s implementation of SQL and data base programming language, PL/SQL. Covers an introduction to Oracle 10g and SQL*Plus; Datatypes, Tables and Indexes; querying including simple SELECT, Joins, Aggregate Functions, Subqueries, and Set Operators; data manipulation, transaction control and concurrency control; overview of Oracle Security; comprehensive introduction to PL/SQL including language fundamentals, concepts, use with SQL, error-handling and tuning.

Online Class Schedule

Request a Class

 		 

Request More Info

  

Topic Summary | Print Version

Class Description:

This course is designed for experienced application developers who are new to Oracle 10g database development. You will learn the skills required to work as an application developer in an Oracle 10g database environment. At the core of these skills are Oracle's implementation of SQL and Oracle's database programming language, PL/SQL.

Hands-on workshops constitute approximately 50% of the class.

Audience: Developers, DBAs

Prerequisites: Experience with a procedural language (e.g. Java, C or COBOL). Relational database experience is helpful but not required.

Next Courses: Advanced Queries for Oracle Databases, SQL Tuning for Developers and DBAs, Advanced PL /SQL Programming.

 

Skills Learned (Objectives): After successfully completing this course, you will be able to:

  • Code Oracle 10g SQL statements including SELECT, UPDATE, DELETE, MERGE, INSERT, Multi-Table INSERT, CREATE, ALTER, DROP and PURGE
  • Incorporate sophisticated techniques into SQL statements such as regular expressions, case expressions, scalar functions and aggregate functions
  • Code sophisticated SQL query operations such as inner join, outer join, ANSI join, subqueries, aggregations (GROUP BY, ROLLUP, CUBE)
  • Use Oracle 10g DML features such as DML error logging
  • Understand and work effectively within Oracle's transaction and concurrency (locking) control models
  • Implement best practices with Oracle datatypes such as VARCHAR2, XML, DATE and TIMESTAMP
  • Grant and revoke object and system privileges, and incorporate the use of roles into a security model
  • Create database objects such as tables, indexes, views, synonyms and sequences
  • Code efficient, scalable PL/SQL programs that include common programming constructs such as data-typing, variable assignment, flow control, cursor handling, bulk processing, array processing and error handling
  • Create PL/SQL stored procedures that accept and return values or sets of values
  • Manage stored procedure dependencies and privileges
  • Create PL/SQL functions, including powerful table functions and pipelined table functions
  • Create database triggers for auditing, complex business rule support, simple replication and more
  • Create and maintain Oracle packages
  • Use the UTL_FILE package to read and write to operating system files.
  • Use the UTL_MAIL package to send email from an Oracle database
  • Use the DBMS_PROFILER package to profile and tune PL/SQL programs
  • Do simple benchmarking of PL/SQL code with the DBMS_UTITLITY package
  • Query Oracle data dictionary tables such as USER_TABLES and USER_OBJECTS

Topic Summary

To Top | Topic Summary