SQL cookbook : query solutions and techniques for all SQL users /
Molinaro, Anthony, database developer,
SQL cookbook : query solutions and techniques for all SQL users / Anthony Molinaro and Robert de Graaf. - Second edition. - xx, 547 pages ; 24 cm
Previous edition: 2006. Includes index.
Retrieving records -- Sorting query results -- Working with multiple tables -- Inserting, updating, and deleting -- Metadata queries -- Working with strings -- Working with numbers -- Date arithmetic -- Date manipulation -- Working with ranges -- Advanced searching -- Reporting and reshaping -- Hierarchical queries -- Odds 'n' ends.
You may know SQL basics, but are you taking advantage of its expressive power? This second edition applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data. Based on real-world examples, this updated cookbook provides a framework to help you construct solutions and executable examples in several flavors of SQL, including Oracle, DB2, SQL Server, MySQL, and PostgreSQL. SQL programmers, analysts, data scientists, database administrators, and even relatively casual SQL users will find SQL Cookbook to be a valuable problem-solving guide for everyday issues. No other resource offers recipes in this unique format to help you tackle nagging day-to-day conundrums with SQL.
9781492077442 1492077445
2022300304
GBC0E2702 bnb
019948549 Uk
SQL (Computer program language)
Database management.
SQL (Langage de programmation)
Bases de données--Gestion.
Database management.
SQL (Computer program language)
QA76.73.S67 / M65 2020
005.7585 MOL 2020
SQL cookbook : query solutions and techniques for all SQL users / Anthony Molinaro and Robert de Graaf. - Second edition. - xx, 547 pages ; 24 cm
Previous edition: 2006. Includes index.
Retrieving records -- Sorting query results -- Working with multiple tables -- Inserting, updating, and deleting -- Metadata queries -- Working with strings -- Working with numbers -- Date arithmetic -- Date manipulation -- Working with ranges -- Advanced searching -- Reporting and reshaping -- Hierarchical queries -- Odds 'n' ends.
You may know SQL basics, but are you taking advantage of its expressive power? This second edition applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data. Based on real-world examples, this updated cookbook provides a framework to help you construct solutions and executable examples in several flavors of SQL, including Oracle, DB2, SQL Server, MySQL, and PostgreSQL. SQL programmers, analysts, data scientists, database administrators, and even relatively casual SQL users will find SQL Cookbook to be a valuable problem-solving guide for everyday issues. No other resource offers recipes in this unique format to help you tackle nagging day-to-day conundrums with SQL.
9781492077442 1492077445
2022300304
GBC0E2702 bnb
019948549 Uk
SQL (Computer program language)
Database management.
SQL (Langage de programmation)
Bases de données--Gestion.
Database management.
SQL (Computer program language)
QA76.73.S67 / M65 2020
005.7585 MOL 2020