数据库系统概念教材ch3 SQL.ppt

Chapter 3: SQL;Chapter 3: SQL;History;Data Definition Language;Domain Types in SQL;Drop and Alter Table Constructs;Basic Query Structure ;The select Clause;The select Clause (Cont.);The select Clause (Cont.);The where Clause;The where Clause (Cont.);The from Clause;The Rename Operation;Tuple Variables;String Operations;Ordering the Display of Tuples;Duplicates;Duplicates (Cont.);Set Operations;Set Operations;Aggregate Functions;Aggregate Functions (Cont.);Aggregate Functions – Group By;Aggregate Functions – Having Clause;Null Values;Null Values and Three Valued Logic;Null Values and Aggregates;Nested Subqueries;Example Query;Example Query;Set Comparison;Definition of Some Clause;Example Query;Definition of all Clause;Test for Empty Relations;Example Query;Test for Absence of Duplicate Tuples;Example Query;Derived Relations;With Clause;Complex Queries using With Clause;Views;View Definition;Example Queries;Views Defined Using Other Views;View Expansion;Modification of the Database – Deletion;Example Query;Modification of the Database – Insertion;Modification of the Database – Insertion;Modification of the Database – Updates;Case Statement for Conditional Updates;Update of a View;Updates Through Views (Cont.);Joined Relations**;Joined Relations – Datasets for Examples;Joined Relations – Examples ;Joined Relations – Examples;Joined Relations – Examples;End of Chapter 3;Figure 3.1: Database Schema;Figure 3.3: Tuples inserted into loan and borrower;Figure 3.4:The loan and borrower relations