Publisher: Sams – November 4, 2012
This book was born out of necessity. I had been teaching and writing on SQL for a long time, but whenever I was asked to recommend a good book on SQL I found myself somewhat stuck. There are good SQL books out there, but most of them are oriented towards database administrators or developers working within a highly database and SQL-centric world. And as such, most of them are overkill – they tend to provide too much information instead of just what most of us need to know.
This book has a specific audience in mind and was designed to be very different from other offerings out there. Instead of being geared towards DBA’s, this book is designed for real-world developers who write in Visual Basic, C/C++ and Objective C, ColdFusion, ASP, .NET. Java, JSP, Perl, PHP, Python, Ruby, and any other language. Instead of being designed for folks who’s occupation is data manipulation, this book is oriented towards users of other client applications, Word users who need to mail-merge against a back end database, report writer users needing to extract information from corporate data stores, and anyone who needs to manipulate and interact with databases, but for whom database manipulation is not a full-time job.
It does not start with database fundamentals, normalization, relational database design, referential integrity, and security infrastructures. Yes, these issues are covered, but that is not the emphasis or the positioning, Rather, the book starts with the SQL SELECT statement, and then adds filtering, sorting, and so on. Table creation, working with different datatypes, implementing constraints, using stored procedures and triggers, and more are all introduced clearly and methodically in small bite size chucks. The emphasis on getting stuff done, and getting it done quickly helping you be productive as quickly as possible in whatever tool or environment you use.
This is the one of the best selling SQL books ever, and is used by individuals, organizations, and as courseware by academic institutions the world over, including: Auburn University (Auburn, AL), Baylor University (Waco, TX), Boise State University (Boise, ID), Brown University (Providence, RI), Central Connecticut State University (New Britain, CT), Columbia College (Chicago, IL), Duke University (Durham, NC), Florida Gulf Coast University (Fort Myers, FL), Florida International University (Miami, FL), Fort Lewis College (Durango, CO), George Fox University (Newberg, OR), Harper College (Palatine, IL), Harvard University (Cambridge, MA), Johns Hopkins University (Baltimore, MD), Louisiana Tech University (Ruston, LA), Manatee Community College (Bradenton, FL), Massachusetts Institute of Technology (Cambridge, MA), Mercy College (New York, NY), Miami University (Oxford, OH), Milwaukee School of Engineering (Milwaukee, WI), Montgomery College (Montgomery County, MD), Morgan State University (Baltimore, MD), North Dakota University System (Bismarck, ND), Open University (UK), Oregon Health & Science University (Portland, OR), Palm Beach Atlantic University (West Palm Beach, FL), Penn State University (University Park, PA), Purdue University (West Lafayette, IN), Portland State University (Portland, OR), Sam Houston State University (Huntsville, TX), Salve Regina University (Newport, RI), St. Mary’s University (San Antonio, TX), Texas A&M University (College Station, TX), The College of William & Mary (Williamsburg, VA), UCLA (Los Angeles, CA), UC Long Beach (Long Beach, CA), UC Santa Barbara (Santa Barbara, CA), University of Baltimore (Baltimore, MD), University of Connecticut (Storrs, CT), University of Denver (Denver, CO), University of Illinois at Urbana-Champaign (Champaign, IL), University of Massachusetts Boston (Boston, MA), University of Michigan (Ann Arbor, MI), University of New Hampshire (Durham, NH), University of Northern Iowa (Cedar Falls, IA), University of Tennessee Knoxville (Knoxville, TN), University of Wisconsin (Madison, WI), University of Washington (Seattle, WA), USC (Los Angeles, CA), Utah Valley University (Orem, UT), Vanderbilt University (Nashville, TN), Virginia Commonwealth University (Richmond, VA), Wayne State University (Detroit, MI), Western Washington University (Bellingham, WA), and many more.
This fourth edition provides additional examples and tips, adds coverage of several advanced topics, and content specific to Apache Open Office Base, IBM DB2, Microsoft Access, Microsoft SQL Server (including SQL Server Express), MariaDB, MySQL, Oracle (including Oracle Express), SQLite, and PostgreSQL.
In addition, this fourth edition is printed in color and features color coding in all example source code.
I hope you find that these objectives have been met, and I welcome your feedback. Enjoy.
- 1: Understanding SQL
- 2: Retrieving Data
- 3: Sorting Retrieved Data
- 4: Filtering Data
- 5: Advanced Data Filtering
- 6: Using Wildcard Filtering
- 7: Creating Calculated Fields
- 8: Using Data Manipulation Functions
- 9: Summarizing Data
- 10: Grouping Data
- 11: Working with Subqueries
- 12: Joining Tables
- 13: Creating Advanced Joins
- 14: Combining Queries
- 15: Inserting Data
- 16: Updating and Deleting Data
- 17: Creating and Manipulating Tables
- 18: Using Views
- 19: Working with Stored Procedures
- 20: Managing Transaction Processing
- 21: Using Cursors
- 22: Understanding Advanced SQL Features
- Appendix A: Sample Table Scripts
- Appendix B: Working in Popular Applications
- Appendix C: SQL Statement Syntax
- Appendix D: Using SQL Datatypes
- Appendix E: SQL Reserved Words
- China (Chinese): Published by Posts and Telecom Press
- Korea (Korean): Published by Insight Publishing
Appendix A: Sample Table Scripts
Appendix A describes the database tables used in the examples in this book. You may download database tables or creation scripts here:
- Apache Open Office Base database
- Microsoft Access 2000, 2003 database
- Microsoft Access 2007, 2010, 2013 database
- IBM DB2 SQL scripts
- Microsoft SQL Server (and SQL Server Express) SQL scripts
- MySQL (and MariaDB) SQL scripts
- Oracle SQL scripts
- Oracle Express SQL scripts
- PostgreSQL SQL scripts
- SAS scripts (tested with SAS 9.2) created by Peter Lumb
- SQLite database
Other Editions Of This Title
- Sams Teach Yourself SQL in 10 Minutes (Published September 1, 1999 by Sams)
- Sams Teach Yourself SQL in 10 Minutes (Second Edition) (Published May 1, 2001 by Sams)
- Sams Teach Yourself SQL in 10 Minutes (Third Edition) (Published April 1, 2004 by Sams)