{"product_id":"sql-run","title":"SQL Run","description":"\u003cp\u003e\u003cstrong\u003eRead this book for free at sqlrun.com\u003c\/strong\u003e. This book teaches newcomers SQL, the language of databases, and includes examples and syntax for the most widely used database systems. In all its editions, this book has sold more than 150,000 copies and is popular with end users, students, data scientists, statisticians, epidemiologists, analysts, app developers, webmasters, and hobbyists. Thorough cross-referencing makes it a useful desktop reference for experienced SQL programmers. In SQL Run, the author has consolidated and updated his earlier SQL titles in a single book.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eCovers Oracle Database, Microsoft SQL Server, IBM Db2 Database, MySQL, PostgreSQL, Microsoft Access, and Standard SQL (ISO\/IEC).\u003c\/li\u003e\n\u003cli\u003eHundreds of examples of varied difficulty encourage you to experiment and explore.\u003c\/li\u003e\n\u003cli\u003eDownload the sample database and SQL source code to follow along with the examples.\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, filter, sort, and format data.\u003c\/li\u003e\n\u003cli\u003eUse functions and operators to transform and summarize data.\u003c\/li\u003e\n\u003cli\u003eAnswer hard questions 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\u003eLearn advanced techniques that extend the power of SQL.\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\u003cbr\u003e15. Advanced SQL\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eAbout the Author\u003c\/strong\u003e\u003cbr\u003eChris Fehily is a statistician and author living in Carmel, California.\u003c\/p\u003e","brand":"None","offers":[{"title":"Couverture souple","offer_id":46426417332434,"sku":"9781937842499","price":39.0,"currency_code":"CAD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0655\/8980\/5233\/files\/1_9e343c81-7ecf-40c8-b6c8-3b79232b2c57.jpg?v=1764403062","url":"https:\/\/iandigo.com\/fr\/products\/sql-run","provider":"Indigo","version":"1.0","type":"link"}