Providing a powerful graphical interface for managing MySQL, phpMyAdmin is one of the most popular open source applications. While most MySQL developers use routine features of phpMyAdmin every day, few are aware of the power and potential of its advanced features.Показать полностьюProviding a powerful graphical interface for managing MySQL, phpMyAdmin is one of the most popular open source applications. While most MySQL developers use routine features of phpMyAdmin every day, few are aware of the power and potential of its advanced features. This book builds a solid understanding of the core capabilities of phpMyAdmin before walking you through every facet of this legendary tool. MySQL Used by millions of developers, MySQL is the most popular open source database, supporting numerous large dynamic websites and applications. MySQL has acquired this wide popularity by virtue of its open source nature, performance, reliability, robustness, and support for various platforms. However, this popularity has also been helped by the existence of phpMyAdmin, the industry standard administration tool that makes database management easy for both the experienced developer and their novice. The powerful graphical interface that it provides to MySQL has made phpMyAdmin an indispensable tool for MySQL and web developers. Every phpMyAdmin user can benefit from unlocking the full potential of this powerful application. Upgrade Advice The prior edition of this book was written for version 2.6. Most of the changes to phpMyAdmin in version 2.8 are in the user interface and not the underlying functionality. This book brings the screen shots and user instructions into line with the new interface. If as a reader you are happy with the new interface already you don't need to upgrade to this new edition of the book.

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. + Provides tutorial-based instruction for the main features of SQL for programmers and other technical professionals in need of a brief but really good introduction to SQL. + The approach is vendor-neutralso very adaptable and flexiblebut the books Web site includes information about DBMS-specific peculiarities. + The focus is on teaching concepts by walking through concrete examples and explanations, and self-review exercises are included at the end of each chapter. + Coverage is on the key features of the language that are required to understand SQL and begin using it effectively. + SQL 2003-compliant.

The second edition of the best-selling PostgreSQL has been updated to completely cover new features and capabilities of the 8.0 version of PostgreSQL.Показать полностьюThe second edition of the best-selling PostgreSQL has been updated to completely cover new features and capabilities of the 8.0 version of PostgreSQL. You will be lead through the internals of the powerful PostgreSQL open source database chapter, offering an easy-to-read, code-based approach that makes it easy to understand how each feature is implemented, how to best use each feature, and how to get more performance from database applications. This definitive guide to building, programming and administering the powerful PostgreSQL open-source database system will help you harness one of the most widely used open source, enterprise-level database systems.

For all the buzz about trendy IT techniques, data processing is still at the core of our systems, especially now that enterprises all over the world are confronted with exploding volumes of data.Показать полностьюFor all the buzz about trendy IT techniques, data processing is still at the core of our systems, especially now that enterprises all over the world are confronted with exploding volumes of data. Database performance has become a major headache, and most IT departments believe that developers should provide simple SQL code to solve immediate problems and let DBAs tune any “bad SQL” later. In The Art of SQL, author and SQL expert Stephane Faroult argues that this “safe approach” only leads to disaster. His insightful book, named after Art of War by Sun Tzu, contends that writing quick inefficient code is sweeping the dirt under the rug. SQL code may run for 5 to 10 years, surviving several major releases of the database management system and on several generations of hardware. The code must be fast and sound from the start, and that requires a firm understanding of SQL and relational theory. The Art of SQL offers best practices that teach experienced SQL users to focus on strategy rather than specifics. Faroult’s approach takes a page from Sun Tzu’s classic treatise by viewing database design as a military campaign. You need knowledge, skills, and talent. Talent can't be taught, but every strategist from Sun Tzu to modern-day generals believed that it can be nurtured through the experience of others. They passed on their experience acquired in the field through basic principles that served as guiding stars amid the sound and fury of battle. This is what Faroult does with SQL. Like a successful battle plan, good architectural choices are based on contingencies. What if the volume of this or that table increases unexpectedly? What if, following a merger, the number of users doubles? What if you want to keep several years of data online? Faroult’s way of looking at SQL performance may be unconventional and unique, but he’s deadly serious about writing good SQL and using SQL well. The Art of SQL is not a cookbook, listing problems and giving recipes. The aim is to get you-and your manager-to raise good questions.

Those of you who are currently using Microsoft SQL Server 7 might not notice significant changes on the surface when you move to Microsoft SQL Server 2000.Показать полностьюThose of you who are currently using Microsoft SQL Server 7 might not notice significant changes on the surface when you move to Microsoft SQL Server 2000. You will soon observe, however, that SQL Server 2000 includes many enhancements. One major enhancement is increased support for larger memory models. In fact, when you use SQL Server 2000 in conjunction with Microsoft Windows 2000 Datacenter Server, you can access up to 64 gigabytes (GB) of physical memory. You might also be able to take advantage of enhanced Extensible Markup Language (XML) support, indexed views, and user-defined functions. As you begin using SQL Server 2000, you will also discover improvements in the tools, such as Enterprise Manager, Query Analyzer, and Profiler. SQL Server 2000 improves on SQL Server 7 in almost every area. To those of you who are already familiar with SQL Server 7, this book will serve as a guide to the enhancements included in SQL Server 2000. To those of you who are new database administrators (DBAs) but are not necessarily familiar with SQL Server, this book will serve as an introduction to SQL Server technology. This book will help the novice get started.

Learn all you need to know about SQL with this one-stop resource. Updated to include information on Web services and XML, this complete guide also comes with a Windows 2000- and XP- compatible CD containing 4 databases (SQL Server 2000, IBM DB2 Version 7.2, Sybase, and mySQL).

SQL Performance Tuning is a handbook of practical solutions for busy database professionals charged with managing an organization’s critically important data.Показать полностьюSQL Performance Tuning is a handbook of practical solutions for busy database professionals charged with managing an organization’s critically important data. Covering today’s most popular and widely installed database environments, this book is an indispensable resource for managing and tuning SQL across multiple platforms. Packed with tips, techniques, and best practices, this hands-on guide covers SQL commands and queries over a wide range of conditions and environments. Every facet of the SQL environment is covered, from concurrency control to optimization—and every issue in between. The book includes an overview of each of the most widely used database management systems (DBMS) and provides tuning tips for common day-to-day situations. Topics covered include: # General and specific tuning # General sort considerations and options # Joins and subqueries # Columns and tables # Indexes, including B-trees and bitmaps # Constraints and stored procedures # ODBC and JDBC # Data changes and concurrency control (locking) # Clients, servers, and middleware Whether you are a programmer, consultant, or user, you will find SQL Performance Tuning an indispensable guide to optimizing SQL performance across today’s popular database environments. Throughout SQL Performance Tuning, ideas and techniques are tested on a variety of popular SQL environments, including IBM DB2, Informix, Ingres, InterBase, Microsoft SQL Server, MySQL, Oracle, and Sybase ASE. The book’s practical examples are written in ANSI/ISO Standard SQL: 1999.

SQL Server 2005 Reporting Services allows you to design, create, view, and manage reports. Reports can be distributed and managed over the Web. End users can create, publish, and share ad hoc reports-all using web-based tools. This book shows you how to use Report Builder, a tool that lets information workers build ad hoc reports, and how to use Report Designer, a report development tool hosted in Visual Studio that lets you interactively create reports.Показать полностьюSQL Server 2005 Reporting Services allows you to design, create, view, and manage reports. Reports can be distributed and managed over the Web. End users can create, publish, and share ad hoc reports-all using web-based tools. This book shows you how to use Report Builder, a tool that lets information workers build ad hoc reports, and how to use Report Designer, a report development tool hosted in Visual Studio that lets you interactively create reports. This book shows you how to publish, manage, and run those reports. This book concludes by showing the three mechanisms used by developers to integrate reports into applications: form controls, parameterized URLs, and web services.

In this book, two of Microsoft’s leading consultants illustrate how to use SQL Server 2005 Business Intelligence (BI) technologies to solve real-world problems in markets ranging from retail and finance to healthcare.Показать полностьюIn this book, two of Microsoft’s leading consultants illustrate how to use SQL Server 2005 Business Intelligence (BI) technologies to solve real-world problems in markets ranging from retail and finance to healthcare. Drawing on extensive personal experience with Microsoft’s strategic customers, John C. Hancock and Roger Toren offer unprecedented insight into BI systems design and step-by-step best practices for implementation, deployment, and management. Hancock and Toren introduce practical BI concepts and terminology and provide a concise primer on the Microsoft BI platform. Next, they turn to the heart of the bookconstructing solutions. Each chapter-length case study begins with the customer’s business goals, and then guides you through detailed data modeling. The case studies show how to avoid the pitfalls that derail many BI projects. You'll translate each model into a working system and learn how to deploy it into production, maintenance, and efficient operation. Whether you're a decision-maker, architect, developer, or DBA, this book brings together all the knowledge you'll need to derive maximum business value from any BI project. • Leverage SQL Server 2005 databases, Integration Services, Analysis Services, and Reporting Services • Build data warehouses and extend them to support very large databases • Design effective Analysis Services databases • Ensure the superior data quality your BI system needs • Construct advanced enterprise scorecard applications • Use data mining to segment customers, cross-sell, and increase the value of each transaction • Design real-time BI applications • Get hands-on practice with SQL Server 2005’s BI toolset

This is a coders book. Its intended to help developers build applications that make use of Transact-SQL. Its not about database administration or design. Its not about end-user or GUI application development. Its not even about server or database performance tuning. Its about developing the best Transact-SQL code possible, regardless of the application.

The Microsoft Transact-SQL programming language has become an increasingly popular solution for developers seeking to build powerful and scalable distributed SQL Server applications.Показать полностьюThe Microsoft Transact-SQL programming language has become an increasingly popular solution for developers seeking to build powerful and scalable distributed SQL Server applications. This follow-up to the widely acclaimed The Guru’s Guide to Transact-SQL covers current subjects critical to successful SQL Server application development in depth, while leading developers to new heights in their overall programming skills. Blending theoretical detail with practical application, this comprehensive reference begins by providing a foundational overview of SQL Server stored procedure programming. From there, the book moves on to best practices and design considerations before progressing to advanced topics — providing the most complete coverage of SQL Server stored procedure programming available in one source. Topics such as extended procedures, OLE Automation, database design, and XML are covered in detail, while the book spotlights undocumented language features and brings the first application of design patterns to SQL. The preview of.NET and a groundbreaking way to add arrays to Transact-SQL make for the most thorough and engaging read published to date on SQL Server programming. The Guru’s Guide to SQL Server Stored Procedures, XML, and HTML includes sample projects with complete source code suitable for plugging into real world applications. Additional highlights include: End-to-end coverage of stored procedure construction, best practices, and common conventions. In-depth coverage of “procedural” objects, including triggers, views, and user-defined functions. A comprehensive discussion of employing HTML and XML in SQL Server applications, as well as an introduction to Microsoft’s new .NET platform. Expert advice on debugging and profiling stored procedure code. Step-by-step instructions on how to create advanced stored procedure objects including extended stored procedures and administrative procedures. A behind-the-scenes look at undocumented Transact-SQL elements and coding tricks. Software engineering essays addressing the work environment, evolutionary code development, and software testing. An accompanying CD-ROM contains the book’s source code along with several handy database administration tools. More than 600 code files, programming utilities, extended procedures, and SQL scripts demonstrate the real power of SQL Server programming and provide a tremendous value to the reader. Both comprehensive and practical, The Guru’s Guide to SQL Server Stored Procedures, XML, and HTML provides developers with a complete tool set for becoming expert stored procedure programmers and better software practitioners.

This guide provides an overview of the general guidelines for keeping a computer network up and running, focuses on specific techniques for clustering, log shipping, using replication, backing up a database, and implementing a recovery model.

Your hands-on guide to learning Microsoft SQL Server Analysis Services, Microsofts customizable analysis solution for business data modeling and interpretation.Показать полностьюYour hands-on guide to learning Microsoft SQL Server Analysis Services, Microsofts customizable analysis solution for business data modeling and interpretation. Analysis Services is a powerful tool for business intelligence, so understanding the essentialshow to create a cube, as well as how to deploy, customize, and extend the basic calculationsis critical to harnessing the full benefits of SQL Server. This step-by-step tutorial shows you how to get started, how to build scalable analytical applications, and how to use and administer advanced features. Interactivity features (enhanced in SQL Server 2005), data translation, and security are also covered in detail. With Step by Step, you work at your own pace through hands-on, learn-by-doing exercises. Whether youre a beginning programmer or new to this version of the technology, youll understand the fundamental techniques for using Analysis Services. A companion CD includes data sets and sample code.

With the release of SQL Server 2005, Microsoft is introducing a new multi-exam certification program. The Microsoft SQL Server 2005 Implementation and Maintenance exam (70-431) is the first stop for everyone entering this new certification track, and serves as both a single exam certification as well as the entry exam for the MCITP-level certifications.Показать полностьюWith the release of SQL Server 2005, Microsoft is introducing a new multi-exam certification program. The Microsoft SQL Server 2005 Implementation and Maintenance exam (70-431) is the first stop for everyone entering this new certification track, and serves as both a single exam certification as well as the entry exam for the MCITP-level certifications. This book provides an introduction to the development and administrative aspects of SQL Server 2005 and features practical guidance for all aspects of the exam. Get a great start in your certification process today with this comprehensive guide which includes: * Hundreds of challenging practice questions plus two bonus exams * Leading-edge exam preparation software, including a test engine Authoritative coverage of all key exam objectives, including: * Installing and Configuring SQL Server 2005 * Implementing High Availability and Disaster Recovery * Supporting Data Consumers * Maintaining Databases * Monitoring and Troubleshooting SQL Server Performance * Creating and Implementing Database Objects

This guide offers advanced advice on tuning the server, optimizing administration tasks through automation, and deploying SQL server in the Enterprise environment.

This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server.Показать полностьюThis book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you'll learn a new world of integration possibilities and be able to move away from scripting complex logic to programming tasks using a full-featured language. What you will learn from this book * Ways to quickly move and transform data * How to configure every aspect of SSIS * How to interface SSIS with web services and XML * Techniques to scale the SSIS and make it more reliable * How to migrate DTS packages to SSIS * How to create your own custom tasks and user interfaces * How to create an application that interfaces with SSIS to manage the environment * A detailed usable case study for a complete ETL solution Who this book is for This book is for developers, DBAs, and users who are looking to program custom code in all of the .NET languages. It is expected that you know the basics of how to query the SQL Server and have some fundamental programming skills. Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

# Covers the latest version of the ISO SQL standard (SQL-99) and gives readers information they need to know about the differences in vendor-specific SQL implementations including Oracle, Microsoft SQL Server, and IBM DB2 # Knowledge of this ubiquitous database programming language is becoming more critical as IT departments move toward more integrated heterogeneous platforms # Covers growing use of SQL with Web services and XML # CD-ROM includes a complete sample database and trial versions of major relational database management software

A major software release, SQL 2000 is tailor-made for the multitude of programmers working in the Windows 2000 Active Directory environment, which allows administrators and others to manage and share data.Показать полностьюA major software release, SQL 2000 is tailor-made for the multitude of programmers working in the Windows 2000 Active Directory environment, which allows administrators and others to manage and share data. This thorough guide is written for users switching from SQL 7 under Windows NT, as well as those starting from scratch. Clear, concise, and packed with examples, it includes: A migration-path chapter for users who are upgrading; configuration techniques using new data warehousing and XML capacities; case studies depicting large-scale deployments of applications and databases built with SQL 2000; a "fast-track" chapter at the end summarizing the entire book; a “secrets” appendix giving information on the least-known, but most powerful features of Microsoft SQL Server 2000; detailing new features of Windows and SQL 2000 and designed for easy reference, this is the professional’s step-by-step, fully illustrated introduction to an exciting new data management system.

Data warehouse administrators, Business Intelligence (BI) solution developers, and BI analysts will find out how to get the most out of Microsoft’s powerful BI tools which are included free in SQL Server 2005.This practical, start-to-finish guide explains how to develop a comprehensive, secure, integrated, and highly available BI solution.Показать полностьюData warehouse administrators, Business Intelligence (BI) solution developers, and BI analysts will find out how to get the most out of Microsoft’s powerful BI tools which are included free in SQL Server 2005.This practical, start-to-finish guide explains how to develop a comprehensive, secure, integrated, and highly available BI solution. Readers will learn to set up the database, mine and analyze data, and deliver the results.

PostgreSQL is one of the world’s most popular Open Source relational database systems. It is renowned for its wide range of capabilities, and its ability to perform functions not available in other databases.Показать полностьюPostgreSQL is one of the world’s most popular Open Source relational database systems. It is renowned for its wide range of capabilities, and its ability to perform functions not available in other databases. The forthcoming release ofA PostgreSQL 8.0 in late 2004/early 2005 will include major revisions, such as Win32 Native Support, and this book will provide the tools for anyone making the transition or learning about PostgreSQL for the first time. This book introduces readers to many of the most prominent features, simultaneously introducing key relational database design and management principles that will help the novice reader effectively manage their data-driven application. Over 150 pages of coverage is devoted to the most popular PostgreSQL APIs, including PHP, Perl, Java and C. Users of all levels will appreciate the 50 pages of condensed reference material covering PostgreSQL data types, syntax, the psql client, and large object support.