A01=Lee Chao
advanced database design strategies
analyzer
Author_Lee Chao
box
business intelligence applications
Business Process
Category=UMZ
Category=UN
Category=UTF
Category=UY
Column Descriptions
combo
Combo Box
data access methods
Data Mining Model
Data Model
Data Warehouse
Database Application
Database Objects
Dialog Box
Differential Backup
DTS
enterprise
Entity Instance
eq_bestseller
eq_computing
eq_isMigrated=1
eq_isMigrated=2
eq_nobargain
eq_non-fiction
Foreign Key
Front End Users
manager
networked database systems
normalization techniques
objects
ODBC Driver
OLAP analytics
open
Open Enterprise Manager
Primary Key
procedure
query
Query Analyzer
RecordSet Object
relational database modeling
Select Statement
SQL Server
SQL Server Authentication
SQL Statement
stored
Stored Procedure
User Defined Data Type
Product details
- ISBN 9780849333187
- Weight: 1292g
- Dimensions: 178 x 254mm
- Publication Date: 13 Jan 2006
- Publisher: Taylor & Francis Ltd
- Publication City/Country: GB
- Product Form: Hardback
Secure
checkout
Fast Shipping
Easy returns
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.
