Close Menu

SQL Databases, IT-D 822

About this Course: 

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. Students will learn the use of Structured Query Language in a variety of application and operating system environments.


IT-D 821 Database Concepts with Oracle, relational database concept, SQL and basic oracle knowledge or equivalent experience required for enrollment.

Course Outline: 

Introduction to Oracle Tables
Introduction to Stored Procedures
Exception Handling
Users and Security
Microsoft ADO
ADO and Oracle Objects
Enterprise Connections and Data Objects

Expected Outcomes: 

Upon completion of this course, participants should be able to:

  • Define the client/server architecture
  • Design databases for client/server application
  • Design and develop client/server applications for various business solutions.

Grading Details: 

Grading/CEU award for this course includes projects, labs and exams.