Database Development and Management (Foundations of Database...

Features

• Cover Type: Hard Cover with 607 pages
• Published by: AUERBACH
• Edition: 1st Edition January 13, 2006
• Written in: English
• ISBN 10 Number: 0849333180
• ISBN 13 Number: 978-0849333187
• Book Dimensions: 10 x 7.2 x 1.4 inches
• Weighs: 2.8 pounds

Product 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 looks at 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.

Reader Reviews
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 :-) Comment | | (Report this)