Database Development and Management (Hardcover)

Introduction to Database Systems
Functions of a Database
Database Management System
Database Components
Database Development Process

Conceptual Design and Data Modeling
Introduction to Database Design Process
Understanding Business Process
Entity-Relationship Data Model
Representing Business Process with Entity-Relationship
Model

Table Structure and Normalization
Introduction to Tables
Table Normalization

Transforming Data Models to Relational Databases .
DBMS Selection
Transforming Data Models to Relational Databases
Enforcing Constraints
Creating Database for Business Process

Physical Design and Database Implementation with
SQL
Physical Design
Creating, Controlling, and Modifying Database
Objects with SQL
Transporting Database Data

Querying Databases
Retrieving Data from Tables

SQL Procedures
SQL Programming Extension
Procedures and Functions
Triggers
Debugging SQL Procedures

Database Views, Indexes, and Cursors
Creating and Managing Views
Creating and Managing Indexes
Creating and Managing Cursors
Case Study: Hillcrest Computing

Accessing Data
Database Accessing
Open Database Connectivity (ODBC)
Object Linking and Embedding Database (OLE DB)
Active Data Object (ADO)

Database Application Development
Understanding Business Process
User Interface Design and Format
Creating Forms
Creating Reports

Network Databases
Client/Server Computing
Introduction to Extensible Markup Language (XML)
Developing Database Applications
with Visual Studio .NET
XML Web Services and InfoPath

Database Administration
Managing Database User Accounts and Security
Backing Up and Recovering Databases
Database Replication
Database Maintenance Plan

Data Analysis Services
Data Warehouse
OnLine Analytical Processing (OLAP)

Data Mining
Data-Mining Process
Data-Mining Algorithms
Developing Data-Mining Models in SQL Server

APPENDICES
Appendix A: Sample Databases
Student_Club Database
Hillcrest Computing Database

Appendix B: Installation of SQL Server
SQL Server Installation

Appendix C: Suggested Resources
Web Sites
Books and Articles