Table of Contents

• Course Plan
• Concepts and Terms

• Module 1
• 1.1 Project Management Intro
• 1.2 What is a Database
• 1.3 Database Design Basics
• 1.4 Data Types
• 1.5 Intro to SSMS and T-SQL
• 1.6 Keyboarding Skills

• Module 2
• 2.1 Gathering Requirements
• 2.2 Standards
• 2.3 Intro to Entity Analysis
• 2.4 Date Data
• 2.5 Query Filters and Ordering
• 2.6 Creating a Database Table
• 2.7 Using the Insert Statement
• 2.8 Personal Assessment

• Module 3
• 3.1 Project Proposal: Executive Memo
• 3.2 Creating an ERD (in Visio)
• 3.3 Database Sizing
• 3.4 Database Normalization
• 3.5 Joining Tables
• 3.6 More Inserts and Filters
• 3.8 Using the Update Statement

• Module 4
• 4.1 Project Planning
• 4.2 Data Integrity
• 4.3 Constraints
• 4.4 Subqueries
• 4.5 Variables and Parameters
• 4.6 Writing Stored Procedures
• 4.7 Personal Work Log

• Module 5
• 5.1 Post-Mortem Project Reviews
• 5.2 App Support: Data Flows
• 5.3 Table Design Variations
• 5.4 CRUD Operations
• 5.5 Importing Data

• Module 6
• 6.2 Backup & Recovery Strategies
• 6.4 Grouping and Aggregates

• Module 7
• 7.1 Security: Users and Permissions
• 7.2 Data Security: Protecting Data
• 7.3 Exception Handling

• Module 8
• 8.1 Full Project Exercise
• 8.2 Making and Executing Test Plans