Web Skills Work

{ beta }

CHAPTERS

• 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. Using Transaction Processing
• 21. Using Cursors
• 22. Understanding Advanced SQL Features
• Appendix A - The Example Tables
• Appendix B - Working in Popular Applications
• Appendix C - SQL Statement Syntax
• Appendix D - SQL Datatypes
• Appendix E - SQL Reserved Words

OVERVIEW

This book is designed for real-world developers who write in Visual Basic, C/C++, ColdFusion, ASP, .NET. Java, JSP, Perl, PHP, and any other language.

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.

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.

RELATED FILES

Visit Website

Access online version of book

Download sample tables (MySQL)

Access online forum

Publisher: Sams Publishing

Author: Ben Forta

Year: 2004