Database Design I
No Thumbnail Available
Keywords
database design , structured query language , database management , SQL , microsoft access , MYSQL , SQL techniques , information technology , IT , Northeast Resiliency Consortium , NRC
Project
Northeast Resiliency Consortium
Authors
Date Submitted
2015
Material Type
Syllabus
Secondary Material Type
Institution
Housatonic Community College
Industry Partner
N/A
License
CC BY
Funding Source
TAACCCT Round 3
Additional Public Access
Abstract
This is the course outline for Housatonic Community College’s Database Design I. The course focuses on the core concepts of relational database design using Structured Query Language (SQL). Topics include the creation, organization, normalization, and maintenance of relational databases and the in-depth use of SQL for querying and data manipulation. The course requires substantial hands-on work with a modern relational database management system, such as Microsoft ACCESS, or MySQL (Preferred), in a computerized classroom environment.
Upon successful completion of the course, the student will be able to: understand the relationship between databases & tables; learn the SQL language syntax, through demonstration and practice, and its ability to create complex reports; understand the relationships that may be established between tables; understand relational database design using the concepts of proper normalization; build SQL scripts to create, modify and delete databases / tables; learn SQL techniques to add, update and delete table entries; create user functions and procedures to access database tables, design, code and test complex SQL queries; and build a level of comfort to pursue independent study / reading of SQL material and user code.
Industry (NAISC)
Professional, Scientific, and Technical Services -- Professional, Scientific, and Technical Services -- Legal Services (5411)
Occupation (SOC)
Computer and Mathematical Occupations -- Computer Programmers (15-1021)
Instructional Program (CIP)
Computer and Information Sciences and Support Services (11)
Credit Type
Credential Type
Certificate
Associate Degree
Associate Degree
Educational Level
1st year Community College or equivalent
2nd Year Community College or equivalent
2nd Year Community College or equivalent