|
|
Course Description and Prerequisites:
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 are required for enrollment.
Expected Outcomes:
At the completion of the course, each successful student
1) will have produced an advanced database application using comprehensive concepts and techniques in a sequence of gradually enhanced guided projects;
2) would have demonstrated knowledge of advanced data modeling techniques, including normalization, and the ability to apply them to real world problems;
3) will have performed advanced querying of database applications;
4) will be proficient in the latest version of MS Access.
Course Syllabus:
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
| Instructor | Alexander Manov |
| Credit | 4.5 CEU |
Database Fundamentals Using Access Schedule
Information & Registration:
To register or for additional information contact us by phone or email
Chicago or Wheaton 630-682-6035
reif@iit.edu