Search Results - "Alias"

Database systems : introduction to databases and data warehouses / by Jukic, Nenad

Table of Contents: “…Note continued: A Note About Designer-Added Entities (Tables) and Keys for Streamlining Database Content Key Terms Review Questions Exercises ch. 5 SQL Introduction SQL Commands Overview Data Definition Language (DDL) Data Manipulation Language (DML) Data Control Language (DCL) and Transaction Control Language (TCL) SQL Data Types Brief SQL Syntax Notes CREATE TABLE DROP TABLE INSERT INTO SELECT WHERE DISTINCT ORDER BY LIKE Aggregate Functions GROUP BY HAVING Nested Queries IN JOIN Alias Joining Multiple Relations ALTER TABLE UPDATE DELETE CREATE VIEW and DROP VIEW Set Operators: UNION, INTERSECT, EXCEPT (MINUS) Additional SQL Examples with Additional SQL Commands CREATE TABLE (Additional Example) INSERT INTO (Additional Example) Constraint Management SELECT (Additional Examples) JOIN of a Relation with Itself (Self-JOIN) OUTER JOIN. …”