|
|
Certificate Program
Course Description and Prerequisites:
This accelerated learning experience gives students a comprehensive knowledge of the client/server environment. Working hands-on, students learn client/server architecture fundamentals, relational database analysis and design, and network communications systems. They learn to use key software tools to develop applications in a client/server environment.
Students must have some previous programming experience to enroll in this class.
Module Overviews:
Module 1: Introduction to Client/Server, Hardware, and Operating Systems
The fundamental information required to grasp the concepts of Client/Server technology is provided. In this module, students will receive an overview of Client/Server architecture, be introduced to Client/Server terminology, and discuss the difference between two-tier and three-tier Client/Server models. The networking portion of the program will focus on network hardware and software, and include a discussion of the Internet as a platform for Client/Server applications.
Module 2: Database
Fundamentals and Building Database Systems
The fundamentals of database design, including how relational
database systems are built, are taught. Students
will design databases using the relational database model, and learn how relational databases fit into on-line
transaction processing (OLTP) applications. The module continues with a detailed study of Relational Database
Management Systems (RDBMS) and SQL concepts. Students will then begin the design of an Oracle database
for a Client/Server application.
Module 3: Advanced Oracle
This module teaches more advanced topics in Oracle by introducing students to Oracle programming in
PL/SQL. Students will learn to create stored procedures and functions, packages, and triggers.
Students will also learn how to manipulate data with cursors and utilize Oracle's built-in
functions. These concepts will be applied to the Client/Server application final project.
Module 4: Designing Client/Server Application Systems
The design and development of Client/Server applications for various business
solutions, incorporating Client/Server application design, business system planning, analysis,
development and implementation are discussed. Students will learn how to design event-driven applications utilizing
application management tools. Students will also discuss the capabilities and benefits of
object-oriented programming.
| Instructor | Bob Hendry |
| Credit | 4.5 CEU |
Oracle in Client/Server Technology Schedule
Information & Registration:
To register or for additional information contact us by phone or email
Chicago or Wheaton 630-682-6035
reif@iit.edu