Oracle school training courses in Boston, MA (public, in-house or online)

For Oracle administration training or enterprise solutions developer training, American Career Institute is your one-stop resource for the new world of IT.

IT departments are continuously changing. Today’s enterprise is made up of many applications built with a variety of technologies and running on multiple platforms. Because of the emergence of .Net, Java and XML, many of these enterprise applications are undergoing major changes.

Many companies are now looking at vast integratio...

Full archival course description>>

Earn your database administration certification at American Career Institute.

Students here learn how to perform the major tasks needed to administer and support Oracle database systems on both Microsoft Windows and Linux. And once you learn, there’s an opportunity to earn. Oracle is the most widely used database management system in the business field today. That creates a demand for skilled Oracle database administrators.

Where you’ll take your Oracle training matters too, especi...

Full archival course description>>

You 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>>

You 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>>

You 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>>