'CISD' -- CIS Database Courses
 
   
 

 
CISD 21 Course Image

CISD 21 - Database Management
                - Microsoft SQL Server
                  (4.0 units)
This course provides comprehensive instruction in the Structured Query Language (SQL) and transact-SQL for Microsoft's SQL Server users.  Students design a database, create database objects, view and update data, define cursors, develop program units, manage transations, and handle database security.

The student receives extensive hands-on instruction on a Windows-based personal computer.
 
(54 hours lecture;  54 hours lab;  Degree applicable)
Advisory Prerequisite:   CISB 11 - Computer Information Systems
                                         and  CISB 15 - Microcomputer Applications

Course Measurable Objectives:

  1. Review data from single and multiple tables.
  2. Insert, update and delete data from database.
  3. Create database objects such as views.
  4. Design, create, and maintain database.
  5. Create cursors and stored program units.
  6. Manage transactions and database security.

Course Level Student Learning Outcomes:


Students completing CISD 21 - Database Management - Microsoft SQL Server will be able to:
  1. update database data using the SQL Server Data Manipulation Language commands.
  2. create a program using scripts and stored procedures.
Send questions or comments about this Web site to the  Business Division's  Web Content Manager .
Use of this Web server is subject to the Mt. San Antonio College   Terms of Use  and  Privacy Policy .
 
   
Invisible Login Button