powered by
Center for Curriculum and Transfer Articulation
SQL Server Database
Course: CIS276DB

First Term: 2020 Fall
 Lec + Lab   3.0 Credit(s)   4.0 Period(s)   4.0 Load  
Subject Type: Occupational
Load Formula: T - Lab Load


Description: A broad overview of the Microsoft Structured Query Language (SQL) Server database. Includes SQL instruction for data definition, data manipulation, and data retrieval. Develops knowledge and skills required to install SQL Server, model and create new databases, manage users, authentication, and stored procedures, and develop backup/restore strategies.



MCCCD Official Course Competencies
1. Demonstrate an understanding of data analysis involved in relational databases. (I)
2. Develop an Entity Relationship Diagram (ERD) to optimize a database`s design. (I)
3. Demonstrate an understanding of database server installation and configuration. (II)
4. Demonstrate the ability to use SQL and the client interface tools. (III, IV, V)
5. Use server-side scripting languages to access a relational database for dynamic content presentation. (III, IV, V)
6. Demonstrate the ability to add/manage users and authentication. (IV)
7. Create database objects. (IV, V)
8. Create a new SQL Server database. (VI)
9. Implement a backup/restore strategy. (VI)
MCCCD Official Course Competencies must be coordinated with the content outline so that each major point in the outline serves one or more competencies. MCCCD faculty retains authority in determining the pedagogical approach, methodology, content sequencing, and assessment metrics for student work. Please see individual course syllabi for additional information, including specific course requirements.
 
MCCCD Official Course Outline
I. Database Architecture
   A. Entity identification
   B. Model relationships and identify attributes
   C. Normalization
   D. Primary and foreign keys
   E. Table structure
   F. Data types
II. Installation
   A. System requirements
   B. Preparation for installation of database management system software
   C. Preparation for installation of client software
III. Using SQL
   A. Retrieving data
      1. Select
      2. From
      3. Where
      4. Order by
      5. Joining tables
   B. Summarizing data
      1. Aggregate functions
      2. Group by
      3. Having
   C. Subqueries
   D. Data manipulation
      1. Inserting
      2. Updating
      3. Deleting
      4. Transactions
IV. Creating and Managing Database Objects
   A. Tables
   B. Sequences
   C. Constraints
   D. Indexes
   E. Views
   F. User and role management
      1. Create users and roles
      2. Granting privileges to users and roles
V. Introduction to Programming
   A. Language structure
   B. Using variables
   C. Controlling program flow
   D. Creating and managing stored procedures, functions, and triggers
   E. Using ASP.net to establish connection and command objects
VI. Database Administration
   A. Authentication and encryption
   B. Starting and stopping the database management system
   C. Creating and removing a database
      1. Physical implementation
         a. Configuration files
         b. Data files
         c. Log files
         d. Pages
      2. Deletion
   D. Using the Data Dictionary
   E. Maintaining a database
   F. Backup and restore
 
MCCCD Governing Board Approval Date: February 25, 2020

All information published is subject to change without notice. Every effort has been made to ensure the accuracy of information presented, but based on the dynamic nature of the curricular process, course and program information is subject to change in order to reflect the most current information available.