Ask Joe   
Mt. SAC Emergency Alert

Alert: Mt. SAC is transitioning online. CLASSES will resume online after March 28. Instructors will communicate next steps to students. OFFICES are shifting to remote services as well. Learn more about our COVID-19 response at www.mtsac.edu/health.

Read More

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.