Database Concepts with Oracle, IT 421
About this Course:
Basic data modeling concepts are introduced. Hands-on database design, implementation, and administration of single-user and shared multi-user database applications using a contemporary relational database management system.
Prerequisites:
Good PC skills and an interest in database modeling required for enrollment.
Who Should Attend:
This course is suitable for professionals who are new to database and applications.
Expected Outcomes:
Participants will produce an advanced database application using comprehensive concepts and techniques in a sequence of gradually enhanced guided projects, will demonstrate knowledge of advanced data modeling techniques, including normalization, and the ability to apply them to real world problems, will perform advanced querying of database applications, and will be proficient in the latest version of MS Access.
Course Outline:
Database Design
UML; E-R Model; Relational Model; mapping
Normalization
Functional dependencies, normal forms, normalization process MS Access
Database Implementation
Visual Development and Visual User Interface Tools
Object-Oriented Approach
Queries
SQL language
Applications
Forms; Reports; Menus
Visual Basic for Applications (VBA)
Database Administration & Data Mining
Databases in Client/Server and Internet Applications
Data Modeling and Database Application Projects
CEU:
4.5
Instructor:
Robert Hendry
As an International Association for Continuing Education and Training (IACET) Authorized Provider, the Professional Learning Programs department of the IIT School of Applied Technology (SAT) offers CEUs for its programs that qualify under the ANSI/IACET Standard.