LEADER 03179oam 2200685I 450 001 9910461949603321 005 20200520144314.0 010 $a1-283-46197-8 010 $a9786613461971 010 $a0-203-18270-7 010 $a1-136-59331-4 024 7 $a10.4324/9780203182703 035 $a(CKB)2670000000161331 035 $a(EBL)958132 035 $a(OCoLC)798531959 035 $a(SSID)ssj0000679234 035 $a(PQKBManifestationID)11930470 035 $a(PQKBTitleCode)TC0000679234 035 $a(PQKBWorkID)10608924 035 $a(PQKB)11342735 035 $a(MiAaPQ)EBC958132 035 $a(PPN)198453892 035 $a(Au-PeEL)EBL958132 035 $a(CaPaEBR)ebr10535090 035 $a(CaONFJC)MIL346197 035 $a(OCoLC)782918740 035 $a(EXLCZ)992670000000161331 100 $a20180706d2012 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aState failure, underdevelopment, and foreign intervention in Haiti /$fJean-Germain Gros 210 1$aNew York :$cRoutledge,$d2012. 215 $a1 online resource (259 p.) 225 1 $aRoutledge studies in North American politics ;$v4 300 $aDescription based upon print version of record. 311 $a0-415-89032-2 320 $aIncludes bibliographical references and index. 327 $aCover; State Failure,Underdevelopment, and Foreign Intervention in Haiti; Copyright; Contents; List of Figures; List of Tables; Foreword; 1. Introduction; 2. Making Sense of the Failed State; 3. The Haitian Failed State in Historical Perspective; 4. A Rational-Choice Theory of Duvalierism; 5. In the Spiral of Anarchy: Post-Duvalier Haiti and Foreign Intervention; 6. Tectonic Plates, Anemic State; 7. Remaking the (Haitian) Failed State: Theoretical and Policy Considerations; Notes; Bibliography; Index 330 $aFailed states are a huge problem in international relations, threatening world order in a number of ways. Conflicts in failed states often spill unto neighbouring states, failed states make for unreliable partners in the resolution of global social problems such as poverty and AIDS, and failed states magnify the effects of natural disasters such as hurricanes and earthquakes. In response to the multiple threats posed by failed states, working states, sometimes acting alone sometimes in concert with others, have undertaken military operations, often under the rubric of humanitarian in 410 0$aRoutledge studies in North American politics ;$v4. 606 $aFailed states$zHaiti 606 $aEconomic assistance$zHaiti 606 $aTechnical assistance$zHaiti 607 $aHaiti$xPolitics and government 608 $aElectronic books. 615 0$aFailed states 615 0$aEconomic assistance 615 0$aTechnical assistance 676 $a972.9407/3 700 $aGros$b Jean-Germain$f1964-,$0961013 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910461949603321 996 $aState failure, underdevelopment, and foreign intervention in Haiti$92178596 997 $aUNINA 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