Databases
Oracle8 Data Warehousing
Gary Dodge covers the basics of data warehousing and then moves into technical instructions on how to select the appropriate hardware architecture, design the warehouse for optimum performance, build the database, and run it. He covers advanced techniques for distributing and mining data.
Oracle Database Administration: The Essential Reference
The Oracle database administrator (DBA) performs a vitally important set of tasks at an Oracle site: database monitoring, backup and recovery, troubleshooting, and tuning for reliability and performance. The DBA also plays a role in initial database design, system configuration, installation, and security planning. This book provides a quick reference to the myriad details an Oracle DBA needs on a day-to-day basis to help do his or her job well.
SQL Server 7 Data Warehousing
A reference guide to data warehousing that covers designing, building, managing, and tuning data warehouses, as well as expansive content on the Plato OLAP server.
Oracle8i for Windows NT Starter Kit
Learn to configure, administer, and tune a database system and master the fundamental skills necessary to build SQL, PL/SQL, and Java applications that interact with Oracle8i.
Oracle8i SQLJ Programming
Explains in detail how to implement SQLJ - the new standard for embedding static SQL directly into Java programs. This authoritative guide shows you how to create cross-platform, distributed, and Web-enabled applications designed specifically for Oracle8i.
Oracle 24x7 Tips & Techniques
This book highlights innovative solutions that are either hidden, undocumented, or can only be discovered through many years of experience or through extensive trial and error.
Oracle DBA 101
Learn the ins-and-outs of Oracle database administration from the experts. Oracle DBA 101 describes in detail the day-to-day duties of a database administrator - and how to accomplish them.
Oracle Developer Advanced Forms and Reports
This guide contains an invaluable resource - a discussion of actual Forms and Reports standards used by the authors to create production systems. Included are standards for the use of SQL and PL/SQL in the development tools, naming conventions, and GUI design.
Oracle8i Web Development Handbook
Cutting-edge Oracle data warehousing from people creating the software Oracle8i Data Warehousing explains how to design, develop, and administer powerful data warehouses and data marts on Windows NT using Oracle's major new industry-leading database. This authoritative guide helps database developers, administrators, and designers master the major new data warehousing and Internet capabilities in Oracle8i and specifically plan and implement affordable and successful data warehouses and data marts. In one exciting package, this book brings together three hot computing topics: new Oracle databases, Windows NT, and Internet technologies.
Oracle Certified Professional Database Administrator Certification Exam Guide
The main content of each DBO Exam Guide chapters will include figures, tables, tips, and other content in the same format as its predecessors, the OCP DBA and Developer Exam Guides. Following the main content will be: short chapter review; two- minute drill; 10-15 multiple choice questions modeled after the OCP exam questions and answers to chapter questions along with explanations. CD-ROM includes electronic, full searchable version of the Exam Guide hyperlinked to over 300 practice exam questions.
SQL Server 7 Backup & Recovery
Learn to develop restore plans for various scenarios, from minor data loss to complete hardware failures; increase reliability, availability, and performance through the use of standby servers and clustering; and distribute data throughout their enterprises with SQL Server 7's replication features. This book is also full of case studies.
Oracle8i Data Warehousing
Explains how to design, develop and administer powerful data warehouses and data marts on Windows NT using Oracle's database. This authoritative guide helps database developers, administrators, and designers master the major new data warehousing and Internet capabilities in Oracle8i and specifically plan and implement affordable and successful data warehouses and data marts.
Data Warehousing With Microsoft SQL Server 7 Technical Reference
This guide simplifies this process by showing you how to use the features of SQL Server 7.0 to design, build, and manage a data warehouse.
The Definitive DataWindow: Your Key to PowerBuilder Success
Part tutorial, part reference, and part practical guide, this indispensable resource will greatly enhance your use of DataWindow and your overall database programming skills.
Oracle DBA Tips & Techniques: Real-World Approaches to Administering Oracle Databases
Expand your Oracle expertise by using the hundreds of tips and techniques provided in this unique reference. Written by an expert Oracle DBA, this volume offers high-end administrative solutions by leveraging little-known Oracle features with proven tactics.
The Official Guide to Informix/Red Brick Data Warehousing
The RedBrick Data Warehousing Bible is the comprehensive tutorial and reference to Informix RedBrick Data Warehouses. The book covers all the features of RedBrick in the process of building a data warehouse through its complete lifecycle, beginning with planning the project, designing the database, building and loading the database, deploying the database to business users and maintaining the data warehouse in the future. Each of the topics is presented in a straightforward fashion by discussing in detail the objective, concepts, and implementation techniques and briefly touching on the more advanced components. One ongoing case study used throughout the book allows the reader to build upon it with each major area to create a sample data warehouse. Sample forms and documents as well as completed exercises are provided on the CD-ROM.
As/400 Data Warehousing : The Complete Guide to Implementation
There are no off-the-shelf solutions and no ready-made tools that will allow you to convert operational data into meaningful, strategic information. You must fundamentally restructure your data - create a data warehouse - before Query can do the job it was designed to do. This book shows you how. It offers a product- independent, do-it-yourself guide to restructuring databases for successful end-user access. Believing that "successful end-user access projects are build as applications, not afterthoughts," author Brian Kelly starts by first present issues and objectives. He then goes on to spell out exactly how to design/restructure databases. Don't fall behind by waiting for a "killer" query product that is never going to come. Find out how to deliver the goods to management by building your own data warehouse!
Distributed Real-Time Systems: Monitoring, Visualization, Debugging, and Analysis
Used in such critical applications as flight control systems, space shuttle landing systems and patient monitoring systems, Distributed Real Time Systems (DRTS's) must operate continuously with near-impeccable reliability. This book is an overview of various systematic approaches--both theoretical and practical-- to monitoring, visualizing, and debugging DRTS's to ensure that these systems are performing consistently at the maximum possible level. Includes detailed worked-out examples the reader can follow.
Practical Issues in Database Management: A Reference for the Thinking Practitioner
Written for database designers, programmers, managers, and users, it addresses the core, commonly recurring issues and problems that practitioners--even the most experienced database professionals--seem to systematically misunderstand.
Teradata SQL: Unleash the Power
Teradata SQL - Unleash the Power is a data warehouse developers dream guide. It contains 441 pages of SQL dynamite showing both ANSI and Teradata SQL in an easy to understand manner. The book has detailed ANSI and Teradata comparisons, syntax, examples, and tips and tricks learned from the industries top two SQL experts. Let Tera-Tom Coffing and Mike Larkins teach you from their experience at over 125 different Teradata sites worldwide. This book was the number one selling book at the Teradata Partners Conference 2001.
Tera-Tom on Teradata Basics
Tera-Tom on Teradata Basics is designed to explain both data warehousing concepts and the basics behind the brilliance of Teradata. Both management and IT will understand this masterpiece written by the world's top authorities on Teradata and data warehousing. After an explanation of the key concepts used by the top data warehouse sites around the globe this book describes how Teradata is built to achieve data warehouse utopia.
Tera-Tom on Teradata E-Business
Tera-Tom on Teradata E-Business gives readers a fascinating explanation of the Internet and e-business marketplace and provides a step-by-step guide on how to build a Teradata data warehouse to take advantage of valuable E-Business data. This simple to understand and easy to read guide makes learning about E-Business and data warehousing fun, motivating, and exciting.
Mastering Oracle SQL
Authors offer the full range of Oracle SQL features that apply to query writing. Discover ways to use Oracle's new analytic SQL features to write ranking queries, lag and lead queries, and more.
Inside Relational Databases
Database books currently tend to fall into two categories: highly theoretical and detailed textbooks and manuals which teach how to use the software but not the underlying theory. Neither type of book explains why the reader would want to do many of the things they describe. Marklyn and Whitehorn cover essential relational database theory and explain how to build databases securely - without bogging them down into too much detail and endless formulae. They start by explaining interface components and letting you build working databases. Along the way the authors guide you through potential disasters and provide the techniques to avoid them. Inside Relational Databases is aimed at equipping students with the necessary skills to build practical databases in the 'real world' as well as ensuring that they have a sufficient theoretical grounding in the subject.
Information Modeling and Relational Databases: From Conceptual Analysis to Logical Design
The information revolution is in motion, and sound database design will drive the ease of data handling and, in turn, improve the results of business practices. A timely topic, then, is Object-Role Modeling (ORM), a way to design and query databases via an application written in lay terms. Halpin expertly explains ORM as well as other solid database design practices so that even seasoned pros will learn something new. Designers, programmers, systems analysts, and managers will discover everything they need to know about database design. Complete with a companion web site, this is highly recommended for libraries serving techies.
Database: Principles, Programming, and Performance, Second Edition
A standard text for database designers and programmers, Database: Principles, Programming, and Performance is out in a new edition. This latest version of the detailed work of the O'Neils includes a new chapter on Object-Relational Structured Query Language (SQL) and its implementations in Oracle and Informix products. On top of that, the authors have revised their chapters on basic and advanced SQL, and added product- specific details (particularly having to do with Oracle, Informix, and IBM DB2 database products) to most areas of their coverage. As a result of these revisions, this book does a great job of balancing academic material with practical examples.
SQL Server Backup and Recovery: Tools and Techniques
Microsoft server specialist McBath presents a training guide and reference for computing professionals responsible for managing a SQL Server database computing environment, particularly in an enterprise where backup and recovery are important. He limits consideration to the two linked functions in order to produce a tool detailed enough for a professional that is also small enough to carry easily in the field.
Web Development with Oracle Portal
An authoritative guide to Web development using Oracle Portal. Covers Version 3.0. Includes the complete export of the demo application and the source code on CD-ROM. Softcover. CD-ROM included.
Database Administration: The Complete Guide to Practices and Procedures
Combining tutorial and reference elements, this guide provides a non- product-based description of database administration techniques and practices. It defines the job of the database administrator (DBA), underscoring the necessity of a DBA for a database management system (DBMS) implementation to succeed, then proceeds chronologically through every task the DBA is likely to encounter. The book can be used as a text for database administration, as the basis for setting up a DBA group, to augment a DBMS-specific text or manual, and to help upper-level management explain why the DBA position is necessary. Mullins is a data management strategist in the private sector.
SQL Server 2000 XML Distilled
XML is one of a family of web standards for data description, validation, manipulation, and interchange. It enables the construction of application-specific data languages, which can be handled by generic tools. Its other main benefits are its platform independence, self-describing structure, and human readability. All the big relational database vendors are adding XML support to their databases – and their confidence in XML as a maturing data standard is strengthening. Microsoft's commitment to XML extends beyond the database to include application and presentation layers, particularly in .NET. The nascent field of web services will depend on the effective interface between relational databases and the XML messages that link them.
SQL Server Security Distilled
Securing SQL Server is one of the most important responsibilities of the SQL Server professional. Ensuring your data is safe requires a combination of good systems and database administration, and intelligent application design – weaving a security plan that matches the capabilities and vulnerabilities of each contributing part. But at its root, security is concerned with controlling access – authenticating who can access the data on the server, authorizing what users can do with that data, and securing data as it is transported. These core topics are the focus of this book.
MegaFox: 1002 Things You Wanted to Know About Extending Visual FoxPro
With its native data engine, rich object-oriented language, and capabilities to produce COM servers and consumer Web services, Visual FoxPro is the single most flexible programming tool available to software developers. But in today's programming environment, nothing stands alone. This guide will show developers how to extend the scope and power of Visual FoxPro as a development tool by integrating it with other software technologies. This much-anticipated sequel to 1001 Things You Wanted to Know About VFP, this both epands coverage of topics such as data driving and reporting and introduces new topics such as e-mail, IntelliSense, charts and graphs, PDF technology, MSDE, COM/DCOM, XML/ADO, and designing for extensibility.
Oracle PL/SQL Language Pocket Reference
Distills the most vital information from Oracle PL/SQL Programming into an accessible summary of fundamental language elements, statements for program control, cursor management, and exception handling. Covers Oracle8 objects, collections, and external procedures.
The Book of FileMaker: Your One-Stop Guide to FileMaker Pro, Pro Unlimited, Developer, Server, and Mobile
This complete reference to FileMaker Pro takes developers at all levels beyond the user manual to create robust and dynamic database systems from the ground up. It begins with an introduction to the FileMaker Pro development environment and relational databases in general, but also covers advanced topics such as Web-enabling databases, integration with external applications, ODBC, using plug-ins, development standards and project planning techniques, and much more. The CDROM contains hundreds of ready-to-use example files for demonstrating all the techniques and ideas presented in the book.
The SQL Server 2000 Book
This book is ideal for the system or database administrator, IT manager, and IT professional working with SQL Server. It covers four main topic areas: technologies and architecture, planning and installing, administering and optimizing, and using SQL Server 2000. Some of the critical topics featured in the book include backing up and restoring databases, optimizing SQL Server, using replication, configuring XML and Internet support, and automating administrative tasks. The book features extensive diagrams, decision trees, and visual tools. The included CDROM features printable planning checklists and worksheets, plus third-party tools and utilities.
Multimedia Databases: An Object-Relational Approach
Brings together for the first time in one book fully comprehensive coverage of multimedia databases. Covers SQL3 and includes examples and practical exercises.
MySQL, Second Edition
In MySQL, Paul DuBois provides you with a comprehensive guide to one of the most popular relational database systems. As an important contributor to the online documentation for MySQL, Paul uses his day-to-day experience answering questions users post on the MySQL mailing list to pinpoint the problems most users and administrators encounter.
Oracle XSQL
While exploring all of the exciting features of XSQL, this guide presents a solid approach to building XML Web applications and Web services with XSQL, Oracle Text, SQL, XSLT, and Java from data found in Oracle databases.
Oracle SQL*Plus Pocket Reference
Provides quick reference information that will help you use SQL Plus, Oracle's interactive query tool. Summarizes all of the SQL Plus syntax, including the syntax for new Oracle8i release 8.1.6 features.
Practical Web Database Design
Unlike other database design books in the market, this one focuses on design of databases for use on the Web. Web databases benefit from good general database design principles, but also have their own set of caveats, which must be considered for their design to be truly successful. This book covers both the general, and the web-specific database principles.
Java Oracle Database Development
Introduces Oracle 8i/9i database design and the structured query language, presents the major approaches to integrating Java in database programming, and compares the strengths and weaknesses of each approach. Written for intermediate Java programmers, the guide surveys the different SQL statements, the basic elements of PL/SQL, and the Oracle object types, then shows how to use SQLJ, JDBC, J2EE, enterprise JavaBeans (EJB), and Java data objects (JDO) to write Java programs that interact with a database procedurally.
DB2 SQL Procedural Language for Linux, Unix and Windows
This developer's resource covers all language elements of DB2 SQL procedure language with an abundance of examples and detailed explanations. It includes expert tips and best practices derived from experiences with real customers from the specialists at the IBM Toronto Lab.
Oracle SQL Interactive Workbook
Gives background in Oracle's implementation of the SQL language. Each chapter is divided into labs, with objectives, examples, and exercises on specific tasks and questions that are designed to help readers discover important aspects of the SQL language. Exercises build knowledge step by step by introducing relational database concepts, the SQL*Plus environment, and the SQL language. Labs also include explained answers, multiple-choice review questions, and critical thinking questions. Morrison works in Internet development. Rischert is co-chair of Columbia University's Database Application Development and Design track at the Computer Technology and Application Program.
FileMaker Pro 6 Advanced for Windows and Macintosh: Visual QuickPro Guide
Feel as if you've done all that you can do with FileMaker? FileMaker Pro 6 Advanced for Windows and Macintosh: Visual QuickPro Guide will help you do more. It's the most efficient way for smart, creative, busy professionals like yourself to learn how to build custom databases using scripts and templates, and to share and manage information with your colleagues in the next cubicle, over an intranet, or on the Web.
Informix Guide to Designing Databases and Data Warehouses
Written by a team of insiders, this is the most complete, authoritative guide to database and data warehouse design, implementation, and administration with Informix Dynamic Server.2000 and Informix Enterprise Decision Server. You'll start by walking through the construction of data models that illustrate each key approach to database design. Compare ANSI and non-ANSI compliant databases, learn the fundamentals of entity-relationship modeling, and choose appropriate data types. Next, you'll learn how to use the Informix implementation of SQL to implement and manage your databases.
Component Database Systems
Discusses the future of major database systems, comprised of contributions from major leaders in the field and respected researchers. Covers component-focused architectures, methods for hooking components, and a host of other topics.
Managing Reference Data in Enterprise Databases
This book describes the different aspects of managing reference data. It is the only book available on this topic and provides both a conceptual foundation and practical advice. It is oriented to a general audience and can be read by both IT professionals and anyone with an interest in how an enterprise should manage its information. Some data modeling notations are used, but these are explained at the beginning of the book. Reference data concepts are introduced and their importance is explored. The management consequences of the unique characteristics of reference data are then described, along with techniques for managing reference data.
An Introduction to Database Systems, Eighth Edition
Amazon.com
The newest edition of the classic An Introduction to Database Systems incorporates the latest developments in relational databases, including semantic modeling, decision support, and temporal modeling. There's better information on distributed databases, security, and the mathematics of relational databases too. With the same strong coverage of fundamental theory that made its predecessors stand out, this book ranks as the definitive textbook for those studying database systems.
This is an extraordinarily academic book. In his preface, C.J. Date goes so far as to lament having to use Structured Query Language (SQL) in some of his examples because it's "so far from being a true embodiment of relational principles." What's more, he writes in a very academic style, peppering his heavily footnoted prose with mathematical expressions and words like relevar and tuple. The academic style and highbrow language isn't a b
Exploratory Data Mining and Data Cleaning
- Written for practitioners of data mining, data cleaning and database management.
- Presents a technical treatment of data quality including process, metrics, tools and algorithms.
- Focuses on developing an evolving modeling strategy through an iterative data exploration loop and incorporation of domain knowledge.
- Addresses methods of detecting, quantifying and correcting data quality issues that can have a significant impact on findings and decisions, using commercially available tools as well as new algorithmic approaches.
- Uses case studies to illustrate applications in real life scenarios.
- Highlights new approaches and methodologies, such as the DataSphere space partitioning and summary based analysis techniques.
Sharpening Your SAS Skills
Sharpening Your SAS Skills is an intermediate text on SAS programming and data management intended for those with some knowledge of the SAS language. It covers the most common tools used by SAS programmers and data analysts in their daily work. Designed as a quick-reference and practitioner's guide, this book will be particularly useful for those preparing for the SAS Base Programming exam. The book includes question and answers at the end of each section to reinforce the reader's knowledge of the topic and tables in each chapter that summarize the syntax and expected data. A companion Web site contains examples, extra exercises, the list and log SAS files, and the pdf/html output files.
Open Source for Windows Administrators
Charles River Media announces Open Source for Windows Administrators, a comprehensive guide that introduces Microsoft(R) Windows(R) administrators to the world of Open Source applications in order to save time and money. The book provides readers with information and techniques for using the appropriate Open Source applications in a variety of situations, such as anti-spam, databases, E-mail, Web content, file sharing, word processing, spreadsheets, and more. By using a component approach in which readers can pick and choose their technologies, the book, for example, enables a Windows administrator to use Apache as a Web server, while still electing Microsoft SQL Server as a database. The focus of the product coverage is to help the administrator to perform more efficiently. The discussion of each option includes: quality of documentation available, how to package for installation in a business setting, and solving common tasks using various techniques.
Database in Depth: Relational Theory for Practitioners
Sebastopol, CA--Theory is practical. This is an article of faith with well-known author and database authority Chris Date. "I mention this point explicitly because so many people seem to believe the exact opposite: namely, that if something's theoretical, it can't be practical," he explains. "But the truth is that theory--at least the theory I'm talking about here, which is relational theory--is most definitely very practical indeed." Relational theory is not just theory for its own sake, Date observes; the purpose of that theory is to allow people to build systems that are one hundred percent practical.
MySQL in a Nutshell
Stable and reliable, MySQL may not possess the elan of trendier open source technologies, but it has definitely earned its standing as one of the true success stories of the open source movement. Long a favorite database in the Linux and open source communities, it's made significant inroads into areas that used to be the exclusive province of Oracle or MS SQL Server. While its price is attractive--the GPL-licensed version is free for internal use, and commercial licenses and support are quite inexpensive--affordability is not the only factor in MySQL's success. There are, after all, other cost-free, open source databases available, but few can compete with MySQL's solid reputation for speed, ease of use, and flexibility.
SQL
Would the basics of SQL querying be useful to you, but you don?t want to start at the very beginning? Do you wish you had an easy way to ramp up quickly to get a basic understanding of key features and capability? Then you need this book! Without a ton of conceptual information or general programming basics you already know, this book is a quick guide for computing professionals and programmers to learn the basics--and more--in an easily digestible way.
SQL for Smarties, 3e
SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an SQL programmer into an expert. This book, the best selling advanced SQL book and written by an SQL guru, has been completely updated to include features of SQL 99 now included in commercial DBMS implementations, with all new examples and war stories. Joe Celko is an Independent Consultant & Columnist for Intelligent Enterprise.
Moving Objects Databases
Why do you need this book? With current systems, most data management professionals are not able to smoothly integrate spatio-temporal data from moving objects, making data from, say, the path of a hurricane very difficult to model, design, and query. Whether your field is geology, national security, urban planning, mobile computing, or almost anything in between, this books concepts and techniques will help you solve the data management problems associated with this kind of data.
SQL: Practical Guide for Developers
Would the basics of SQL querying be useful to you, but you dont want to start at the very beginning? Do you wish you had an easy way to ramp up quickly to get a basic understanding of key features and capability? Then you need this book! Without a ton of conceptual information or general programming basics you already know, this book is a quick guide for computing professionals and programmers to learn the basics--and more--in an easily digestible way.
Professional Oracle Programming
If you are a developer who wants to use Oracle to build effective, robust, and scalable software applications, look no further. Written by a team of leading authorities on the Oracle database, this example-packed book is divided into three main areas: how the Oracle database works, how to use SQL and programming languages to access Oracle, and how to use the features of Oracle effectively in creating your applications.
Cryptography in the Database: The Last Line of Defense
If hackers compromise your critical information, the results can be catastrophic. You're under unprecedented pressure—from your customers, your partners, your stockholders, and now, the government—to keep your data secure. But what if hackers evade your sophisticated security mechanisms? When all else fails, you have one last powerful line of defense: database cryptography. In this book, a leading crypto expert at Symantec demonstrates exactly how to use encryption with your own enterprise databases and applications.
(Review excerpt from Amazon.com)
Oracle PL/SQL by Example, 3rd Edition
This book presents the Oracle PL/SQL programming language in a unique and highly effective format. It challenges you to learn Oracle PL/SQL by using it rather than simply reading about it.
SQL Server 2005 Distilled
Need to get your arms around Microsoft SQL Server 2005 fast, without getting buried in the details? Need to make fundamental decisions about deploying, using or administering Microsoft's latest enterprise database? Need to understand what's new in SQL Server 2005 and how it fits with your existing IT and business infrastructure? SQL Server 2005 Distilled delivers the answers you need - quickly, clearly and objectively.
Microsoft SQL Server 2005 Reporting Services
SQL Server Reporting enables the creation, management, and delivery of both traditional, paper-oriented reports and interactive, Web-based reports. An integrated part of the Microsoft business intelligence framework, Reporting Services combines the data management capabilities of SQL Server and Microsoft Windows Server with familiar and powerful Microsoft Office System applications to deliver real-time information to support daily operations and drive decisions. Microsoft SQL Server 2005 Reporting Services will help you understand Reporting Services from various perspectives:
- How it fits business scenarios
- How to install and configure Reporting Services
- Reporting Services components
- Developing reports
As you progress to advanced user status, you will enjoy the chapter about accessing Reporting Services programmatically and extending Reporting Services, and you will be able to use this b
Mobile Database Systems
A breakthrough sourcebook to the challenges and solutions for mobile database systems
This text enables readers to effectively manage mobile database systems (MDS) and data dissemination via wireless channels. The author explores the mobile communication platform and analyzes its use in the development of a distributed database management system. Workable solutions for key challenges in wireless information management are presented throughout the text.
Following an introductory chapter that includes important milestones in the history and development of mobile data processing, the text provides the information, tools, and resources needed for MDS management, including:
- Fundamentals of wireless communication
- Location and handoff management
- Fundamentals of conventional database management systems and why existing approaches are not adequate for mobile databases
- Concurrency control mechanism schemes
- Data
SQL Server 2005 for Developers
Capturing and analyzing data about customers, products, and the market is essential to staying competitive. Microsoft SQL Server is a leading database tool, and with its ease of use and low total ownership cost, you can customize it to meet your ever-changing business needs. SQL Server 2005 has many enhanced tools that fall into three main categories: data management, developer tools, and business intelligence.
SQL Server 2005 for Developers teaches you how to leverage these new tools by covering the topics relevant to developers. Samples throughout the book illustrate the features of SQL Server 2005 in a realistic manner, and provide insights into the new ways for developers to manipulate servers and databases. Specific discussions of similarities and differences between SQL Server 2005 and past versions allow you to use what you already know and apply it efficiently. After working through the book, you?ll be up to speed and ready to integrate S
Oracle Database Programming Using Java and Web Services
This is the first book to cover new Java, JDBC, SQLJ, JPublisher and Web Services features in Oracle Database 10g Release 2 (the coverage starts with Oracle 9i Release 2). This book is a must-read for database developers audience (DBAs, database applications developers, data architects), Java developers (JDBC, SQLJ, J2EE and OR Mapping frameworks) and to the emerging Web services assemblers.
Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition
In Joe Celko's SQL for Smarties: Advanced SQL Programming, he picks up where basic SQL training and experience leaves many database professionals and offers tips, techniques, and explanations that help readers extend their capabilities to top-tier SQL programming.
Although Celko denies that the book is about database theory, he nevertheless alludes to theory often to buttress his practical points. This title is not for novices, as the author points out. Instead, its intended audience is SQL programmers with at least a year's experience. The book maintains a fine balance between technical discussion and practical explanation--picking hot topics and offering advice on a wide range of issues.
The Relational Database Dictionary
This book contains more than six hundred entries dealing with issues, terms and concepts involved in, or arising from use of, the relational model of data. Many of the entries include not only definitions but also one or more illustrative examples. Dr. Date says, "I've done my best to make the definitions as clear, precise, and accurate as possible; they're based on my own best understanding of the material, an understanding I've been honing gradually over some thirty-five years of involvement in this field."
Whether you're using Oracle, DB2, SQL Server, MySQL, or PostgreSQL, "The Relational Database Dictionary" will prevent confusion about the precise meaning of database-related terms (e.g., attribute, 3NF, one-to-many correspondence, predicate, repeating group, join dependency), helping to ensure the success of your database projects. The dictionary has been carefully reviewed for clarity, accuracy, and completeness to make certain it's an authoritative a
Mining Graph Data
This text takes a focused and comprehensive look at an area of data mining that is quickly rising to the forefront of the field: mining data that is represented as a graph. Each chapter is written by a leading researcher in the field; collectively, the chapters represent the latest findings and applications in both theory and practice, including solutions to many of the algorithmic challenges that arise in mining graph data. Following the authors' step-by-step guidance, even readers with minimal background in analyzing graph data will be able to represent data as graphs, extract patterns and concepts from the data, and apply the methodologies presented in the text to real datasets.
MySQL Cookbook
Along with MySQL's popularity has come a flood of questions about solving specific problems, and that's where this Cookbook is essential. Designed as a handy resource when you need quick solutions or techniques, the book offers dozens of short, focused pieces of code and hundreds of worked-out examples for programmers of all levels who don't have the time (or expertise) to solve MySQL problems from scratch.
The new edition covers MySQL 5.0 and its powerful new features, as well as the older but still widespread MySQL 4.1. One major emphasis of this book is how to use SQL to formulate queries for particular kinds of questions, using the mysql client program included in MySQL distributions. The other major emphasis is how to write programs that interact with the MySQL server through an API. You'll find plenty of examples using several language APIs in multiple scenarios and situations, including the use of Ruby to retrieve and format data.
Microsoft SQL Server 2005 Analysis Services (SQL Server Series)
Microsoft SQL Server 2005 Analysis Services is definitive guide to programming Analysis Services 2005. It will give you unparalleled insight into the ways in which Analysis Services functions straight from the members of the Analysis Services team at Microsoft . It not only explains ways to use Analysis Services 2005 to design and create multidimensional objects, databases, dimensions, cubes, but it also provides invaluable information about the reasons behind design decision taken by the development team.
Chapters include:
- Introduction to Analysis Services
- Creating Multidimensional Models using Analysis Services
- Security
- High availability
- Localization and Globalization
SQL Server 2005 Practical Troubleshooting: The Database Engine
From caching to clustering, query processing to Service Broker, this book will help you address even the toughest problems with database engine operations. Each chapter begins with a brief architectural overview of a key SQL Server component, then drills down into the most common problems users encounter, offering specific guidance on investigating and resolving them. You'll find comprehensive, in-depth chapters on
- Waiting and blocking
- Data corruption and recovery
- Memory
- Procedure cache issues
- Query processing
- Server crashes and other critical failures
- Service Broker
- SQLOS and scheduling
- tempdb
- Clustering
SQL Server 2005 DBA Street Smarts: A Real World Guide to SQL Server 2005 Cert.
Hit the ground running with the street-smart training you'll find in this practical book. Using a "Year in the life" approach, it gives you an inside look at SQL Server 2005 database administration, with key information organized around the actual day-to-day tasks, scenarios, and challenges you'll face in the field. This valuable training tool is loaded with hands-on, step-by-step exercises covering all phases of SQL Server 2005 administration, including:
- Installing and configuring SQL Server
- High availability and disaster recovery
- Maintenance and automation
- Monitoring and troubleshooting
SQL Server 2005 Bible
Seasoned database developers think inside the box, because that's where the cool code is. This comprehensive reference takes you inside the latest, coolest, and most powerful box, Microsoft's SQL Server 2005. Each of the book's seven sections focuses on key elements in a logical sequence, so you can easily find what you need—including all the basics, best practices, dozens of targeted examples, and sample code. If you develop, manage, or maintain SQL Server 2005 databases, this in-depth book is what you need to succeed!
- Master the fundamentals of SQL Server technology
- Write better logic queries for greater success
- Manage and secure a production database 24/7/365
- Integrate with .NET CLR and XML
- Understand SOA and emerging technologies
CompTIA A+ Complete Study Guide
All-in-one guide prepares you for CompTIA's new A+ Certification
Candidates aiming for CompTIA's revised, two-exam A+ Certified Track will find everything they need in this value-packed book. Prepare for the required exam, CompTIA A+ Essentials (220-601), as well as your choice of one of three additional exams focusing on specific job roles--IT Technician (220-602), Remote Support Technician (220-603), or Depot Technician (220-604). Inside, you'll find:
- Comprehensive coverage of all exam objectives for all four exams in a systematic approach, so you can be confident you're getting the instruction you need
- Hand-on exercises to reinforce critical skills
- Real-world scenarios that show you life beyond the classroom and put what you've learned in the context of actual job roles
- Challenging review questions in each chapter to prepare you for exam day
- Exam Essentials, a key feature at the end of each chapter <
Professional SQL Server 2005 Administration
Drawing on their own first-hand experiences to offer you best practices, unique tips and tricks, and useful workarounds, the authors help you handle even the most difficult SQL Server 2005 administration issues, including blocking and locking. You'll learn how to fine-tune queries you've already written, automate redundant monitoring and maintenance tasks, and use hidden tools so that you can quickly get over the learning curve of how to configure and administer SQL Server 2005.
What you will learn from this book:- How to use some of the more advanced concepts of installation.
- Techniques for properly administering development features such as SQL CLR.
- Ways to secure your SQL Server from common threats.
- How to choose the right hardware configuration.
- Best practices for backing up and recovering your database.
- Step-by-step guidelines for clustering your SQL Server.
Beginning SQL Server 2005 Administration
Beginning with a foundation that features detailed coverage of typical administrative duties, the authors proceed to explain how to build complex data transformations for data import, build distributed data solutions, and maintain the security and integrity of the database. You will be able to apply what you learn to real-world scenarios, and smoothly navigate the vastly changed landscape of SQL Server 2005 administration.
What you will learn from this book:- How to install, maintain, and manage an SQL Server 2005 installation, including high availability and security considerations.
- Various features such as the Common Language Runtime, SQL Server Integration Services, Notification Service, and the Service Broker.
- How to use the tools that are necessary to manage configuration, backups, restores, security, availability, performance and monitoring.
- A sampling of some of the more advanced areas and complex jobs of the broadening role of a d
Professional SQL Server 2005 CLR Programming: with Stored Procedures, Functions,
SQL Server 2005 offers the capability to write code in a .NET language that can be compiled and run inside SQL Server. CLR Integration, or SQL CLR, lets you create stored procedures, user-defined types, triggers, table valued functions, and aggregates using a .NET managed language. You can read and write to resources outside of SQL Server and enjoy a tighter integration with XML, web services, and simple file and logging capabilities.
Here's the reference you'll want on your desk as you develop SQL CLR solutions. It helps you decide whether to use SQL CLR, how to lock down security, and learn from real examples. If you want to develop stored procedures or other objects in .NET for SQL Server 2005, this book offers exactly what you need.
Professional SQL Server 2005 Programming (Programmer to Programmer)
Professional SQL Server 2005 Programming shows experienced developers how to master the substantially revamped feature set of the latest release of Microsoft SQL Server. The book begins with a concise overview of the new features of SQL Server that is of interest to experienced developers. This is especially important given the substantial changes to SQL Server with this release. From there, the book quickly moves on to the "meat" of the title. Beginning-level material has been removed to provide more room for covering new features and more extensive code examples.
Understanding MySQL Internals
The core of Understanding MySQL Internals begins with an Architecture Overview that provides a brief introduction of how the different components of MySQL work together. You then learn the steps for setting up a working compilable copy of the code that you can change and test at your pleasure. Other sections of the book cover:
- Core server classes, structures, and API
- The communication protocol between the client and the server
- Configuration variables, the controls of the server; includes a tutorial on how to add your own
- Thread-based request handling -- understanding threads and how they are used in MySQL
- An overview of MySQL storage engines
- The storage engine interface for integrating third-party storage engines
- The table lock manager
- The parser and optimizer for improving MySQL's performance
- Integrating a transactional storage engine into MySQL
- The internals of replication
SQL for MySQL Developers: A Comprehensive Tutorial and Referenc
MySQL version 5 offers a SQL dialect with immense power. In SQL for MySQL Developers, Rick F. van der Lans helps you master this version ofSQL and take advantage of its full potential. Using case study examplesand hands-on exercises, van der Lans illuminates every key concept,technique, and statement-including advanced features that make iteasier to create even the most complex statements and programs.
Whether you're a programmer, Web developer, analyst, DBA, or database user, this book can take you from "apprentice" to true SQL expert. If you've used SQL in older versions of MySQL, you'll become dramatically more effective-and if you're migrating from other database platforms, you'll gain practical mastery fast.- Coverage includes
- Writing queries, including joins, functions, and subqueries
- Updating data
- Creating tables, views, and other database objects
- Specifying keys and other integrity constraints
Physical Database Design
Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more.
The rapidly increasing volume of information contained in relational databases places a strain on databases, performance, and maintainability, and DBAs are under greater pressure than ever to optimize database structure for system performance and administration.
Physical Database Design discusses the concept of how physical structures of databases affect performance and includes specific examples, guidelines, and best and worst practices for a variety of DBMSs and configurations. Something as simple as improving the table index design has a profound impact on performance. Every form of relational database, such as Online Transaction Processing (OLTP), Enterprise Resource Management (ERP), Data Mining (DM), or Management Resource Planning (MRP), can be improved using these methods.Refactoring Databases: Evolutionary Database Design
From the Back Cover
Refactoring has proven its value in a wide range of development projects-helping software professionals improve system designs, maintainability, extensibility, and performance. Now, for the first time, leading agile methodologist Scott Ambler and renowned consultant Pramodkumar Sadalage introduce powerful refactoring techniques specifically designed for database systems.
SQL Queries for Mere Mortals
Unless you are working at a very advanced level, this is the only SQL book you will ever need.
Implementing Enterprise Data Warehousing
Designing complex analytical data structures is difficult enough, but to do it for an entire enterprise becomes a real challenge. This little primer provides a simple method of preparing your people for the complexity of this endeavor. This is just like opening a new restaurant where certain components have to be designed and thought out before you start to build the kitchen. You do not have to be an "expert" to build a data warehouse. A lot can be outsourced, but you do need to be able to create your own plan according to your culture's specific requirements. Some cultures take more 'informing' and 'training' than others. The pace and aggressiveness with which you unfold your plan is something that you understand best. This primer defines the data warehouse components and helps you decide when they can be done, in what order, and by how many people.
Information Modeling and Relational Databases
Information Modeling and Relational Databases, second edition, provides an introduction to ORM (Object-Role Modeling)and much more. In fact, it is the only book to go beyond introductory coverage and provide all of the in-depth instruction you need to transform knowledge from domain experts into a sound database design.
Oracle PL/SQL: Expert Techniques For Developers and Database Administrators
This book takes you beyond the existing solutions found in other professional and reference texts or in online documentation. Starting from PL/SQL internals that include PL/SQL program structure, internal representation, compilation, and execution, users are taught PL/SQL concepts and techniques that go way beyond SQL, such as data structure management, error management, data management, application management, and transaction management.
