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.
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.
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.
UML; E-R Model; Relational Model; mapping
Functional dependencies, normal forms, normalization process MS Access
Visual Development and Visual User Interface Tools
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