SQL (Database Programming) (2015 Edition)

SQL (Database Programming) (2015 Edition)
FRoDAQAAQBAJ
648
By:"Chris Fehily"
"Computers"
Published on 2014-07-14 by Questing Vole Press

An \u003cb\u003eSQL\u003c/b\u003e statement ends with a semicolon. \u003cb\u003eSQL\u003c/b\u003e is afreeform language whose \u003cbr\u003e\nstatements can: Be inuppercase or lowercase. (SELECT, select, and sElEcT \u003cbr\u003e\nareconsidered to be identical keywords, for example.) Continue onthe next line \u003cbr\u003e\nas long ...

READ NOW

2015 Edition. Perfect for end users, analysts, data scientists, and app developers, this best-selling guide will get you up and running with SQL, the language of databases. You'll find general concepts, practical answers, and clear explanations of what the various SQL statements can do. Hundreds of examples of varied difficulty encourage you to experiment and explore. Full-color SQL code listings help you see the elements and structure of the language. You can download the sample database to follow along with the author's examples. - Covers Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Microsoft Access.- Learn the core language for standard SQL, and variations for the most widely used database systems.- Organize your database in terms of the relational model.- Master tables, columns, rows, and keys.- Retrieve, sort, and format data.- Filter the data that you don't want to see.- Convert and manipulate data with SQL's built-in functions and operators.- Use aggregate functions to summarize data.- Create complex SQL statements by using joins, subqueries, constraints, conditional logic, and metadata.- Create, alter, and drop tables, indexes, and views.- Insert, update, delete, and merge data.- Execute transactions to maintain the integrity of your data.- Avoid common pitfalls involving nulls.- Troubleshoot and optimize queries.- Plenty of tips, tricks, and timesavers.- Fully cross-referenced, linked, and searchable. ContentsIntroduction1. Running SQL Programs2. The Relational Model3. SQL Basics4. Retrieving Data from a Table5. Operators and Functions6. Summarizing and Grouping Data7. Joins8. Subqueries9. Set Operations10. Inserting, Updating, and Deleting Rows11. Creating, Altering, and Dropping Tables12. Indexes13. Views14. Transactions

This Book was ranked 35 by Google Books for keyword sql programming.

The book is written in enfor NOT_MATURE

Read Ebook Now
true
false

Printed Version of this book available in
BOOK

Availability of Ebook version is true,"listPrice": {"amount": 12.97,"currencyCode": "USD"in trueor false

Public Domain Status false

Rating by

SAMPLE

false