Learning SQL

  • Auteur: Alan Beaulieu
  • ISBN: 059655558X
  • Date de sortie: 2009-04-11
  • Collection: "O'Reilly Media, Inc."
  • Total Download: 9888
  • Total Read: 1070

Télécharger Lire


Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will: Move quickly through SQL basics and learn several advanced features Use SQL data statements to generate, manipulate, and retrieve data Create database objects, such as tables, indexes, and constraints, using SQL schema statements Learn how data sets interact with queries, and understand the importance of subqueries Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.

SQL Cookbook

  • Auteur: Anthony Molinaro
  • ISBN: 9780596555016
  • Date de sortie: 2005-12-16
  • Collection: "O'Reilly Media, Inc."
  • Total Download: 9031
  • Total Read: 9604

Télécharger Lire


You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level. Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT columns FROM table WHERE conditions. But there is so much more you can do with the language. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about: Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing out Powerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES function Pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set Bucketization, and why you should never use that term in Brooklyn. How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques The technique of walking a string, which allows you to use SQL to parse through the characters, words, or delimited elements of a string Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.

SQL in a Nutshell

  • Auteur: Kevin Kline
  • ISBN: 0596554257
  • Date de sortie: 2008-11-21
  • Collection: "O'Reilly Media, Inc."
  • Total Download: 3377
  • Total Read: 6705

Télécharger Lire


For programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today's most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You'll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts -- all packed into a succinct, comprehensive, and easy-to-use format. This book provides: Background on the Relational Database Model, including current and previous SQL standards Fundamental concepts necessary for understanding relational databases and SQL commands An alphabetical command reference to SQL statements, according to the SQL2003 ANSI standard The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server An alphabetical reference of the ANSI SQL2003 functions, as well as the vendor implementations Platform-specific functions unique to each implementation Beginning where vendor documentation ends, SQL in a Nutshell distills the experiences of professional database administrators and developers who have used SQL variants to support complex enterprise applications. Whether SQL is new to you, or you've been using SQL since its earliest days, you'll get lots of new tips and techniques in this book.

SQL

  • Auteur: Robert Sheldon
  • ISBN: 9780072228854
  • Date de sortie: 2003
  • Collection: McGraw Hill Professional
  • Total Download: 9880
  • Total Read: 8569

Télécharger Lire


Explains how to program with SQL, covering topics including database objects, queries, modifications, embedded statements, and troubleshooting.

SQL

  • Auteur: Chris Fehily
  • ISBN: 0321553578
  • Date de sortie: 2008
  • Collection: Peachpit Press
  • Total Download: 5899
  • Total Read: 5847

Télécharger Lire


Task-based guide delivers the SQL know-how to employ and maintain any SQL-based database.

SQL

  • Auteur: Michael J. Donahoo
  • ISBN: 0122205316
  • Date de sortie: 2005
  • Collection: Academic Press
  • Total Download: 6589
  • Total Read: 5993

Télécharger Lire


A solid guide and reference to the key elements of SQL and how to use it effectively. SQL 2003 compliant.

Clarion Databases SQL

  • Auteur: David Gerhard Harms
  • ISBN: 9780968955338
  • Date de sortie: 2004
  • Collection: CoveComm Inc.
  • Total Download: 7445
  • Total Read: 9001

Télécharger Lire


DMCA - Contact