Learning SQL / Alan Beaulieu.

Format:

Book

Author/Creator:

Beaulieu, Alan.

Language:

English

Subjects (All):

Query languages (Computer science).

SQL (Computer program language).

Physical Description:

1 online resource (312 p.)

Edition:

First edition.

Place of Publication:

Sebastopol, California : O'Reilly Media, 2005.

Language Note:

English

System Details:

text file

Summary:

SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. If you're working with a relational database--whether you're writing applications, performing administrative tasks, or generating reports--you need to know how to interact with your data. Even if you are using a tool that generates SQL for you, such as a reporting tool, there may still be cases where you need to bypass the automatic generation feature and write your own SQL statements. To help you attain this fundamental SQL know

Contents:

Learning SQL; Why Use This Book to Do It?; Structure of This Book; Conventions Used in This Book; How to Contact Us; Using Code Examples; Safari Enabled; Acknowledgments; 1. A Little Background; 1.1.2. The Relational Model; 1.1.3. Some Terminology; 1.2. What Is SQL?; 1.2.2. SQL: A Nonprocedural Language; 1.2.3. SQL Examples; 1.3. What Is MySQL?; 1.4. What&s in Store; 2. Creating and Populating a Database; 2.2. Using the mysql Command-Line Tool; 2.3. MySQL Data Types; 2.3.1.2. Text data; 2.3.2. Numeric Data; 2.3.3. Temporal Data; 2.4. Table Creation; 2.4.2. Step 2: Refinement

2.4.3. Step 3: Building SQL Schema Statements2.5. Populating and Modifying Tables; 2.5.1.2. The insert statement; 2.5.2. Updating Data; 2.5.3. Deleting Data; 2.6. When Good Statements Go Bad; 2.6.2. Nonexistent Foreign Key; 2.6.3. Column Value Violations; 2.6.4. Invalid Date Conversions; 2.7. The Bank Schema; 3. Query Primer; 3.2. Query Clauses; 3.3. The select Clause; 3.3.2. Removing Duplicates; 3.4. The from Clause; 3.4.1.2. Views; 3.4.2. Table Links; 3.4.3. Defining Table Aliases; 3.5. The where Clause; 3.6. The group by and having Clauses; 3.7. The order by Clause

3.7.2. Sorting via Expressions3.7.3. Sorting via Numeric Placeholders; 3.8. Exercises; 3.8.2. 3-2; 3.8.3. 3-3; 3.8.4. 3-4; 4. Filtering; 4.1.2. Using the not Operator; 4.2. Building a Condition; 4.3. Condition Types; 4.3.1.2. Data modification using equality conditions; 4.3.2. Range Conditions; 4.3.2.2. String ranges; 4.3.3. Membership Conditions; 4.3.3.2. Using not in; 4.3.4. Matching Conditions; 4.3.4.2. Using regular expressions; 4.4. NULL: That Four-Letter Word; 4.5. Exercises; 4.5.2. 4-2; 4.5.3. 4-3; 4.5.4. 4-4; 5. Querying Multiple Tables; 5.1.2. Inner Joins; 5.1.3. The ANSI Join Syntax

5.2. Joining Three or More Tables5.2.2. Using the Same Table Twice; 5.3. Self-Joins; 5.4. Equi-Joins Versus Non-Equi-Joins; 5.5. Join Conditions Versus Filter Conditions; 5.6. Exercises; 5.6.2. 5-2; 5.6.3. 5-3; 6. Working with Sets; 6.2. Set Theory in Practice; 6.3. Set Operators; 6.3.2. The intersect Operator; 6.3.3. The except Operator; 6.4. Set Operation Rules; 6.4.2. Set Operation Precedence; 6.5. Exercises; 6.5.2. 6-2; 6.5.3. 6-3; 7. Data Generation, Conversion, and Manipulation; 7.1.1.2. Including special characters; 7.1.2. String Manipulation

7.1.2.2. String functions that return strings7.2. Working with Numeric Data; 7.2.2. Controlling Number Precision; 7.2.3. Handling Signed Data; 7.3. Working with Temporal Data; 7.3.2. Temporal Data Generation; 7.3.2.2. String-to-date conversions; 7.3.2.3. Functions for generating dates; 7.3.3. Temporal Data Manipulation; 7.3.3.2. Temporal functions that return strings; 7.3.3.3. Temporal functions that return numbers; 7.4. Conversion Functions; 7.5. Exercises; 7.5.2. 7-2; 7.5.3. 7-3; 8. Grouping and Aggregates; 8.2. Aggregate Functions; 8.2.2. Counting Distinct Values; 8.2.3. Using Expressions

8.2.4. How Nulls Are Handled

Notes:

"A pain-free introduction to SQL for database developers & administrators."--Cover.

Includes bibliographical references (pages 267-277) and index.

Description based on print version record.

ISBN:

9781306816618

1306816610

9780596522360

0596522363

9780596552923

0596552920

OCLC:

609841025