This book is a comprehensive user’s guide and reference for SQL'Mochile, an Oracle application development tool. This Guide includes a complete description of Module Language, an ANSI/ISO SQL standard for developing applications that access data stored in a relational database.Показать полностьюThis book is a comprehensive user’s guide and reference for SQL'Mochile, an Oracle application development tool. This Guide includes a complete description of Module Language, an ANSI/ISO SQL standard for developing applications that access data stored in a relational database. Module Language uses parameterized procedures to encapsulate SQL statements. The procedures can then be called from an Ada application. This Guide also describes how you can use SQL*Module to call PL/SQL procedures stored in an Oracle database. A number of complete examples using Module Language. Ada code, and stored database procedures are provided.

The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples.Показать полностьюThe vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQL on a regular basis, you want much more. You want to access the full power of SQL to write queries in an Oracle environment. You want a solid understanding of what’s possible with Oracle SQL, creative techniques for writing effective and accurate queries, and the practical, hands-on information that leads to true mastery of the language. Simply put, you want useful, expert best practices that can be put to work immediately, not just non-vendor specific overview or theory. Updated to cover the latest version of Oracle, Oracle 10g, this edition of the highly regarded Mastering Oracle SQL has a stronger focus on technique and on Oracle’s implementation of SQL than any other book on the market. It covers Oracle s vast library of built-in functions, the full range of Oracle SQL query-writing features, regular expression support, new aggregate and analytic functions, subqueries in the SELECT and WITH clauses, multiset union operators, enhanced support for hierarchical queries: leaf and loop detection, and the CONNECT_BY_ROOT operator, new partitioning methods (some introduced in Oracle9i Release 2), and the native XML datatype, XMLType. Mastering Oracle SQL, 2nd Edition fills the gap between the sometimes spotty vendor documentation, and other books on SQL that just don't explore the full depth of what is possible with Oracle-specific SQL. For those who want to harness the untapped (and often overlooked) power of Oracle SQL, this essential guide for putting Oracle SQL to work will prove invaluable.

You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL’s expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications.Показать полностьюYou know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL’s expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level. Let’s face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT FROM WHERE . But there is so much more you can do with the language. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about: -Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing out -Powerful, database-specific features such as SQL Server’s PIVOT and UNPIVOT operators, -Oracle’s MODEL clause, and PostgreSQL’s very useful GENERATE_SERIES function -Pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set -Bucketization, and why you should never use that term in Brooklyn. -How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques — The technique of walking a string, which allows you to use SQL to parse through the characters, words, or delimited elements of a string Written in O'Reilly’s popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony’s credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what’s still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.

This book is about POSTGRESQL, the most advanced open source database. From its origins in academia, POSTGRESQL has moved to the Internet with explosive growth. It is hard to believe the advances during the past four years under the guidance of a team of worldwide Internet developers. This book is a testament to their vision, and to the success that POSTGRESQL has become.

PL/SQL, Oracle’s powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performance and as the lines between developers and DBAs blur.

Get full details on all the innovative features and benefits available in the release of SQL Server 2005. This authoritative guide explains new and improved enterprise data management capabilities, developer functions, and business intelligence tools.

Traditional relational databases and embedded databases both have shortcomings that can leave a developer perplexed. So for many people, the solution resides in SQLite, an open source embeddable database with an amazingly small footprint (less than 250 kilobytes).Показать полностьюTraditional relational databases and embedded databases both have shortcomings that can leave a developer perplexed. So for many people, the solution resides in SQLite, an open source embeddable database with an amazingly small footprint (less than 250 kilobytes). SQLite packs a powerful array of features and can handle databases as large as 2 terabytes. It offers a flexible set of datatypes and the ability to perform transactions, and it is supported by languages like C, PHP, Perl, and Python. And because SQLite’s databases are completely file based, privileges are granted at the operating system level, allowing for easy and fast user management. The Definitive Guide to SQLite is the first book to devote complete coverage to the latest version of this powerful database. It offers you a thorough overview of SQLite capabilities and APIs, while remaining cognizant of newcomers who may be making their first foray into a database environment with SQLite. This book serves as both a first-time tutorial and future reference guide. You'll learn about SQLite extensions available for C, Java, Perl, PHP, Python, Ruby, and Tcl. The book thoroughly covers SQLite internals to help you take full advantage of its features while minimally impacting resource consumption. Author Mike Owens is the original creator of Pysqlite, the popular Python extension for SQLite.

This introduction to SQL server 2000 data transformation services (DTS) walks step-by-step through the procedures for building an extensible data movement application that periodically moves data from delimited text files.

This official MCSE TRAINING KIT teaches database administrators how to set up and support SQL Server 2000-as they prepare for MCP Exam 70-228, an elective on the MCSE track for Microsoft Windows(r) 2000 and a core exam for MCDBA certification.Показать полностьюThis official MCSE TRAINING KIT teaches database administrators how to set up and support SQL Server 2000-as they prepare for MCP Exam 70-228, an elective on the MCSE track for Microsoft Windows(r) 2000 and a core exam for MCDBA certification. Topics map directly to the objectives measured by the MCP exam, including installing and configuring SQL Server 2000, creating databases, optimizing database performance, extracting and transforming data, managing security, and monitoring and troubleshooting SQL Server system activity. Students learn through an integrated system of skill-building tutorials, case study examples, and self-assessment exercises. An economical alternative to classroom instruction, this kit enables students to set their own pace and learn by doing!

This book reveals the power of the SQL Server 2005 tools to database management system professionals, enabling you to maximize productivity. The authors of the book have been working on the SQL Server 2005 team since its inception, they share the philosophy behind the design of the tools, and they are familiar with insider tips and tricks. The SQL Server 2005 family of products consists of Database Engine, Analysis Services, Reporting Services, Integration Services, Notification Services, and SQL Server Mobile Edition (SQL Server Everywhere Edition).Показать полностьюThis book reveals the power of the SQL Server 2005 tools to database management system professionals, enabling you to maximize productivity. The authors of the book have been working on the SQL Server 2005 team since its inception, they share the philosophy behind the design of the tools, and they are familiar with insider tips and tricks. The SQL Server 2005 family of products consists of Database Engine, Analysis Services, Reporting Services, Integration Services, Notification Services, and SQL Server Mobile Edition (SQL Server Everywhere Edition). This book describes the core functionality of all the SQL Server 2005 tools, and closely examines the Database Engine tools. The book provides solutions for installation, upgrade, configuration, schema design, management, authoring, development, optimization, deployment, operation, and troubleshooting. It covers the Installation Wizard, Upgrade Advisor, SQL Server Configuration Manager, SQL Server Management Studio, Database Tuning Advisor, SQLCMD, Database Mail, SQL Server Agent, and SQL Server Profiler. It also touches on technologies that these tools are built upon, such as SQL Server Management Objects (SMO), the Windows Management Instrumentation (WMI) Provider, and ADO.NET. The book describes individual features and how they work together to create end-to-end scenarios. For the beginning user, we have screenshots and code samples. We provide examples with code snippets where applicable. When we introduce particular aspects of tool behavior or scenarios, we start first by describing them and relating them to other previously described tasks. Screen shots show how these things look inside the tools. For the more experienced users, we provide tips and insight. In addition, we provide code snippets to illustrate how particularly interesting functionalities can be implemented with underlying APIs. In summary, the book will provide: * Hundreds of time-saving solutions * Tips, tricks, and workarounds * Solutions for working smarter * A vehicle through which you can expand your existing knowledge of SQL Server tools The book is targeted at both new and experienced database professionals. New professionals who have never used the SQL Server tools will learn how to efficiently use each tool to perform specific tasks. More experienced database professionals can update their existing knowledge of the tools, learn about new features, and learn tips and tricks of the SQL Server 2005 toolset. The purpose of this book is not to introduce you to the basic concepts of databases. We assume that you have been working with databases for at least one year. This book will show you how the tools can be used to maximize productivity while performing common SQL Server 2005 tasks. After reading this book you will be very comfortable using the tools for day-to-day tasks. The book is organized by SQL Server tools and scenarios. Each chapter presents a tool or set of tools and also includes a number of relevant scenarios that illustrate the use of the tools. If you are interested in specific tools or scenarios, you can move straight to those chapters, or you can read through the book in a linear fashion for a more complete understanding of all the tools and features.

You'll learn the basics of working with SSE databases, and see how the Visual Basic(r) 2005 Express Edition programming environment is tailored to work well with SSE.Показать полностьюYou'll learn the basics of working with SSE databases, and see how the Visual Basic(r) 2005 Express Edition programming environment is tailored to work well with SSE. Step-by-step examples cover major scenarios that you're likely to face, from installation and development to debugging and deployment. Plus, the CD-ROM features both VB Express and SSE so you can get started designing your databases right away. What you will learn from this book * How to create simple, single table applications without writing a single line of code * Making the transition from SSE to a higher-level version of SQL Server * The benefits of using XML in your database * How to deploy your applications using Xcopy * How to secure your database applications * How to move your database to a multi-user scenario Who this book is for This book is for database or programming novices who want to create and deploy database applications. It is also useful for experienced developers and independent software vendors who intend to develop applications for SSE. Wrox Starter Kits give you a CD-ROM with the software development tools you need to get started as well as structured tutorials that walk you through all the techniques you need to begin programming right away.

Start developing applications with Oracle PL/SQL — fast! This integrated book-and-Web learning solution teaches all the Oracle PL/SQL skills you need, hands on, through real-world labs, extensive examples, exercises, projects, and a complete Web-based training site.Показать полностьюStart developing applications with Oracle PL/SQL — fast! This integrated book-and-Web learning solution teaches all the Oracle PL/SQL skills you need, hands on, through real-world labs, extensive examples, exercises, projects, and a complete Web-based training site. Oracle PL/SQL by Example, Third Edition covers Oracle 10g and all the fundamentals: Master PL/SQL syntax, iterative and conditional control, scoping, anchored datatypes, cursors, triggers, security, tables, procedures, functions, packages and Oracle-supplied packages — plus powerful new techniques for working with exceptions, cursors, collections, and records. Your free Web-based training module includes a Virtual Study Lounge where you can interact with other learners, work on new projects, and get updates!

A must-read for developers and IT professionals who need tounderstand Microsoft SQL Server from the inside out. Written bya Microsoft SQL Server guru, this comprehensive guide providesupdated, authoritative advice for installing, administering, andprogramming with version 7.0. The CD contains productevaluation documentation, sample code and scripts, white papers,and a benchmarking kit.

* Serving as both a tutorial and a reference guide to the MDX (Multidimensional Expressions) query language, this book shows data warehouse developers what they need to know to build effective multidimensional data warehouses * After a brief overview of the MDX language and a look at how it is used to access data in sophisticated, multidimensional databases and data warehousing, the authors move directly to providing practical examples of MDX in use * New material covers changes in the MDX language itself as well as major changes in its implementation with the latest software releases of Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase * Also covers more advanced techniques, like aggregation, query templates, and MDX optimization, and shows users what they need to know to access and analyze data to make better business decisions

PostgreSQL Essential Reference is a reference book for developers and system administrators who are already familiar with SQL database concepts but that need clear and concise documentation that is specific to PostgreSQL. The book is divided into 3 parts; Basic SQL Reference, PostgreSQL specifics, and PostgreSQL administration.Показать полностьюPostgreSQL Essential Reference is a reference book for developers and system administrators who are already familiar with SQL database concepts but that need clear and concise documentation that is specific to PostgreSQL. The book is divided into 3 parts; Basic SQL Reference, PostgreSQL specifics, and PostgreSQL administration. On a whole, it provides a command, the syntax, available options, description, and example code. Readers will be able to easily utilize the code and concepts into their use f the product. An added advantage to this book is that provides all reference material in two ways; alphabetically and by task. This is important because readers of the book will be looking for this information by both methods.

See how SQL interfaces with today’s environments. Start building and using relational databases with SQL’s newest features. The database may be the twenty-first century filing cabinet, but building one is a little more complex than sliding drawers into a metal box.Показать полностьюSee how SQL interfaces with today’s environments. Start building and using relational databases with SQL’s newest features. The database may be the twenty-first century filing cabinet, but building one is a little more complex than sliding drawers into a metal box. With this book to guide you through all the newest features of SQL, you’ll soon be whipping up relational databases, using SQL with XML to power data-driven Web sites, and more. Discover how to * Use SQL in a client/server system * Build a multitable relational database * Construct nested and recursive queries * Set up database security * Use SQL within applications * Map SQL to XML

This book developed from course notes used in Stanford’s CS145 introduction to databases. CS145 is the first in a sequence of five courses.1 As taught originally by Arthur Keller, it evolved into a course that stresses the aspects of database systems of most use to the majority of computer science students: database design and programming.Показать полностьюThis book developed from course notes used in Stanford’s CS145 introduction to databases. CS145 is the first in a sequence of five courses.1 As taught originally by Arthur Keller, it evolved into a course that stresses the aspects of database systems of most use to the majority of computer science students: database design and programming. The course also involves an extensive, running project, in which the students design and then implement a substantial database application. Assignments related to this project, other homework assignments, exams, and other course materials are available from this book’s home page; see the section on "Support on the World Wide Web."

"A great resource to help you unlock the hidden gems in SQL Server Reporting Services." Brian Welcker Group Program Manager Microsoft SQL Server Reporting Services With Microsoft SQL Server 2005 you can structure and store terabytes of data-but how do you make sense of that much information? Reporting Services transforms raw data into meaningful reports and puts your valuable information to work. SQL Server 2005 Reporting Services in Action shows you how to build effective Windows and Web-based reporting solutions using SQL Server 2005.Показать полностью"A great resource to help you unlock the hidden gems in SQL Server Reporting Services." Brian Welcker Group Program Manager Microsoft SQL Server Reporting Services With Microsoft SQL Server 2005 you can structure and store terabytes of data-but how do you make sense of that much information? Reporting Services transforms raw data into meaningful reports and puts your valuable information to work. SQL Server 2005 Reporting Services in Action shows you how to build effective Windows and Web-based reporting solutions using SQL Server 2005. Using this example-driven book, you'll build Reporting Services-centric solutions, including report forecasting, RSS feeds, ASP.NET web controls for server-side report generation, extending Reporting Services to report on ADO.NET datasets, delivering reports to Web services, authenticating users, performance testing, and capacity planning. You'll quickly move beyond canned reports and put the Report Designer through its paces. The book will show you how to add interactive features to your tabular reports and how to improve performance by using external images without taking up valuable database real estate. When you have large systems, efficiency is key to productivity. Author Bret Updegraff shows you how to avoid doing the same tasks twice. You'll see a nifty sales forecast that uses embedded code to create reusable utility functions that you can call from multiple places your reports. As well, you'll find fundamentals like employing XSLT to create XML reports and advanced techniques such as accessing custom code in an external .NET assembly. Reporting Services 2005 lets you give users greater control over their reporting needs. SQL Server 2005 Reporting Services in Action will help you provide safe, user-friendly reporting options to your users and free up your time for more important tasks. This book shows you how to set up ad hoc reporting through Report Builder so business users can get the information you need from the database without your help! You won't stop with the basics, though. You'll also learn how to apply advanced filters and security practices to protect your data from unwelcome or misguided queries. Of course, this new edition is thoroughly updated to include coverage of all the new features introduced with SQL Server 2005. You'll see: # Direct Client Printing: Send a report directly to a printer without having to export to printable format first # End User Sort: Let the end user to re-sort data within the report # Multi Valued Parameters: Use multiple values for parameters # Custom Report Items: Build and embed custom server controls You'll also work with the improved Report Designer, Report Builder, and Analysis Services Query Builder. You'll learn about SharePoint WebParts and the Report Viewer Controls for WinForms and ASP.NET, as well.

Since 1994 when he wrote his first "Hitchhiker’s Guide", William Vaughn has been providing developers all over the world the intimate details of how SQL Server can be accessed and managed from RAD languages like Visual Basic and Visual Basic .NET.Показать полностьюSince 1994 when he wrote his first "Hitchhiker’s Guide", William Vaughn has been providing developers all over the world the intimate details of how SQL Server can be accessed and managed from RAD languages like Visual Basic and Visual Basic .NET. With the 7th Edition, Bill has completely rewritten this encyclopedic work from cover to covergiving readers his insightful views on how applications should be built to maximize both developer and code performance. Visual Studio and the languages it hosts have never been as sophisticated as they are todaythe same can be said for SQL Server. This makes it even more important for developers to understand how to best leverage their features without being held back by their complexity. That’s what this book is all aboutmaking it easier for developers regardless of their know-how. The 7th edition is unique in that it’s designed to provide not only up-to-date tutorials on the latest development tools provided by Visual Studio and SQL Server, but also a solid platform of architectural advice and rich examples for developers trying to choose between the myriad of platform options. Beginners and experts alike will find comprehensive step-by-step instructions that can make the reader’s introduction to the latest versions of Visual Studio and SQL Server far easier. Key topic coverage includes: • Data access architectures and how to choose the best strategy for Windows Forms, ASP.NET, XML Web Services, and SQL Server CLR executables. Where do these make sense and how much will they cost to build and maintain? • SQL Server and relational database fundamentals and inner-machinery. How does SQL Server work and why is it important that developers know? • Making the development experience more productive through judicious use of the Visual Studio toolset, and how to know when the wizards can help. • Using the latest ADO.NET data provider efficiently and safely. • How to protect the security of your databaseand your jobby avoiding common mistakes. • How to build secure, efficient, scalable applications in less time with fewer resourceshow to create faster code faster. • How to leverage the potential of SQL Server CLR executables and knowing when these features make sense. • How to work with your DBA to maintain database integrity and security. • Working with the new Visual Studio report controls to expose your organization’s data safely and easily with or without leveraging existing SQL Server Reporting Services technology. William R. Vaughn is the President of Beta V Corporation and a Microsoft MVP. In 2000 he retired from Microsoft after 14 years to focus on mentoring, speaking, and writing. His specialty is data access application design especially when connecting to SQL Serverover the years he’s written 12 books on the subject. He’s a popular speaker at technical conferences all over the world where his wit and no-holds-barred technical insights win him rave reviews. William is also a member of the prestigious INETA Speaker’s Bureau. His works include articles for SQL Server Magazine and a bi-weekly editorial for Processor Magazine as well as books published by Microsoft Press and Apress.

Professional SQL Server 2005 Programming shows experienced developers how to master the substantially revamped feature set of the latest release of Microsoft SQL Server.Показать полностью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.