Database Design |
CISD 40 |
- Students completing CISD 40 - Database Design will be able to apply normalization rules to database design.
- Students completing CISD 40 - Database Design will be able to create E-R (Entity Relationship) and UML (Unified Modeling Language) diagrams for a given database scenario.
|
Database Managemen - Oracle Laboratory |
CISD 31L |
- Students completing CISD 31L will be able to create queries to retrieve data from multiple tables using Oracle functions, views, and scripts.
- Students completing CISD 31L will be able to use decision making statements, loops, and cursors in order to create a business application.
|
Database Management - Microsoft SQL Server |
CISD 21 |
- Students completing CISD 21 - Database Management - Microsoft SQL Server Lecture will be able to update database data using the SQL Server Data Manipulation Language commands.
- Students completing CISD 21 - Database Management - Microsoft SQL Server Lecture will be able to create a program using scripts and stored procedures.
- Students completing CISD21 - SQL Server Lecture will be able to understand functions for simplifying daily database tasks.
- Students completing CISD21 will be able to understand the summary queries and know how to use the aggregate functions.
|
Database Management - Microsoft SQL Server Laboratory |
CISD 21L |
- Students completing CISD21L - Microsoft SQL Server Lab will be able to use the aggregation functions to create summary queries for database tables.
- Student completing CISD21L - SQL Server Lab will be able to create database triggers to enforce referential integrity.
|
Database Management - Oracle |
CISD 31 |
- Students completing CISD 31 - Database Management - Oracle Lecture will be able to create queries to retrieve data from multiple tables using Oracle functions, views, and scripts.
- Students completing CISD 31 - Database Management - Oracle Lecture will be able to use decision making statements, loops, and cursors in order to create a business application.
- Students completing CISD31 will understand exception handling and know how to take the actions when exceptions are raised.
- Students completing CISD 31 will be able to understand subqueries.
|