pic_cooming_soonSQL Language

  1. An Introduction to SQL
  2. An Overview of the SELECT Statement
  3. The FROM Clause
  4. The WHERE Clause
  5. The GROUP BY Clause
  6. The HAVING Clause
  7. The SELECT Clause
  8. The ORDER BY Clause
  9. SQL Data Types
  10. Relational Integrity
  11. Special Structures

An Introduction to SQL

SQL Statement Overview

Keyword, Identifiers, and Constants
Clauses
Syntax

Data Definition Language

CREATE, ALTER, and DROP

Starting Over

Data Manipulation Language

INSERT, UPDATE and DELETE
The SELECT Statement

Standard SQL

Read The Fine Manual

An Introduction to SQL

An Overview of the SELECT Statement

The SELECT Statement

The SELECT and FROM Clauses

Content Management System

The WHERE Clause

The GROUP BY and HAVING Clauses

The ORDER BY Clause

The FROM Clause

Why Start with the FROM Clause?

Parsing an SQL Statement

FROM One Table

FROM More than One Table Using JOINs

Types of Join
The Inner Join
Outer Joins
The Cross Join

Real World Joins

Inner Join: Categories and Entries
Left Outer Join: Categories and Entries
Right Outer Join: Categories and Entries
Full Outer Join: Categories and Entries

Views

Views in Web Development
Sub-queries and Derived Tables
The FROM Clause

The WHERE Clause

Conditions

Conditions that are True
Where “Not True” is Preferable

Shopping Carts

Conditions that Evaluate as UNKNOWN

Operators

Comparison Operators
The LIKE Operator
The BETWEEN Operator

Compound Condition with AND and OR

Truth Tables
Combining AND and OR

IN Condition

IN with Sub-Queries

Correlated Sub-Queries

EXISTS Conditions

NOT IN or NOT EXISTS?

WHERE Clause Performance

Indexes

The WHERE Clause

The GROUP BY Clause

Grouping is More than Seqencing

Out of Many, One

Drill-down SQL
GROUP BY in Context

How GROUP BY Works

Group Rows

Rules for GROUP BY

Columns with Certain Large Data Types

The HAVING Clause

HAVING Filters Group Rows

HAVING without a GROUP BY Clause

The Having Clause

The SELECT Clause

SELECT in the Sequence of Execution

Which Columns  Can Be Selected?

Detail Rows
Group Rows

Functions

Aggregate Functions
Scalar Functions

Operators

Numeric Operators
The Concatenation Operator
Temporal Operators

The Dreaded, Evil Select Star

SELECT DISTINCT

The SELECT Clause

The ORDER BY Clause

ORDER BY Syntax

How ORDER BY Works

ASC and DESC
ORDER BY Clause Performance
The Sequence of Values

The Scope of ORDER BY

Using ORDER BY with GROUP BY
ORDER BY Expressions
Special Sequencing

ORDER BY with UNION BY Clause

SQL Data Types

An Overview of Data Types

Numeric Data Types

Integers
Decimals
Floating-Point Numbers
Conversions in Numeric Calculations
Numeric Functions

Character Data Types

CHAR
VARCHAR
Numeric or Character?
NCHAR and NVARCHAR
CLOB and BLOB
String Functions

Temporal Data Types

DATE
TIME
TIMESTAMP
Intervals
Date Functions

Column Constraints

NULL or NOT NULL
DEFAULT
CHECK Constraints

SQL Data Types

Relational Integrity

Identity

Data Modelling

Entities and Attributes
Entities and Relationships

Primary Keys

UNIQUE Constrains

Foreign Keys

How Foreign Keys Work
Using Foreign Keys

Natural versus Surrogate Keys

Autonumbers

Relational Integrity

Special Structures

Joining to a Table Twice
Joining a Table to Itself
Implementing a Many-to.many Relationship: Keywords
Special Structures

 

Online Lectures:
Further Reading:

1. Stephens, Jones and Plew: SQL in 24 Hours, Sams Teach Yourself Paperback – 13 Dec 2015

sql_24

In just 24 lessons of one hour or less, Sams Teach Yourself SQL in 24 Hours, Sixth Edition, helps you use SQL to build effective databases, efficiently retrieve data, and manage everything from performance to security.

This book’s straightforward, step-by-step approach shows you how to work with database structures, objects, queries, tables, and more. In just hours, you will be applying advanced techniques, including views, transactions, web connections, and powerful Oracle and SQL Server extensions. Every lesson builds on what you’ve already learned, giving you a rock-solid foundation for real-world success.

Step-by-step instructions carefully walk you through the most common SQL tasks.
Practical, hands-on examples show you how to apply what you learn.
Quizzes and exercises help you test your knowledge and stretch your skills.
Notes and tips point out shortcuts and solutions.

Learn how to…
• Define efficient database structures and objects
• “Normalize” raw databases into logically organized tables
• Edit relational data and tables with DML
• Manage transactions
• Write effective, well-performing queries
• Categorize, summarize, sort, group, and restructure data
• Work with dates and times
• Join tables in queries, use subqueries, and combine multiple queries
• Master powerful query optimization techniques
• Administer databases and manage users
• Secure databases and protect data
• Use views, synonyms, and the system catalog
• Extend SQL to the enterprise and Internet
• Master important Oracle and Microsoft extensions to ANSI SQL

Register your product at informit.com/register for convenient access to downloads, updates, and corrections as they become available.

  • Paperback: 464 pages
  • Publisher: Sams; 6 edition (13 Dec. 2015)
  • Language: English
  • ISBN-10: 0672337592
  • ISBN-13: 978-0672337598
  • Product Dimensions: 17.5 x 3 x 22.9 cm

Buy at Amazon.co.uk