Overview

Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job. Expert trainer and popular author Ben Forta teaches you just the parts of SQL you need to know–starting with simple data retrieval and quickly going on to more complex topics including the use of joins, subqueries, stored procedures, cursors, triggers, and table constraints. You'll learn methodically, systematically, and simply–in short, quick lessons that will each take only 10 minutes or less to complete.

Full Product Details

Author:   Ben Forta
Publisher:   Pearson Education (US)
Imprint:   Addison Wesley
Edition:   5th edition
Dimensions:   Width: 15.40cm , Height: 1.20cm , Length: 22.80cm
Weight:   0.408kg
ISBN:  

9780135182796

ISBN 10:   0135182794
Pages:   256
Publication Date:   18 August 2020
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   In Print  
This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us.

Table of Contents

Introduction 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. SQL Datatypes Appendix E. SQL Reserved Words

Reviews

Author Information

Ben Forta is Adobe’s Senior Director of Education Initiatives and has three decades of experience in the computer industry in product development, support, training, and product marketing. He is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes (including spinoff titles on MariaDB, MySQL, SQL Server T-SQL, and Oracle PL/SQL), Learning Regular Expressions, as well as books on Java, Windows, and more. He has extensive experience in database design and development, has implemented databases for several highly successful commercial software programs and websites, and is a frequent lecturer and columnist on application development and Internet technologies. Ben lives in Oak Park, Michigan, with his wife, Marcy, and their children. He welcomes your email at ben@forta.com and invites you to visit his website at http://forta.com.     

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions