Limit search to available items
Record 20 of 23
Previous Record Next Record
Book Cover
E-book
Author Forta, Ben.

Title Sams teach yourself SQL in 10 minutes / Ben Forta
Edition Second edition
Published Indianapolis, Ind. : Sams, [2001]
©2001
Online access available from:
Safari O'Reilly books online    View Resource Record  

Copies

Description 1 online resource (vii, 258 pages)
Series Teach Yourself Ser
Teach Yourself Ser
Contents Understanding SQL -- Database Basics -- Retrieving Data -- The Select Statement -- Retrieving Individual Columns -- Retrieving Multiple Columns -- Retrieving All Columns -- Sorting Retrieved Data -- Sorting Data -- Sorting by Multiple Columns -- Sorting by Column Position -- Specifying Sort Direction -- Filtering Data -- Using the Where Clause -- The Where Clause Operators -- Advanced Data Filtering -- Combining Where Clauses -- Using the In Operator -- Using the Not Operator -- Using Wildcard Filtering -- Using the Like Operator -- Tips for Using Wildcards -- Creating Calculated Fields -- Understanding Calculated Fields -- Concatenating Fields -- Performing Mathematical Calculations -- Using Data Manipulation Functions -- Understanding Functions -- Using Functions -- Summarizing Data -- Using Aggregate Functions -- Aggregates on Distinct Values -- Combining Aggregate Functions -- Grouping Data -- Understanding Data Grouping -- Creating Groups -- Filtering Groups -- Grouping and Sorting -- Select Clause Ordering -- Working with Subqueries -- Understanding Subqueries -- Filtering by Subquery -- Using Subqueries As Calculated Fields -- Joining Tables -- Understanding Joins -- Creating a Join -- Creating Advanced Joins -- Using Table Aliases -- Join Types -- Using Joins with Aggregate Functions -- Using Joins and Join Conditions -- Combining Queries -- Understanding Combined Queries -- Creating Combined Queries -- Inserting Data -- Understanding Data Insertion -- Copying from One Table to Another -- Updating and Deleting Data -- Updating Data -- Deleting Data -- Guidelines for Updating and Deleting Data -- Creating and Manipulating Tables -- Creating Tables -- Updating Tables -- Deleting Tables -- Renaming Tables -- Using Views -- Understanding Views -- Creating Views -- Working with Stored Procedures -- Understanding Stored Procedures -- Why to Use Stored Procedures -- Executing Stored Procedures -- Creating Stored Procedures -- Managing Transaction Processing -- Understanding Transaction Processing -- Controlling Transactions -- Using Cursors -- Understanding Cursors -- Working with Cursors -- Understanding Advanced SQL Features -- Understanding Constraints -- Understanding Indexes -- Understanding Triggers -- Database Security -- Sample Table Scripts -- Sample Tables Overview -- Creating the Sample Tables -- Populating the Sample Tables -- Working in Popular Applications -- Configuring ODBC Data Sources -- Using Allaire ColdFusion -- Using Allaire JRun 3.x -- Using DB2 -- Using Informix Dynamic Server 7.x -- Using Microsoft Access -- Using Microsoft ASP -- Using Microsoft Query -- Using Microsoft SQL Server 6.x -- Using Microsoft SQL Server 7 -- Using Microsoft SQL Server 2000 -- Using Microsoft Visual Basic -- Using Microsoft Visual C++ -- Using Oracle 8 -- Using Query Tool -- Using Sybase -- SQL Statement Syntax -- Alter Table -- Commit -- Create Index -- Create Procedure -- Create Table -- Create View -- Delete -- Drop -- Insert -- Insert Select -- Rollback -- Select -- Update -- Using SQL Datatypes -- String Datatypes -- Numeric Datatypes -- Date and Time Datatypes -- Binary Datatypes -- SQL Reserved Words
Summary Annotation "Sams Teach Yourself SQL in 10 Minutes, 2E" is a tutorial-based book, organized into a series of easy-to-follow, 10-minute lessons. These well targeted lessons teach you in 10 minutes what some books take several hours or days to teach. Instead of dwelling of database theory and relational design, this book takes a very hands-on approach to solving the needs of the majority of SQL users who simply need to interact with data. The reader of this book will learn how to: Retrieve and sort dataFilter data using comparisons and wildcardsUse the aggregate functions to analyze dataPerform insert, update, and delete operationsJoin relational tables using inner, outer, and self joinsCombine queries using unionsUse viewsCreate and use stored procedures, triggers, and other advanced database features
Notes Includes index
Subject Database management.
SQL (Computer program language)
Form Electronic book
ISBN 0672321289
0768657598 (electronic bk. ; Adobe Reader)
9780672321283
9780768657593 (electronic bk. ; Adobe Reader)
Other Titles Teach yourself SQL in 10 minutes