{"id":"https://openalex.org/W2336094686","doi":null,"title":"Sql pocket guide, 2nd edition","display_name":"Sql pocket guide, 2nd edition","alternate_titles":[],"publication_year":2006,"publication_date":"2006-04-17","ids":{"openalex":"https://openalex.org/W2336094686","mag":"2336094686"},"language":"en","primary_location":{"id":"mag:2336094686","doi":null,"is_oa":false,"landing_page_url":"https://dl.acm.org/citation.cfm?id=1406336","pdf_url":null,"source":{"id":"https://openalex.org/S4306477231","display_name":"O'Reilly eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"O'Reilly eBooks","raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W2336094686"],"child_works_count":0,"type":"book","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5021640509","display_name":"Jonathan Gennick","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Jonathan Gennick","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5021640509"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9771000146865845,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9771000146865845,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13681","display_name":"Engineering and Information Technology","score":0.02070000022649765,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.00019999999494757503,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.9810000061988831},{"id":"https://openalex.org/keywords/database-programming","display_name":"database programming","score":0.5770000219345093},{"id":"https://openalex.org/keywords/sql-statements","display_name":"SQL statements","score":0.6589999794960022},{"id":"https://openalex.org/keywords/sql-functions","display_name":"SQL functions","score":0.9850000143051147},{"id":"https://openalex.org/keywords/database-administration","display_name":"database administration","score":0.6600000262260437},{"id":"https://openalex.org/keywords/oracle-database-10g","display_name":"Oracle 10g","score":0.8560000061988831},{"id":"https://openalex.org/keywords/microsoft-sql-server-2005","display_name":"SQL Server 2005","score":0.9850000143051147},{"id":"https://openalex.org/keywords/ibm-db2","display_name":"DB2","score":0.8880000114440918},{"id":"https://openalex.org/keywords/database-objects","display_name":"database objects","score":0.5},{"id":"https://openalex.org/keywords/database-queries","display_name":"database queries","score":0.4860000014305115},{"id":"https://openalex.org/keywords/data-modification","display_name":"data modification","score":0.8849999904632568}],"concepts":[{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.8543677926063538},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.8211631774902344},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7952661514282227},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.7752434015274048},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.7651047706604004},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7065714001655579},{"id":"https://openalex.org/C33882796","wikidata":"https://www.wikidata.org/wiki/Q4826222","display_name":"Autocommit","level":5,"score":0.6537512540817261},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6528826951980591},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.6373343467712402},{"id":"https://openalex.org/C114724005","wikidata":"https://www.wikidata.org/wiki/Q5001740","display_name":"Business Intelligence Markup Language","level":5,"score":0.5759362578392029},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5648825168609619},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.5643146634101868},{"id":"https://openalex.org/C206384180","wikidata":"https://www.wikidata.org/wiki/Q599380","display_name":"User-defined function","level":5,"score":0.4877799153327942},{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.4637840986251831},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.44443950057029724},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4015282988548279},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.34605836868286133},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.05427885055541992},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:2336094686","doi":null,"is_oa":false,"landing_page_url":"https://dl.acm.org/citation.cfm?id=1406336","pdf_url":null,"source":{"id":"https://openalex.org/S4306477231","display_name":"O'Reilly eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"O'Reilly eBooks","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W7068530220","https://openalex.org/W6996730291","https://openalex.org/W2738342198","https://openalex.org/W1503787388","https://openalex.org/W2211268470","https://openalex.org/W2521335221","https://openalex.org/W2252243883","https://openalex.org/W149057283","https://openalex.org/W2742483413","https://openalex.org/W2612068935"],"abstract_inverted_index":{"SQL":[0,59,85,100,106,116,121,162,178],"is":[1,30,88,109],"the":[2,20,23,37,135,154,158,170],"language":[3],"of":[4,39,128,157],"databases.":[5],"It's":[6],"used":[7,115,120,161],"to":[8,60,92,113,152],"create":[9],"and":[10,96,118,140],"maintain":[11],"database":[12,94,185],"objects,":[13,18],"place":[14],"data":[15,28],"into":[16],"those":[17],"query":[19],"data,":[21,24],"modify":[22],"and,":[25],"finally,":[26],"delete":[27],"that":[29,50],"no":[31],"longer":[32],"needed.":[33],"Databases":[34],"lie":[35],"at":[36],"heart":[38],"many,":[40],"if":[41,51,64],"not":[42],"most":[43,159],"business":[44],"applications.":[45],"Chances":[46],"are":[47],"very":[48,83],"good":[49,72],"you're":[52,57,65],"involved":[53],"with":[54],"software":[55],"development,":[56],"using":[58,66],"some":[61],"degree.":[62],"And":[63],"SQL,":[67],"you":[68],"should":[69],"own":[70],"a":[71,89,110],"reference":[73,112],"or":[74],"two.Now":[75],"available":[76],"in":[77,101,146],"an":[78,125],"updated":[79,151],"second":[80],"edition,":[81],"our":[82],"popular":[84],"Pocket":[86,107],"Guide":[87,108],"major":[90],"help":[91],"programmers,":[93],"administrators,":[95],"everyone":[97],"who":[98],"uses":[99],"their":[102],"day-to-day":[103],"work.":[104],"The":[105,144],"concise":[111],"frequently":[114],"statements":[117],"commonly":[119,160],"functions.":[122],"Not":[123],"just":[124],"endless":[126],"collection":[127],"syntax":[129],"diagrams,":[130],"this":[131,147],"portable":[132],"guide":[133],"addresses":[134],"language's":[136],"complexity":[137],"head":[138],"on":[139],"leads":[141],"by":[142],"example.":[143],"information":[145],"edition":[148],"has":[149],"been":[150],"reflect":[153],"latest":[155],"versions":[156],"variants":[163],"including:Oracle":[164],"Database":[165,173],"10g,":[166],"Release":[167],"2":[168],"(including":[169],"free":[171],"Oracle":[172],"10g":[174],"Express":[175],"Edition":[176],"(XE))Microsoft":[177],"Server":[179],"2005MySQL":[180],"5IBM":[181],"DB2":[182],"8.2PostreSQL":[183],"8.1":[184]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2336094686","counts_by_year":[],"updated_date":"2025-10-10T17:16:08.811792","created_date":"2016-06-24T00:00:00"}
