Sign up
Forgot password?
FAQ: Login

Celko J. Joe Celko's SQL for Smarties: Advanced SQL Programming

  • pdf file
  • size 6,27 MB
  • added by
  • info modified
Celko J. Joe Celko's SQL for Smarties: Advanced SQL Programming
3rd edition. — Morgan Kaufmann, 2010. — 839 p. — ISBN13: 978-0-12-369379-2, ISBN10: 0-12-369379-9.
Database Design
Normalization
Numeric Data in SQL
Temporal Data Types in SQL
Character Data Types in SQL
NULLs: Missing Data in SQL
Multiple Column Data Elements
Table Operations
Comparison or Theta Operators
Valued Predicates
CASE Expressions
LIKE Predicate
BETWEEN and OVERLAPS Predicates
The [NOT] IN() Predicate
EXISTS() Predicate
Quantified Subquery Predicates
The SELECT Statement
VIEWs, Derived Tables, Materialized Tables, and Temporary Tables
Partitioning Data in Queries
Grouping Operations
Aggregate Functions
Auxiliary Tables
Statistics in SQL
Regions, Runs, Gaps, Sequences, and Series
Arrays in SQL
Set Operations
Subsets
Trees and Hierarchies in SQL
Temporal Queries
Graphs in SQL
OLAP in SQL
Transactions and Concurrency Control
Optimizing SQL
  • Sign up or login using form at top of the page to download this file.
  • Sign up

See also

Details

Celko J. Joe Celko's SQL for Smarties: Advanced SQL Programming

  • pdf
Morgan Kaufmann, 2015. — 852 p. — 5th ed. — ISBN: 0128007613, 9780128007617 SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 20 years later and in its fifth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches...
  • 5,66 MB
  • added
  • info modified
Details

Celko J. Joe Celko's Trees and Hierarchies in SQL for Smarties

  • pdf
2nd Edition. — Morgan Kaufmann, 2012. — 278 p. — ISBN: 978-0-12-387733-8. The demand for SQL information and training continues to grow with the need for a database behind every website capable of offering web-based information queries. SQL is the de facto standard for database retrieval, and if you need to access, update, or utilize data in a modern database management system,...
  • 3,92 MB
  • added
  • info modified
Details

Celko J. SQL Puzzles and Answers

  • pdf
Second Edition. — Morgan Kaufmann, 2006. — 347 p. — ISBN10: 0-12-373596-3, ISBN13: 978-0-12-373596-3. Contents (Puzzles): Fiscal Year Tables. Absentees. The Anesthesia Puzzle. Security Badges. Alpha Data. Hotel Reservations. Keeping A Portfolio. Scheduling Printers. Available Seats. Wages Of Sin. Work Orders. Claims Status. Teachers. Telephone. Find The Last Two Salaries....
  • 4,07 MB
  • added
  • info modified
Details

Freeman E., Freeman E., Bates B., Sierra K., Robson E. Head First. Design Patterns

  • pdf
O’Reilly Media, 2004. — 629 p. You're not alone. At any given moment, somewhere in the world someone struggles with the same software design problems you have. You know you don't want to reinvent the wheel (or worse, a flat tire), so you look to Design Patterns-the lessons learned by those who've faced the same problems. With Design Patterns, you get to take advantage of the...
  • 42,28 MB
  • added
  • info modified
Details

Han J., Kamber M. Data Mining: Concepts and Techniques

  • pdf
Second Edition. — Morgan Kaufmann, 2006. — 743 p. This book explores the concepts and techniques of data mining, a promising and ourishing frontier in database systems and new database applications. Data mining, also popularly referred to as knowledge discovery in databases (KDD), is the automated or convenient extraction of patterns representing knowledge implicitly stored in...
  • 27,31 MB
  • added
  • info modified
Details

Nisbet R., Elder J., Miner G. Handbook of Statistical Analysis and Data Mining Applications

  • pdf
Academic Press, 2009. — 864 p. — ISBN: 0123747651. Robert Nisbet, Pacific Capital Bank Corporation, Santa Barbara, CA, USA John Elder, Elder Research, Inc. and the University of Virginia, Charlottesville, USA Gary Miner, StatSoft, Inc. , Tulsa, OK, USA Description The Handbook of Statistical Analysis and Data Mining Applications is a comprehensive professional reference book...
  • 41,49 MB
  • added
  • info modified
Up