LEADER 04779oam 2200697M 450 001 9910793359803321 005 20240102235724.0 010 $a1-945612-63-0 035 $a(OCoLC)1080448354$z(OCoLC)1082261171 035 $a(OCoLC)on1080448354 035 $a(MiAaPQ)EBC5602384 035 $a(CKB)4100000007164520 035 $a(EXLCZ)994100000007164520 100 $a20181213d2019 fy 0 101 0 $aeng 135 $aurcn||m|||a|| 181 $ctxt$2rdacontent 182 $2isbdmedia 183 $acr$2rdacarrier 200 10$aSQL by example /$fJohn Russo 210 1$aNew York [New York] (222 East 46th Street, New York, NY 10017) :$cMomentum Press,$d2019. 215 $a1 online resource (1 PDF (xxii, 101 pages)) $cillustrations 225 1 $aComputer science collection 300 $aIncludes index. 300 $aTitle from PDF title page (viewed on December 13, 2018). 311 08$aPrint version: 9781945612626 327 $a1. The shore to shore shipping case study -- 1.1 Overview -- 1.2 Objectives -- 1.3 The Shore to Shore Shipping Company case study -- 1.4 Captain -- 1.5 Manufacturer -- 1.6 Ship -- 1.7 Item -- 1.8 Distance -- 1.9 Shipment -- 1.10 Shipment_Line -- 1.11 Problem solving using database management systems -- 1.12 Summary 327 $a2. Basic SQL syntax -- 2.1 Objectives -- 2.2 Syntax of an SQL statement -- 2.3 Expressions in the select clause -- 2.4 Extending SQL: the distinct clause -- 2.5 Qualifying the result set: the where clause -- 2.6 Putting it all together: selective aggregation -- 2.7 Summary 327 $a3. Single table queries -- 3.1 Introduction -- 3.2 Objectives -- 3.3 Review -- 3.4 Logical operators -- 3.5 On your own exercises -- 3.6 Compound where clauses -- 3.7 Order of operator precedence -- 3.8 Special operators -- 3.9 Computed columns -- 3.10 The order by clause -- 3.11 Summary 327 $a4. Introduction to joins -- 4.1 Introduction -- 4.2 Objectives -- 4.3 Multiple-table queries -- 4.4 Referential integrity constraints -- 4.5 Joining tables -- 4.6 Composite keys -- 4.7 Joining more than two tables -- 4.8 Shore to shore shipping map -- 4.9 Summary 327 $a5. Advanced join operations -- 5.1 Introduction -- 5.2 Objectives -- 5.3 Review of join operations -- 5.4 Self joins -- 5.5 Outer joins -- 5.6 Summary 327 $a6. Sub-queries -- 6.1 Introduction -- 6.2 Objectives -- 6.3 Sub-queries -- 6.4 Summary 327 $a7. Grouping data -- 7.1 Introduction -- 7.2 Objectives -- 7.3 The group by clause -- 7.4 Calculated fields -- 7.5 Group by with the having clause -- 7.6 Using count distinct -- 7.7 Count distinct and outer joins -- 7.8 Inline views -- 7.9 Summary 327 $aAbout the author -- Index. 330 3 $aSQL by Example uses one case study to teach the reader basic structured query language (SQL) skills. The author has tested the case study in the classroom with thousands of students. While other SQL texts tend to use examples from many different data sets, the author has found that once students get used to one case study, they learn the material at a much faster rate. The text begins with an introduction to the case study and trains the reader to think like the query processing engine for a relational database management system. Once the reader has a grasp of the case study then SQL programming constructs are introduced with examples from the case study. In order to reinforce concepts, each chapter has several exercises with solutions provided on the book's website. SQL by Example is designed both for those who have never worked with SQL as well as those with some experience. It is modular in that each chapter can be approached individually or as part of a sequence, giving the reader flexibility in the way that they learn or refresh concepts. This also makes the book a great reference to refer back to once the reader is honing his or her SQL skills on the job. 410 0$aComputer science collection. 606 $aSQL (Computer program language)$vProblems, exercises, etc 606 $aSQL (Computer program language)$2fast$3(OCoLC)fst01102869 608 $aProblems and exercises.$2fast 610 $aquery 610 $alanguage 610 $aRDBMS 610 $arelation database management systems 610 $aSQL 610 $aStructured query language 610 $atable 615 0$aSQL (Computer program language) 615 7$aSQL (Computer program language) 676 $a005.756 700 $aRusso$b John$01095979 801 0$bNYMPP 801 1$bNYMPP 801 2$bOCLCO 801 2$bOCLCF 801 2$bOCLCQ 801 2$bLMQ 801 2$bYDX 906 $aBOOK 912 $a9910793359803321 996 $aSQL by example$93841040 997 $aUNINA