Today's database professionals must understand how to apply database systems to business processes and how to develop database systems for both business intelligence and Web-based applications.
Database Development and Management explains all aspects of database design, access, implementation, application development, and management, as well as data analysis for business intelligence. This self-contained text gives students hands-on projects required for professionally developing and managing databases. It provides detailed instruction via an easy-to-follow, step-by-step case-based approach.
Following an introduction to database components, the book uses case studies to illustrate the modeling process, covers table structures and normalization, and analyzes the transformation of a data model to a relational database. It explains the use of SQL in managing database objects and in querying databases, then discusses Transact-SQL and the views, indexes, and cursors that bridge databases and their applications.
The book examines three major data-accessing techniques, and then shows how to develop sophisticated applications based upon the material included in previous chapters. It explores the use of databases in network environments, and details the multiple tasks handled by database administrators (DBAs).
The text also discusses the OnLine Analytical Processing (OLAP) system, data warehousing, and other analysis tools that support business intelligence and decision making. It concludes with a review of data mining.
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
Biography
Lee Chao
