05177nam 2200637Ia 450 991097336960332120250428223553.097811186571881118657187(CKB)2670000000402375(EBL)1335264(OCoLC)855504594(SSID)ssj0001103909(PQKBManifestationID)11749548(PQKBTitleCode)TC0001103909(PQKBWorkID)11088592(PQKB)10864729(MiAaPQ)EBC1335264(EXLCZ)99267000000040237520091026d2013 uy 0engtxtccrSQL for dummies /by Allen G. Taylor8th ed.Hoboken, NJ Wiley ;Chichester John Wiley [distributor]20131 online resource (483 p.)--For dummiesIncludes index.1-118-60796-1 Table of Contents; Introduction; About This Book; Who Should Read This Book?; Icons Used in This Book; Where to Go from Here; Part I: Getting Started with SQL; Chapter 1: Relational Database Fundamentals; Keeping Track of Things; What Is a Database?; Database Size and Complexity; What Is a Database Management System?; Flat Files; Database Models; Database Design Considerations; Chapter 2: SQL Fundamentals; What SQL Is and Isn't; A (Very) Little History; SQL Statements; Reserved Words; Data Types; Null Values; Constraints; Using SQL in a Client/Server SystemUsing SQL on the Internet or an Intranet Chapter 3: The Components of SQL; Data Definition Language; Data Manipulation Language; Data Control Language; Part II: Using SQL to Build Databases; Chapter 4: Building and Maintaining a Simple Database Structure; Using a RAD Tool to Build a Simple Database; Building POWER with SQL's DDL; Portability Considerations; Chapter 5: Building a Multi-table Relational Database; Designing a Database; Working with Indexes; Maintaining Data Integrity; Normalizing the Database; Part III: Storing and Retrieving Data; Chapter 6: Manipulating Database DataRetrieving Data Creating Views; Updating Views; Adding New Data; Updating Existing Data; Transferring Data; Deleting Obsolete Data; Chapter 7: Handling Temporal Data; Understanding Times and Periods in SQL: 2011; Working with Application-Time Period Tables; Working with System-Versioned Tables; Tracking Even More Time Data with Bitemporal Tables; Chapter 8: Specifying Values; Values; Value Expressions; Functions; Chapter 9: Using Advanced SQL Value Expressions; CASE Conditional Expressions; CAST Data-Type Conversions; Row Value Expressions; Chapter 10: Zeroing In on the Data You WantModifying Clauses FROM Clauses; WHERE Clauses; Logical Connectives; GROUP BY Clauses; HAVING Clauses; ORDER BY Clauses; Limited FETCH; Peering through a Window to Create a Result Set; Chapter 11: Using Relational Operators; UNION; INTERSECT; EXCEPT; Join Operators; ON versus WHERE; Chapter 12: Delving Deep with Nested Queries; What Subqueries Do; Chapter 13: Recursive Queries; What Is Recursion?; What Is a Recursive Query?; Where Might You Use a Recursive Query?; Where Else Might You Use a Recursive Query?; Part IV: Controlling Operations; Chapter 14: Providing Database SecurityThe SQL Data Control Language User Access Levels; Granting Privileges to Users; Granting Privileges across Levels; Granting the Power to Grant Privileges; Taking Privileges Away; Using GRANT and REVOKE Together to Save Time and Effort; Chapter 15: Protecting Data; Threats to Data Integrity; Reducing Vulnerability to Data Corruption; Constraints Within Transactions; Chapter 16: Using SQL within Applications; SQL in an Application; Hooking SQL into Procedural Languages; Part V: Taking SQL to the Real World; Chapter 17: Accessing Data with ODBC and JDBC; ODBC; ODBC in a Client/Server EnvironmentODBC and the InternetUncover the secrets of SQL and start building better relational databases today!This fun and friendly guide will help you demystify database management systems so you can create more powerful databases and access information with ease. Updated for the latest SQL functionality, SQL For Dummies, 8th Edition covers the core SQL language and shows you how to use SQL to structure a DBMS, implement a database design, secure your data, and retrieve information when you need it. Includes new enhancements of SQL:2011, including temporal data functionality which--For dummiesFor dummiesSQL (Computer program language)Computer programmingRelational databases (Computer program)SQL (Computer program language)Computer programming.Relational databases (Computer program)005.75/85005.7585Taylor Allen G861604MiAaPQMiAaPQMiAaPQBOOK9910973369603321SQL for dummies4372529UNINA02982nam 2200721Ia 450 991096303350332120251117003606.00-19-045238-21-281-99860-597866119986080-19-972479-2(CKB)1000000000715788(EBL)415456(OCoLC)437093736(SSID)ssj0000185662(PQKBManifestationID)11164245(PQKBTitleCode)TC0000185662(PQKBWorkID)10216228(PQKB)10201367(MiAaPQ)EBC415456(Au-PeEL)EBL415456(CaPaEBR)ebr10288397(CaONFJC)MIL199860(MiAaPQ)EBC7034611(Au-PeEL)EBL7034611(OCoLC) 230730059(FINmELB)ELB166793(OCoLC)1336403070(EXLCZ)99100000000071578820080530d2008 uy 0engur|n|---|||||txtccrJews and the sporting life /edited by Ezra MendelsohnOxford ;New York Oxford University Press20081 online resource (306 p.)Studies in contemporary Jewry,0740-8625 ;23Description based upon print version of record.0-19-538291-9 Includes bibliographical references.Contents; Symposium: Jews and the Sporting Life; Essays; Review Essays; Book Reviews; Cultural Studies and Religion; History and the Social Sciences; Zionism, Israel, and the Middle East; Contents for Volume XXIV; Note on Editorial PolicySymposium: Jews and the Sporting Life. Thoughts on the Jewish Body, Baseball, and the Problem of Integration, Sander L. Gilman (Emory University). Jews and Sports in Poland before the Second World War, Diethelm Blecking (Albert-Ludwigs-Universitat). ""Boxing for Everyone"": Jewish DPs, Sports, and Boxing, Gabriel N. Finder (University of Virginia). The Jewish Bookmaker: Gambling, Legitimacy, and the American Political Economy, Michael Alexander (University of California, Riverside). Pride and Priorities: American Jewry's Response to Hakoah Vienna's U.S. Tour of 1926, Jeffrey S. Gurock, (YeshivStudies in contemporary Jewry ;23.Avraham Harman Institute of Contemporary Jewry, The Hebrew University of JerusalemJewish athletesSportsSocial aspectsJewish athletes.SportsSocial aspects.796.089796.089/924796.089924796.089924Mendelsohn Ezra298491Makhon le-Yahadut zemanenu a. sh. Avraham Harman.MiAaPQMiAaPQMiAaPQBOOK9910963033503321Jews and the sporting life4463820UNINA