Introduction to database management techniques using Microsoft Access includes fundamentals of database design and programming with emphasis on relational file processing. Meets concurrently with credit course INT-1150. Text required. For the online version of this class visit www.pgcconline.com for details. Students must have an Owl Link account and a college e-mail address.
DPR-624 Introduction to Database Design 0.6 CEU
This class covers the logical and comprehensive approaches to defining what your anticipated outcomes/needs are and then how to most effectively attain your information goals by developing considered database parameters. Prerequisite: Personal Computers (PC ) knowledge and MS-Access or permission of the instructor. No text required. Please bring a USB compatible flashdrive to every class session.
2 sessions, $75* (includes a $25 lab fee) Next Class offered in the Fall Semester.
DPR-327 Introduction to SQL 2.4 CEUs
For many new or intermediate database developers, it's difficult to know where to start when designinga relational database. It's easy to make the mistake of assuming that the functionality of a database will take shape over time, or the design will fall into place as you build the database. This course covers the steps to effectively plan and design functional, efficient databases. It will start
with an introduction to SQL and Relational Database Management Systems, the Fundamentals of SQL Concepts and Principles, and Creating and altering RDBMS objects. Prerequisites: Before taking this course, you should have a basic understanding of your computer's operating system. For example, you should know how to launch an application, create and save files, and copy files from CD and other media. You should have some familiarity with data tables and basic knowledge of how to create queries in microsoft Access. Text: The SQL Bible by Kreigel and Trukhnov.
4 sessions, $150* (includes a $40 lab fee) Next Class offered in the Fall Semester.