Read this book for free at fehily.com . 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 ...
Read More
Read this book for free at fehily.com . 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. Contents Introduction 1. Running SQL Programs 2. The Relational Model 3. SQL Basics 4. Retrieving Data from a Table 5. Operators and Functions 6. Summarizing and Grouping Data 7. Joins 8. Subqueries 9. Set Operations 10. Inserting, Updating, and Deleting Rows 11. Creating, Altering, and Dropping Tables 12. Indexes 13. Views 14. Transactions About the Author Chris Fehily is a statistician and author living in Carmel, California.
Read Less
Add this copy of Sql (Database Programming) to cart. $4.12, good condition, Sold by Phatpocket Limited rated 4.0 out of 5 stars, ships from Waltham Abbey, ESSEX, UNITED KINGDOM, published 2014 by Questing Vole Press.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
Good. Ships from UK in 48 hours or less (usually same day). Your purchase helps support Sri Lankan Children's Charity 'The Rainbow Centre'. Ex-library, so some stamps and wear, but in good overall condition. 100% money back guarantee. We are a world class secondhand bookstore based in Hertfordshire, United Kingdom and specialize in high quality textbooks across an enormous variety of subjects. We aim to provide a vast range of textbooks, rare and collectible books at a great price. Our donations to The Rainbow Centre have helped provide an education and a safe haven to hundreds of children who live in appalling conditions. We provide a 100% money back guarantee and are dedicated to providing our customers with the highest standards of service in the bookselling industry.
Add this copy of Sql (Database Programming) to cart. $9.95, fair condition, Sold by Goodwill of Greater Milwaukee rated 5.0 out of 5 stars, ships from Milwaukee, WI, UNITED STATES, published 2014 by Questing Vole Press.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
Fair. Book is considered to be in acceptable condition. The actual cover image may not match the stock photo. Book may have one or more of the following defects: noticeable wear on the cover dust jacket or spine; curved dog eared or creased page s; writing or highlighting inside or on the edges; sticker s or other adhesive on cover; CD DVD may not be included; and book may be a former library copy.
Add this copy of Sql (Database Programming) to cart. $10.93, good condition, Sold by ThriftBooks-Dallas rated 5.0 out of 5 stars, ships from Dallas, TX, UNITED STATES, published 2014 by Questing Vole Press.
Add this copy of Sql (Database Programming) to cart. $14.13, very good condition, Sold by BooksRun rated 5.0 out of 5 stars, ships from Philadelphia, PA, UNITED STATES, published 2014 by Questing Vole Press.
Add this copy of Sql (Database Programming) to cart. $15.07, fair condition, Sold by BookDrop rated 3.0 out of 5 stars, ships from Phoenix, AZ, UNITED STATES, published 2014 by Questing Vole Press.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
Fair. Reading copy. May have signs of wear and previous use scuffs library copy highlighting writing and underlining. Dust jacket may be missing. 100% GUARANTEE! Shipped with delivery confirmation if you're not satisfied with purchase. Ships USPS Media Mail.
Add this copy of Sql (Database Programming) to cart. $18.34, good condition, Sold by SurplusTextSeller rated 5.0 out of 5 stars, ships from Columbia, MO, UNITED STATES, published 2014 by Questing Vole Press.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
Good. Ships in a BOX from Central Missouri! May not include working access code. Will not include dust jacket. Has used sticker(s) and some writing or highlighting. UPS shipping for most packages, (Priority Mail for AK/HI/APO/PO Boxes).
Add this copy of SQL (Database Programming) to cart. $24.39, good condition, Sold by GreatBookPricesUK5 rated 4.0 out of 5 stars, ships from Castle Donington, DERBYSHIRE, UNITED KINGDOM, published 2014 by Questing Vole Press.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
Good. Trade paperback (US). Glued binding. 410 p. May show signs of wear, highlighting, writing, and previous use. This item may be a former library book with typical markings. No guarantee on products that contain supplements Your satisfaction is 100% guaranteed. Twenty-five year bookseller with shipments to over fifty million happy customers.
Add this copy of SQL (Database Programming) to cart. $26.67, good condition, Sold by GreatBookPrices rated 4.0 out of 5 stars, ships from Columbia, MD, UNITED STATES, published 2014 by Questing Vole Press.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
Good. Trade paperback (US). Glued binding. 410 p. May show signs of wear, highlighting, writing, and previous use. This item may be a former library book with typical markings. No guarantee on products that contain supplements Your satisfaction is 100% guaranteed. Twenty-five year bookseller with shipments to over fifty million happy customers.
