|
|
Course Description and Prerequisites:
Advanced topics in database management and programming including client server application development are introduced. Expands knowledge of data modeling concepts and introduces object-oriented data modeling techniques. Participants will learn the use of Structured Query Language in a variety of application and operating system environments. Current technologies included in this course include SQL in Microsoft SQL Server, Oracle and MySQL
IT 421 Database Fundamentals With Access or equivalent experience required for enrollment.
Who Should Attend:
Professionals, who are interested in learning about client/server technology, designs of databases and developing client/server applications for business solutions.
Course Description:
Introduction to Client/Server, Hardware, and Operating Systems
The fundamental concepts of client/server technology are introduced. Participants 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.
Database Fundamentals and Building Database Systems
The fundamentals of database design, including how relational database systems are built, are taught. Participants 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.
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. Participants will learn how to design event-driven applications utilizing application management tools. Participants will also discuss the capabilities and benefits of object-oriented programming. Advanced Oracle
This module teaches more advanced topics in Oracle by introducing participants to Oracle programming in PL/SQL. Participants will learn to create stored procedures and functions, packages, and triggers. Participants will also learn how to manipulate data with cursors and utilize Oracle's built-in functions.
| Instructor | Kevin Vaccaro |
| Credit | 4.5 CEU |
Information & Registration:
To register or for additional information contact us by phone or email
Chicago or Wheaton 630-682-6035
reif@iit.edu