SQL in 10 Minutes, Sams Teach Yourself
10%
off

SQL in 10 Minutes, Sams Teach Yourself

4.01 (689 ratings by Goodreads)
By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 1 business day
When will my order arrive?

Description

Sams Teach Yourself SQL in 10 Minutes, Fourth Edition

New full-color code examples help you see how SQL statements are structured





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 22 short, quick lessons that will each take only 10 minutes or less to complete.





With the Fourth Edition of this worldwide bestseller, the book has been thoroughly updated, expanded, and improved. Lessons now cover the latest versions of IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite, MariaDB, and Apache Open Office Base. And new full-color SQL code listings help the beginner clearly see the elements and structure of the language.

10 minutes is all you need to learn how to...








Use the major SQL statements
Construct complex SQL statements using multiple clauses and operators
Retrieve, sort, and format database contents
Pinpoint the data you need using a variety of filtering techniques
Use aggregate functions to summarize data
Join two or more related tables
Insert, update, and delete data
Create and alter database tables
Work with views, stored procedures, and more

Table of Contents

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
show more

Product details

  • Paperback | 288 pages
  • 137.16 x 208.28 x 12.7mm | 362.87g
  • Sams Publishing
  • Indianapolis, United States
  • English
  • 4th edition
  • w. ill.
  • 0672336073
  • 9780672336072
  • 14,899

Table of contents

Sams Teach Yourself SQL in 10 Minutes, Fourth Edition

1 Understanding SQL
Database Basics


What Is SQL?


Try It Yourself


2 Retrieving Data


The SELECT Statement


Retrieving Individual Columns


Retrieving Multiple Columns


Retrieving All Columns


Retrieving Distinct Rows


Limiting Results


Using Comments


3 Sorting Retrieved Data


Sorting Data


Sorting by Multiple Columns


Sorting by Column Position


Specifying Sort Direction


4 Filtering Data


Using the WHERE Clause


The WHERE Clause Operators


5 Advanced Data Filtering


Combining WHERE Clauses


Using the IN Operator


Using the NOT Operator


6 Using Wildcard Filtering


Using the LIKE Operator


Tips for Using Wildcards


7 Creating Calculated Fields


Understanding Calculated Fields


Concatenating Fields


Performing Mathematical Calculations


8 Using Data Manipulation Functions


Understanding Functions


Using Functions


9 Summarizing Data


Using Aggregate Functions


Aggregates on Distinct Values


Combining Aggregate Functions


10 Grouping Data


Understanding Data Grouping


Creating Groups


Filtering Groups


Grouping and Sorting


SELECT Clause Ordering


11 Working with Subqueries


Understanding Subqueries


Filtering by Subquery


Using Subqueries as Calculated Fields


12 Joining Tables


Understanding Joins


Creating a Join


13 Creating Advanced Joins


Using Table Aliases


Using Different Join Types


Using Joins with Aggregate Functions


Using Joins and Join Conditions


14 Combining Queries


Understanding Combined Queries


Creating Combined Queries


15 Inserting Data


Understanding Data Insertion


Copying from One Table to Another


16 Updating and Deleting Data


Updating Data


Deleting Data


Guidelines for Updating and Deleting Data


17 Creating and Manipulating Tables


Creating Tables


Updating Tables


Deleting Tables


Renaming Tables


18 Using Views


Understanding Views


Creating Views


19 Working with Stored Procedures


Understanding Stored Procedures


Why to Use Stored Procedures


Executing Stored Procedures


Creating Stored Procedures


20 Managing Transaction Processing


Understanding Transaction Processing


Controlling Transactions


21 Using Cursors


Understanding Cursors


Working with Cursors


22 Understanding Advanced SQL Features


Understanding Constraints


Understanding Indexes


Understanding Triggers


Database Security


A Sample Table Scripts


Understanding the Sample Tables


Obtaining the Sample Tables


B Working in Popular Applications


Using Apache Open Office Base


Using Adobe ColdFusion


Using IBM DB2


Using MariaDB


Using Microsoft Access


Using Microsoft ASP


Using Microsoft ASP.NET


Using Microsoft Query


Using Microsoft SQL Server (including Microsoft SQL Server Express)


Using MySQL


Using Oracle


Using Oracle Express


Using PHP


Using PostgreSQL


Using SQLite


Configuring ODBC Data Sources


C SQL Statement Syntax


ALTER TABLE


COMMIT


CREATE INDEX


CREATE PROCEDURE


CREATE TABLE


CREATE VIEW


DELETE


DROP


INSERT


INSERT SELECT


ROLLBACK


SELECT


UPDATE


D Using SQL Datatypes


String Datatypes


Numeric Datatypes


Date and Time Datatypes


Binary Datatypes


E SQL Reserved Words
show more

About Ben Forta

Ben Forta is Adobe Systems' Director of Developer Relations and has more than 20 years 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, spinoff titles on MySQL and SQL Server T-SQL, ColdFusion Web Application Construction Kit and Advanced ColdFusion Application Development (both published by Adobe Press), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on Flash, Java, Windows, and other subjects. 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 Internet and database technologies.
show more

Rating details

689 ratings
4.01 out of 5 stars
5 36% (248)
4 38% (265)
3 18% (127)
2 5% (33)
1 2% (16)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X