Detailseite wird geladen...
This book teaches SQL in order to get results with the world's top database platforms: Oracle for the enterprise, and Microsoft Access for the desktop. This book shows exactly how to retrieve the data you want, when you need it, in any application - from ad hoc reports to the data warehouse. The book delivers the practical techniques and examples needed. Every concept is illustrated with an example that is explained in detail. -- Compares and contrasts the 2 most widely used databases - Oracle 9I and Access 2000 databases -- Shows how to create tables and views to divide a complex process into a series of simple steps -- Covers topics such as inner joins, outer joins, self joins and subqueries using clear, easy to follow examples throughout -- Helps write SQL queries that are easy to understand, verify, modify, and extend -- Value packed CD ROM includes free trial version of Oracle products SQL stands for Structured Query Language, and pronounced either seekwell or as separate letters. SQL is a standardized query language for requesting information from a database. The original version called SEQUEL (structured English query language) was designed by an IBM research center in 1974 and 1975. SQL was first introduced as a commercial database system in 1979 by Oracle Corporation. Historically, SQL has been the favorite query language for database management systems running on minicomputers and mainframes. Increasingly, however, SQL is being supported by PC database systems because it supports distributed databases (databases that are spread out over several computer systems). This enables several users on a local-area network to access the same databasesimultaneously. Although there are different dialects of SQL, it is nevertheless the closest thing to a standard query language that currently exists. In 1986, ANSI approved a rudimentary version of SQL as the official standard, but most versions of SQL since then have included many extensions to the ANSI standard. In 1991, ANSI updated the standard. The new standard is known as SAG SQL. This tutorial approaches SQL from 3 directions - the standard language, how the standard is implemented and how it is modified in two of the most widely used SQL products - Oracle and Access (6.0, 7.0 and Windows 98) databases. It emphasizes the major purpose of SQL and relational databases - to make information available to people who need it Begins with an introduction to accessing information, then moves on to describe how to design a database of your own. This book will give you the power and ability to understand and work effectively with relational databases. This book is targeted at programmers and database administrators who want to learn SQL. The CD-ROM contains a library of Access databases and the code for building Oracle databases. All the tables used in the book are furnished in both Oracle and Access format. A website provides additional technical support to assure that all the cod SQL Fundamentals [With CDROM Contains a Library of Access Databases] Patrick, John J.
Shipping costs:plus shipping costs
1999, ISBN: 9780130960160
Softcover, Gebraucht, Free State Books. Never settle for less., [PU: Prentice Hall]
Halethorpe, MD, Free State Books
Shipping costs:plus shipping costs
SQL Fundamentals Author :John J. Patrick 9780130960160 0130960160, [PU: Prentice Hall]
new Shipping costs: EUR 0.00
Details of the book - Sql Fundamentals With Cdrom
EAN (ISBN-13): 9780130960160
ISBN (ISBN-10): 0130960160
Publishing year: 1999
Publisher: Prentice Hall
Book in our database since 05.03.2008 21:19:12
Book found last time on 03.12.2015 21:57:34
ISBN - alternate spelling:
< to archive...
- "Computer Security Policies and Sunscreen Firewalls", from "Kathryn M. Walker; Llinda Croswhite Cavanaugh; Linda Croswhite Cavanaugh" (0130960152)
- "Business Ethics: Concepts and Cases - 2nd edition", from "Velasquez, Manuel G." (0130960179)
- "Windows NT Cluster Server Guidebook", from "Dave Libertone" (9780130960191)
- "The Sounds of English: Phonetics and Phonology for English Teachers in", from "David Deterding, Gloria Poedjosoedarmo" (013096011X)
- "READING MATTERS 1/E: ANSWER KEY", from "JANE MERIVALE" (9780130960108)
- "Exploring the Internet with Netscape Communicator 4.0 (Exploring Office 97 Series)", from "Robert T. Grauer, Gretchen Marx" (0130960098)