What do you think?
Rate this book
SQL Fundamentals
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 productsSQL 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 code is completely correct and works with the latest version of both Oracle and Access.
-- 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 productsSQL 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 code is completely correct and works with the latest version of both Oracle and Access.
- GenresNonfictionComputers
Paperback
First published January 1, 1999
5 people are currently reading
20 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
