Database development and management Book

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