Learning SQL By Alan Beaulieu

    DOWNLOAD Learning SQL

    Great read! It pieced together a lot of concepts that I learned on the job, and it provided the theory I was missing. Comprehensive (but not detailed) guide. Alan Beaulieu I’ve read the third edition and really liked it. I learned a little SQL on the job, but was happy to get some good background information. I enjoyed both the brief history of the language and clear examples for using various functions. And there are some fun jokes here and there. Good stuff. Alan Beaulieu Learning SQL is a fine introduction to SQL, with concise & practical practice exercises following each chapter. My only gripe is that even a beginner book should have at least one chapter on query optimization and performance tuning; it's a little too easy for beginners to knock over an entire database with one bad query. So if you do use this to learn SQL, do yourself (and your DBA) a favor and learn some basic optimization & tuning tricks for your own DBMS before you start to write and run queries in a production environment. (For query optimization, it's best to use a book specific to your RDBMS, as each has its own tricks and pitfalls. For MySQL, High Performance MySQL: Optimization, Backups, and Replication is terrific, and PostgreSQL 9.0 High Performance is very good for PostgreSQL.) Alan Beaulieu This is a fine book if you are looking for the first exposure to SQL. The author does a good job of introducing the basics of how the language works, touching all the essential features of SQL that you may encounter day-to-day.

    As an introductory book, what could have been done better, in my opinion, is to provide pointers to learning resources for those who wish to delve deeper into each topic. The book covers a wide range of topics but rather superficially, so some more care in that regard would have made the book more valuable.

    Given that the syntax variants for a couple of database engines (e.g., DB2, Oracle, SQL Server) are interleaved throughout the book, it is a little odd the book leaves out PostgreSQL almost entirely. Rather than interleaving, putting those as footnotes/endnotes may have made the book slightly easier to follow. (I read it on Safari Books Online in case that matters.) Alan Beaulieu At the time of reading this book SQL is new to me. I am familiar with a single command really (select * from [Table]). My work place uses MS SQL but I didn't want to just limit myself to Microsoft technology.

    Learning SQL starts off nicely for new users of SQL, it uses MySQL to provide you the examples, but the author is clear at telling you when a command is different between MSSQL, MySQL and Oracle.

    The whole history, and explanation of how relational databases came about and work the way they do is rightly skipped over. This is not something you need to worry about when starting out, but becomes more interesting to you once you know and use the product. So instead you get down and dirty with the real stuff you want to learn.

    It's a great book for introducing you to SQL, allowing you to decide which route you might take for specialising in one of the big branded database servers. It sets a sound foundation for more advanced techniques and I would recommend it to anyone wanting to learn SQL for the first time. Alan Beaulieu

    SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. If you're working with a relational database--whether you're writing applications, performing administrative tasks, or generating reports--you need to know how to interact with your data. Even if you are using a tool that generates SQL for you, such as a reporting tool, there may still be cases where you need to bypass the automatic generation feature and write your own SQL statements.

    To help you attain this fundamental SQL knowledge, look to Learning SQL, an introductory guide to SQL, designed primarily for developers just cutting their teeth on the language.

    Learning SQL moves you quickly through the basics and then on to some of the more commonly used advanced features. Among the topics discussed: The history of the computerized databaseSQL Data Statements--those used to create, manipulate, and retrieve data stored in your database; example statements include select, update, insert, and deleteSQL Schema Statements--those used to create database objects, such as tables, indexes, and constraintsHow data sets can interact with queriesThe importance of subqueriesData conversion and manipulation via SQL's built-in functionsHow conditional logic can be used in Data StatementsBest of all, Learning SQL talks to you in a real-world manner, discussing various platform differences that you're likely to encounter and offering a series of chapter exercises that walk you through the learning process. Whenever possible, the book sticks to the features included in the ANSI SQL standards. This means you'll be able to apply what you learn to any of several different databases; the book covers MySQL, Microsoft SQL Server, and Oracle Database, but the features and syntax should apply just as well (perhaps with some tweaking) to IBM DB2, Sybase Adaptive Server, and PostgreSQL.

    Put the power and flexibility of SQL to work. With Learning SQL you can master this important skill and know that the SQL statements you write are indeed correct. Learning SQL

    Learning

    This book manages to easily expose the basic SQL concepts. After reading it you are ready to go and design your database or app.

    Although it focuses on MySQL there are a lot of examples of MS SQL and Oracle SQL.

    It is a beginner's book so it misses some advanced techniques such as optimization or high level design. Alan Beaulieu Read the 3rd edition. Had a surface-level understanding of SQL going in and wanted a more structured walkthrough of the language, especially w.r.t. querying.

    The treatment of querying was quite good. I'd only suggest more on query optimization (there's a couple of other advanced topics I felt could be replaced with this instead); or at least cover best practices / things to avoid.

    Overall very readable and has a lot of breadth. Would recommend to fill in knowledge gaps or just want more structured learning on the topic. Alan Beaulieu For my purposes, this was a fantastic book. I can understand that mileage may vary if you are a DBA or need to get into great depth on a specific database and the intricacies of its syntax, but as a general overview to relational databases and SQL, this is an excellent resource. If you work with software that has a database component, the information contained herein will help you to understand what kinds of things are more or less easily doable with your data. I found the book very pragmatic and the examples helpfully illustrative. Alan Beaulieu Really good introduction. Not just the specifications and grammar, but examples on how to do things right and why they are right. Alan Beaulieu Nice SQL refresher Alan Beaulieu