Course
Schedule
AJAX
ASP_NET
Access DB
Acrobat
ActiveDir
C# .NET Prog.
CSS (HTML)
Cisco Week
Crystal Reports
DP Design
DigCameras
Dreamweaver
E-commerce
Excel
Exchange
ExpressionWeb
FileMaker
Fireworks
Flash
HTML
Illustrator
InDesign
Introductory
JSP
Java
JavaScript
Linux
Networks
ObjectOProg.
Office2007
Oracle
Outlook
PHP
Perl
PhotoElems
Photoshop
PowerPoint
Premiere
Prog. Concpts
Project
Publisher
QuarkXPress
QuickBooks
SQL
SQL Reporting
SQLServerAdm
Security
SharePoint
SharePtAdmin
SharePtDesign
Support
TCP/IP
UNIX
VB.NET
Visio
Vista Admin
Vista Intro.
Vista Trans.
Visual Basic 6
W2003 Policy
W2003 Server
W2008 Server
Win XP Intro.
Wireless Net.
Word
XML
|
Oracle |
| ||
 | |||
|
Fundamentals of SQL Using Oracle: Level 1 (Prerequisite: Introduction to Windows and Introduction to Access or equivalent experience with another database.) This course introduces a variety of SQL commands useful in working with Oracle databases. Learn to create effective queries by using SQL SELECT statements to retrieve and sort records from your tables. Work with comparison and logical operators to display only records that meet certain criteria. Practice creating tables and inserting, updating, and deleting records. Additional topics include deleting, renaming, and truncating tables and controlling transactions by committing and reversing database changes. Fee: $189 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| G9735 | Wed., Jan. 14 | West County | Andrew Schwartz |
| |||
|
Fundamentals of SQL Using Oracle: Level 2 (Prerequisite: Fundamentals of SQL Using Oracle: Level 1 or equivalent experience.) Further your SQL skills using Oracle by refining your queries to retrieve the information you need from single and multiple tables. Understand the different types of joins and how to use them to display data from multiple tables. Learn to use a variety of SQL functions to replace null values, perform calculations, and customize the format of date data. Practice using SQL group functions to count records, determine minimum and maximum values, calculate sums and averages, and display subtotals. Additional topics include creating and understanding the appropriate uses of views and subqueries. Fee: $189 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| G9736 | Wed., Jan. 21 | West County | Andrew Schwartz |
| |||
|
Fundamentals of SQL Using Oracle: Level 3 (Prerequisite: Fundamentals of SQL Using Oracle: Level 2 or equivalent experience.) This course focuses on advanced applications of SQL in an Oracle environment, including managing tables and users. Practice creating sophisticated tables that include constraints to validate your data. Understand the rules of referential integrity and how to create primary and foreign keys that enforce these rules. Learn to modify the structure of existing tables by adding, deleting, and renaming columns. Control database access by creating users and roles and granting object and system privileges. Additional topics include writing and executing SQL scripts and creating and maintaining indexes, sequences, and synonyms. Fee: $189 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| G9483 | Fri., Oct. 3 | West County | Andrew Schwartz |
| G9737 | Wed., Jan. 28 | West County | Andrew Schwartz |
| |||
|
Oracle Programming Using PL/SQL: Level 1 (Prerequisite: Fundamentals of SQL Using Oracle: Level 2 or Accelerated Fundamentals of SQL Using Oracle or equivalent experience.) Learn how Oracle's PL/SQL programming language can help you increase the flexibility and usefulness of your database applications. Write and execute blocks of code that interact with your Oracle data by combining SQL statements with PL/SQL programming constructs. Learn how to declare and reference variables in PL/SQL and use cursors to process rows returned by a query. Practice writing conditional and looping structures to control the flow of statements within your PL/SQL blocks. Throughout the course, you will learn and apply many techniques for writing effective code, including using efficient logic, incorporating accepted naming conventions, and commenting your code. Fee: $389 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| G9495 | Thurs., Oct. 16 & Fri., Oct. 17 | West County | Andrew Schwartz |
| |||
|
Oracle Programming Using PL/SQL: Level 2 (Prerequisite: Oracle Programming Using PL/SQL: Level 1 or equivalent experience.) Extend and apply your knowledge of PL/SQL by writing reusable procedures, functions, and packages that incorporate common programming constructs along with various SQL commands and functions. Understand the different types of triggers and learn to write triggers that respond to data manipulation events, such as inserting, updating, and deleting records. Additional topics include learning effective methods for testing your code, handling errors, and managing program units and triggers. Fee: $389 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| G9496 | Thurs., Oct. 30 & Fri., Oct. 31 | West County | Andrew Schwartz |
|
| |||
