Web Services

Introduction to Relational Database Management Systems

Database Management Systems are used to support every systems application in use today. This class will discuss the various data models available, and how they can be used to support applications. In particular, it will discuss the Relational Data Model, which is used by systems such as DB2 and SQL Server. The SQL query language will be explored, along with database normalization and Logical Data Structures (Entity Relationship Diagrams).

1.0 Introduction to Database Management Systems

	Rationale for using database technology
	Basic concepts of data and information management
	Basic database concepts
	Database design concepts
	Fundamental issues in database technology

2.0 Data Models

	Data Dependence vs. Data Independence
	Database Terminology
	Database Models
	Methods used to Store Information in the Different Database Models

3.0 The Relational Model

	Benefits of the Relational Model Compared to Other Database Models
	Major Concepts of the Relational Model
	Operations Used in the Relational Model
	Relational Algebra

4.0 The Structured Query Language (SQL)

	Features and Benefits of Query Languages
	ANSI Standard SQL
	Creating Tables with SQL
	Performing Queries using SQL
	Performing Ordering Operations using SQL
	Performing Aggregation Operations using SQL
	Built-in Functions to Manipulate Data
	Pattern Matching Techniques to Control Selection
	Grouping Techniques and Nested Queries
	Table Joins

5.0 Database Normalization

	The Need for Effective Database Design
	Modeling a Relational Database Schema
	Relational Database Integrity
	Characteristics of Normal Forms
	Normalizing Databases
	Anomilies

6.0 Logical Modeling

	Why Use Logical Models?
	Graphical Symbols Used in Modeling
	Logical Modeling Methods
	Analyzing Schemas using Logical Models

[Back to Training Page]