SQL Fundamentals

By: John Patrick

Write A Review

Paperback | 1 September 2008 | Edition Number 3

Sorry, we are not able to source the book you are looking for right now.

We did a search for other books with a similar title, however there were no matches. You can try selecting from a similar category, click on the author's name, or use the search box above to find your book.

SQL for the Real World

Don&;t just learn &;generic&; SQL. Learn SQL to get results with the world&;s top database platforms&;Oracle for the enterprise and Microsoft Access for the desktop. Based on John Patrick&;s hands-on SQL course at the University of California, Berkeley Extension, 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. Thoroughly updated for the newest versions of Oracle, Access, and the SQL standard, this book contains more exercises, techniques, and solutions than ever before. You&;ll learn exactly how to write SQL queries that are easy to understand, verify, modify, and extend&;even if you&;ve never worked with databases before.

SQL Fundamentals,Third Edition, teaches you how to

Build simple statements to retrieve, store, or modify data
Craft complex queries that draw information from multiple tables
Sort and summarize your data just the way you want it
Create and edit your own tables
Protect the integrity of your data
Create more efficient, high-performance queries
Work with unions, subqueries, self joins, cross joins, inner joins, and outer joins
Use the Oracle Data Dictionary

About the Web Site

The accompanying Web site, https://www.box.com/shared/ylbckg2fn0 , contains all the SQL code and tables from the book, including the full databases for several versions of Access and code for building the corresponding Oracle databases. It also provides solutions to many of the book&;s problems and an open area for discussions with the author and other readers.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $89.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Computer Programming & Software Development Database Programming Computer Science Databases Database Software SQL Server & MS SQL

Preface	p. xxv
Storing Information in Tables	p. 1
Introduction	p. 3
The Parts of a Table	p. 9
Examples of Tables	p. 19
Key Points	p. 30
Getting Information from a Table	p. 31
The Select Statement	p. 33
The Select Clause	p. 37
The Where Clause	p. 50
The Order By Clause	p. 71
Key Points	p. 80
Compound Conditions in the Where Clause	p. 83
Compound Conditions in the Where Clause	p. 85
Constant Values	p. 95
Punctuation Matters	p. 102
Case Sensitivity	p. 113
Three-Valued Logic	p. 120
Error Messages	p. 122
Some Exercises Solved for You	p. 124
Key Points	p. 131
Saving Your Results	p. 133
Saving Your Results in a New Table or View	p. 135
Modifying the Data in a Table with SQL	p. 151
Modifying the Data in a Table with the GUI	p. 161
Restrictions on Modifying the Data in a Table	p. 167
Key Points	p. 170
The Data Dictionary and Other Oracle Topics	p. 171
Commit, Rollback, and Transactions	p. 173
Modifying Data through a View	p. 179
The SQL Commands Page in Oracle	p. 192
Using the Oracle Data Dictionary
	p. 195
Key Points	p. 207
Creating Your Own Tables	p. 209
Creating Tables	p. 211
Changing Tables	p. 226
Tables with Duplicate Rows	p. 236
Key Points	p. 243
Formats, Sequences, and Indexes	p. 245
Formats	p. 247
Sequences	p. 257
Indexes	p. 262
Using the Oracle Data Dictionary
	p. 266
An Exercise Solved for You	p. 278
Key Points	p. 280
Data Integrity	p. 281
Constraints on One Table	p. 283
Referential Integrity	p. 289
The Delete Options and Update Options of RI	p. 303
Variations of Referential Integrity	p. 311
How to Code Constraints in a Create Table Statement	p. 316
Key Points	p. 319
Row Functions	p. 321
Introduction to Row Functions	p. 323
Numeric Functions	p. 334
Text Functions	p. 340
Date Functions	p. 350
Key Points	p. 359
Using Row Functions	p. 361
Specialized Row Functions	p. 363
Using the Documentation of Row Functions	p. 372
Creating Patterns of Numbers and Dates	p. 376
Key Points	p. 397
Summarizing Data	p. 399
Introduction to the Column Functions	p. 401
Maximum and Minimum	p. 404
Count	p. 411
Sum and Average	p. 420
Other Topics	p. 428
Key Points	p. 434
Controlling the Level of Summarization	p. 435
Dividing a Table into Groups of Rows	p. 437
Eliminating Some of the Summarized Data	p. 459
Key Points	p. 471
Inner Joins	p. 473
Introduction to Joins	p. 475
Inner Joins of Two Tables	p. 479
Variations of the Join Condition	p. 495
Applications of Joins	p. 504
Key Points	p. 515
Outer Joins	p. 517
Introduction to Outer Joins	p. 519
Applications of Outer Joins	p. 534
Key Points	p. 553
Union and Union All	p. 555
Union Basics	p. 557
Unconventional Unions	p. 573
Applications of a Union	p. 577
Set Intersection and Set Difference in Oracle	p. 590
Key Points	p. 595
Cross Joins, Self Joins, and Cross Tab Queries	p. 597
Cross Joins	p. 599
Self Joins	p. 613
Cross Tab Queries in Access	p. 624
Cross Tab Queries in Oracle	p. 645
Key Points	p. 650
Combining Tables in a Production Database	p. 653
Methods of Joining Three or More Tables	p. 655
Losing Information	p. 660
Caring about the Efficiency of Your Computer	p. 663
Standardizing the Way That Tables Are Joined	p. 666
Key Points	p. 671
If-Then-Else, Parameter Queries, and Subqueries	p. 673
If-Then-Else Logic	p. 675
Table of Contents provided by Publisher. All Rights Reserved.

SQL Fundamentals

Shipping

How to return your order

Defective items

You Can Find This Book In

More in SQL Server & MS SQL

The Definitive Guide to DAX 2nd edition

Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI

Microsoft Transact-SQL: The Definitive Guide

The Definitive Guide

Professional Microsoft SQL Server 2012 Reporting Services

Oracle 12c: SQL

3rd Edition

Database Professional's Library

Database Professional's Library

Database Professional's Library

Database Pro Library

Admin911

Survival Guide for System Administrators

Delivering Business Intelligence with Microsoft SQL Server 2005

Utilize Microsoft's Data Warehousing, Mining & Reporting Tools to Provide Critical Intelligence to a

Microsoft SQL Server 2005 Developer's Guide

Database & ERP - OMG

Microsoft SQL Server 2005: The Complete Reference

Full Coverage of All New and Improved Features

Programming SQL Server 2005

Prepare for Deeper SQL Server Waters

Test Yourself

Test Yourself

Portable DBA

SQL Server

Professional Microsoft SQL Server 2012 Administration

Delivering Business Intelligence with Microsoft SQL Server 2012

Database & ERP - OMG

Microsoft SQL Server 2012 a Beginners Guide 5/E

Database & ERP - OMG

Microsoft SQL Server 2008 Administration for Oracle DBAs

Database & ERP - OMG

Expert's Voice in SQL Server

Pro

Expert's Voice in SQL Server

Pro

Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition

Database & ERP - OMG

Microsoft SQL Server 2008 R2 Master Data Services

Implementation & Administration

Practical DMX Queries for Microsoft SQL Server Analysis Services 2008

Database & ERP - OMG

The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit

Database Implementation and Maintenance

The Real MCTS SQL Server 2008 Exam 70-433 Prep Kit

Database Design

This product is categorised by