Skip to content

Joe Celko's SQL for Smarties Advanced SQL Programming

Best in textbook rentals since 2012!

ISBN-10: 0123820227

ISBN-13: 9780123820228

Edition: 4th 2011

Authors: Joe Celko

List price: $47.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Customers also bought

Book details

List price: $47.99
Edition: 4th
Copyright year: 2011
Publisher: Elsevier Science & Technology
Publication date: 11/22/2010
Binding: Paperback
Pages: 816
Size: 7.50" wide x 9.21" long x 0.75" tall
Weight: 2.882
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…    

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