Jun 21, 2024  
College Catalog 2023-2024 
    
College Catalog 2023-2024 [ARCHIVED CATALOG]

Add to Favorites (opens a new window)

ITCS 2140 - Database Programming Using Microsoft SQL Server

Credit Hours: 3.00


Prerequisites: ITCS 1170  and either ITCS 1140  or ITCS 1950  

This course instructs students on how to develop a database using Structured Query Language (SQL) and Transaction Structured Query Language (T‑SQL). Advanced querying techniques and the implementation of programming objects will also be explored.

Billable Contact Hours: 3

Search for Sections
Transfer Possibilities
Michigan Transfer Network (MiTransfer) - Utilize this website to easily search how your credits transfer to colleges and universities.
OUTCOMES AND OBJECTIVES
Outcome 1: Upon completion of this course, students will be able to implement a database design using Structured Query Language (SQL) and Transaction Structured Query Language (T-SQL).

Objectives:

  1. Given a set of design specifications student will create tables, constraints, indexes, and views with a minimum of 75% accuracy.
  2. Given a set of design specifications students will implement datatypes with a minimum of 75% accuracy.
  3. Given a set of base tables, students will alter tables, constraints, indexes, and views with a minimum of 75% accuracy.

Outcome 2: Upon completion of this course, students will be able to create and implement Transaction Structured Query Language (T-SQL) programming objects.

Objectives:

  1. Given a set of base tables, students will design, construct and debug T-SQL scripts with a minimum of 75% accuracy.
  2. Given a set of base tables, students will design, construct, implement and test T-SQL stored procedures with a minimum of 75% accuracy.
  3. Given a set of base tables, students will design, construct, implement and test T-SQL triggers with a minimum of 75% accuracy.
  4. Given a set of base tables, students will design, construct, implement and test T-SQL functions with a minimum of 75% accuracy.
  5. Given a database, students will implement transactional control with a minimum of 75% accuracy.
  6. Given a database, students will implement security protocols with a minimum of 75% accuracy.

Outcome 3: Upon completion of this course, students will demonstrate advanced querying techniques utilizing Structured Query Language (SQL) and Transaction Structured Query Language (T-SQL).

Objectives:

  1. Given a set of base tables, students will design, construct and test advanced SELECT statements utilizing aggregate functions, sorting, grouping and built-in functions with a minimum of 75% accuracy.
  2. Given a set of base tables, students will design, construct, and test subqueries with a minimum of 75% accuracy.
  3. Given a set of base tables, students will design, construct, and test the various methods to join tables in a query with a minimum of 75% accuracy.
  4. Given a set of base tables, students will apply ranking functions with a minimum of 75% accuracy.
  5. Given a set of base tables, students will implement common table expressions with a minimum of 75% accuracy.

COMMON DEGREE OUTCOMES (CDO)
  • Communication: The graduate can communicate effectively for the intended purpose and audience.
  • Critical Thinking: The graduate can make informed decisions after analyzing information or evidence related to the issue.
  • Global Literacy: The graduate can analyze human behavior or experiences through cultural, social, political, or economic perspectives.
  • Information Literacy: The graduate can responsibly use information gathered from a variety of formats in order to complete a task.
  • Quantitative Reasoning: The graduate can apply quantitative methods or evidence to solve problems or make judgments.
  • Scientific Literacy: The graduate can produce or interpret scientific information presented in a variety of formats.
CDO marked YES apply to this course:
Critical Thinking: YES
Information Literacy: YES
Quantitative Reasoning: YES
COURSE CONTENT OUTLINE
  1. Query Review.
  2. Single Table Queries and grouping data.
  3. Querying many tables.
  4. Subqueries.
  5. Working with Data Types & Functions.
  6. Creating Tables and Working with Data.
  7. Coding Scripts.
  8. Working with Procedures, Functions & Triggers.
  9. Database Security.
  10. Managing Transactions.

Primary Faculty
Jenaway, Elizabeth
Secondary Faculty

Associate Dean
Evans-Mach, Patrick
Dean
Balsamo, Michael



Primary Syllabus - Macomb Community College, 14500 E 12 Mile Road, Warren, MI 48088



Add to Favorites (opens a new window)