dmarrero.com
DBMS 110
Home
Getting Started
Course Plan
Keywords
Tutorials
Hide
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
Table of Contents
Full Project Exercise
Making and Executing Test Plans
Content not yet available