Subscribe: Ben Forta's Blog - SQL
Added By: Feedage Forager Feedage Grade A rated
Language: English
book  crash  mariadb  minutes  mysql  new  oracle  sams teach  sams  selling  sql book  sql minutes  sql  teach sql  teach 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: Ben Forta's Blog - SQL

Ben Forta's Blog - SQL

The web, app development, mobile, ColdFusion, gadgets, and whatever else tickles my fancy.

Published: Fri, 23 Mar 2018 19:08:45 -0400

Last Build Date: Tue, 09 Jan 2018 17:31:00 -0400


My Oracle Book In Chinese

Tue, 09 Jan 2018 17:31:00 -0400

(image) My Sams Teach Yourself Oracle PL/SQL In 10 Minutes has just been released in Chinese (making this my 8th book transalted into Chinese).

Sams Teach Yourself Oracle PL/SQL In 10 Minutes Now Available

Thu, 01 Oct 2015 17:25:00 -0400

(image) My Sams Teach Yourself Oracle PL/SQL In 10 Minutes is now available and shipping. This book is the 4th DBMS specific title based on my best-selling Sams Teach Yourself SQL in 10 Minutes, and like its siblings (on MariaDB, MySQL, and Microsoft SQL Server), goes into far more detail than the generic SQL book. Details, and a chapter listing, can be found on the book page.

Up To 70% Off SQL Video Tutorial

Thu, 03 Sep 2015 16:55:00 -0400

(image) I recently released a SQL video tutorial (based on my best-selling Sams Teach Yourself SQL in 10 Minutes). InformIT is running a Labor Day promotion with discounts on video lessons of up to 60-70% off, and my new SQL series is included in the promotion. The sale ends Wednesday, September 9th.

Half-Off Sams Teach Yourself SQL In 10 Minutes

Mon, 24 Aug 2015 20:03:00 -0400

(image) Want to learn SQL? InformIT is running a special on the best reviewed titles on My Sams Teach Yourself SQL In 10 Minutes is on that list, and so you can use this link to grab a copy of the best-selling SQL book of all time for 40% off (or buy multiple copies at 50% off). This offer ends September 1, 2015.

SQL Video Tutorials Released

Thu, 30 Jul 2015 22:26:00 -0400

(image) I recently mentioned that I was working on a SQL tutorial video series based on my best-selling Sams Teach Yourself SQL books (and their spin-offs). Well, the videos are now online, close to 3 hours of yours truly walking you through getting started with SQL. The lessons are based on the flow and format of the SQL books, even using the same examples and sample data, and are designed to be used in conjunction with the books if so desired. The videos are on Safari Books Online and InformIT and other streaming sites.

Just Wrapped Next SQL Book

Tue, 14 Jul 2015 16:34:12 -0400

(image) It's been sixteen years since the publication of my first book on SQL, Sams Teach Yourself SQL in 10 Minutes. That book was met with such positive feedback that it has been updated three times, has spawned several DBMS-specific spin-off titles, has been translated more than a dozen times, and is part of the curriculum in numerous schools and colleges the world over. In all of its various flavors and iterations, this little book has helped hundreds of thousands learn the basics of SQL. And along the way it has become the best-selling SQL book of all time, a fact that is both incredibly humbling and a source of great pride. I mentioned the DBMS-specific spin-off titles, thus far for Microsoft SQL Server T-SQL, MySQL, and MariaDB. Well, the (much delayed) 4th is on the way. Earlier today I finished reviewing the manuscript for an edition focused on Oracle PL/SQL (covering Oracle 10, 11, 12, and XE). The book page says it's out of print, but that's just because it's not yet shipping. It is available for pre-order, and I'll post a note when I have a final publication date. Oh and I'm not done yet. I'm also wrapping a SQL video series, and I'll post more on that when I have a link to share.

Latest SQL Book Now In Chinese

Thu, 27 Feb 2014 21:09:00 -0400

(image) Every edition of every SQL book I have written has been translated into other languages, including Chinese. And I'm pleased to announce that the 4th edition of my Sams Teach Yourself SQL In 10 Minutes is now available in Chinese, too.

SQL Book Discounted At Barnes & Noble

Tue, 25 Feb 2014 16:40:00 -0400

(image) Barnes & Noble is running an in-store promotion through March 12, a 30% discount on select "Sams Teach Yourself" titles. And my Sams Teach Yourself SQL In 10 Minutes is included in this promotion.

SQL Book Translated Into Korean

Wed, 04 Sep 2013 10:05:00 -0400

(image) Every edition of every SQL book I have written has been translated into other languages. And as per this blog post, it looks like the 4th edition of my Sams Teach Yourself SQL In 10 Minutes is now available in Korean.

New SQL Book Now In Color

Fri, 21 Sep 2012 10:51:00 -0400

(image) My little Sams Teach Yourself SQL in 10 Minutes is my best-selling title, it has sold over 1/4 million copies in English, has been translated into more than a dozen languages, has created spin-off titles focused on specific DBMSs, and has even become a textbook in numerous colleges and universities worldwide. And at just over 200 pages, it was surprisingly one of the most difficult books to write, too. As such, I've been very reluctant to tamper with this title, sometimes you just want to leave a good thing alone. It took significant prodding from my publisher, but I have indeed updated this book. For starters, we needed to update content to cover newer versions of popular databases like SQL Server, MySQL, and Oracle. I also wanted to add specific coverage for important new options, most notably SQLite. But, the most important enhancement, and this is what clinched the update for me, is that this new edition is printed in color (as proudly noted on the cover image). Colored titles and headers are pretty cool, but where you really see the value is in long SQL statements that are so much more readable when color-coded. I'm really excited about this update, and want to publicly thank the folks at Pearson for the push and support. More to follow!

Now Available: MariaDB Crash Course

Sun, 18 Sep 2011 08:06:00 -0400

(image) MariaDB is a fork (offshoot) of MySQL, one of the most popular database management systems in the world. MariaDB was created by the creator of MySQL to address some of the limitations and shortcomings in MySQL, and is intended to be a drop in replacement for MySQL as well. At the request of Monty Widenius, creator of MySQL and MariaDB, I ported my best-selling MySQL Crash Course to focus specifically on MariaDB. The new book, MariaDB Crash Course, was just released and is now available for purchase. Note: As already noted, MariaDB is based on MySQL. Indeed, it can be thought of as MySQL plus new features and improvements. In other words, if you have used MySQL then you already know how to use MariaDB. As such, if you have a copy of my MySQL Crash Course or my Sams Teach Yourself SQL In 10 Minutes, then you'll likely NOT want a copy of this new title.

MariaDB Crash Course Available For Pre-Order

Wed, 27 Jul 2011 07:17:00 -0400

(image) At the request of Monty Widenius, creator of MySQL and now MariaDB, I ported my MySQL Crash Course to create a new book entitled MariaDB Crash Course. The book won't be out for a couple of months, but it is now available for pre-order.

Manually Creating The MariaDB Windows Service

Tue, 05 Apr 2011 23:15:00 -0400

I've been doing quite a bit of work with MariaDB, a drop-in replacement for MySQL (forked from the MySQL codebase by Monty Widenius, the creator of MySQL). One issue I ran into is that the current Windows installer does not create the Windows service that you generally would want to use. And because I had to (yet again) dig around today for the solution, I am posting it here for the next time I need it. At a command prompt, go to the bin folder under the MariaDB installation folder, and then run: mysqld --install You should see a message telling you that the service (named MySQL by default) was created.

Sams Teach Yourself Book Tops Lists

Wed, 21 Jul 2010 07:30:00 -0400

(image) A reader just pointed out to me that my my Sams Teach Yourself SQL In 10 Minutes is in's Top 10 lists in the databases, SQL, DBMSs, and databases categories. It's also #1 in the Relational Databases category! Cool! :-)

Sams Teach Yourself SQL OpenOffice Base Database

Wed, 30 Jun 2010 16:02:00 -0400

At the request of a reader, I created an OpenOffice Base version of the example database used in my Sams Teach Yourself SQL in 10 Minutes. The file can be downloaded from the book page. To use this, you'll obviously need OpenOffice. And as it turns out, Base is actually a really nice database to experiment with, as it features a built-in screen that lets you simply enter and execute SQL. So, once you have OpenOffice installed, here's what you need to do:
  • Open the book database with OpenOffice Base
  • Select the Query tab on the left
  • Click the "Create Query in SQL View" task to display the Query Design screen
  • Type your SQL in the window
  • Click the Run Query button (it has an image of a green check mark on top of 2 documents) to execute your SQL, you can also just press F5 to run
  • Your results will be shown above your SQL code (unless you generate an error)
Thank you Roy (no last name provided) for the inspiration.