| | |  | Software Engineering | Home » » » Database Development and Management (Foundations of Database Design) | | | | | | | Product Promotions: | | | | | Description: | | 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. | | | Product Details: | | | Author:
| Lee Chao | | Hardcover:
| 607 pages | | Publisher:
| Auerbach Publications | | Publication Date:
| January 13, 2006 | | Language:
| English | | ISBN:
| 0849333180 | | Product Length:
| 10.32 inches | | Product Width:
| 7.26 inches | | Product Height:
| 1.52 inches | | Product Weight:
| 2.8 pounds | | Package Length:
| 10.0 inches | | Package Width:
| 7.2 inches | | Package Height:
| 1.4 inches | | Package Weight:
| 2.8 pounds | | Average Customer Rating:
|  based on 4 reviews |
| | | | Customer Reviews: | |
Average Customer Review:
 ( 4 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
An Excellent Foundation Re:(Building & Managing databases): The whole Ball of WaxMar 13, 2006
By Pocket Rocket
"Pock-dot-Rock"
The 3 customer reviews i saw for this book are quite accurate in this readers opinion. this book provides an excellent foundation for database design
however, i think giving just the in-topic highlights would have helped an interested reader like myself,in making a more informed decision; and as such, i thought i might include these here in a review :
Re:
(A.) Database Implementation & Design elements;
-----------------------------------------------
You will learn all about : how to ;
-Represent business processes with ERD's in a conceptual design & data model/design blueprint,
-Create, control & modify a database,
-Structure a table & normalize it,
-Transform a data model/design blueprint into a relational db,
-Lay-out a solid phyical design, and
how to implement your design/blueprint solution by:
-deciding on the db sytem architecture to use,
-creating,tables,constraints, views,
-controlling db object priveldges,
-transporting data via bulk copy, a study on the import/export wizard,
-querying databases using SQL , subqueries, joins
-SQL procedures ie: Triggers,User defined functions, creating & using stored procedures, flow-control structures ie: IF's , WHILE loops, CASE statements ,et cetera ;
-creating & managing indexes and index views
-Data access via ADO, ODBC,OLE DB
Re:
(B.) The Database Application Development aspect;
-------------------------------------------------
You will learn all about :
-creating database applications with Visual Studio.Net,
-Developing a Web based Applications interface to a database system ,viz:
-creating forms based on views/queries
-creating reports, embedding subforms and subreports,
-creating reports based on stored procedures
-creating network databases ie: client/server architecture,
-using XML, XML datafiles, XML schema, creating XML Web services with Visual Studio.Net
Re:
(C.) Database Administration elements ;
----------------------------------------
You will learn all about :
-Installation of SQL Server
-Server security, Managing Database User accounts,
-Security Authentication, Roles, Permissions,
-Backup and recovery
-Database Replication
-Database Optimization & tools used in performance tuning ie: transactions & locking
-Building a database maintenance plan.
Re:
(D.) Data Analysis Services elements;
-------------------------------------
You will learn all about :
-Building & Designing an OLAP (On-Line Analytical Processing) solution
-Building a Data warhouse ie: dimensional modelling, fact table, ETL(extract,transform,load),
-DTS-(data transformation services)
An example OLAP Case study : demonstrating visually a star-schema, snowflake-schema etc
Re:
(E.) -Data mining ;
-------------------
You will learn all about :
-developing data-mining models ,
-data-mining algorithms
-creating decison trees
-deploying data-mining results with DTS
An example data-mining Case study
et cetera, et cetera
i hope this helps
Laying that 1st powerful FoundationMar 09, 2006
By derazz
"derazz"
They say, how high you get to build or you will go with anything depends on the foundation you are able to establish.
and that we all sit on the shoulders of giants
well, if you want to develop and manage database systems professionally (ie: conceive database design blueprints, develop, implement/produce or bring the blueprint into the physical, and deliver with articulate proficiency any relational database system -(for database applications at the enterprise level ie:client/server-based applications and web-based applications)
then, you are going to need a thorough mastery of the core underpinnings eventually, before you can commandingly build brilliantly the way you like ie:
You need to permit yourself a
1.) Thorough mastery of relational theory in order to have the flexibility & adaptability to consistently produce solid database design blueprints; this implies knowing how to make the right design decisions/design selections & the ability to see the whole picture ie:(how everything will fit together beforehand)+ the ability to then work-inwards & outwards in the detail levels, in order to forge the database you want.
2.) Thorough mastery of putting out a conceptual design to meet, answer/respond to your users business needs.
3.)concrete knowledge of the steps to take to verify the accuracy of your design proposal(logically), checking it for correctness & adequecy, regardless of the design methodology u adopt before you give the green light to implementation.
4.)knowledge of database implementation & how to manipulate the data to retrieve whatever u and the boss require or want out of it.
5.)knowledge of how to fit/hook-up your implementated database as part of a complete system solution and make it belong; eg: as a client/server-based applications & web-based application in the context of an enterprise ie: as an accessible enterprise application residing on a network-share.
6.) knowledge of how to keep historic data , classify these away, organise and set them apart for future purposes ; ie: for future reporting or querying . in short, expertise in building yourself an OLAP side to your design blueprint , a data warehouse et cetera, in order to set up/satisfy a clients data-mining & future decison-analyses ambitions/prospects for the database system.
These are the things you will need. This is the professional know-how which can help you become a highly-paid, consulted professional or a senior developer/designer.
This is the secret most newbee's stuck on the outside looking in on the inside, not knowing how to navigate the tide or where to begin from to get to the heart of the profession, seek.
This is clarity.
Thus, If you have any gaps in your database development know-how, which requires filling -(you'll know this in yourself), then i would recommend 2 primordial books for it:
(1.)"Database Development and Management (foundations of Database Design)" isbn 0849333180
&
(2.)"Database Design and Development a visual approach" isbn 0130351229
Now with regards each book :
Note: (due to review real estate constraints, i shall limit this review to Book 1, the current book in question.
you'll find my Book 2 review on Book 2's customer review page under :"Database Design and Development a visual approach" ISBN: 0130351229)
Book 1:"Database Development and Management (foundations of Database Design)" isbn 0849333180
is your cement/concrete foundation book.
the book does show favor for implementation in SQL SERVER & MS Visual Studio.Net, but the central database design foundation/tenets is sound for ORACLE,DB2,SQL SERVER,MS Access.
Basically, this one book answers questions like: what is a database, the component parts & pieces that make one up , how do the pieces all fit together, what does each one do, what do they each bring to the picture of a database blueprint solution
From the book you will learn all about :
(A.)Database Implementation & Design elements
(B.)The Database Application Development aspect ie: creating database applications with Visual Studio.Net, Developing a Web Application
(C.)Database Administration elements
(D.)Data Analysis Services (OLAP, data-ware housing)
(E.)Data mining
the long & short of it is that,
If database design, development and management appears to be one big convoluted puzzle, well, this book puts it all together for you and tells you how & where everthing fits.
this is the power of this book. and as such, it is brilliant!
This is a book you'll want to keep, its of great value and accessible to the very green beginner, intermediate or pro person.
these 2 books will bring you something most Developers and DBA spend half their careers trying to figure out ;which is, d complete skill-set of how to handle a database project from point A to Z all by yourself. For most people, theory only ever meets hands-on practise in the proverbial 2-3years work experience context , from on the job experience.
However,the db design foundation which this book delivers to one features the core staple a fledging database developer or DBA would go through a
-MCSD -(Micorsoft Certified Solutions Developer) or -MCDBA -(Microsoft Certified Database Administrator) I.T certification/ accreditation in order to obtain.
this applies in a lot of ways too to ORACLE
This staple constitutes the core skill-set,profile/credentials, employers in the real world generally seek to hire onto db management projects despite the hard won bachelors degree in computing.
cheers :-)
Must have Book for developing and managing databaseMar 04, 2006
By Jaya Pai
"Jay"
Excellent book, Easy to understand and covers most topics of database which includes database design with detail explanation about data modeling, table structure, normalization and transformation of data model to relational database, use of SQL in managing database objects and querying databases, views, indexes, cursors for database applications and much more.
Other topics includes data accessing techniques, use of database in network environment, database administration, data analysis using Online Analytical Processing (OLAP), data warehousing, and other analysis tools, and also discusses about data mining.
Since it provides detailed easy to follow instructions using step-by-step case based approach, it helps to understand database concepts clearly. I recommend you to buy this book.
A must-have book on your bookshelfMar 02, 2006
By Vinh Nguyen
If you consider database administrator or developer as your career, this book is for you. The book covers most topics in the database field from database design, programming, administration, to data mining. All topics are well organized to keep you in track, step-by-step to build a strong foundation for your database career.
With more than five years of working as a DBA and developer, this book is still helpful to me every day. Your every penny counts in this book.
Thank you Dr. Chao for such great work.
| | |
|
