{"product_id":"sql-database-programming-paperback","title":"SQL (Database Programming) - Paperback","description":"\u003cp\u003eby \u003cb\u003eChris Fehily\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eRead this book for free at sqlrun.com\u003c\/strong\u003e. 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.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eCovers Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Microsoft Access.\u003c\/li\u003e\n\u003cli\u003eLearn the core language for standard SQL, and variations for the most widely used database systems.\u003c\/li\u003e\n\u003cli\u003eOrganize your database in terms of the relational model.\u003c\/li\u003e\n\u003cli\u003eMaster tables, columns, rows, and keys.\u003c\/li\u003e\n\u003cli\u003eRetrieve, sort, and format data.\u003c\/li\u003e\n\u003cli\u003eFilter the data that you don't want to see.\u003c\/li\u003e\n\u003cli\u003eConvert and manipulate data with SQL's built-in functions and operators.\u003c\/li\u003e\n\u003cli\u003eUse aggregate functions to summarize data.\u003c\/li\u003e\n\u003cli\u003eCreate complex SQL statements by using joins, subqueries, constraints, conditional logic, and metadata.\u003c\/li\u003e\n\u003cli\u003eCreate, alter, and drop tables, indexes, and views.\u003c\/li\u003e\n\u003cli\u003eInsert, update, delete, and merge data.\u003c\/li\u003e\n\u003cli\u003eExecute transactions to maintain the integrity of your data.\u003c\/li\u003e\n\u003cli\u003eAvoid common pitfalls involving nulls.\u003c\/li\u003e\n\u003cli\u003eTroubleshoot and optimize queries.\u003c\/li\u003e\n\u003cli\u003ePlenty of tips, tricks, and timesavers.\u003c\/li\u003e\n\u003cli\u003eFully cross-referenced, linked, and searchable.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eContents\u003c\/strong\u003e\u003cbr\u003eIntroduction\u003cbr\u003e1. Running SQL Programs\u003cbr\u003e2. The Relational Model\u003cbr\u003e3. SQL Basics\u003cbr\u003e4. Retrieving Data from a Table\u003cbr\u003e5. Operators and Functions\u003cbr\u003e6. Summarizing and Grouping Data\u003cbr\u003e7. Joins\u003cbr\u003e8. Subqueries\u003cbr\u003e9. Set Operations\u003cbr\u003e10. Inserting, Updating, and Deleting Rows\u003cbr\u003e11. Creating, Altering, and Dropping Tables\u003cbr\u003e12. Indexes\u003cbr\u003e13. Views\u003cbr\u003e14. Transactions\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eAbout the Author\u003c\/strong\u003e\u003cbr\u003eChris Fehily is a statistician and author based in San Francisco.\u003c\/p\u003e\u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 410\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.9 x 9.8 x 7.9 IN\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e July 14, 2014\u003c\/div\u003e","brand":"Books by splitShops","offers":[{"title":"Default Title","offer_id":42712471371839,"sku":"9781937842314","price":45.36,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0105\/8226\/1823\/files\/389ac172b52c2326b05cc490adf60f27.webp?v=1765061853","url":"https:\/\/dhlswag.com\/products\/sql-database-programming-paperback","provider":"BBB","version":"1.0","type":"link"}