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.

The Best Fully Integrated Study System Available With hundreds of practice questions and hands-on exercises, MCTS SQL Server 2005 Implementation & Maintenance Study Guide covers what you need to know-and shows you how to prepare-for this challenging exam. 100% complete coverage of all official objectives for Exam 70-431Exam Readiness Checklist at the front of the book-you're ready for the exam when all objectives on the list are checked offInside the Exam sections in every chapter highlight key exam topics coveredSimulated exam questions match the format, tone, topics, and difficulty of the real examCovers all the exam topics, including:Installing and Configuring SQL Server 2005 * Creating Databases and Database Objects * SQL Server Security * Creating Views, Partitions, and Linked Servers * Transact-SQL Programming * Working with Constraints, Triggers, and Stored Procedures * Backup and Restore of SQL Server with SQL Agent Jobs * Data Redundancy and Availability * Using the Service Broker * XML Data Support * SQL Server Performance Monitoring and Tuning * Troubleshooting Server and Database ErrorsCD-ROM includes:Complete MasterExam practice testing engine, featuring: One full practice exam; Detailed answers with explanations; Score Report performance assessment toolVideo training clips from the authorElectronic book for studying on the goWith free online registration:One-hour LearnKey video training sessionBonus downloadable MasterExam practice test.

Microsoft SQL Server 2005 Management and Administration, based on Service Pack 2, addresses the challenges database administrators regularly encounter on SQL Server 2005 by providing detailed guidance in the areas of management, administration, security, and monitoring. With coverage of the new features and functionality of SQL Server 2005 Service Pack 2, this book is designed to be comprehensive, resulting in something for all database administrators—from simple tips to tactical solutions. Microsoft SQL Server 2005 Management and Administration goes far beyond the basic installation and setup information found in many other resources. The book looks at day-to-day administration, best practices, tips, and step-by-step configurations based on real-world examples found in the industry. Unlike others, this book includes not only administration and management details on the Database Engine, but also coverage of other SQL Server 2005 components often overlooked, including Analysis Services, Reporting Services, and more.   Understand how to… Configure and tune the Database Engine, Reporting Services, Analysis Services, Integration Services, and Notification Services Harden a SQL Server implementation Implement SQL Server highavailability alternatives, such as Failover Clustering, Log Shipping, Database Mirroring, and Replication Monitor a SQL Server 2005 infrastructure with Operations Manager 2007, including how to configure the SQL Server Management Pack and install Operations Manager 2007 Automate SQL Server routine maintenance Encrypt SQL Server data and communications, including setting up a Certificate Authority Performance tune and troubleshoot a SQL Server environment Create Integration Services packages and transfer data On the Web: Download bonus chapters from www. informit. com/title/9780672329562     Introduction 1 Part I                Administering SQL Server Components 1          Administering SQL Server 2005 Database Engine 11 2          Administering SQL Server 2005 Analysis Services 67 3          Administering SQL Server 2005 Reporting Services 99 4          Administering SQL Server 2005 Notification Services 149 5          Administering SQL Server 2005 Integration Services 183 6          Administering SQL Server Replication 209 Part II    Managing SQL Server 2005 7          Conducting a SQL Server 2005 Health Check 261 8          SQL Server 2005 Maintenance Practices 289 9          Managing and Optimizing SQL Server 2005 Indexes 317 10         Managing Full-Text Catalogs 353 11         Creating Packages and Transferring Data 387 Part III   Securing the SQL Server Implementation 12         Hardening a SQL Server 2005 Environment 435 13         Administering SQL Server Security 469 14         Encrypting SQL Server Data and Communications 509 The following chapters are located online: Part IV  SQL Server 2005 Overview (located online) 15         SQL Server 2005 Technology Primer  537 16         Tools of the Trade 571 Part V   Disaster Recovery and High Availability (located online) 17         Backing Up and Restoring the SQL Server 2005 Environment 597 18         Administering and Managing Failover Clustering 647 19         Administering and Managing Database Mirroring 691 20         Administering and Managing Log Shipping 721 Part VI  Monitoring and Troubleshooting SQL Server (located online) 21         Monitoring SQL Server 2005 753 22         Performance Tuning and Troubleshooting SQL Server 2005 787 Appendix           SQL Server 2005 Management and Administration 821.

Discover the SQL Query window, which provides an easy-to-use windowing interface to the SQL procedure. A comprehensive overview and step-by-step examples show you how to query SAS data sets and data from database management systems. The SQL Query window supports the PROC SQL Pass-Through facility and enables you to access data through remote hosts using SAS/CONNECT software. You can also design reports with PROC REPORT based on your SQL Query Window's output. This title is written for those who are familiar with basic SAS terminology and concepts. No previous experience with PROC SQL or SAS code is needed. This title is available for purchase as a hardcopy or digital book, or in the SAS OnlineDoc CD-ROM with PDF files. The HTML version of SAS OnlineDoc CD-ROM is shipped free with Version 8. Supports releases 8. 00 and higher of SAS software.

Clustered configuration first hit the scene nearly 20 years ago when Digital Equipment Corporation (DEC) introduced the VaxCluster. Until now, the topic of Real Application Clusters (RAC) implementation had never been fully explored. For the first time, Murali Vallath dissects RAC mysteries in his book Oracle Real Application Clusters to enlighten and educate readers on the internals of RAC operations, cache fusion, fusion recovery processes and the fast reconfiguration of RAC. This book provides comprehensive coverage of the features, technology and principles of RAC that is part of the Oracle9i release of Oracle's RDBMS product. It is divided into three main parts: application/database design, development and maintenance life cycles. Compared to its predecessor OPS, the architecture behind RAC implementation have changed significantly. Vallath discusses Oracle9i features in a RAC implementation with respect to usage and design considerations, as well as those parameters that are and are not applicable. Areas covered include partitioning, indexes, tablespace management, transaction management, backup and recovery principles. Performance tuning with examples, troubleshooting and problem solving scenarios are covered in detail, as well as discussions on the migration process from a single instance database to RAC and migration from an OPS implementation to RAC. Oracle Real Application Clusters takes readers through a logical flow from RAC concepts to operations, covering each facet with a fine-tooth comb. [+]

This case study by Mark Plummer explores design and implementation of an enterprise application data tier using C# and SQL Server. It's main focus is on single database servers, but multiple server implementation is also looked at along the way. Throughout the article, you'll learn to employ the new features of. NET with proven methodologies to create a high-performance, scalable transactional data tier.

This book is a pragmatic text designed to enable the reader to use the database INGRES, with the minimum amount of effort. It provides the essential foundation for becoming either an expert user of the system or mastering database design. Combining a practical approach with a theoretical understanding, this text allows the reader to become proficient in INGRES and to understand what features are being used and why.

If you want to learn SQL, you've picked the right book. Unlike most SQL books, this one starts by showing you how to use SQL queries to extract and update the data in a database, because that's what every application developer needs to know first. Then, it shows how to design and implement a database, how to use server-side features like views, stored procedures, cursors, and transactions, and how to use the CLR integration feature (new in SQL Server 2005) to create database objects in a. NET language like C# or Visual Basic. With this breadth of material, this book works well for application developers and SQL programmers, but it's also a great first book for DBAs-in-training.

Oracle's Mr. Linux details everything from installing the OS (Red Hat and United Linux) to installing the database to debugging and troubleshooting to performance, availability, and scalability. Wim is the Director of Linux Engineering at Oracle.

The MCTS 70-431 Exam Cram is a must-have resource in your MCTS 70-431 exam preparation.  The Exam Cram focuses on exactly what you need to know to get certified. This includes features like: Complete coverage of all 70-431 exam objectives Exam alerts, practice questions, notes, tips, sidebars, cautions, test-taking strategies, and time-saving tips Access to MeasureUp practice questions and innovative testing software The popular Cram Sheet tear card, giving you the key facts you should review before you enter the testing center Insight from author Thomas Moore, a Microsoft Certified Trainer (MCT) and SQL Server expert who has helped hundreds of students earn their SQL Server certifications.

Provides a total interactive prep for Microsoft's SQL Server 7 Exam (70-028) with 80+ digital videos, animations, and hundreds of interactive exercises. System requirements: Windows 95+, 20MB disk space 32MB RAM and a CD-ROM drive. CD-ROM.

This unique guide, written by a senior member of IBM's DB2 development team, is the first book to cover DB2 version 6. And the only book to offer a trial edition of the software on CD-ROM. You will discover how to install a DB2 server and clients, design and administer a database, and much more. DB2 for Dummies approaches problems of database engineering and administration via IBM's DB2 Universal Database solution. It assumes essentially no reader experience with relational databases, and absolutely no experience with DB2. For those reasons, it is excellent. All three of the authors work for IBM on the DB2 team, and they've merged their technical expertise into the Dummies format nicely. The book earns its keep for two classes of readers. First, it's well-suited to people who have no database experience at all and want to learn via DB2. Second, it's a fine text for people who have experience with another relational database management system (RDBMS), such as Oracle or Sybase, and want to learn how DB2 works. [+]