Sams teach yourself SQL in 10 minutes
Sams Teach Yourself SQL in 10 Minutes has established itself as the gold standard for introductory SQL books, offering a fast-paced accessible tutorial to the major themes and techniques involved in applying the SQL language. Forta¿s examples are clear and his writing style is crisp and concise. As...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, Ind. :
Sams
c2004.
|
| Edición: | 3rd ed |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627085006719 |
Tabla de Contenidos:
- Cover
- Contents
- Introduction
- 1 Understanding SQL
- Database Basics
- What Is SQL?
- Try It Yourself
- Summary
- 2 Retrieving Data
- The SELECT Statement
- Retrieving Individual Columns
- Retrieving Multiple Columns
- Retrieving All Columns
- Summary
- 3 Sorting Retrieved Data
- Sorting Data
- Sorting by Multiple Columns
- Sorting by Column Position
- Specifying Sort Direction
- Summary
- 4 Filtering Data
- Using the WHERE Clause
- The WHERE Clause Operators
- Summary
- 5 Advanced Data Filtering
- Combining WHERE Clauses
- Using the IN Operator
- Using the NOT Operator
- Summary
- 6 Using Wildcard Filtering
- Using the LIKE Operator
- Tips for Using Wildcards
- Summary
- 7 Creating Calculated Fields
- Understanding Calculated Fields
- Concatenating Fields
- Performing Mathematical Calculations
- Summary
- 8 Using Data Manipulation Functions
- Understanding Functions
- Using Functions
- Summary
- 9 Summarizing Data
- Using Aggregate Functions
- Aggregates on Distinct Values
- Combining Aggregate Functions
- Summary
- 10 Grouping Data
- Understanding Data Grouping
- Creating Groups
- Filtering Groups
- Grouping and Sorting
- SELECT Clause Ordering
- Summary
- 11 Working with Subqueries
- Understanding Subqueries
- Filtering by Subquery
- Using Subqueries As Calculated Fields
- Summary
- 12 Joining Tables
- Understanding Joins
- Creating a Join
- Summary
- 13 Creating Advanced Joins
- Using Table Aliases
- Using Different Join Types
- Using Joins with Aggregate Functions
- Using Joins and Join Conditions
- Summary
- 14 Combining Queries
- Understanding Combined Queries
- Creating Combined Queries
- Summary
- 15 Inserting Data
- Understanding Data Insertion
- Copying from One Table to Another
- Summary
- 16 Updating and Deleting Data
- Updating Data
- Deleting Data.
- Guidelines for Updating and Deleting Data
- Summary
- 17 Creating and Manipulating Tables
- Creating Tables
- Updating Tables
- Deleting Tables
- Renaming Tables
- Summary
- 18 Using Views
- Understanding Views
- Creating Views
- Summary
- 19 Working with Stored Procedures
- Understanding Stored Procedures
- Why to Use Stored Procedures
- Executing Stored Procedures
- Creating Stored Procedures
- Summary
- 20 Managing Transaction Processing
- Understanding Transaction Processing
- Controlling Transactions
- Summary
- 21 Using Cursors
- Understanding Cursors
- Working with Cursors
- Summary
- 22 Understanding Advanced SQL Features
- Understanding Constraints
- Understanding Indexes
- Understanding Triggers
- Database Security
- Summary
- A: Sample Table Scripts
- Understanding the Sample Tables
- Obtaining the Sample Tables
- B: Working in Popular Applications
- Using Aqua Data Studio
- Using DB2
- Using Macromedia ColdFusion
- Using Microsoft Access
- Using Microsoft ASP
- Using Microsoft ASP.NET
- Using Microsoft Query
- Using Microsoft SQL Server
- Using MySQL
- Using Oracle
- Using PHP
- Using PostgreSQL
- Using Query Tool
- Using Sybase
- 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
- Index.
