All CategoriesUncategorized
To Checkout

$ 29.68

Learning SQL 2nd Edition

2 customer reviews | Q&A
  • Image
Product Details
Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals.

Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will:
  • Move quickly through SQL basics and learn several advanced features
  • Use SQL data statements to generate, manipulate, and retrieve data
  • Create database objects, such as tables, indexes, and constraints, using SQL schema statements
  • Learn how data sets interact with queries, and understand the importance of subqueries
  • Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements
Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.
Reviews and Q&A

5

2 total
5
100.00%

  • Programmers, please read!

    • 12
    • 01
    • 2017
    by John R. Smith

    If you're writing any type of database driven code and you think that you don't need to
    understand SQL, read this book. You do need to understand it, and this book teaches it very well.
    Man, I'm so tired of cleaning up bad SQL code. Code that makes hundreds of queries when one would
    suffice. Or tables that have no primary keys. Or code that never makes use of joins. SQL is not
    horrible. It's worth understanding and knowing how to write well.
    This book is well written, well illustrated, and makes learning SQL as pain-free as it can be.
    Please, please, please, read this book.

  • Excellent choice for learning SQL

    • 12
    • 01
    • 2017
    by Robert L. Stevenson

    To all my Notes/Domino developer colleagues, here's a tip you already know... it's time to learn
    SQL. If it's been on your list of "things to learn or brush up on", I'd recommend the book
    Learning SQL by Alan Beaulieu. It's an excellent way to get up to speed (or *back* up to speed).
    Contents: A Little Background; Creating and Populating a Database; Query Primer; Filtering;
    Querying Multiple Tables; Working with Sets; Data Generation, Conversion, and Manipulation;
    Subqueries; Joins Revisited; Conditional Logic; Transactions; Indexes and Constraints; ER Diagram
    for Example Database; MySQL Extensions to the SQL Language; Solutions to Exercises; Further
    Resources; Index Notes/Domino 7 incorporates the ability to store your Domino data in a DB2
    repository. Then using Data Access Views, you can create application views that use SQL statements
    to generate the selection formula. While you don't absolutely *have* to know SQL, it'd be a good
    time to start adding that skill to your repertoire. Beaulieu's book is a clearly written tutorial
    on SQL that uses the open source MySQL database package to teach you the necessary skills. I like
    the decision to use MySQL, as it's something that's free and available to everyone. Trying to get
    DB2 up and running can be difficult, and it's definitely overkill if you're just trying to learn
    SQL. When you finish this book, you'll know all the key concepts that will allow you get data
    out of (and put data into) any relational database table out there. Obviously that's a valuable
    skill to have in your toolbox...
    So... commit to picking up a new skill or two in the upcoming year. I'd recommend that one of
    those skills be a fundamental knowledge of SQL, and Learning SQL can help you get there.