{"id":"https://openalex.org/W205596458","doi":null,"title":"SQL for DB2","display_name":"SQL for DB2","publication_year":2009,"publication_date":"2009-01-16","ids":{"openalex":"https://openalex.org/W205596458","mag":"205596458"},"language":"en","primary_location":{"id":"mag:205596458","doi":null,"is_oa":false,"landing_page_url":"https://www.amazon.com/SQL-James-Cooper-Paul-Conte/dp/1583041230","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/A5018348931","display_name":"James Cooper","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"James Cooper","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5081456066","display_name":"Katie Tipton","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Katie Tipton","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":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_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9185000061988831,"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.9185000061988831,"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.06260000169277191,"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/T13034","display_name":"Information Systems Education and Curriculum Development","score":0.007699999958276749,"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.8460000157356262},{"id":"https://openalex.org/keywords/ibm-db2","display_name":"DB2","score":0.9599999785423279},{"id":"https://openalex.org/keywords/database-design","display_name":"database design","score":0.7170000076293945},{"id":"https://openalex.org/keywords/normalization","display_name":"normalization","score":0.6129999756813049},{"id":"https://openalex.org/keywords/data-modeling","display_name":"data modeling","score":0.8330000042915344},{"id":"https://openalex.org/keywords/entity-relationship-diagram","display_name":"entity relationship diagram","score":0.6759999990463257},{"id":"https://openalex.org/keywords/database-constraints","display_name":"database constraints","score":0.7559999823570251},{"id":"https://openalex.org/keywords/embedded-sql","display_name":"embedded SQL","score":0.828000009059906},{"id":"https://openalex.org/keywords/precipitating-factors","display_name":"precipitating factors","score":0.8349999785423279},{"id":"https://openalex.org/keywords/database-security","display_name":"database security","score":0.8730000257492065}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7744951248168945},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.769582211971283},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.6128759384155273},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.6094769239425659},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.49029186367988586},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.48833009600639343},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.4722157120704651},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.43921220302581787},{"id":"https://openalex.org/C33882796","wikidata":"https://www.wikidata.org/wiki/Q4826222","display_name":"Autocommit","level":5,"score":0.4380023777484894},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.3695979118347168},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3629947900772095},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.15998077392578125},{"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":1,"locations":[{"id":"mag:205596458","doi":null,"is_oa":false,"landing_page_url":"https://www.amazon.com/SQL-James-Cooper-Paul-Conte/dp/1583041230","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/W2530586957","https://openalex.org/W7046200745","https://openalex.org/W647002924","https://openalex.org/W2470566046","https://openalex.org/W36681664","https://openalex.org/W622640849","https://openalex.org/W4255853826","https://openalex.org/W2521335221","https://openalex.org/W1501251577","https://openalex.org/W2738342198"],"abstract_inverted_index":{"This":[0,70,182],"focused,":[1],"comprehensive":[2],"textbook":[3],"provides":[4],"start-to-finish":[5],"coverage":[6,195,202],"of":[7,47,67,95,120,139,196,203,211,214],"SQL":[8,18,33,88,132,154,207,225,283,292,298,308],"for":[9,19,21,34,43,64,89,133,155,157],"DB2.":[10],"Whether":[11],"you":[12],"re":[13],"a":[14,26,65,96,116],"college":[15],"student":[16],"studying":[17],"DB2":[20,86,90,134,156,189,220],"the":[22,40,62,79,92,128,137],"first":[23],"time":[24],"or":[25],"professional":[27],"developer":[28],"who":[29],"needs":[30],"to":[31,52,55,83,130,148,153,219,224,233],"learn":[32,53],"DB2,":[35],"this":[36],"book":[37,50,71],"covers":[38,91],"all":[39],"basics":[41],"necessary":[42,82],"success.":[44],"The":[45,290],"purpose":[46],"any":[48],"database":[49,98],"is":[51],"how":[54],"develop":[56,84],"databases":[57,205],"effectively":[58],"and":[59,111,123,161,176,190,198,236,268,277,285,314,316],"precisely":[60],"without":[61],"need":[63],"lot":[66],"complicated":[68],"jargon.":[69],"delivers":[72],"on":[73,78,136],"that":[74,126],"promise":[75],"by":[76],"focusing":[77],"skill":[80],"set":[81],"well-designed":[85],"databases.":[87],"core":[93],"requirements":[94],"traditional":[97],"course.":[99],"Topics":[100,309],"are":[101],"presented":[102],"in":[103,299],"an":[104,150],"accessible,":[105],"easy-to-learn":[106],"manner":[107],"with":[108,168,206],"numerous":[109],"examples":[110],"tips.":[112],"End-of-chapter":[113],"materials":[114],"include":[115],"chapter":[117],"summary,":[118],"list":[119],"key":[121],"terms,":[122],"hands-on":[124],"exercises":[125],"put":[127],"concepts":[129],"work.":[131],"builds":[135],"foundation":[138],"its":[140],"widely":[141],"acclaimed":[142],"predecessor,":[143],"SQL/400":[144],"Developer":[145],"s":[146,159],"Guide,":[147],"provide":[149],"up-to-date":[151],"introduction":[152],"today":[158],"students":[160],"professionals.":[162],"All":[163],"chapters":[164,187],"have":[165,173],"been":[166,174,180],"refreshed,":[167],"improved":[169],"organization":[170],"throughout.":[171],"Examples":[172],"updated,":[175],"new":[177,183],"material":[178],"has":[179],"added.":[181],"edition":[184],"includes:":[185],"*New":[186],"introducing":[188],"System":[191],"i":[192],"Navigator":[193],"*Expanded":[194,201],"single-":[197],"multiple-table":[199],"queries":[200],"updating":[204],"*An":[208],"expanded":[209],"discussion":[210],"normalization":[212],"Table":[213,263],"Contents":[215],"Chapter":[216,221,226,230,239,244,249,252,257,260,265,270,274,281,288,295,302,305,310],"1":[217],"Introduction":[218,223,232],"2":[222],"3":[227],"Single-Table":[228],"Queries":[229,264],"4":[231],"Data":[234,242],"Modeling":[235,243],"Database":[237,255,312],"Design":[238,256],"5":[240],"Logical":[241],"6":[245],"Entity":[246],"Relationship":[247],"Diagram":[248],"7":[250],"Normalization":[251],"8":[253],"Physical":[254],"9Database":[258],"Constraints":[259],"10":[261],"Multiple":[262],"11":[266],"Views":[267],"Indexes":[269],"12":[271],"Updating":[272],"Tables":[273],"13":[275],"Static":[276],"Dynamic":[278],"Embedded":[279],"Statements":[280,318],"14":[282],"Cursors":[284],"Result":[286],"Sets":[287],"15":[289],"Create":[291],"Program":[293],"Command":[294],"16":[296],"Using":[297],"RPG":[300],"Programs":[301],"17":[303],"Triggers":[304],"18":[306],"Additional":[307],"19":[311],"Security":[313],"Grant":[315],"Revoke":[317]},"counts_by_year":[],"updated_date":"2025-11-06T04:12:42.849631","created_date":"2016-06-24T00:00:00"}