ITC 35000 - Databases

This course will introduce you to the concepts needed to understand database technology. Concepts covered will be SQL for data retrieval and modification; creation of tables, data types and data integrity; stored procedures, triggers, views, and functions, query performance optimization; SQL Server manageability features.

Preparation for Course
P: ITC 11000; and ITC 13000 or ECET 11400 or CS 16000.

Cr. 3.
Student Learning Outcomes
1. Use the SQL Server Management Studio.
2. Write Select statements to query a single table.
3. Write Select statements using JOINs to query multiple tables.
4. Write summary queries and subqueries.
5. Write Insert, Delete and Update statements to apply changes to the database.
6. Use correct data types in the database.
7. Write statements to Create, Alter and Drop tables in the database.
8. Write and use functions in queries.
9. Write and apply views, scripts, stored procedures, triggers and cursors.
10. Manage database transactions.
11. Retrieve data in XML format.