Official Course Description: MCCCD Approval: 03/23/99
CIS275CJ 19994-20036	L+L	3 Credit(s)	4 Period(s)
Implementing a Database on Microsoft Structured Query Language Server 7.0
Implementation of a database on a Microsoft (MS) Structured Query Language (SQL) Server, version 7.0. Covers database creation as well as query techniques, indexes, transactions, locks, stored procedures, triggers and distributed data. Prerequisites: CIS105 or permission of instructor.

Go to Competencies    Go to Outline
 

MCCCD Official Course Competencies:
CIS275CJ   19994-20036	Implementing a Database on Microsoft Structured Query Language Server 7.0

1.	Explain the Microsoft (MS) Structured Query Language (SQL) Server 7.0 and its supported operating system platforms. (I)
2.	Describe the SQL Server architecture, security, databases and application design options. (I)
3.	Describe the basic elements of Transact-SQL. (II)
4.	Create and configure a database. (III)
5.	Explain types of data integrity and the methods that enforce it. (IV)
6.	Plan and create indexes. (V)
7.	Demonstrate how to combine data from two or more tables. (VI)
8.	Differentiate between subqueries. (VII)
9.	Use aggregate functions to generate a single summary value. (VIII)
10.	Manage transactions and locks. (IX)
11.	Define view and lists its advantages. (X)
12.	Explain the process of a stored procedure. (XI)
13.	Explain and create a trigger. (XII)
14.	Set up a distributed environment to access data. (XIII)
15.	Write queries that access data from a linked server. (XIII)

Go to Description    Go to top of Competencies
 

MCCCD Official Course Outline:
CIS275CJ   19994-20036	Implementing a Database on Microsoft Structured Query Language Server 7.0

I. Sstructured Query Language (SQL) Server Overview A. Platforms B. Integration with Windows NT C. Integration with Microsoft (MS) BackOffice D. Services E. Client Software F. Architecture G. Security H. Databases I. Working With Server II. Transact-SQL A. Overview B. SQL Server Programming Tools C. Programming Language D. Elements E. Executing Statements F. Processing Queries III. Database Creation A. Basics B. Working With Databases C. Modifying Databases D. Creating Filegroups E. Library Database F. Creating Data Types G. Creating Tables H. Generating Scripts IV. Implementing Data Integrity A. Types of Data Integrity B. Enforcing C. Using Constraints D. Using Defaults and Rules E. Enforcement Methods V. Planning and Creating Indexes A. Definitions B. Guidelines C. Architecture D. CREATE INDEX Statement E. CREATE INDEX Options F. Maintenance G. Performance Considerations VI. Querying Multiple Tables A. Combing Data B. Join Types 1. Inner 2. Outer 3. Cross 4. More than 2 Tables 5. A Table to Itself C. Combining Multiple Result Sets D. Creating a Table from Result Set VII. Advanced Query Techniques A. Subqueries B. Nested Subqueries C. Correlated Subqueries D. EXISTS and NOT EXISTS Keywords E. Modifying Data VIII. Summarizing Data A. Aggregate Functions B. GROUP BY Fundamentals C. Aggregate Values Within Result Sets D. COMPUTE and COMPUTE BY Clauses E. TOP n Values IX. Managing Transactions and Locks A. Overview B. Transactions C. SQL Server Locking D. Locks X. Implementing Views A. Definitions B. Advantages C. Modifying Data D. Performance Considerations XI. Implementing Stored Procedures A. Definition B. Initial Processing C. Subsequent Processing D. Advantages E. Creating F. Executing G. Modifying H. Using Parameters I. Executing Extended Procedures J. Error Messages K. Performance Considerations XII. Implementing Triggers A. Definition B. Creating C. Altering and Dropping D. INSERT E. DELETE F. UPDATE G. Nested H. Recursive I. Examples XIII. Working with Distributed Data A. Setting Up Environment B. Querying a Linked Server C. Executing a Stored Procedure D. Modifying E. Managing

Go to Description    Go to top of Competencies    Go to top of Outline