CIS Professional in SQL (Certificate M0811)
Business Division
Certificate M0811
The SQL Server certificate is designed to prepare students for a career in database administration using SQL Server. The certificate offers a balanced set of classes that provides students skills in database design, data retrieval and database programming. Emphasis is placed on building databases; retrieving data; creating and maintaining database objects; writing stored procedures, functions and triggers for reusable software components. Students will demonstrate the ability to view and update databases and develop programs to automate database functions. Opportunities available after the completion of this certificate include SQL Server report writer, SQL Server developer and software engineer.
Required Courses
Course Prefix | Course Name | Units |
---|---|---|
CISD 21 | Database Management - Microsoft SQL Server | 3 |
CISD 21L | Database Management - Microsoft SQL Server Laboratory | 0.5 |
CISD 31 | Database Management - Oracle | 3 |
CISD 31L | Database Management - Oracle Laboratory | 0.5 |
CISD 40 | Database Design | 3 |
Total Units | 10 |
Program Learning Objectives
Upon successful completion of this program, a student will be able to:
- Apply normalization rules to database design.
- Create E-R (Entity Relationship) and UML (Unified Modeling Language) diagrams for a given database scenario.
Review Student Learning Outcomes (SLOs) for this program.
Looking for guidance? A counselor can help.This Guided Pathways for Success (GPS) is a suggested sequence of coursework needed for program completion. It is not an official educational plan. Schedule an appointment with a counselor or advisor as soon as possible to create an individualized Mountie Academic Plan (MAP) specific to your goals and needs.
Fall Term | Units | |
---|---|---|
CISD 21 | Database Management - Microsoft SQL Server | 3 |
CISD 21L | Database Management - Microsoft SQL Server Laboratory | .5 |
CISD 31 | Database Management - Oracle | 3 |
CISD 31L | Database Management - Oracle Laboratory | .5 |
Units | 7 | |
Spring Term | ||
CISD 40 | Database Design | 3 |
Certificate: Professional Certificate (SQL) M0811 1 | ||
Submit petition: inside.mtsac.edu, Student Tab #45 5 | ||
Units | 3 | |
Total Units | 10 |