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...

SQL (Structured Query Language) is a standardized query language for requesting information from a database. Historically, SQL has been the choice for database management systems running on minicomputers and mainframes. Increasingly, however, SQL is being adapted to PC database systems because it supports distributed databases--databases that are spread out over several computer systems, so that several users on a local-area network can access the same database simultaneously. Although there are different dialects of SQL, it is the closest thing to a standard query language that currently exists.

“

SQL Server 2000 is a major milestone for Microsoft, which is trying to position itself as a significant player in the database market. The demand for databasedriven sites on the Internet is exploding (some major sites are running SQL Server 2000 as their back end, Microsoft included), creating a demand for qualified people who understand the product—from technical support people to analysts to programmers without database experience.

”

Information is a valuable resource to an organization. Computer software provides an efficient means of processing information, and database systems are becoming an increasingly common means by which it is possible to store and retrieve information in an effective manner. This book provides comprehensive coverage of fundamentals of database management systems. This book is for those who wish a better understanding of relational data modeling, its purpose, its nature, and the standards used in creating relational data models.

In this complete revision and expansion of his first SQL Puzzles book, Joe Celko challenges you with his trickiest puzzlesand then helps solve them with a variety of solutions and explanations. Joe demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but help develop the mindset needed to solve the many difficult SQL puzzles you face every day. Of course, part of the fun is to see whether or not you can write better solutions than Joes.

Master queries for any SQL database! Your one-stop guide to building and maintaining relational databases with SQL If you're looking for a good general reference on SQL, look no further. This all-in-one guide delivers the goods on all major SQL topics, from basic concepts to the latest XML data-handling functions. Whether you're a database developer or DBA, you'll find fast answers to your SQL questions and savvy tips on building databases that are robust, secure, and efficient.

Master queries for any SQL database! Your one-stop guide to building and maintaining relational databases with SQL If you're looking for a good general reference on SQL, look no further. This all-in-one guide delivers the goods on all major SQL topics, from basic concepts to the latest XML data-handling functions. Whether you're a database developer or DBA, you'll find fast answers to your SQL questions and savvy tips on building databases that are robust, secure, and efficient.

Master queries for any SQL database! Your one-stop guide to building and maintaining relational databases with SQL If you're looking for a good general reference on SQL, look no further. This all-in-one guide delivers the goods on all major SQL topics, from basic concepts to the latest XML data-handling functions. Whether you're a database developer or DBA, you'll find fast answers to your SQL questions and savvy tips on building databases that are robust, secure, and efficient.

Master the language of PROC SQL! Get faster and better results when you use the SQL procedure with this step-by-step, example-driven guide in your hands. You will find information about implementing both American National Standards Institute (ANSI) guidelines and non-ANSI features. A broad range of SAS users including applications programmers, database designers and administrators, statisticians, and systems analysts will find techniques to enhance their data access, manipulation, and presentation prowess.

SQLite is a small, zero-configuration, custom-tailored, embeddable, threadsafe, easily maintainable, transactionoriented, SQL-based, relational database management system. There is no separate install or setup procedure to initialize SQLite before using it. There is no configuration file.

Sams Teach Yourself SQL in 24 Hours, Third Edition presents the key features of SQL (Structured Query Language) in an easy to understand format with updated code examples, notes, diagrams, exercises, and quizzes. New material covers more information on transactions, constructs, embedded databases, and object-oriented programming. In this edition, the authors include examples based on a database like MySQL, a very popular open source database.

DB2 Universal Database v8 builds on the world's #1 enterprise database to simplify anytime/anywhere information integration, streamline management, automate resource tuning,enhance business intelligence, and maximize performance, scalability, and reliability. Now, IBM offers complete, start-to-finish coverage of DB2 Universal Database v8 administration and development for UNIX, Linux, and Windows platforms... and authoritative preparation for IBM's newest DB2 certification exam.