The Certificate in Microsoft Access Database Programming provides students with the theories and skills necessary to develop databases. This Certificate prepares adult learners to seek entry-level career positions such as: Database Developer, Database Analyst, Database Designer, Database Specialist, and Microsoft Access Developer. Students will develop entity relationship diagrams, perform data modeling, design databases, normalize table structures, develop effective graphical user interfaces (GUI), and interact with the database using ANSI standard SQL. While enrolled in this certificate, the student will: Differentiate between the hierarchical, network, relational, and object-relational database models; and demonstrate the need for procedural language facilities in the world of American National Standards Institute (ANSI) standard SQL. Examine the process for developing entity diagrams, designing databases, developing database applications, managing databases, implementing data integrity, assuring information, and implementing transaction processing. Assess the impact and issues related to relational databases, entity diagrams, and PL/SQL on Information Technology Management, enterprise applications and on global e-commerce. Analyze the need, the objective, and the principles of Normalization to engineer and design databases. Evaluate the concepts and principles of integrity (including referential integrity and transactional integrity) in the context of relational database design.
|
