SQL Pocket guide / Alice Zhao
Material type: TextPublication details: India Shroff Publishers 2021Edition: 4th edDescription: 334pISBN:- 9789391043544
- 005.7565 ZHA-A
Item type | Current library | Collection | Shelving location | Call number | Status | Date due | Barcode | Item holds | |
---|---|---|---|---|---|---|---|---|---|
Books | BITS Pilani Hyderabad | 003-007 | General Stack (For lending) | 005.7565 ZHA-A (Browse shelf(Opens below)) | Available | 46261 |
Browsing BITS Pilani Hyderabad shelves, Shelving location: General Stack (For lending), Collection: 003-007 Close shelf browser (Hides shelf browser)
005.7565 SMI-G PostgreSQL 9.0 high performance : accelerate your PostgreSQL system / | 005.7565 TAN-C SQL for data analysis : advanced techniques for transforming data into insights / | 005.7565 ZEI-C Oracle 11g for dummies / | 005.7565 ZHA-A SQL Pocket guide / | 005.7565 ZIK-P IBM DB2 new features / | 005.757 CHO-K MongoDB : the definitive guide / | 005.7575 BRA-S MongoDB : the definitive guide : powerful and scalable data storage / |
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 critical 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 querying and making database changes. 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 SQL Apply the book's syntax examples to your queries Update SQL queries to work in five different database management systems. NEW: Connect Python and R to a relational database. NEW: Look up frequently asked SQL questions in the "How to Do I?" chapter.
There are no comments on this title.