{"id":"https://openalex.org/W42614002","doi":null,"title":"SQL: Visual QuickStart Guide","display_name":"SQL: Visual QuickStart Guide","publication_year":2002,"publication_date":"2002-07-01","ids":{"openalex":"https://openalex.org/W42614002","mag":"42614002"},"language":"en","primary_location":{"id":"pmh:oai:cds.cern.ch:2742030","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/2742030","pdf_url":null,"source":{"id":"https://openalex.org/S4306402195","display_name":"CERN Document Server (European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":null},"volume":null,"type":"article","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/A5059427269","display_name":"Chris Fehily","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Chris Fehily","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5059427269"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.5512,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.76184363,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":95},"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.5938000082969666,"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.5938000082969666,"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.3806000053882599,"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.010099999606609344,"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.9599999785423279},{"id":"https://openalex.org/keywords/relational-model","display_name":"relational model","score":0.8149999976158142},{"id":"https://openalex.org/keywords/database-management","display_name":"database management","score":0.9120000004768372},{"id":"https://openalex.org/keywords/database-queries","display_name":"database queries","score":0.6290000081062317},{"id":"https://openalex.org/keywords/database-administration","display_name":"database administration","score":0.6079999804496765},{"id":"https://openalex.org/keywords/database-objects","display_name":"database objects","score":0.6710000038146973},{"id":"https://openalex.org/keywords/sql-syntax","display_name":"SQL syntax","score":0.5080000162124634},{"id":"https://openalex.org/keywords/non-programmers","display_name":"non-programmers","score":0.6029999852180481}],"concepts":[{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.8235882520675659},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8183203339576721},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.7982230186462402},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.7847530245780945},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.6837121844291687},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.6100921034812927},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.5994993448257446},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5782756209373474},{"id":"https://openalex.org/C114724005","wikidata":"https://www.wikidata.org/wiki/Q5001740","display_name":"Business Intelligence Markup Language","level":5,"score":0.5250304341316223},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5161231756210327},{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.4763094186782837},{"id":"https://openalex.org/C60048249","wikidata":"https://www.wikidata.org/wiki/Q37437","display_name":"Syntax","level":2,"score":0.4750787615776062},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.47342851758003235},{"id":"https://openalex.org/C2777315864","wikidata":"https://www.wikidata.org/wiki/Q15853013","display_name":"Visual Basic","level":3,"score":0.4638293981552124},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.45259594917297363},{"id":"https://openalex.org/C56288433","wikidata":"https://www.wikidata.org/wiki/Q58673","display_name":"Data manipulation language","level":2,"score":0.44377508759498596},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.4379955530166626},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.42108798027038574},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.4137963652610779},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1893225610256195},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:cds.cern.ch:2742030","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/2742030","pdf_url":null,"source":{"id":"https://openalex.org/S4306402195","display_name":"CERN Document Server (European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":null},{"id":"mag:42614002","doi":null,"is_oa":false,"landing_page_url":"https://openlibrary.org/books/OL3658043M/SQL","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":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W7006629151","https://openalex.org/W2225860617","https://openalex.org/W1515331193","https://openalex.org/W4245199659","https://openalex.org/W2741459018","https://openalex.org/W2334639190","https://openalex.org/W2521335221","https://openalex.org/W4255487128","https://openalex.org/W42465558","https://openalex.org/W4402684916"],"abstract_inverted_index":{"From":[0],"the":[1,71,76,129],"Publisher:\r\n\r\nUntitled\r\nDatabase":[2],"management.":[3],"It":[4],"may":[5,154],"sound":[6],"daunting,":[7],"but":[8,147,160],"it":[9],"doesn't":[10],"have":[11],"to":[12,26,94,104,112,119,135,144,167],"be,":[13],"evenif":[14],"you've":[15],"never":[16],"programmed":[17],"before.":[18],"SQL:":[19,162],"Visual":[20],"QuickStart":[21],"Guideisn't":[22],"an":[23,34],"exhaustive":[24],"guide":[25],"SQL":[27,86,99],"written":[28],"for":[29,37,150],"aspiring":[30],"programming":[31,57,158],"experts.It's":[32],"simply":[33],"invaluable":[35],"resource":[36],"those":[38],"who":[39,164],"want":[40],"a":[41,62,142,157],"fast,":[42],"easy":[43],"way":[44],"toharness":[45],"information":[46],"living":[47],"in":[48],"complex":[49],"databases.\r\nBecause":[50],"author":[51],"Chris":[52],"Fehily":[53,140],"assumes":[54],"no":[55],"prior":[56],"experience":[58],"on":[59,138],"yourpart":[60],"(just":[61],"familiarity":[63],"with":[64,161],"your":[65],"OS's":[66],"file":[67],"system),":[68],"he":[69,89],"spends":[70],"firstfew":[72],"chapters":[73],"laying":[74],"out":[75],"basics,":[77],"including":[78],"clear":[79],"explanations":[80],"of":[81],"therelational":[82],"database":[83,116,152],"model":[84],"and":[85,110,114,118,121,132],"syntax.":[87],"Then":[88],"jumps":[90],"into":[91],"step-by-steptasks":[92],"designed":[93],"get":[95],"you":[96,137],"comfortable":[97],"using":[98],"right":[100],"away.":[101],"You'll":[102],"learnhow":[103],"use":[105],"SQL's":[106],"most":[107],"popular":[108],"statements":[109],"commands":[111],"maintain,retrieve,":[113],"analyze":[115],"information,":[117],"create":[120],"edit":[122],"databaseobjects.":[123],"Each":[124],"visually":[125],"oriented":[126],"task":[127],"features":[128],"actual":[130],"code":[131],"plenty":[133],"ofscreenshots":[134],"keep":[136],"track.":[139],"takes":[141],"software-independentapproach":[143],"teaching":[145],"SQL,":[146],"includes":[148],"tips":[149],"specific":[151],"software.You":[153],"not":[155],"be":[156],"expert,":[159],"VQS,":[163],"will":[165],"beable":[166],"tell?":[168]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2013,"cited_by_count":2}],"updated_date":"2026-11-12T12:28:57.059296","created_date":"2016-06-24T00:00:00"}