UID:
almahu_9947366321302882
Format:
1 online resource (273 p.)
Edition:
1st ed.
ISBN:
1-281-02000-1
,
9786611020002
,
1-4237-4347-4
,
0-08-048974-5
Series Statement:
The Morgan Kaufmann practical guides series
Content:
Would the basics of SQL querying be useful to you, but you don't want to start at the very beginning? Do you wish you had an easy way to ramp up quickly to get a basic understanding of key features and capability? Then you need this book! Without a ton of conceptual information or general programming basics you already know, this book is a quick guide for computing professionals and programmers to learn the basics--and more--in an easily digestible way.+ Provides tutorial-based instruction for the main features of SQL for programmers and other technical professionals in need of a brief
Note:
Includes index.
,
Front Cover; SQL: Practical Guide for Developers; Copyright Page; Contents; Chapter 1. Databasics; 1.1 Tables; 1.2 Data Types; 1.3 NULL; 1.4 Primary Key; 1.5 Table Relationships; 1.6 Restaurant Database; 1.7 Wrap Up; Chapter 2. Retrieval: Basic SELECTion; 2.2 Selecting Rows; 2.3 Standard Comparison Operators; 2.4 String Comparisons; 2.5 Matching String Patterns with LIKE; 2.6 Getting What We Haven't Got with NOT; 2.7 Combining Conditions with AND and OR; 2.8 Selecting a Range of Values with BETWEEN; 2.9 Selecting a Set of Values Using IN; 2.10 IS NULL: Exploring the Unknown
,
2.11 ANDs, ORs, NOTs with NULLs: Three-Valued Logic2.12 Three-Valued Logic and the IN Operator; 2.13 How WHERE Determines What's In and Out; 2.14 Wrap Up; Chapter 3. Reshaping Results; 3.1 AS: Naming Result Table Columns; 3.2 DISTINCT and ALL: Dealing with Duplicates; 3.3 Derived Attributes; 3.4 Computation in the WHERE Clause; 3.5 ORDER BY: Ordering Result Table Traversal; 3.6 CAST: Data Type Conversion; 3.7 CASE, COALESCE, and NULLIF: Conditional Expressions; 3.8 Wrap Up; Chapter 4. Aggregating Results; 4.1 Aggregation Functions; 4.2 Removing Rows before Aggregation with WHERE
,
4.3 Removing Repeating Data with DISTINCT before Aggregation4.4 Mixing Attributes, Aggregates, and Literals; 4.5 Group Aggregation Using GROUP BY; 4.6 Removing Rows before Grouping with WHERE; 4.7 Sorting Groups with ORDER BY; 4.8 Removing Groups with HAVING; 4.9 Aggregates over Expressions; 4.10 Wrap Up; Chapter 5. Joins; 5.1 Two Table Joins with WHERE; 5.2 Table Aliases; 5.3 Joins Needing More Than Two Tables; 5.4 Self-Join: Joining a Table with Itself; 5.5 Example Joins; 5.6 How Does a Join Really Work?; 5.7 Theta Joins: Generalizing Join Predicates; 5.8 JOIN Operator; 5.9 Join Strategies
,
5.10 Wrap UpChapter 6. Set Queries: UNION, INTERSECT, and EXCEPT; 6.1 UNION; 6.2 INTERSECT; 6.3 EXCEPT; 6.4 Wrap Up; Chapter 7. Subqueries; 7.1 What Are Subqueries?; 7.2 Multilevel Subquery Nesting; 7.3 Subqueries Using NOT IN; 7.4 Subqueries with Empty Results; 7.5 Combining JOIN and Subqueries; 7.6 Standard Comparison Operators with Lists Using ANY, SOME, or ALL; 7.7 Correlated Subqueries; 7.8 EXISTS; 7.9 Derived Relations-Subqueries in the FROM Clause; 7.10 Subqueries in the HAVING Clause; 7.11 Subset Queries; 7.12 Subqueries in the SELECT Clause; 7.13 Wrap Up; Chapter 8. Modifying Data
,
8.1 INSERT: Adding New Rows8.2 DELETE: Removing Rows; 8.3 UPDATE: Changing Row Values; 8.4 Testing Your DELETE and UPDATE WHERE Conditions; 8.5 Living within Constraints; 8.6 Wrap Up; Chapter 9. Creating, Deleting, and Altering Tables; 9.1 Creating Simple Tables; 9.2 DEFAULT Values; 9.3 Constraints; 9.4 Creating a Table from Tables; 9.5 CREATE DOMAIN; 9.6 Referential Actions: The Autopilot of Foreign Key Maintenance; 9.7 Indexes; 9.8 DROP TABLE; 9.9 ALTER TABLE; 9.10 Generated Values; 9.11 Sequences; 9.12 Global and Local Temporary Tables; 9.13 Creating a Database; 9.14 Wrap Up
,
Chapter 10. Views
,
English
Additional Edition:
ISBN 0-12-220531-6
Language:
English
