SQL Fundamentals [With CDROM]

SQL Fundamentals With CDROM 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 y

  • Title: SQL Fundamentals [With CDROM]
  • Author: John J. Patrick
  • ISBN: 9780130669476
  • Page: 420
  • Format: Paperback
  • 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 iThis 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.

    • Free Read [Business Book] ✓ SQL Fundamentals [With CDROM] - by John J. Patrick ↠
      420 John J. Patrick
    • thumbnail Title: Free Read [Business Book] ✓ SQL Fundamentals [With CDROM] - by John J. Patrick ↠
      Posted by:John J. Patrick
      Published :2018-08-16T06:17:47+00:00

    1 thought on “SQL Fundamentals [With CDROM]”

    Leave a Reply

    Your email address will not be published. Required fields are marked *