{"id":"https://openalex.org/W604023535","doi":null,"title":"SQL For Dummies","display_name":"SQL For Dummies","publication_year":1995,"publication_date":"1995-08-01","ids":{"openalex":"https://openalex.org/W604023535","mag":"604023535"},"language":"en","primary_location":{"id":"mag:604023535","doi":null,"is_oa":false,"landing_page_url":"https://ci.nii.ac.jp/ncid/BA39894396","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},"volume":null,"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/A5037509159","display_name":"Allen G. Taylor","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Allen G. Taylor","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5037509159"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":93},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.8988999724388123,"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.8988999724388123,"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.09719999879598618,"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/T11734","display_name":"Decision Support System Applications","score":0.000699999975040555,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.9449999928474426},{"id":"https://openalex.org/keywords/relational-databases","display_name":"relational databases","score":0.8960000276565552},{"id":"https://openalex.org/keywords/database-management-systems","display_name":"database management systems","score":0.9860000014305115},{"id":"https://openalex.org/keywords/database-design","display_name":"database design","score":0.9150000214576721},{"id":"https://openalex.org/keywords/data-security","display_name":"data security","score":0.7739999890327454},{"id":"https://openalex.org/keywords/temporal-data","display_name":"temporal data","score":0.9869999885559082},{"id":"https://openalex.org/keywords/data-recovery","display_name":"data recovery","score":0.42800000309944153},{"id":"https://openalex.org/keywords/database-maintenance","display_name":"database maintenance","score":0.3659999966621399},{"id":"https://openalex.org/keywords/microsoft-access","display_name":"Microsoft Access","score":0.652999997138977},{"id":"https://openalex.org/keywords/oracles","display_name":"oracles","score":0.9679999947547913},{"id":"https://openalex.org/keywords/sql-server","display_name":"SQL Server","score":0.9649999737739563},{"id":"https://openalex.org/keywords/mysql","display_name":"MySQL","score":1.0}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7791421413421631},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7483232021331787},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.7465167045593262},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.694333016872406},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.6800929307937622},{"id":"https://openalex.org/C33882796","wikidata":"https://www.wikidata.org/wiki/Q4826222","display_name":"Autocommit","level":5,"score":0.6526533365249634},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.6199086308479309},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.5690754652023315},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.5548073053359985},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5435185432434082},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.5284205079078674},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.498685359954834},{"id":"https://openalex.org/C123327596","wikidata":"https://www.wikidata.org/wiki/Q212606","display_name":"Open Database Connectivity","level":5,"score":0.4494209587574005},{"id":"https://openalex.org/C114724005","wikidata":"https://www.wikidata.org/wiki/Q5001740","display_name":"Business Intelligence Markup Language","level":5,"score":0.4454772472381592},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.43069350719451904},{"id":"https://openalex.org/C206384180","wikidata":"https://www.wikidata.org/wiki/Q599380","display_name":"User-defined function","level":5,"score":0.4298243224620819},{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.424513578414917},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.410356342792511},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.17854079604148865},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"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:604023535","doi":null,"is_oa":false,"landing_page_url":"https://ci.nii.ac.jp/ncid/BA39894396","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"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/W2211268470","https://openalex.org/W2252243883","https://openalex.org/W149057283","https://openalex.org/W2611728168","https://openalex.org/W7043535486","https://openalex.org/W2611163296","https://openalex.org/W2748533328","https://openalex.org/W2336094686","https://openalex.org/W2738342198","https://openalex.org/W1552133951"],"abstract_inverted_index":{"Uncover":[0],"the":[1,37,47],"secrets":[2],"of":[3,78],"SQL":[4,39,41,49,57,115,153,165],"and":[5,13,30,51,69,95,104,117,137,158],"start":[6],"building":[7],"better":[8],"relational":[9,108],"databases":[10,29],"today!This":[11],"fun":[12],"friendly":[14],"guide":[15],"will":[16],"help":[17],"you":[18,24,53,73,86],"demystify":[19],"database":[20,64,98,109,148],"management":[21,110],"systems":[22,111],"so":[23],"can":[25],"create":[26],"more":[27],"powerful":[28],"access":[31],"information":[32,71,106],"with":[33],"ease.":[34],"Updated":[35],"for":[36,91,120],"latest":[38],"functionality,":[40],"For":[42,154],"Dummies,":[43,155],"8th":[44,156],"Edition":[45],"covers":[46],"core":[48],"language":[50],"shows":[52],"how":[54],"to":[55,58,87,93,134,164],"use":[56],"structure":[59],"a":[60,63],"DBMS,":[61],"implement":[62],"design,":[65],"secure":[66],"your":[67,122,143,162],"data,":[68],"retrieve":[70],"when":[72],"need":[74],"it.Includes":[75],"new":[76],"enhancements":[77],"SQL:2011,":[79],"including":[80],"temporal":[81],"data":[82,123],"functionality":[83],"which":[84],"allows":[85],"set":[88],"valid":[89],"times":[90],"transactions":[92],"occur":[94],"helps":[96],"prevent":[97],"corruptionCovers":[99],"creating,":[100],"accessing,":[101],"manipulating,":[102],"maintaining,":[103],"storing":[105],"in":[107,142],"like":[112],"Access,":[113],"Oracle,":[114],"Server,":[116],"MySQLProvides":[118],"tips":[119],"keeping":[121],"safe":[124],"from":[125],"theft,":[126],"accidental":[127],"or":[128,131],"malicious":[129],"corruption,":[130],"loss":[132],"due":[133],"equipment":[135],"failures":[136],"advice":[138],"on":[139,161],"eliminating":[140],"errors":[141],"workDon't":[144],"be":[145,160],"daunted":[146],"by":[147],"development":[149],"anymore":[150],"-":[151],"get":[152],"Edition,":[157],"you'll":[159],"way":[163],"stardom.":[166]},"counts_by_year":[{"year":2020,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-10-25T09:29:13.331239","created_date":"2016-06-24T00:00:00"}