DATABASE DESIGN AND SQL

  • Program: Information Technology/Computer Careers
  • Course: Database Design and SQL
  • Course #: CCIS2701
  • Total Credits: 4

Course Description

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, the E-R model, and transaction management. The use of Structured Query Language (SQL) will be emphasized.

Course 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.

Disability Services

Hennepin Technical College offers reasonable accommodations to qualified students with disabilities. If you have a documented disability that may require accommodations, contact the college’s Disability Services Director: Sara Laviolette at Brooklyn Park (763-488-2477) or Jean Kreutter at Eden Prairie (952-995-1544).

Course Goals

The following goals 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
Implement many to many relationships using the bridge entity
Develop E-R models
Utilize dependencies
Normalize data structures to 3rd Normal Form
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

Credit Details
  • Lecture: 4
  • MnTC Goal: 0
Course Details
  • Prerequisites:  CCIS1000
  • Campus: Brooklyn Park/Eden Prairie

Apply Now Search Awards Search Courses