下载地址:
下载地址1资源简介:
中文名: SQL袖珍参考手册(第3版,涵盖DB2,MySQL,Oracle,PostgreSQL,SQL Server)原名: SQL Pocket Guide: A Guide to SQL Usage作者: Jonathan Gennick资源格式: PDF版本: 英文文字版/更新源代码出版社: O'Reilly书号: 978-1-4493-9409-7发行时间: 2010年11月地区: 美国语言: 英文简介: 内容介绍:If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2.All example SQL statements in this book execute against a set of tables, with data that you can quickly download. The third edition covers important database changes, including:Oracle's support of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operatorsFunctions new to Oracle, such as LISTAGG, NTH_VALUE, and morePostgreSQL’s support of recursive WITH and some window functionsDB2 syntax and datatypes, some compatible with OracleMySQL features such as the TIMESTAMP type and the TO_SECONDS function 目录: IntroductionAnalytic FunctionsCASE Expressions: SimpleCASE Expressions: SearchedCAST FunctionCONNECT BY QueriesData Type ConversionData Types: Binary IntegerData Types: Character StringData Types: DatetimeData Types: DecimalDatetime Conversions: DB2Datetime Conversions: MySQLDatetime Conversions: OracleDatetime Conversions: PostgreSQLDatetime Conversions: SQL ServerDatetime Functions: DB2Datetime Functions: MySQLDatetime Functions: OracleDatetime Functions: PostgreSQLDatetime Functions: SQL ServerDeleting DataEXTRACT FunctionGREATESTGrouping and SummarizingHierarchical QueriesIndexes, CreatingIndexes, RemovingInserting DataJoining TablesLEASTLiteralsMerging DataNullsNumeric Conversions: DB2Numeric Conversions: MySQLNumeric Conversions: OracleNumeric Conversions: PostgreSQLNumeric Conversions: SQL ServerNumeric/Math FunctionsOLAP FunctionsPivoting and UnpivotingPredicatesRecursive QueriesRegular ExpressionsSelecting DataString FunctionsSubqueriesTables, CreatingTables, DroppingTables, ModifyingTransaction ManagementUnion QueriesUpdating DataWindow Functions
飞网下载站,免费下载共享资料,内容涉及教育资源、专业资料、IT资源、娱乐生活、经济管理、办公文书、游戏资料等。