Language of SQL, The,2nd edition

• Larry Rockoff
Products list
• Available for purchase from all major ebook resellers, including InformIT.com
Products list

Details

• A print text
• Free shipping
• Also available for purchase as an ebook from all major ebook resellers, including InformIT.com
A quick, clearly written introduction to the use of SQL to store and retrieve information
The Language of SQL, 2nd Edition

Introduction
Â  Â Topics and Features
Â  Â Whatâ€™s New in the Second Edition
Â  Â Plan of the Book
Â  Â Companion Website

1. Relational Databases and SQL
Â  Â What Is SQL?
Â  Â Microsoft SQL Server, MySQL, and Oracle
Â  Â Relational Databases
Â  Â Primary and Foreign KeysÂ
Â  Â Datatypes
Â  Â NULL Values
Â  Â The Significance of SQL

2. Basic Data Retrieval
Â  Â A Simple SELECT
Â  Â Syntax Notes
Â  Â Specifying ColumnsÂ
Â  Â Column Names with Embedded Spaces
Â  Â Preview of the Full SELECT

3. Calculated Fields and Aliases
Â  Â Literal Values
Â  Â Arithmetic Calculations
Â  Â Concatenating Fields
Â  Â Column Aliases
Â  Â Table Aliases

4. Using Functions
Â  Â What Is a Function?
Â  Â Character Functions
Â  Â Composite Functions
Â  Â Date/Time Functions
Â  Â Numeric Functions
Â  Â Conversion Functions

5. Sorting Data
Â  Â Sorting in Ascending Order
Â  Â Sorting in Descending Order
Â  Â Sorting by Multiple Columns
Â  Â Sorting by a Calculated Field
Â  Â Sort Sequences

6. Selection Criteria
Â  Â Applying Selection Criteria
Â  Â WHERE Clause Operators
Â  Â Limiting Rows
Â  Â Limiting Rows with a Sort
Â  Â Pattern Matching
Â  Â Wildcards

7. Boolean Logic
Â  Â Complex Logical Conditions
Â  Â The AND Operator
Â  Â The OR Operator
Â  Â Using Parentheses
Â  Â Multiple Sets of Parentheses
Â  Â The NOT Operator
Â  Â The BETWEEN Operator
Â  Â The IN Operator
Â  Â Boolean Logic and NULL Values

8. Conditional Logic
Â  Â The CASE Expression
Â  Â The Simple CASE Format
Â  Â The Searched CASE Format
Â  Â Conditional Logic in ORDER BY Clauses
Â  Â Conditional Logic in WHERE Clauses

9. Summarizing Data
Â  Â Eliminating Duplicates
Â  Â Aggregate Functions
Â  Â The COUNT Function
Â  Â Grouping Data
Â  Â Multiple Columns and Sorting
Â  Â Selection Criteria on Aggregates
Â  Â Conditional Logic in GROUP BY Clauses
Â  Â Conditional Logic in HAVING Clauses
Â  Â Ranking Functions
Â  Â Partitions

10. Subtotals and Crosstabs
Â  Â  Adding Subtotals with ROLLUP
Â  Â  Adding Subtotals with CUBE
Â  Â  Creating Crosstab Layouts

11. Inner Joins
Â  Â  Joining Two Tables
Â  Â  The Inner Join
Â  Â  Table Order in Inner Joins
Â  Â  An Alternate Specification of Inner Joins
Â  Â  Table Aliases Revisited

12. Outer Joins
Â  Â  The Outer Join
Â  Â  Left Joins
Â  Â  Testing for NULL Values
Â  Â  Right Joins
Â  Â  Table Order in Outer Joins
Â  Â  Full Joins
Â  Â  Cross Joins

13. Self Joins and Views
Â  Â  Self Joins
Â  Â  Creating Views
Â  Â  Referencing Views
Â  Â  Benefits of Views
Â  Â  Modifying and Deleting Views

14. Subqueries
Â  Â  Types of Subqueries
Â  Â  Using a Subquery as a Data Source
Â  Â  Using a Subquery in Selection Criteria
Â  Â  Correlated Subqueries
Â  Â  The EXISTS Operator
Â  Â  Using a Subquery as a Calculated Column
Â  Â  Common Table Expressions

15. Set Logic
Â  Â  Using the UNION Operator
Â  Â  Distinct and Non-Distinct Unions
Â  Â  Intersecting Queries

16. Stored Procedures and Parameters
Â  Â  Creating Stored Procedures
Â  Â  Parameters in Stored Procedures
Â  Â  Executing Stored Procedures
Â  Â  Modifying and Deleting Stored Procedures
Â  Â  Functions Revisited

17. Modifying Data
Â  Â  Modification Strategies
Â  Â  Inserting Data
Â  Â  Deleting Data
Â  Â  Updating Data

18. Maintaining Tables
Â  Â  Data Definition Language
Â  Â  Table Attributes
Â  Â  Table Columns
Â  Â  Primary Keys and Indexes
Â  Â  Foreign Keys
Â  Â  Creating Tables
Â  Â  Creating Indexes

19. Principles of Database Design
Â  Â  Goals of Normalization
Â  Â  How to Normalize Data
Â  Â  The Art of Database Design
Â  Â  Alternatives to Normalization

20. Strategies for Displaying Data
Â  Â  Crosstab Layouts Revisited
Â  Â  Excel and External Data
Â  Â  Excel Pivot Tables

A. Getting Started with Microsoft SQL Server
Â  Â Installing SQL Server 2016 Express
Â  Â Installing SQL Server 2016 Management Studio Express
Â  Â Using SQL Server 2016 Management Studio Express

B. Getting Started with MySQL
Â  Â Installing MySQL on Windows
Â  Â Installing MySQL on Mac
Â  Â Using MySQL Workbench

C. Getting Started with Oracle
Â  Â Installing Oracle Database Express Edition
Â  Â Using Oracle Database Express EditionÂ

Need help? Get in touch