Joe Celko's SQL for Smarties Advanced SQL Programming

ISBN-10: 0123820227
ISBN-13: 9780123820228
Edition: 4th 2010
Authors: Joe Celko
List price: $41.99 Buy it from $25.80
eBook available
This item qualifies for FREE shipping

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

New Starting from $75.10
eBooks Starting from $67.95
Buy
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Periodic Table Online content $4.95 $1.99
Add to cart
Study Briefs
Calculus 1 Online content $4.95 $1.99
Add to cart
Study Briefs
Medical Terminology Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $41.99
Edition: 4th
Copyright year: 2010
Publisher: Elsevier Science & Technology
Publication date: 11/22/2010
Binding: Paperback
Pages: 816
Size: 7.50" wide x 9.25" long x 0.75" tall
Weight: 1.342
Language: English

Rob Shimonski (www.shimonski.com) is an experienced entrepreneur and an active participant in the business community. Rob is a best-selling author and editor with over 15 years experience developing, producing and distributing print media in the form of books, magazines and periodicals. To date, Rob has successfully created over 100 books that are currently in circulation. Rob has worked for countless companies to include CompTIA, Entrepreneur Magazine, Microsoft, McGraw Hill Education, Cisco, the National Security Agency and Digidesign. Rob has an extremely diverse background in the print media industry filling roles such as author, co-author, technical editor, copy editor and developmental editor. Since print media shifted to the digital domain, Rob has focused the past decade on developing all of the needed skills to produce professional audio and video media. An expert in Digital Audio Workstation (DAW) design and video production, Rob has created over 500 different media packages to include commercials for TV, online advertising clips, audio podcasts and much more. Rob started to train others while in the US Marine Corps. Since, Rob has held a NY State teaching certificate as well as multiple trainer roles in colleges and trade schools across the world.Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards. Mr. Celko is author a series of books on SQL and RDBMS for Elsevier/MKP. He is an independent consultant based in Austin, Texas. He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.

Introduction
Databases versus File Systems
Transactions and Concurrency Control
Schema Level Objects
Locating Data and Special Numbers
Base Tables and Related Elements
Procedural, Semi-Procedural and Declarative Programming
Procedural Constructs
Auxiliary Tables
Normalization
Numeric Data Types
Temporal Data Types
Character Data Types
NULLs -- Missing Data in SQL
Multiple Column Data Elements
Table Operations
Comparison or Theta Operators
Valued Predicates
CASE Expressions
LIKE and SIMILAR TO Predicates
BETWEEN and OVERLAPS Predicates
The [NOT] IN() Predicate
EXISTS() Predicate
Quantified Subquery Predicates
The Simple SELECT Statement
Advanced SELECT Statements
Virtual Tables: VIEWs, Derived Tables, CTEs and MQTs
Partitioning Data in Queries
Grouping Operations
Simple Aggregate Functions
Advanced Grouping, Windowed Aggregation and OLAP in SQL
Descriptive Statistics in SQL
Sub-Sequences, Regions, Runs, Gaps, and Islands
Matrices in SQL
Set Operations
Subsets
Trees and Hierarchies in SQL
Graphs in SQL
Temporal Queries
Optimizing SQL

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×