1. Introduction > 
  2. Previous Syllabi

Previous Syllabi

Previous Versions of this page:

  • CC 520 Syllabus - Spring 2024
  • Syllabus

6.0.0

Last modified by: weeser Jan 16, 2024

CC 520 Textbook

  • 0. Introduction
    • 0. CC 520 Syllabus - Spring 2025
    • 1. MS SQL Server Access
    • Previous Syllabi
      • 0. CC 520 Syllabus - Spring 2024
      • 0. Syllabus
  • 1. Introduction to Databases
    • 1. Database Overview
    • 2. What is a Database?
  • 2. Introduction to Tables and Constraints
    • 1. Introduction to Tables and Constraints
    • 2. Key, Check, and Default Constraints
  • 3. Single Table Queries
    • 3.1 Single Table Queries Part 1
      • 1. Single Table Queries Part 1
      • 2. SELECT FROM
      • 3. WHERE
      • 4. GROUP BY - HAVING
      • 5. Processing Order
    • 3.2 Single Table Queries Part 2
      • 1. Single Table Queries Part 2
      • 2. DISTINCT
      • 3. TOP Results
      • 4. OFFSET-FETCH
    • 3.3 Single Table Queries Part 3
      • 1. Single Table Queries Part 3
      • 2. CASE
      • 3. Variables
      • 4. Character Types
      • 5. Date Time
  • 4. Joins
    • 1. Introduction to Joins
    • 2. Cross Joins
    • 3. Inner Joins
    • 4. Join Variations
    • 5. Join Review
    • 6. Outer Joins
  • 5. Subqueries
    • 1. Introduction to Subqueries
    • 2. Scalar Self-contained Subqueries
    • 3. Multi-value Self-contained Subqueries
    • 4. Correlated Subqueries
    • 5. Multi-value Correlated Subqueries Part 1
    • 6. Multivalue Correlated Subqueries Part 2
  • 6. Table-valued Expressions
    • 1. Introduction to Table-valued Expressions
    • 2. Derived Tables
    • 3. Common Table Expressions
    • 4. Views and Inline Table-valued Functions
    • 5. The Apply Operator
  • 7. Window Functions
    • 1. Introduction to Window Functions
    • 2. Rank Window Functions
    • 3. Aggregate Window Functions
    • 4. Offset Window Functions
  • 8. Set Operators
    • 1. Introduction to Set Operators
    • 2. Union
    • 3. Intersect
    • 4. Except
  • 9. Obtaining Good Design
    • 1. Database Design Principles
    • 2. Database Design Example
    • 3. Obtaining Good Database Design
    • 4. Functional Dependencies
    • 5. Functional Dependency Examples
    • 6. Anomolies and Armstrong Rules
    • 7. Closure Sets
    • 8. Super Keys
    • 9. BCNF Decomposition with Functional Depenencies
    • 10. BCNF Decomposition with Closure Sets
    • 11. Lossless Decomposition
    • 12. Limitations of BCNF Decomposition
    • 13. Other Normal Forms
    • 14. Third Normal Form vs BCNF
  • 10. Design Patterns and Practices
    • 1. General Database Design Practices
    • 2. Database Relationship Types
    • 3. Relationship Variants
    • 4. Database Subclasses
    • 5. Union Types
    • 6. Weak Entities
    • 7. The Multiple Path Problem
  • 11. Data Modification
    • 1. Insert
    • 2. Identity & Sequence Objects
    • 3. Delete & Truncate
    • 4. Update
    • 5. Merge
    • 6. Output
  • 12. Programmable Objects
    • 1. Batches
    • 2. Temporary Table Constructs
    • 3. Views & User Defined Functions
    • 4. Stored Procedures
    • 5. Triggers
    • 6. Error Handling
  • 13. Databases and Applications
    • 1. Applications & Databases
    • 2. Applications & DB Example
  • 14. Transactions and Indexes
    • 1. Indexes
    • 2. Transactions & Concurrency 1
    • 3. Transactions & Concurrency 2
    • 4. Transaction Log
  • 15. Potpourri

  •  
  •  
  •  

Built using Hugo and Hugo Relearn Theme.


© Copyright 2023, Joshua L. Weese and John Keller. All rights reserved.