Close cookie details

This site uses cookies. Learn more about cookies.

OverDrive would like to use cookies to store information on your computer to improve your user experience at our Website. One of the cookies we use is critical for certain aspects of the site to operate and has already been set. You may delete and block all cookies from this site, but this could affect certain features or services of the site. To find out more about the cookies we use and how to delete them, click here to see our Privacy Policy.

If you do not wish to continue, please click here to exit this site.

Hide notification

  Main Nav
SQL All-In-One For Dummies
Cover of SQL All-In-One For Dummies
SQL All-In-One For Dummies

The latest on SQL databases

SQL All -In-One For Dummies, 3rd Edition, is a one-stop shop for everything you need to know about SQL and SQL-based relational databases. Everyone from database administrators to application programmers and the people who manage them will find clear, concise explanations of the SQL language and its many powerful applications.

With the ballooning amount of data out there, more and more businesses, large and small, are moving from spreadsheets to SQL databases like Access, Microsoft SQL Server, Oracle databases, MySQL, and PostgreSQL. This compendium of information covers designing, developing, and maintaining these databases.

  • Cope with any issue that arises in SQL database creation and management
  • Get current on the newest SQL updates and capabilities
  • Reference information on querying SQL-based databases in the SQL language
  • Understand relational databases and their importance to today’s organizations
  • SQL All-In-One For Dummies is a timely update to the popular reference for readers who want detailed information about SQL databases and queries.

    The latest on SQL databases

    SQL All -In-One For Dummies, 3rd Edition, is a one-stop shop for everything you need to know about SQL and SQL-based relational databases. Everyone from database administrators to application programmers and the people who manage them will find clear, concise explanations of the SQL language and its many powerful applications.

    With the ballooning amount of data out there, more and more businesses, large and small, are moving from spreadsheets to SQL databases like Access, Microsoft SQL Server, Oracle databases, MySQL, and PostgreSQL. This compendium of information covers designing, developing, and maintaining these databases.

  • Cope with any issue that arises in SQL database creation and management
  • Get current on the newest SQL updates and capabilities
  • Reference information on querying SQL-based databases in the SQL language
  • Understand relational databases and their importance to today’s organizations
  • SQL All-In-One For Dummies is a timely update to the popular reference for readers who want detailed information about SQL databases and queries.

    Available formats-
    • Kindle Book
    • OverDrive Read
    • EPUB eBook
    Languages:-
    Copies-
    • Available:
      0
    • Library copies:
      1
    Levels-
    • ATOS:
    • Lexile:
    • Interest Level:
    • Text Difficulty:

    Recommended for you

    About the Author-
    • Allen G. Taylor is a 40-year veteran of the computer industry and the author of more than 40 books, including SQL For Dummies and Database Development For Dummies. For the latest news on Allen's activities, check out his online courses (at pioneer-academy1.teachable.com) and his blog (at www.allengtaylor.com). You can contact Allen at allen.taylor@ieee.org.

    Table of Contents-
    • Introduction 1

      About This Book 1

      Foolish Assumptions 2

      Conventions Used in This Book 3

      What You Don’t Have to Read 3

      How This Book is Organized 3

      Book 1: SQL Concepts 3

      Book 2: Relational Database Development 4

      Book 3: SQL Queries 4

      Book 4: Data Security 4

      Book 5: SQL and Programming 5

      Book 6: SQL and XML 5

      Book 7: Database Tuning Overview 5

      Book 8: Appendices 5

      Icons Used in This Book 6

      Where to Go from Here 6

      Book 1: SQL Concepts 9

      Chapter 1: Understanding Relational Databases 11

      Understanding Why Today’s Databases are Better than Early Databases 12

      Databases, Queries, and Database Applications 16

      Examining Competing Database Models 18

      Why the Relational Model Won 29

      Chapter 2: Modeling a System 31

      Capturing the Users’ Data Model 31

      Translating the Users’ Data Model to a Formal Entity-Relationship Model 34

      Entity-Relationship modeling techniques 35

      Chapter 3: Getting to Know SQL 55

      Where SQL Came From 55

      Knowing What SQL Does 56

      The ISO/IEC SQL Standard 57

      Knowing What SQL Does Not Do 57

      Choosing and Using an Available DBMS Implementation 58

      Chapter 4: SQL and the Relational Model 67

      Sets, Relations, Multisets, and Tables 68

      Functional Dependencies 69

      Keys 70

      Views 71

      Users 72

      Privileges 72

      Schemas 73

      Catalogs 74

      Connections, Sessions, and Transactions 74

      Routines 75

      Paths 75

      Chapter 5: Knowing the Major Components of SQL 77

      Creating a Database with the Data Definition Language 77

      Operating on Data with the Data Manipulation Language (DML) 88

      Maintaining Security in the Data Control Language (DCL) 97

      Chapter 6: Drilling Down to the SQL Nitty-Gritty 99

      Executing SQL Statements 99

      Module language 104

      Using Reserved Words Correctly 105

      SQL’s Data Types 105

      Handling Null Values 123

      Applying Constraints 124

      Book 2: Relational Database Development 131

      Chapter 1: System Development Overview 133

      The Components of a Database System 133

      The System Development Life Cycle 136

      Chapter 2: Building a Database Model 149

      Finding and Listening to Interested Parties 150

      Building Consensus 152

      Building a Relational Model 154

      Being Aware of the Danger of Anomalies 157

      The Database Integrity versus Performance Tradeoff 164

      Chapter 3: Balancing Performance and Correctness 167

      Designing a Sample Database 168

      Maintaining Integrity 179

      Avoiding Data Corruption 183

      Speeding Data Retrievals 185

      Working with Indexes 187

      Reading SQL Server Execution Plans 194

      Chapter 4: Creating a Database with SQL 199

      First Things First: Planning Your Database 199

      Building Tables 200

      Setting Constraints 204

      Keys and Indexes 205

      Ensuring Data Validity with Domains 205

      Establishing Relationships between Tables 206

      Altering Table Structure 210

      Deleting Tables 210

      Book 3: SQL Queries 211

      Chapter 1: Values, Variables, Functions, and Expressions 213

      Entering Data Values 213

      Working with Functions 217

      Using Expressions 229

      Chapter 2: SELECT Statements and Modifying Clauses 239

      ...
    Title Information+
    • Publisher
      Wiley
    • Kindle Book
      Release date:
    • OverDrive Read
      Release date:
    • EPUB eBook
      Release date:
    Digital Rights Information+
    • Copyright Protection (DRM) required by the Publisher may be applied to this title to limit or prohibit printing or copying. File sharing or redistribution is prohibited. Your rights to access this material expire at the end of the lending period. Please see Important Notice about Copyrighted Materials for terms applicable to this content.

    Status bar:

    You've reached your checkout limit.

    Visit your Checkouts page to manage your titles.

    Close

    You already have this title checked out.

    Want to go to your Checkouts?

    Close

    Recommendation Limit Reached.

    You've reached the maximum number of titles you can recommend at this time. You can recommend up to 5 titles every 7 day(s).

    Close

    Sign in to recommend this title.

    Recommend your library consider adding this title to the Digital Collection.

    Close

    Enhanced Details

    Close
    Close

    Limited availability

    Availability can change throughout the month based on the library's budget.

    is available for days.

    Once playback starts, you have hours to view the title.

    Close

    Permissions

    Close

    The OverDrive Read format of this eBook has professional narration that plays while you read in your browser. Learn more here.

    Close

    Holds

    Total holds:


    Close

    Restricted

    Some format options have been disabled. You may see additional download options outside of this network.

    Close

    MP3 audiobooks are only supported on macOS 10.6 (Snow Leopard) through 10.14 (Mojave). Learn more about MP3 audiobook support on Macs.

    Close

    You've reached your library's checkout limit for digital titles.

    To make room for more checkouts, you may be able to return titles from your Checkouts page.

    Close

    Excessive Checkout Limit Reached.

    There have been too many titles checked out and returned by your account within a short period of time.

    Try again in several days. If you are still not able to check out titles after 7 days, please contact Support.

    Close

    You have already checked out this title. To access it, return to your Checkouts page.

    Close

    This title is not available for your card type. If you think this is an error contact support.

    Close

    An unexpected error has occurred.

    If this problem persists, please contact support.

    Close

    Close

    NOTE: Barnes and Noble® may change this list of devices at any time.

    Close
    Buy it now
    and help our library WIN!
    SQL All-In-One For Dummies
    SQL All-In-One For Dummies
    Allen G. Taylor
    Choose a retail partner below to buy this title for yourself.
    A portion of this purchase goes to support your library.
    Clicking on the 'Buy It Now' link will cause you to leave the library download platform website. The content of the retail website is not controlled by the library. Please be aware that the website does not have the same privacy policy as the library or its service providers.
    Close
    Close

    There are no copies of this issue left to borrow. Please try to borrow this title again when a new issue is released.

    Close
    Barnes & Noble Sign In |   Sign In

    You will be prompted to sign into your library account on the next page.

    If this is your first time selecting “Send to NOOK,” you will then be taken to a Barnes & Noble page to sign into (or create) your NOOK account. You should only have to sign into your NOOK account once to link it to your library account. After this one-time step, periodicals will be automatically sent to your NOOK account when you select "Send to NOOK."

    The first time you select “Send to NOOK,” you will be taken to a Barnes & Noble page to sign into (or create) your NOOK account. You should only have to sign into your NOOK account once to link it to your library account. After this one-time step, periodicals will be automatically sent to your NOOK account when you select "Send to NOOK."

    You can read periodicals on any NOOK tablet or in the free NOOK reading app for iOS, Android or Windows 8.

    Accept to ContinueCancel