Skip to main content

You are here

Database

Sams Teach Yourself SQL in 10 Minutes

The Sams Teach Yourself SQL in 10 Minutes series is the best selling SQL book series, and after reading this book (although older version since I read the second edition), I can see why that is the case. This is a really good SQL good. It is SQL agnostic, though it does mention the difference between major RDMS, and also provides the different implementations using SQL Server, Oracle, and on a few occasions even MySQL.

This book goes into far more detail than MySQL in 10 minutes. I read both books jointly, and I think this is the best approach for anyone new to SQL and if you’re learning via MySQL. Unlike MySQL in 10 minutes, this book does have consequently updated editions published.

This book was extremely easy to follow and very well written, and in my opinion it is perhaps the best introductory SQL book.

Sams Teach Yourself SQL in 10 Minutes

Rating 4/5

Chapter 1: Understanding SQL
Chapter 2: Retrieving Data
Chapter 3: Sorting Retrieved Data
Chapter 4: Filtering Data
Chapter 5: Advance Filtering
Chapter 6: Using Wildcard Filtering
Chapter 7: Creating Calculated Fields
Chapter 8: Using Data Manipulation Functions
Chapter 9: Summarizing Data
Chapter 10: Grouping Data
Chapter 11: Working with Subqueries
Chapter 12: Joining Tables
Chapter 13: Creating Advance Joins
Chapter 14: Combining Queries
Chapter 15: Inserting Data
Chapter 16: Updating and Deleting Data
Chapter 17: Creating and Manipulating Tables
Chapter 18: Using Views
Chapter 19: Working with Stored Procedures
Chapter 20: Managing Transaction Processing
Chapter 21: Using Cursors
Chapter 22: Understanding Advance SQL Features

Book: 

Book Category: 

Sams Teach Yourself MySQL in 10 Minutes

This primer book has practically all the content necessary in order to be fluent in MySQL and SQL in general at a medium to advance level knowledge. The examples are short and easy to understand. (After all the author’s goal was for each chapter to take 10 minutes to read). The chapters are perfectly structured, as you progress throughout the book, the chapters beautifully build up on top of content that you’ve already read (and hopefully learned). This book will teach you how to use MySQL, it doesn’t go into administration or any advance database optimization features of this fantastic relational database management system.

Published in 2006, so it obviously it has some information that is not quite up to date, but overall I think 90% of the content covered in this book is still perfectly valid. The only chapters that I didn’t bothered reading were the ones of using MySQL with different programming languages. This book is a perfect complementary MySQL and SQL reference book. The only drawback is the small outdated content, which hopefully in the near feature will have an updated version published.

Sams Teach Yourself MySQL in 10 Minutes

Rating 4/5

Chapter 1: Introducing MySQL
Chapter 2: Using MySQL
Chapter 3: Retrieving Data
Chapter 4: Filtering and Sorting Data
Chapter 5: Advanced Data Filtering
Chapter 6: Numeric Operators and Functions
Chapter 7: String Operators and Functions
Chapter 8: Date Operators an Functions
Chapter 9: Summarizing Data
Chapter 10: Using Subqueries
Chapter 11: Joining Tables
Chapter 12: Creating Advanced Joins
Chapter 13: Combining Queries
Chapter 14: Creating and Modifying Tables
Chapter 15: Working with Data
Chapter 16: Designing Your Database
Chapter 17: Keys and Indexes
Chapter 18: Managing User Access
Chapter 19: Views
Chapter 20: Stored Routines
Chapter 21: Triggers
Chapter 22: Using ODBC
Chapter 23: Using MySQL with C
Chapter 24: Using MySQL with PHP
Chapter 25: Using MySQL with Perl

Book: 

Book Category: 

Visual Quickstart Guide: MySQL

Visual Quickstart Guide: MySQL is yet another outdated physical book that I’ve decided to finish reading so I can toss it off my book shelf. This is a fantastic MySQL and general SQL book. It starts you off with basic MySQL and SQL usage, and database design theory, to more advance SQL usage and built-in MySQL functionality, as well as using MySQL with PHP, Perl, and Java. This book comprehensively covers associated mysql* tools.

It’s unbelievable for me to admit, but I really starting to dislike physical books. However, I really love how this book’s text is laid out. The layout is of two vertical columns, where text is presented and usually only side a visual image of what its being described. (I enjoy seeing the walls of text in my epic high fantasy books, and not in my technical books!)

Sadly, this book doesn’t have a modern recent edition. Being published in 2006, it definitely has outdated information. Thus said, I highly recommend this book to anyone new or wanting to learn SQL and MySQL, however I would highly suggest to also read the official documentation regarding each topic that it’s being described in the book. This is a beginner to mid level book, so you’ll definitely will not be seeing any advance MySQL features like replication, tuning, and performance (also mainly because this book covers MySQL 5.0)

Visual Quickstart Guide: MySQL
Rating 4/5

Chapter 1: Installing MySQL
Chapter 2: Running MySQL
Chapter 3: Database Design
Chapter 4: Creating a MySQL Database
Chapter 5: Basic SQL
Chapter 6: MySQL Functions
Chapter 7: MySQL and PHP
Chapter 8: MySQL and Perl
Chapter 9: MySQL and Java
Chapter 10: Advanced SQL and MySQL
Chapter 11: MySQL 5 Features
Chapter 12: Techniques For Programming
Chapter 13: MySQL Administration

Book: 

Book Category: 

Getting Started with Memcached

Packt Publishing's starter book series are short and meant to help readers get up to speed with the given technology. Getting Started with Memcached is a really short book aimed for developers and system administrators who are looking to quickly learn and configure memcached clusters in their web applications.

This book in a nutshell describes how to install Memcached in Linux (Ubuntu) and OS X, how to configure it and how to use it using PHP, Python, Ruby, and Java's Memcached client libraries as well as other popular web frameworks. I would never disencourage anyone for reading a technical book no matter how bad it is, after all at the end of the day, a technicall book will always teach you something new that you didn't knew prior to reading it. This is definetly not a bad book, however given how dead simple a Memcached distributed cluster implementation is, it would of been a lot better if this book covered Memcached more in depth. Anyone looking to learn Memcached will not go wrong purchasing this book, but I feel the offical Memcached documentation will do a better job teaching Memcached to a new user.

Chapters:
Getting Started with Memcached
Basic installation of memcached on Ubuntu (Simple)
Basic installation of memcached on Mac (Simple)
Compiling memcached from a source on Ubuntu (Simple)
Talking with memcached (Advanced)
Setting up memcached to start on boot in Ubuntu (Simple)
Setting up distributed memcached (Intermediate)
Using memcached with PHP (Intermediate)
Using memcached with Python (Intermediate)
Using memcached with Ruby (Intermediate)
Using memcached with Java (Intermediate)
Setting up memcached support in Rails (Simple)
Setting up memcached support in Django (Intermediate)
Setting up memcached to support in Play (Intermediate)

Rating: 3/5
Getting Started with Memcached

Book: 

Book Category: 

Premium Drupal Themes by Adaptivethemes