Developing SQL Queries for Oracle Databases
School: Learning Tree International
Venue: Annapolis, Atlanta, Baltimore, Boston, Chicago, Dallas, Los Angeles, New York, Philadelphia
Tel.: 1-888-843-8733You Will Learn How To
Formulate complex queries with Oracle SQL
Apply the full range of complex query types
Use the analytic OLAP functions of Oracle
Test SQL queries completely
Select the most efficient solution to complex SQL problems
Choose between Oracle and ANSI style joins
Course Benefits
SQL forms the cornerstone of all relational database operations. Taking full advantage of its power requires an in-depth understanding of the language. In this co...
Full archival course description>>
|
Application Development and Tuning for Oracle Databases
School: Learning Tree International
Venue: Annapolis, Atlanta, Baltimore, Boston, Chicago, Dallas, Los Angeles, New York, Philadelphia
Tel.: 1-888-843-8733You Will Learn How To
Design and implement efficient applications while incorporating Oracle features
Load data into Oracle databases using SQL*Loader or external tables
Maintain and secure the database with advanced application techniques
Enhance applications with key Oracle-provided packages
Improve query performance using the Oracle-provided toolset
Tune applications for optimal performance
Course Benefits
Developing efficient, secure, high-performanc...
Full archival course description>>
|
Oracle PL/SQL Programming
School: Learning Tree International
Venue: Annapolis, Atlanta, Baltimore, Boston, Chicago, Dallas, Los Angeles, New York, Philadelphia
Tel.: 1-888-843-8733You Will Learn How To
Develop efficient PL/SQL programs to access Oracle databases
Create stored procedures and functions for maximum reuse and minimum code maintenance
Design modular applications using packages
Manage data retrieval for front-end applications
Bulk bind collections to increase the speed of data movement operations
Invoke native dynamic SQL to develop high-level abstract code
Course Benefits
The Oracle PL/SQL language—a flexible procedura...
Full archival course description>>
|
Oracle Database 10g:Backup, Recovery and Server Tuning
School: Learning Tree International
Venue: Annapolis, Atlanta, Baltimore, Boston, Chicago, Dallas, Los Angeles, New York, Philadelphia
Tel.: 1-888-843-8733You Will Learn How To
Deploy backup and recovery strategies to safeguard Oracle 10g databases
Perform recovery operations to maintain consistent and available data
Failover to hot standby databases for high availability
Exploit automated backup and recovery techniques with Recovery Manager
Implement flashback and logmining to roll back user and logical errors
Tune the Oracle 10g server by controlling memory allocation, disk I/O and locking/latch contention
Cour...
Full archival course description>>
|
Oracle Database 10g Administration
School: Learning Tree International
Venue: Annapolis, Atlanta, Baltimore, Boston, Chicago, Dallas, Los Angeles, New York, Philadelphia
Tel.: 1-888-843-8733You Will Learn How To
Create, configure and maintain Oracle 10g databases
Optimize space and performance for effective storage management
Maximize database efficiency using the Oracle Enterprise Manager
Ensure database security by managing user privileges and roles
Implement Oracle partitions to manage large tables and indexes
Deploy appropriate backup, recovery and flashback procedures
Course Benefits
Databases represent the core of an organization’...
Full archival course description>>
|
