Database Management Technology Course Information
Curriculum | Course Descriptions | Textbooks | Send Info | Enroll
BUS 5610 Database Management Technology
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
