Send More Info
Apply Now
Classroom Login
Call Now
Call Now 855-300-1469

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


  • 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


  • 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


  • 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


  • 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


  • 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


  • 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


  • 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


  • 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