Book Review: SAMS Teach Yourself SQL

Wouldn’t use this book if I was trying to learn SQL because it’s soo basic. It’s pretty good as a refresher of basic queries. The book’s examples are way too simple. Coverage of the different types of joins aren’t great either. I wouldn’t recommend this book to a beginner.

One thing I hadn’t used in awhile was the CONCAT() operator. Well for MySQL it’s CONCAT(col1, “, “, col2, …) ; for Oracle it’s column1 || ‘, ‘ || col2 … ; for MS SQL Server it’s col1+’, ‘+col2+… .

This entry was posted in Book, SQL. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s