ITCS 2140 - Database Programming Using Microsoft SQL Server

Credit Hours: 3.00

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.

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

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.