ITEC2701 SQL/NoSQL Database Design
This course covers relational databases and the efficient design of these databases. The course will include the definition of tables and indexes, logical and physical design, entity relationships, and transaction management. The use of Structured Query Language (SQL) and NoSQL (nonSQL) databases will be emphasized.
Course Requirements and Evaluation
Refer to Course Syllabus for detailed information regarding the requirements and evaluation standards for this course. The Course Syllabus will be distributed the first week of the course.
Learning Outcomes
The following outcomes will be addressed in the course:
Describe benefits of Database Management Systems
Compare the hierarchical, network, and relational database models
Create relational database tables
Manage the relationship between tables using candidate keys, primary keys, and foreign keys
Utilize data using the data dictionary
Contrast one-to-many, many-to-many, and one-to-one relationships
Develop Entity Relationship (ER) models
Utilize dependencies
Normalize data structures to Third Normal Form (3NF)
Develop database designs using the Database Life Cycle
Manipulate the database using DML, DDL, and DCL
Control concurrency of data using transactions
Contrast Data Warehouse with OLTP systems
Formulate SQL queries to retrieve data
Use relational algebra operators
Text and References
A list of textbooks required for this course is available at the
campus store and in eServices.
Course Scheduling
The scheduled hours of instruction include sixteen hours for each lecture credit, thirty-two hours for each lab credit, and forty hours for each credit of supervised occupational experience (SOE). Lecture credit may include formal or impromptu lectures, demonstrations, or discussions with the entire class or with small groups or individuals. Refer to the Course Credits section of this course outline for the credit breakdown.
Accommodations Statement
Access Services - Reasonable accommodations are available to qualified students with documented disabilities. Upon attending an intake meeting with Access Services, qualified students will receive a letter listing the approved accommodations that they may provide to their instructors. If you have a documented disability that may require accommodations, contact HTC Access Services at
AccessServices@hennepintech.edu or
https://hennepintech.edu/current-students/access-services/index.html.
Campus
Brooklyn Park Campus and Eden Prairie Campus: 952-995-1300
Credit Details