ITE 117: Introduction to Databases and SQL Programming

Course Description

This course will focus on the design and implementation of SQL and NoSQL databases. Topics include how to design, develop, and implement relational database management systems to solve business problems as well as NoSQL systems. (3 credits)

Prerequisite

  • None

Student Learning Outcomes (SLOs)

Students who successfully complete this course will be able to:

  1. Explain why organizations use DBMS and assess its advantages.
  2. Design a logical database model to represent organizational data effectively.
  3. Transform a logical database model into a physical database design using best practices.
  4. Develop SQL queries to create, modify, and retrieve data from database management systems.
  5. Evaluate issues that affect database administration, including performance and data integrity.
  6. Analyze and implement database security measures to safeguard sensitive data.
  7. Describe an enterprise data warehouse and identify how it supports data mining.
  8. Explore NoSQL databases.

Course Activities and Grading

AssignmentsWeight

Discussions (Weeks 1-8)

5%

Minicase Assignments (Weeks 1-7)

35%

Chapter Quizzes (Weeks 1-5, 7 & 8)

5%

Coursera Quizzes (Weeks 3, 4, 6 & 7)

5%

Coursera Labs (Weeks 3, 4, 6 & 7)

40%

Final Exam (Week 8)

10%

Total

100%

Required Textbook

Available through Charter Oak State College's Book Bundle

  • Gillenson, Mark. Fundamentals of Database Management Systems. 3rd ed. Wiley & Sons, 2023. ISBN-13: 9781119907428

Course Schedule

Week

SLOs

Readings and Exercises

Assignments

1

1

Topics: Introduction to Database Management Systems

  • Readings:
    • Chapter 1
    • Chapter 2
  • Read assigned chapters
  • Review the lecture material
  • Participate in the Discussions
  • Install Smartdraw
  • Submit Week 1 Quiz - Chapters 1 & 2
  • Submit Week 1 Assignment - Minicase #1, Page 35

2

1,5,6

Topics: The Database Concept

  • Readings:
    • Chapter 3
  • Read assigned chapter
  • Review the lecture material
  • Participate in the Discussions
  • Submit Week 2 Quiz - Chapter 3
  • Submit Week 2 Assignment - Minicase #1, Page 57: Parts E, F, and G

3

4

Topics: SQL

  • Readings:
    • Chapter 4
    • SQL: A Practical Introduction for Querying Databases - Module 1
  • Read assigned chapter
  • Review assigned link
  • Review Coursera module
  • Review the lecture material
  • Participate in the Discussions
  • Submit Week 3 Quiz - Chapter 4
  • Submit Week 3 Assignment - Minicase #1, Page 93: Parts A-M
  • Submit Week 3 Coursera quiz and labs

4

2

Topics: Logical Database Design

  • Readings:
    • Chapter 5
    • Chapter 6
    • Chapter 7
    • SQL: A Practical Introduction for Querying Databases - Module 2
  • Read assigned chapters
  • Review Coursera module
  • Review the lecture material
  • Participate in the Discussions
  • Submit Week 4 Quiz - Chapters 5-7
  • Submit Week 4 Assignment - Minicase #1, Page 124: Parts B, D, and G
  • Submit Week 4 Coursera quiz and labs

5

2,3

Topics: Physical Database Design

  • Readings:
    • Chapters 8
  • Read assigned chapter
  • Review the lecture material
  • Participate in the Discussions
  • Submit Week 5 Quiz - Chapter 8
  • Submit Week 5 Assignment - Page 223: Questions 1, 2, and 4

6

4

Topics: SQL Revisited 

  • Readings:
    • SQL: A Practical Introduction for Querying Databases - Module 3
  • Review Coursera module
  • Participate in the Discussions
  • Submit Week 6 Assignment - Minicase #2, Page 93: Parts A-F
  • Submit Week 6 Coursera quizzes and labs

7

8

Topics: NoSQL

  • Readings:
    • Chapter 13
    • Get Started with Cloud Native, DevOps, Agile, and NoSQL - Module 4
  • Read assigned chapter
  • Review Coursera module
  • Review the lecture material
  • Participate in the Discussions
  • Submit Week 7 Quiz - Chapter 13
  • Submit Week 7 Assignment - Minicase #1, Page 340
  • Submit Week 7 Coursera quiz and labs

8

7

Topics: The Data Warehouse

  • Readings:
    • Chapter 12
  • Read assigned chapter
  • Review the lecture material
  • Participate in the Discussions
  • Submit Week 8 Quiz - Chapter 12
  • Submit Week 8 Final Exam
  • Complete Course Evaluation

COSC Accessibility Statement

Charter Oak State College encourages students with disabilities, including non-visible disabilities such as chronic diseases, learning disabilities, head injury, attention deficit/hyperactive disorder, or psychiatric disabilities, to discuss appropriate accommodations with the Office of Accessibility Services at OAS@charteroak.edu.

COSC Policies, Course Policies, Academic Support Services and Resources

Students are responsible for knowing all Charter Oak State College (COSC) institutional policies, course-specific policies, procedures, and available academic support services and resources. Please see COSC Policies for COSC institutional policies, and see also specific policies related to this course. See COSC Resources for information regarding available academic support services and resources.