SQL Fundamentals

SQL Fundamentals
ISBN-10
0130669474
ISBN-13
9780130669476
Category
Computers / Languages / SQL
Pages
834
Language
English
Published
2002
Publisher
Prentice Hall Ptr
Author
John J. Patrick

Description

A comprehensive tutorial covering the fundamental concepts and ideas of SQL, and showing how these are implemented in both Oracle 9I and Access 2000 databases. John Patrick discusses how to create tables and views to divide a complex process into a series of simple steps, and covers topics such as inner joins, self joins and subqueries using easy-to-follow examples throughout. The work should help readers to write SQL queries that are easy to understand, verify, modify and extend. The accompanying CD-ROM includes a trial version of Oracle products.

Get the book

Amazon.com
Amazon.com
Search the book
eBay.com
eBay.com
Search the book

Similar books

  • JDBC API Tutorial and Reference: Universal Data Access for the Java 2 Platform
    JDBC API Tutorial and Reference: Universal Data Access for the Java 2 Platform
    By Seth White

    This license allows and is limited to the creation and distribution of clean room implementations of this specification that ... For more information , please contact : Pearson Education Corporate Sales Division ; 201 W. 103rd Street ...

  • XML: Designing XML internet applications
    By David Megginson

    XML: Designing XML internet applications

  • 数据挖掘在医学中的应用
    数据挖掘在医学中的应用
    By 徐颖, 张维朋

    由于各部分自由度不相等,因此各部分离差平方和不能比较,必须将各部分离差平方和除以相应自由度,其即比值称为均方差,简称为均方。组间均方: ,组内均方:。这时根据这两个值可以进行F检验,即: }gs}image81-5.jpg}/gs} ,表示各个样本不是来自同一总体, ...

  • Inside Microsoft SQL Server 2008: T-SQL Querying
    Inside Microsoft SQL Server 2008: T-SQL Querying
    By Itzik Ben-Gan

    Tackle the toughest set-based querying and query tuning problems--guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals--and gain practical approaches and...

  • Inside Microsoft SQL Server 2008: T-SQL Programming
    Inside Microsoft SQL Server 2008: T-SQL Programming
    By Itzik Ben-Gan

    Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the...

  • Advanced Oracle PL/SQL: Programming with Packages
    Advanced Oracle PL/SQL: Programming with Packages
    By Steven Feuerstein

    Steven Feuerstein's first book,Oracle PL/SQL Programming, has become the classic reference to PL/SQL, Oracle's procedural extension to its SQL language. His new book looks thoroughly at one especially advanced and...

  • Inside Microsoft SQL Server 2005: Query Tuning and Optimization
    Inside Microsoft SQL Server 2005: Query Tuning and Optimization
    By Kalen Delaney

    Dig into the internals of tuning and optimization features in SQL Server 2005--with insights from leading SQL Server experts. This in-depth guide delivers best practices, pragmatic advice, and code samples...

  • A Developer's Guide to SQL Server 2005
    A Developer's Guide to SQL Server 2005
    By Bob Beauchemin, Dan Sullivan

    "I come from a T-SQL background, so when I first laid my eyes on SQL Server 2005, I was shocked--and then, I was scared! I didn't have a CLR or...