{"id":"https://openalex.org/W2267360574","doi":null,"title":"Oracle SQL: A Beginner's Tutorial","display_name":"Oracle SQL: A Beginner's Tutorial","publication_year":2013,"publication_date":"2013-09-25","ids":{"openalex":"https://openalex.org/W2267360574","mag":"2267360574"},"language":"en","primary_location":{"id":"pmh:oai:cds.cern.ch:1643784","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/1643784","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/A5040797584","display_name":"Djoni Darmawikarta","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Djoni Darmawikarta","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5040797584"],"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":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.9916999936103821,"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.9916999936103821,"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.007300000172108412,"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/oracle-sql","display_name":"Oracle SQL","score":0.9020000100135803},{"id":"https://openalex.org/keywords/oracle-database","display_name":"Oracle database","score":0.8489999771118164},{"id":"https://openalex.org/keywords/relational-databases","display_name":"relational databases","score":0.9480000138282776},{"id":"https://openalex.org/keywords/sql-queries","display_name":"SQL queries","score":0.8809999823570251},{"id":"https://openalex.org/keywords/grouping","display_name":"grouping","score":0.625},{"id":"https://openalex.org/keywords/join","display_name":"join","score":0.8500000238418579},{"id":"https://openalex.org/keywords/database-views","display_name":"database views","score":0.8399999737739563},{"id":"https://openalex.org/keywords/database-metadata","display_name":"database metadata","score":0.9430000185966492},{"id":"https://openalex.org/keywords/indexing","display_name":"indexing","score":0.8479999899864197}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8258794546127319},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.7201718688011169},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6975662708282471},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.6182048320770264},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6107244491577148},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.5918577909469604},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.5779057741165161},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.5336343050003052},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5203144550323486},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.502140998840332},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.47562816739082336},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.46718743443489075},{"id":"https://openalex.org/C22664368","wikidata":"https://www.wikidata.org/wiki/Q4045949","display_name":"Oracle Unified Method","level":5,"score":0.42585283517837524},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.39903977513313293},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2735615074634552},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.07723739743232727},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"pmh:oai:cds.cern.ch:1643784","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/1643784","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":"pmh:oai:cds.cern.ch:2134000","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/2134000","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:2267360574","doi":null,"is_oa":false,"landing_page_url":"https://www.amazon.com/Oracle-SQL-Beginners-Djoni-Darmawikarta/dp/0980839645","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/W2290904476","https://openalex.org/W2327539013","https://openalex.org/W105399545","https://openalex.org/W376148143","https://openalex.org/W640867714","https://openalex.org/W571000893","https://openalex.org/W4252191608","https://openalex.org/W604962236","https://openalex.org/W4240025496","https://openalex.org/W6986193532"],"abstract_inverted_index":{"This":[0],"introduction":[1],"to":[2,36,46,56,59,66,79,104],"SQL":[3,25],"for":[4],"the":[5,81,89,92,98,112],"Oracle":[6,99,106,113],"database":[7,100],"begins":[8],"by":[9],"discussing":[10,102],"exactly":[11],"how":[12,35,45,55,65,78,103],"data":[13,61,115],"is":[14],"stored":[15,73],"and":[16,28,44,48,77,101,110],"maintained":[17],"in":[18,74,97],"a":[19,75,84],"relational":[20],"database,":[21,76],"familiarizing":[22],"readers":[23],"with":[24],"INSERT,":[26],"UPDATE,":[27],"DELETE":[29],"statements.":[30],"The":[31],"guide":[32],"then":[33],"discusses":[34],"construct":[37],"basic":[38],"queries,":[39],"choose":[40],"an":[41],"appropriate":[42],"output,":[43],"create":[47,67],"use":[49,57],"groups.":[50],"Readers":[51],"will":[52],"also":[53],"learn":[54],"joins":[58],"query":[60],"from":[62],"multiple":[63],"tables,":[64],"predefined":[68],"views":[69],"that":[70],"can":[71],"be":[72],"utilize":[80],"metadata":[82],"of":[83],"database.":[85],"Appendices":[86],"round":[87],"out":[88],"book,":[90],"covering":[91],"various":[93],"indexing":[94],"techniques":[95],"available":[96],"install":[105],"Database":[107],"Express":[108],"Edition":[109],"list":[111],"built-in":[114],"types.":[116]},"counts_by_year":[{"year":2022,"cited_by_count":1}],"updated_date":"2026-11-04T10:54:05.112534","created_date":"2016-06-24T00:00:00"}