Bestsellers > Books > Databases
|
|
Bestsellers > Books > Databases
|
|
Building the Data Warehouse, 2nd Edition»rank: 220245by: W. H. Inmon
: :Everything you need to know to design, develop, and build your data warehouse The data warehouse solves the problem of getting information out of legacy systems quickly and efficiently. If designed and built right, data warehouses can provide significant freedom of access to data, thereby delivering enormous benefits to any organization. In this unique handbook, W. H. Inmon, 'the father of the data warehouse,' provides detailed discussion and analysis of all major issues related to the design and construction of the data ware-house, including granularity of data, partitioning data, metadata, lack of creditability of decision support systems (DSS) data, the system of record, migration, and more. This Second Edition of ... |
Fast Track to MDX»rank: 44189by: Mark Whitehorn, Robert Zare, Mosha Pasumansky
: :Fast Track to MDX (for SQL Server 2000) Second Edition Mark Whitehorn, Robert Zare and Mosha Pasumansky OLAP (On-Line Analytical Processing) is the most powerful Business Intelligence tool currently available and Microsoft's Analysis Manager makes OLAP cubes incredibly easy to build and deploy. However the real power of OLAP lies in its ability to help you solve real-life business problems; to release that power you need to use the language that controls the cubes and allows them to be queried. That language is MDX (Multi Dimensional eXpressions). Fast Track to MDX gives you all the necessary background to let you write useful, powerful MDX expressions and introduces the most frequently ... |
||
DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification: Certification Study Guide»rank: 93453by: Roger E. Sanders, Dwaine R Snow
: :Database administrators versed in DB2 wanting to learn more about advanced database administration activities and students wishing to gain knowledge to help them pass the DB2 9 UDB Advanced DBA certification exam will find this exhaustive reference invaluable. Written by two individuals who were part of the team that developed the certification exam, this comprehensive study guide prepares the student for challenging questions on database design; data partitioning and clustering; high availability diagnostics; performance and scalability; security and encryption; connectivity and networking; and much more. Providing sample questions in each chapter, a complete practice test modeled after the actual exam, and an extensive answer key providing full explanations for each ... |
Essential SQLAlchemy»rank: 74570by: Rick Copeland
: :Essential SQLAlchemy introduces a high-level open-source code library that makes it easier for Python programmers to access relational databases such as Oracle, DB2, MySQL, PostgreSQL, and SQLite. SQLAlchemy has become increasingly popular since its release, but it still lacks good offline documentation. This practical book fills the gap, and because a developer wrote it, you get an objective look at SQLAlchemy's tools rather than an advocate's description of all the 'cool' features. SQLAlchemy includes both a database server-independent SQL expression language and an object-relational mapper (ORM) that lets you map 'plain old Python objects' (POPOs) to database tables without substantially changing your existing Python code. Essential SQLAlchemy demonstrates how to ... |
||
Alison Balter's Mastering Microsoft Office Access 2007 Development (Sams)»rank: 105204by: Alison Balter
: :Microsoft Office 2007 is a major upgrade from the last version of Office; Access will also be greatly revised. Alison Balter is the name that Access developers will trust to guide them through Access 2007's new features. She has the rare ability to take complex topics and explain them clearly, as shown by the success of her ten previous books on Access. Balter is known for providing real-world solutions to specific Access development problems. She also is known for her ability to back up her practical examples with just enough underlying theory to give the reader a good overall understanding of Access. In short, this book will provide beginning and ... |
SQL: Visual QuickStart Guide (3rd Edition) (Visual QuickStart Guide)»rank: 45116by: Chris Fehily
: :SQL is a standard interactive and programming language for querying and modifying data and managing databases. This task-based tutorial and reference guide takes the mystery out learning and applying SQL. After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily immediately launches into the tasks that will get readers comfortable with SQL. In addition to covering all the SQL basics, this thoroughly updated reference contains a wealth of in-depth SQL knowledge and serves as an excellent reference for more experienced users. |
||
OCP Oracle Database 11g: New Features for Administrators Exam Guide (Exam 1Z0-050) (Osborne Oracle Press)»rank: 73588by: Sam R. Alapati
: :A Fully Integrated Study System for OCP Exam 1Z0-050Prepare for the Oracle Certified Professional Oracle Database 11g New Features for Administrators exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test, and serve as your essential on-the-job reference. Get complete coverage of all OCP objectives for exam 1Z0-050, including:Installation and upgradesPartitioning and storageIntelligent infrastructureDiagnostics and fault managementPerformanceOracle Recovery Manager and Oracle FlashbackSecurityOracle SQL Performance AnalyzerSQL plan managementAutomatic SQL tuningOn the CD-ROM:One full practice exam that simulates the actual OCP examDetailed answers ... |
Concepts of Database Management, Sixth Edition»rank: 165109by: Philip J. Pratt, Joseph J. Adamski
: :This concise yet comprehensive introduction to fundamental database concepts is an indispensable resource to develop your knowledge of database management concepts. Now in its sixth edition, Concepts of Database Management maintains the focus on real-world cases that made previous editions so effective addressing the most current database issues faced today such as database design, data integrity, concurrent updates, and data security. Special features include detailed coverage of the relational model (including Query-By-Example (QBE) and SQL), normalization and views, database design, database administration and management, and more. This book's advanced topics include distributed databases, data warehouses, stored procedures, and triggers fostering an in-depth understanding of database management that will prepare users ... |
||
Programming the Microsoft® ADO.NET Entity Framework (PRO-Developer)»rank: 16962by: David Sceppa
: :This concise yet comprehensive introduction to fundamental database concepts is an indispensable resource to develop your knowledge of database management concepts. Now in its sixth edition, Concepts of Database Management maintains the focus on real-world cases that made previous editions so effective addressing the most current database issues faced today such as database design, data integrity, concurrent updates, and data security. Special features include detailed coverage of the relational model (including Query-By-Example (QBE) and SQL), normalization and views, database design, database administration and management, and more. This book's advanced topics include distributed databases, data warehouses, stored procedures, and triggers fostering an in-depth understanding of database management that will prepare users ... |
Understanding DB2(R): Learning Visually with Examples (2nd Edition)»rank: 110708by: Raul F. Chong, Xiaomei Wang, Michael Dang, Dwaine R. Snow
: :The Easy, Visual Way to Master IBM® DB2 for Linux®, UNIX®, and Windows®—Fully Updated for Version 9.5IBM DB2 9 and DB2 9.5 provide breakthrough capabilities for providing Information on Demand, implementing Web services and Service Oriented Architecture, and streamlining information management. Understanding DB2: Learning Visually with Examples, Second Edition, is the easiest way to master the latest versions of DB2 and apply their full power to your business challenges.Written by four IBM DB2 experts, this book introduces key concepts with dozens of examples drawn from the authors' experience working with DB2 in enterprise environments. Thoroughly updated for DB2 9.5, it covers new innovations ranging from manageability to performance and XML ... |