Course Description
Introduces basic concepts of database management. Examines database systems from organization and management perspectives. Includes concepts, tools and techniques used to design, implement and use a database system. Also includes database architecture, conceptual and relational data models, structured query language (SQL), administration, concurrent processing, and data warehousing and mining.
Week 1
Lecture: Course Introduction
Lecture: SQL Server Express 2008 Installation
Outcomes
- Know how data and databases add value to a business as a resource and for competitive advantage
- Understand the need for data management
- Identify business sources for data collection requirements in developing a data management system
- Identify data management concerns inclusive of data accuracy and security
Week 2
Lecture: Keys
Lecture: Entity Relationship Diagram (ERD) Examples
Outcomes
- Understand key database concepts and terminology
- Understand basic database models and their use in industry
- Identify database components as part of the database architecture
- Understand the role of people and procedures in a database environment
- Understand the database design process
- Apply Entity-Relationship (E-R) data modeling concepts
Week 3
Lecture: SQL Server Express 2008 Creating Objects
Outcomes
- Understand how to convert an E-R data model to a database design
- Identify the importance of data normalization
- Know how to apply data normalization for improving database design
- Understand types of data integrity and recognize data integrity issues
- Know how to use SQL language to create objects
- Know how to create tables, indexes, and views based on physical design requirements
Week 4
Lecture: Group Function
Lecture: SQL Server Express 2008: Data Manipulation
Outcomes
- Understand SQL fundamentals, operators, and functions
- Know the basic SQL language components
- Understand the use of arithmetic, comparison, and logical expressions
- Recognize and write DML/DDL query statements
Week 5
Lecture: Behind the Scenes
Lecture: SQL Basics
Outcomes
- Understand how to manipulate data using simple and advanced SQL queries
- Design and write SQL queries using joins and subqueries
- Identify how scripts and batches are executed
Week 6
Lecture: Indexes
Outcomes
- Identify tools and utilities for measuring performance
- Understand how indexes improve data retrieval
- Know the use of views for data filtering
- Understand basic concepts of local area networks configuration requirements
- Describe the importance of distributed databases in the global marketplace
- Identify distributed data support issues
- Know about Internet issues associated with database management
Week 7
Lecture: Database Administration
Outcomes
- Understand the basics of database administration
- Know the responsibilities of a database administrator
- Identify management tasks associated with database administration
- Understand transaction tasks associated with database administration
- Describe concurrency errors and their causes
- Know the basics of concurrency control management
Week 8
Outcomes
- Understand database connectivity concepts and requirements
- Know about managing database access control
- Identify appropriate physical data storage options
- Know how to protect data and keep it safe
- Identify the basics of data backup mechanisms
The course description, objectives and learning outcomes are subject to change without notice based on enhancements made to the course. November 2011