Ask Joe   

Discipline

  • Results for SLO Disciplines>

Student Learning Outcomes

Discipline: Certificate: CIS Professional Certificate in SQL - E0730
Course Name Course Number Objectives
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.