{"product_id":"sql-database-programming-fifth-edition-9781937842475","title":"SQL Database Programming (Fifth Edition)","description":"\u003cp\u003e\u003cb\u003e2024 update. Author site: fehily.com\u003c\/b\u003e. This book teaches newcomers SQL, the language of databases, and includes examples 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.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eCovers Oracle Database, Microsoft SQL Server, Microsoft Access, IBM Db2 Database, MySQL, PostgreSQL, and Standard SQL.\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\u003eCreate, alter, and drop database tables.\u003c\/li\u003e\n\u003cli\u003eAnswer hard questions by using joins, subqueries, constraints, conditional logic, and metadata.\u003c\/li\u003e\n\u003cli\u003eCreate indexes that speed sorts and searches.\u003c\/li\u003e\n\u003cli\u003eUse views to secure and simplify data access.\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\u003cb\u003eContents\u003c\/b\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\u003cb\u003eAbout the Author\u003c\/b\u003e\u003cbr\u003eChris Fehily is a statistician and author living in Carmel, California.\u003c\/p\u003e\u003cbr\u003e","brand":"Questing Vole Press","offers":[{"title":"Default Title","offer_id":50915736125714,"sku":"9781937842475","price":24.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0831\/4771\/8930\/files\/img_522235eb-936c-4ec0-90e3-3b8ddc274222.jpg?v=1738828065","url":"https:\/\/surprise-castle.myshopify.com\/products\/sql-database-programming-fifth-edition-9781937842475","provider":"Surprise Castle","version":"1.0","type":"link"}