Oracle Database 11g Underground Advice for Database Administrators

• Oracle Database 11g Underground Advice for Database Administrators By April Sims
• Publisher: Packt Publishing 2010 | 348 Pages | ISBN: 1849680000 | PDF | 4 MB
• A real-world DBA survival guide for Oracle 11g database implementations
• A comprehensive handbook aimed at reducing the day-to-day struggle of Oracle 11g Database newcomers
• Real-world reflections from an experienced DBA-what novice DBAs should really know
• Implement Oracle's Maximum Availability Architecture with expert guidance
• Extensive information on providing high availability for Grid Control
• 
  
• In Detail
• Today DBAs are expected to deploy and manage large databases with quality service and little to no downtime. The DBA's main focus is on increasing productivity and eliminating idle redundancy throughout the enterprise. However, there is no magic set of best practices or hard and fast rules that DBAs need to follow, and this can make life difficult. But if DBAs follow some basic approaches and best practices, tasks can be performed more efficiently and effectively.
• This survival guide offers previously unwritten underground advice for DBAs. The author provides extensive information to illuminate where you fit in, and runs through many of the tasks that you need to be watchful of, extensively covering solutions to the most common problems encountered by newcomers to the world of Oracle databases.
• The book will quickly introduce you to your job responsibilities, as well as the skills, and abilities needed to be successful as a DBA. It will show you how to overcome common problems and proactively prevent disasters by implementing distributed grid computing-scalable and robust-with the ability to redeploy or rearchitect when business needs change. Reduce downtime across your enterprise by standardizing hardware, software, tools, utilities, commands, and architectural components.
• This book will also help you in situations where you need to install Oracle Database 11g or migrate to new hardware making it compliant with a Maximum Availability Architecture. By the end of this book you will have learned a lot and gained confidence in your abilities. You will be armed with knowledge as to which tools are best used to accomplish tasks while proactively moving towards an automated environment.
• An example-oriented guide to optimize a DBA's performance on 11g databases
• 
  
• depositfiles
• sharingmatrix
• uploading
• turbobit

Database Modeling and Design: Logical Design (Repost)

• Database Modeling and Design: Logical Design By Toby J. Teorey, Sam S. Lightstone, Tom Nadeau, H.V. Jagadish
• Publisher: Morgan Kaufmann 2005 | 296 Pages | ISBN: 0126853525 | PDF | 6 MB
• Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your database application in consideration of new technology or new business needs?
• 
  
• In the extensively revised fourth edition, you'll get clear explanations, lots of terrific examples and an illustrative case, and the really practical advice you have come to count on--with design rules that are applicable to any SQL-based system. But you'll also get plenty to help you grow from a new database designer to an experienced designer developing industrial-sized systems.
• 
  
• + a detailed look at the Unified Modeling Language (UML-2) as well as the entity-relationship (ER) approach for data requirements specification and conceptual modeling--with examples throughout the book in both approaches!
• + the details and examples of how to use data modeling concepts in logical database design, and the transformation of the conceptual model to the relational model and to SQL syntax;
• + the fundamentals of database normalization through the fifth normal form;
• + practical coverage of the major issues in business intelligence--data warehousing, OLAP for decision support systems, and data mining;
• + examples for how to use the most popular CASE tools to handle complex data modeling problems.
• + Exercises that test understanding of all material, plus solutions for many exercises.
• 
  
• depositfiles
• turbobit
• sharingmatrix
• uploading

SQL Clearly Explained, 3 Edition

• Jan L. Harrington, "SQL Clearly Explained, 3 Edition"
• Morgan Kaufmann | 2010 | ISBN: 0123756979 | 480 pages | PDF | 3,5 MB
• Although the core of the SQL language remains relatively unchanged, the most recent release of the SQL standard (SQL:2008) includes two sets of extensions: 1) support for object-relational databases and 2) support for XML. The second edition of this book included some material about the object-relational extensions. However, that set of commands has been greatly extended and the new edition takes that into account. The XML extensions are entirely new to the third edition. A chapter on basic relational concepts will be also added to broaden the audience and make the book more complete in its own right.
• All of the chapters will be revised to be sure they are up to date. Chapter 10 ("Views, Temporary Tables, and Indexes") from the second edition will be expanded to include common table expression (CTEs). The material in the existing Chapter 14 ("Unimplemented SQL-92 Features 251") will be disbursed through the chapters where the particular type of operation is discussed. While the content throughout will be updated where necessary, the existing organizational structure through chapter 14 will remain largely intact because this coverage represents the stable portion of the SQL language.
• There will be two NEW chapters at the beginning of the book. Chapter 1 ("The Relational Data Model") covers the relational data model conceptual material; Chapter 2 ("Manipulating Relations with Relational Algebra") covers the relational algebra material that will be pulled from the retrieval chapters. Part 5 ("Non-relational SQL Extensions") will now include the non-relational SQL extensions in three chapters. Chapter 17 (NEW) will cover XML. Chapter 18 will contain the object-relational conceptual material from the original chapter 15 and chapter 19 (NEW) will cover SQL object-relational support. (Some of chapter 19 will come from the second edition, however, a great deal of object-relational support has been added to the current standard and therefore needs to be added.) The other NEW chapter is Chapter 14, which covers triggers and stored procedures. This material was missing from previous editions. Many readers should find it a useful addition.
• •Demonstrates how to formulate SQL queries and how queries are processed to maximize performance of the database management system
• Explains use of SQL to enter, modify or delete data to maintain database structural elements
• Download
• uploading.com
• sharingmatrix.com