Contents
Access Your Free Digital Assets
Overview
Sample Database
Introduction
What Is SQL?
Syntax & Structure
| 1 | Retrieving Data with SQL
The SELECT Statement
The FROM Clause
Limiting Data by Specifying Columns
SQL Predicates
Returning DISTINCT rows
TOP
The WHERE Clause
Table. 1 : List of conditional operators
Comparison Operators
Logical Operators
fg. 11 : List of suppliers coming from the country of Brazil or the city of Tokyo
Dealing With Ranges & Wildcards
Operator Precedence
The ORDER BY Clause
fg. 16 : List of companies ordered by multiple columns
Using Aliases with the AS Clause
Selecting Records from Multiple Tables
Including Excluded Data with OUTER JOIN
fg. 25 : Products results from a RIGHT OUTER JOIN example
NULL Values
Table 3 : SQL built-in functions
COUNT
| 2 | Built-In Functions & Calculations
SUM
Other Functions
Grouping Data with the GROUP BY Clause
Limiting Group Results with HAVING
| 3 | Entering & Modifying Data
INSERT Information INTO the Database
Updating Data
Deleting Data from Tables
| 4 | Defining Databases
Creating/Deleting a Database
Data Types
Table. 4 : Fundamental data types
Characters
Numerical Data
Date & Time
Defining Tables
Conclusion
Glossary
About Clydebank