SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Mani

Description

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