 |
Learning SQL by Alan Beaulieu
Book Summary InformationAuthor: Alan Beaulieu Edition: Paperback Audio: English (Unknown); English (Original Language); English (Published) Published: 2005-08-29 ISBN: 0596007272 Number of pages: 312 Publisher: O'Reilly Media
Book Reviews of Learning SQLBook Review: SQL 101 Summary: 5 Stars
Over the past 30+ years programming languages (popular ones) have come, gone, and new ones seem to appear every couple of years or so. FORTRAN, COBOL, Pascal, C, C++, Java, and now C#... the question isn't IF the next big language is going to come but WHEN. While the way we program has changed, the de facto standard for talking and creating databases hasn't changed much since the early 70s when SQL was created. While refined and standardized several times since its inception, SQL remains the tried and true backbone way of communicating with all databases, whether they are Oracle, SQL Server, MYSql, Access, etc.
For this reason, it is not only important, but I believe ESSENTIAL for all developers in this day and age to come quickly up to speed and learn what SQL is because no matter who you are, at some point (probably sooner than later) you will have to use SQL in your development career. Back when I was introduced to SQL in the mid 90s I knew nothing of what SQL was, thrown into it by immediately looking at SELECT queries, INSERTS, and so on. I would have loved some overview teaching guide to help me get my feet wet, instead learning the hard way.
Have no fear, those days are over.
With 'Learning SQL', Alan Beaulieu gives a great overview of what SQL is and what makes it so important in the world today. More than any other programming language, databases are what keeps the world moving on a daily basis, whether it's the financial sector, health care, government, etc. No matter where you using a computer, you will be accessing a database and for that data to be grabbed and manipulated, you will need to use SQL to make your calls/updates.
O'Reilly has a storied tradition of making great "Learning" books, and the same can easily be said here as well. I find it amazing that it took so long for a Learning SQL book to come out, but sometimes it's better to wait and let the finished product be even better with age.
Highlights include:
History of SQL (background)
Creating and populating a database
Using SELECT statements to get data
Filtering data with conditions
Querying multiple tables at once
Working with sets (UNIONS et al)
Data generation, conversion, manipulation
GROUP statements
Creating subqueries
JOINS in detail
Adding conditional logic
The importance of Transactions
Performance gains via Indexes and Constraints
For anyone that isn't a SQL expert, this is a great refresher for all. For anyone that is new or an amateur in their SQL careers, this book is absolutely a gem.
This should be required reading for all database 101 students, and I give it an A+ for not only the content within but the simplicity with which it is to read.
***** HIGHEST POSSIBLE RECOMMENDATION
Summary of Learning SQLSQL (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 database
- SQL Data Statements--those used to create, manipulate, and retrieve data stored in your database; example statements include select, update, insert, and delete
- SQL Schema Statements--those used to create database objects, such as tables, indexes, and constraints
- How data sets can interact with queries
- The importance of subqueries
- Data conversion and manipulation via SQL's built-in functions
- How conditional logic can be used in Data Statements
Best 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.
|
 |
Machine Learning and Its Applications: Advanced Lectures (Lecture Notes in Computer Science / Lecture Notes in Artificial Intelligence)Springer; Published: 2001-09-21; Paperback; BookBest price: $55.67Price in other shops: $69.95
Web Dynamics: Adapting to Change in Content, Size, Topology and UseSpringer; Published: 2004-06-14; Hardcover; BookBest price: $79.41Price in other shops: $129.00
Discovery Science: 8th International Conference, DS 2005, Singapore, October 8-11, 2005, Proceedings (Lecture Notes in Computer Science / Lecture Notes in Artificial Intelligence)Springer; Published: 2005-11-14; Paperback; BookBest price: $69.31Price in other shops: $78.00
Advances in Database Technology - EDBT 2004Springer; Published: 2004-04-14; Paperback; BookBest price: $111.27Price in other shops: $129.00
Collaborative Knowledge Acquisition from Semantically Disparate, Distributed Data Sources (Advanced Information and Knowledge Processing)by Vasant Honavar, Doina Caragea Springer; Published: 2012-04-13; Hardcover; BookBest price: $84.75Price in other shops: $99.00
Adaptive Web Sites: A Knowledge Extraction from Web Data Approach - Volume 170 Frontiers in Artificial Intelligence and Applicationsby J. D. Velasquez, V. Palade IOS Press; Published: 2008-01-15; Hardcover; BookBest price: $161.00
Kdd Proceedings 2000: Conference of Knowledge Discovery of Data-MiningAssn for Computing Machinery; Published: 2000-08; Paperback; BookBest price: $78.00
COMPLIFE 2007: 3rd International Symposium on Computational Life Science (AIP Conference Proceedings)American Inst. of Physics; Published: 2007-09-26; Hardcover; BookBest price: $61.00Price in other shops: $85.00
Molecular Sequence Analysis: A Primer on Computational and Bioinformatic Approachesby Sudhir Kumar, Alan Filipski Wiley-Liss; Published: 2009-01-26; Paperback; BookPrice in other shops: $69.95
Fuzy Model Tools Data Mining Replaceby Cox Academic Press; Paperback; Book
|
|