Posted March 2Mar 2 SQL Pocket Guide SQL Pocket Guide A Guide to SQL Usage by Alice Zhao Publisher "O'Reilly Media, Inc." Published Date 2021-08-26 Page Count 356 Categories Computers / Languages / SQL, Computers / Data Science / Data Modeling & Design, Computers / Data Science / Data Analytics, Computers / Data Science / Data Warehousing Language EN Average Rating N/A (based on N/A ratings) Maturity Rating No Mature Content Detected ISBN 1492090352 If you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is your ideal on-the-job reference. You'll find many examples that address the language's complexities, along with key aspects of SQL used in Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL, and SQLite.In this updated edition, author Alice Zhao describes how these database management systems implement SQL syntax for both querying and making changes to a database. You'll find details on data types and conversions, regular expression syntax, window functions, pivoting and unpivoting, and more.Quickly look up how to perform specific tasks using SQLApply the book's syntax examples to your own queriesUpdate SQL queries to work in five different database management systems NEW: Connect Python and R to a relational databaseNEW: Look up frequently asked SQL questions in the "How Do I?" chapter More Information
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.