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

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