Advanced
Error loading page.
Try refreshing the page. If that doesn't work, there may be a network issue, and you can use our self test page to see what's preventing the page from loading.
Learn more about possible network issues or contact support for more help.
Title details for Learning SQL by Alan Beaulieu - Available

Learning SQL

Generate, Manipulate, and Retrieve Data

by Alan Beaulieu
ebook
1 of 1 copy available
Borrow Read a sample Read a sample
1 of 1 copy available

As data floods into your company, you need to put it to work right away—and SQL is the best tool for the job. With the latest edition of this introductory guide, author Alan Beaulieu helps developers get up to speed with SQL fundamentals for writing database applications, performing administrative tasks, and generating reports. You'll find new chapters on SQL and big data, analytic functions, and working with very large databases.

Each chapter presents a self-contained lesson on a key SQL concept or technique using numerous illustrations and annotated examples. Exercises let you practice the skills you learn. Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly discover how to put the power and flexibility of this language to work.

  • Move quickly through SQL basics and several advanced features
  • Use SQL data statements to generate, manipulate, and retrieve data
  • Create database objects, such as tables, indexes, and constraints with SQL schema statements
  • Learn how datasets interact with queries; understand the importance of subqueries
  • Convert and manipulate data with SQL's built-in functions and use conditional logic in data statements

    • Creators

    • Publisher

    • Release date

      March 4, 2020

    • Formats

      • Kindle Book

      • OverDrive Read

        • ISBN: 9781492057567

      • EPUB ebook

        • ISBN: 9781492057567
        • File size: 2851 KB

    • Languages

      • English

    • Reviews

      • Library Journal

        April 1, 2006
        SQL is the standard programming language for creating, manipulating, and retrieving information stored in relational databases; most libraries should own one or more guides. SQL Cookbook, a comprehensive source of code samples (or -recipes -) that shows developers how to solve common problems, compares solutions from different database management systems (DBMS), including SQL Server, PostgreSQL, Oracle, MySQL, and DB2. Each recipe contains a problem, a solution (with code samples from each platform), and a brief discussion and range from concatenating column values to searching for mixed alphanumeric strings. A great purchase for all medium and larger libraries as a supplement to basic how-to guides.

        The three other titles each target beginners. A good self-study guide, SQL Demystified incorporates chapter quizzes and a -Final Exam - to test mastery. From a basic introduction to relational databases through SQL performance and tuning, Demystifie clearly introduces SQL concepts and points out where implementations on various platforms differ. Its conversational style and clear examples recommend it for all libraries. SQL: Visual QuickStart Guide moves from an overview of various DBMS to how to execute transactions. A nice layout shows both code samples and results, usage differences among DBMS are explained, a companion web site contains sample files, and an appendix lists standard SQL keywords. Clear prose and a sense of humor make this a winner for all libraries. Examples in Learning SQL run on MySQL, Oracle, and SQL Server, but the platform used in the book itself is (the free) MySQL. Coverage ranges from a background on databases to indexes and constraints; step-by-step examples and chapter exercises help readers learn independently. Appropriate for all libraries.

        Copyright 2006 Library Journal, LLC Used with permission.

    Formats

    • Kindle Book
    • OverDrive Read
    • EPUB ebook

    subjects

    Languages

    • English

    Loading
    Check Out What's Being Checked Out Right Now