skip to content
Sams teach yourself SQL in 24 hours Preview this item
ClosePreview this item

Sams teach yourself SQL in 24 hours

Author: Ryan K Stephens; Ronald R Plew; Arie Jones
Publisher: Indianapolis, Ind. : Sams Pub., ©2011.
Series: Sams teach yourself.
Edition/Format:   eBook : Document : English : 5th edView all editions and formats

Editions vary--sometimes Stephens is listed as first author, other editions list Plew as first author.


(not yet rated) 0 with reviews - Be the first.

More like this

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...


Genre/Form: Electronic books
Electronic book
Additional Physical Format: Print version:
Stephens, Ryan K.
Sams teach yourself SQL in 24 hours.
Indianapolis, Ind. : Sams Pub., ©2011
(DLC) 2011011148
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Ryan K Stephens; Ronald R Plew; Arie Jones
ISBN: 9780132603942 0132603942
OCLC Number: 741107253
Description: 1 online resource (xii, 473 pages) : illustrations
Contents: Part I: An SQL Concepts OverviewHOUR 1: Welcome to the World of SQL 1SQL Definition and History 1SQL Sessions 8Types of SQL Commands 9The Database Used in This Book 12Summary 17Q&A 17Workshop 18 Part II: Building Your DatabaseHOUR 2: Defining Data Structures 21What Is Data? 21Basic Data Types 22Summary 31Q&A 31Workshop 32HOUR 3: Managing Database Objects 37What Are Database Objects? 37What Is a Schema? 37Tables: The Primary Storage for Data 39Integrity Constraints 49Summary 54Q&A 55Workshop 55HOUR 4: The Normalization Process 61Normalizing a Database 61Denormalizing a Database 69Summary 70Q&A 70Workshop 71HOUR 5: Manipulating Data 73Overview of Data Manipulation 73Populating Tables with New Data 74Updating Existing Data 80Deleting Data from Tables 82Summary 83Q&A 83Workshop 84HOUR 6: Managing Database Transactions 87What Is a Transaction? 87Controlling Transactions 88Transactional Control and Database Performance 95Summary 96Q&A 96Workshop 97 Part III: Getting Effective Results from QueriesHOUR 7: Introduction to the Database Query 99What Is a Query? 99Introduction to the SELECT Statement 99Examples of Simple Queries 108Summary 112Q&A 112Workshop 113HOUR 8: Using Operators to Categorize Data 115What Is an Operator in SQL? 115Comparison Operators 116Logical Operators 119Conjunctive Operators 126Negative Operators 129Arithmetic Operators 133Summary 136Q&A 137Workshop 137HOUR 9: Summarizing Data Results from a Query 141What Are Aggregate Functions? 141Summary 150Q&A 150Workshop 150HOUR 10: Sorting and Grouping Data 153Why Group Data? 153The GROUP BY Clause 154GROUP BY Versus ORDER BY 159CUBE and ROLLUP Expressions 161The HAVING Clause 164Summary 165Q&A 166Workshop 166HOUR 11: Restructuring the Appearance of Data 169ANSI Character Functions 169Common Character Functions 170Miscellaneous Character Functions 179Mathematical Functions 183Conversion Functions 183Combining Character Functions 186Summary 187Q&A 188Workshop 188HOUR 12: Understanding Dates and Times 191How Is a Date Stored? 191Date Functions 193Date Conversions 198Summary 204Q&A 204Workshop 205 Part IV: Building Sophisticated Database QueriesHOUR 13: Joining Tables in Queries 207Selecting Data from Multiple Tables 207Understanding Joins 208Join Considerations 217Summary 221Q&A 222Workshop 222HOUR 14: Using Subqueries to Define Unknown Data 225What Is a Subquery? 225Embedded Subqueries 231Correlated Subqueries 233Subquery Performance 234Summary 235Q&A 235Workshop 236HOUR 15: Combining Multiple Queries into One 239Single Queries Versus Compound Queries 239Compound Query Operators 240Using ORDER BY with a Compound Query 246Using GROUP BY with a Compound Query 248Retrieving Accurate Data 250Summary 250Q&A 250Workshop 251 Part V: SQL Performance TuningHOUR 16: Using Indexes to Improve Performance 255What Is an Index? 255How Do Indexes Work? 256The CREATE INDEX Command 257Types of Indexes 258When Should Indexes Be Considered? 260When Should Indexes Be Avoided? 261Altering an Index 263Dropping an Index 263Summary 264Q&A 264Workshop 265HOUR 17: Improving Database Performance 267What Is SQL Statement Tuning? 267Database Tuning Versus SQL Statement Tuning 268Formatting Your SQL Statement 268Full Table Scans 274Other Performance Considerations 275Cost-Based Optimization 279Performance Tools 280Summary 280Q&A 281Workshop 281 Part VI: Using SQL to Manage Users and SecurityHOUR 18: Managing Database Users 285User Management in the Database 285The Management Process 288Tools Utilized by Database Users 296Summary 296Q&A 297Workshop 297HOUR 19: Managing Database Security 299What Is Database Security? 299What Are Privileges? 301Controlling User Access 304Controlling Privileges Through Roles 308Summary 310Q&A 310Workshop 311 Part VII: Summarized Data StructuresHOUR 20: Creating and Using Views and Synonyms 313What Is a View? 313Creating Views 316WITH CHECK OPTION 320Creating a Table from a View 321Views and the ORDER BY Clause 322Updating Data Through a View 322Dropping a View 323Performance Impact of Using Nested Views 323What Is a Synonym? 324Summary 325Q&A 326Workshop 326HOUR 21: Working with the System Catalog 329What Is the System Catalog? 329How Is the System Catalog Created? 331What Is Contained in the System Catalog? 331System Catalog Tables by Implementation 333Querying the System Catalog 334Updating System Catalog Objects 336Summary 337Q&A 337Workshop 338 Part VIII: Applying SQL Fundamentals in Today's WorldHOUR 22: Advanced SQL Topics 339Cursors 339Stored Procedures and Functions 343Triggers 346Dynamic SQL 348Call-Level Interface 349Using SQL to Generate SQL 350Direct Versus Embedded SQL 351Windowed Table Functions 351Working with XML 352Summary 353Q&A 353Workshop 354HOUR 23: Extending SQL to the Enterprise, the Internet, and the Intranet 355SQL and the Enterprise 355Accessing a Remote Database 357SQL and the Internet 360SQL and the Intranet 361Summary 362Q&A 363Workshop 363HOUR 24: Extensions to Standard SQL 367Various Implementations 367Example Extensions 370Interactive SQL Statements 373Summary 374Q&A 375Workshop 375 Part IX: AppendixesAPPENDIX A: Common SQL Commands 377SQL Statements 377SQL Clauses 381APPENDIX B: Using the Databases for Exercises 383Windows Installation Instructions for MySQL 383Windows Installation Instructions for Oracle 386Windows Installation Instructions for Microsoft SQL Server 388APPENDIX C: Answers to Quizzes and Exercises 391APPENDIX D: CREATE TABLE Statements for Book Examples 439APPENDIX E: INSERT Statements for Data in Book Examples 443APPENDIX F: Glossary 451APPENDIX G: Bonus Exercises 455INDEX 461
Series Title: Sams teach yourself.
Other Titles: Sams teach yourself Standard Query Language in twenty four hours
Responsibility: Ryan Stephens, Ron Plew, Arie D. Jones.


User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...


Be the first.

Similar Items

Related Subjects:(1)

User lists with this item (1)

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data

Primary Entity

<> # Sams teach yourself SQL in 24 hours
    a schema:CreativeWork, schema:Book, schema:MediaObject ;
   library:oclcnum "741107253" ;
   library:placeOfPublication <> ; # Indianapolis, Ind.
   library:placeOfPublication <> ;
   schema:about <> ; # SQL (Computer program language)
   schema:about <> ;
   schema:alternateName "Sams teach yourself Standard Query Language in twenty four hours" ;
   schema:bookEdition "5th ed." ;
   schema:bookFormat schema:EBook ;
   schema:contributor <> ; # Arie Jones
   schema:contributor <> ; # Ronald R. Plew
   schema:copyrightYear "2011" ;
   schema:creator <> ; # Ryan K. Stephens
   schema:datePublished "2011" ;
   schema:exampleOfWork <> ;
   schema:genre "Electronic books"@en ;
   schema:inLanguage "en" ;
   schema:isSimilarTo <> ;
   schema:name "Sams teach yourself SQL in 24 hours"@en ;
   schema:productID "741107253" ;
   schema:publication <> ;
   schema:publisher <> ; # Sams Pub.
   schema:url <> ;
   schema:url <> ;
   schema:url <> ;
   schema:workExample <> ;
   wdrs:describedby <> ;

Related Entities

<> # Indianapolis, Ind.
    a schema:Place ;
   schema:name "Indianapolis, Ind." ;

<> # SQL (Computer program language)
    a schema:Intangible ;
   schema:name "SQL (Computer program language)"@en ;

<> # Arie Jones
    a schema:Person ;
   schema:familyName "Jones" ;
   schema:givenName "Arie" ;
   schema:name "Arie Jones" ;

<> # Ronald R. Plew
    a schema:Person ;
   schema:familyName "Plew" ;
   schema:givenName "Ronald R." ;
   schema:name "Ronald R. Plew" ;

<> # Ryan K. Stephens
    a schema:Person ;
   schema:familyName "Stephens" ;
   schema:givenName "Ryan K." ;
   schema:name "Ryan K. Stephens" ;

    a schema:ProductModel ;
   schema:isbn "0132603942" ;
   schema:isbn "9780132603942" ;

    a schema:CreativeWork ;
   rdfs:label "Sams teach yourself SQL in 24 hours." ;
   schema:description "Print version:" ;
   schema:isSimilarTo <> ; # Sams teach yourself SQL in 24 hours

Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.