Database Design I
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.
- Date:
- 2015
- Primary Material Type:
- Syllabus
- Institution:
- Housatonic Community College
- Project Name:
- Northeast Resiliency Consortium
- Funding Source:
- TAACCCT Round 3
- Subjects:
- database design, structured query language, database management, SQL, microsoft access, MYSQL, SQL techniques, information technology, IT, Northeast Resiliency Consortium, NRC
Industry / Occupation
- Industry Partner:
- N/A
- Industry Sector:
- Professional, Scientific, and Technical Services -- Professional, Scientific, and Technical Services -- Legal Services (5411)
- Occupation:
- Computer and Mathematical Occupations -- Computer Programmers (15-1021)
Education / Instructional Information
- Instructional Program:
- Computer and Information Sciences and Support Services (11)
- Credential Type:
-
- Certificate
- Associate Degree
- Educational Level of Materials:
-
- 1st year Community College or equivalent
- 2nd Year Community College or equivalent
- Language:
- English (United States)
- Interactivity Type:
- Presentation only - requires user to navigate through content.
- Quality Rubric:
- Other
- Quality Note:
- Uploaded Document Describing Third Party Review Process:
https://www.skillscommons.org/handle/taaccct/11916
- Quality of Subject Matter was assured by:
-
- Using an approved rubric to conduct the evaluation of the instructional materials and providing a report
- Quality of Online/Hybrid Course Design assured by:
-
- Course Note:
- CSC 231
Accessibility
- Accessibility Features:
-
- Text Access - Text to Speech
- Text Adjust - Compatible
- Text Adjustment - Adjust Font and Colors
- Reading Layout - Reflow the Text
- Reading Layout - Page numbers match printed material
- Reading Layout - Reflow the Text
- Reading Order - Digital resource layout
- Structural Markup - Navigation Text
- Structural Markup - Lists
- Structural Markup - eReader application
- Hyperlinks Rendered As Active
- Colors Compatible With Assistive Technology
- Contrast Ratio of at Least 4.5:1.
- Language - Markup
- Language - Passage Markup
- Non-Decorative Images Have Alt Text
- Decorative Images Marked With Null Alt Text
- Complex Images, Charts, and Graphs Have Text Descriptions
- Non Flickering Content
- Interactive - Keyboard
- Interactive - Markup
- Interactive - Text prompts
Copyright / Licensing
Except where otherwise noted, the works contained in this website are licensed under a
Creative Commons
Attribution 4.0 International License. Accessibility Support Strategy.
Terms of Service.