{"id":"https://openalex.org/W2211268470","doi":null,"title":"SQL: A BEGINNER'S GUIDE 3/E","display_name":"SQL: A BEGINNER'S GUIDE 3/E","publication_year":2008,"publication_date":"2008-08-08","ids":{"openalex":"https://openalex.org/W2211268470","mag":"2211268470"},"language":"en","primary_location":{"id":"mag:2211268470","doi":null,"is_oa":false,"landing_page_url":"https://dl.acm.org/citation.cfm?id=SERIES11887.1481064","pdf_url":null,"source":{"id":"https://openalex.org/S4306475711","display_name":"McGraw-Hill, Inc. eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4323253411","host_organization_name":"McGraw-Hill","host_organization_lineage":["https://openalex.org/P4323253411"],"host_organization_lineage_names":["McGraw-Hill"],"type":"ebook platform"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"McGraw-Hill, Inc. eBooks","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/A5080125418","display_name":"Andy Oppel","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Andy Oppel","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5021712224","display_name":"Robert Sheldon","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Robert Sheldon","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"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.9789999723434448,"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.9789999723434448,"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.017999999225139618,"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/T10533","display_name":"Teaching and Learning Programming","score":0.00039999998989515007,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"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.9769999980926514},{"id":"https://openalex.org/keywords/relational-databases","display_name":"relational databases","score":0.921999990940094},{"id":"https://openalex.org/keywords/database-programming","display_name":"database programming","score":0.4740000069141388},{"id":"https://openalex.org/keywords/data-retrieval","display_name":"data retrieval","score":0.5019999742507935},{"id":"https://openalex.org/keywords/data-modification","display_name":"data modification","score":0.7570000290870667},{"id":"https://openalex.org/keywords/data-integrity","display_name":"data integrity","score":0.6010000109672546},{"id":"https://openalex.org/keywords/views","display_name":"views","score":0.6990000009536743},{"id":"https://openalex.org/keywords/database-security","display_name":"database security","score":0.9929999709129333},{"id":"https://openalex.org/keywords/subqueries","display_name":"subqueries","score":0.7960000038146973},{"id":"https://openalex.org/keywords/transactions","display_name":"transactions","score":0.9599999785423279},{"id":"https://openalex.org/keywords/sql-xml","display_name":"SQL/XML","score":0.6769999861717224},{"id":"https://openalex.org/keywords/mysql","display_name":"MySQL","score":0.5379999876022339},{"id":"https://openalex.org/keywords/sql-server-2008","display_name":"SQL Server 2008","score":0.9139999747276306},{"id":"https://openalex.org/keywords/oracle-database-11g","display_name":"Oracle Database 11g","score":0.996999979019165}],"concepts":[{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.8204431533813477},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7915886640548706},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7748515605926514},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.7425152659416199},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.6682648658752441},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.6406590938568115},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.5731131434440613},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5378023982048035},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.5255675911903381},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.4815278649330139},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4770031273365021},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.46846550703048706},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.458456426858902},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.45572298765182495},{"id":"https://openalex.org/C56288433","wikidata":"https://www.wikidata.org/wiki/Q58673","display_name":"Data manipulation language","level":2,"score":0.42726367712020874},{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.4163650870323181},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.4111921489238739},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.36995217204093933},{"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:2211268470","doi":null,"is_oa":false,"landing_page_url":"https://dl.acm.org/citation.cfm?id=SERIES11887.1481064","pdf_url":null,"source":{"id":"https://openalex.org/S4306475711","display_name":"McGraw-Hill, Inc. eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4323253411","host_organization_name":"McGraw-Hill","host_organization_lineage":["https://openalex.org/P4323253411"],"host_organization_lineage_names":["McGraw-Hill"],"type":"ebook platform"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"McGraw-Hill, Inc. eBooks","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2252243883","https://openalex.org/W2738342198","https://openalex.org/W2334639190","https://openalex.org/W149057283","https://openalex.org/W70041207","https://openalex.org/W2611163296","https://openalex.org/W604023535","https://openalex.org/W3153046210","https://openalex.org/W201931643","https://openalex.org/W1552133951"],"abstract_inverted_index":{"Essential":[0],"Skills--Made":[1],"Easy!\r\n\r\nWritten":[2],"to":[3,24,111,117,123,148,207,251],"the":[4,63,92,95,118,133,156],"SQL:2006":[5,254],"ANSI/ISO":[6],"standard,":[7],"this":[8],"easy-to-follow":[9],"guide":[10],"will":[11,21],"get":[12],"you":[13],"started":[14],"programming":[15,134],"in":[16,91,260],"SQL":[17,54,72,157,170,184,188,223,227,231,235,257],"right":[18],"away.":[19],"You":[20],"learn":[22],"how":[23,110],"retrieve,":[25],"insert,":[26],"update,":[27],"and":[28,32,35,49,75,102,144,151,161,180,197,209],"delete":[29],"database":[30],"data,":[31],"perform":[33],"management":[34],"administrative":[36],"functions.":[37],"SQL:":[38],"A":[39],"Beginner's":[40],"Guide,":[41],"Third":[42],"Edition":[43],"covers":[44],"new":[45],"features,":[46],"including":[47],"SQL/XML,":[48],"is":[50],"loaded":[51],"with":[52,57,62,99,129,155,195,243],"updated":[53],"examples":[55],"along":[56],"notes":[58],"on":[59],"using":[60],"them":[61],"latest":[64],"RDBMS":[65],"software":[66],"versions":[67],"such":[68],"as":[69],"MySQL":[70],"5.0,":[71],"Server":[73],"2008,":[74],"Oracle":[76],"Database":[77,174],"11g.":[78],"\r\n\r\nDesigned":[79],"for":[80],"Easy":[81],"Learning:":[82],"\r\n\r\nKey":[83],"Skills":[84],"&":[85],"Concepts--Lists":[86],"of":[87,138],"specific":[88],"skills":[89],"covered":[90],"chapter":[93],"\r\nAsk":[94],"Experts--Q&A":[96],"sections":[97],"filled":[98],"bonus":[100],"information":[101,115],"helpful":[103],"tips":[104],"\r\nTry":[105],"This--Hands-on":[106],"exercises":[107],"that":[108,131],"show":[109],"apply":[112],"your":[113,125],"skills\r\nNotes--Extra":[114],"related":[116],"topic":[119],"being":[120,136],"covered\r\nSelf-Tests--Chapter-ending":[121],"quizzes":[122],"test":[124],"knowledge\r\nAnnotated":[126],"Syntax--Example":[127],"code":[128],"commentary":[130],"describes":[132],"techniques":[135],"illustrated\r\n\r\n\r\nTable":[137],"contents\r\nPART":[139],"I":[140],"-":[141,177,213,247],"Relational":[142,149],"Databases":[143,150],"SQL\r\nChapter":[145,152],"1.":[146],"Introduction":[147],"2.":[153],"Working":[154,194,242],"Environment\r\nChapter":[158],"3.":[159],"Creating":[160,169,218,222],"Altering":[162],"Tables\r\nChapter":[163,203],"4.":[164],"Enforcing":[165],"Data":[166,178,215,236],"Integrity\r\nChapter":[167],"5.":[168],"Views\r\nChapter":[171],"6.":[172],"Managing":[173,230],"Security\r\nPart":[175],"II":[176],"Access":[179,208],"Modification\r\nChapter":[181],"7.":[182],"Querying":[183],"Data\r\nChapter":[185,189],"8.":[186],"Modifying":[187],"9.":[190],"Using":[191,205,226],"Predicates\r\nChapter":[192],"10.":[193],"Functions":[196],"Value":[198],"Expressions\r\nChapter":[199],"11.":[200],"Accessing":[201,234],"Multiple":[202],"12.":[204],"Subqueries":[206],"Modify":[210],"Data\r\nPart":[211,245],"III":[212],"Advanced":[214],"Access\r\nChapter":[216],"13.":[217],"SQL-Invoked":[219],"Routines\r\nChapter":[220],"14.":[221],"Triggers\r\nChapter":[224],"15.":[225],"Cursors\r\nChapter":[228],"16.":[229],"Transactions\r\nChapter":[232],"17.":[233],"from":[237],"Your":[238],"Host":[239],"Program\r\nChapter":[240],"18.":[241],"XML":[244],"IV":[246],"Appendices\r\nAppendix":[248],"A:":[249],"Answers":[250],"SelfTest\r\nAppendix":[252],"B:":[253],"Keywords\r\nAppendix":[255],"C:":[256],"Code":[258],"Used":[259],"Try":[261],"This":[262],"Exercises\r\nIndex":[263]},"counts_by_year":[{"year":2017,"cited_by_count":1}],"updated_date":"2026-08-21T09:56:20.448147","created_date":"2016-06-24T00:00:00"}