03SQL-new选读.pptx

Principles of Database Systems （双语教学课程）; Chapter 3 SQL(Structured Query Language ) 结构化查询语言;Outline;1 Background -History;Background;Background;Background;Background; 示例数据库1; 示例数据库2;2 Data Definition Language (DDL);DDL;Domain Types in SQL;Domain Types in SQL;Domain Types in SQL;Domain Types in SQL Server 2005;Domain Types in SQL Server 2005-Summary;create domain;Create Table Construct;Example: create table branch (branch-name char(15) not null, branch-city char(30), assets integer);Integrity Constraints in Create Table;Integrity Constraints in Create Table;Create Table;Create Table;Create Table;Create Table;Alter Table Constructs;Alter Table Constructs;Drop table;drop table;在SQL Server中建立数据库和表;3 Basic Structure of queries;Basic Structure;An simple Example;The select Clause;The select Clause;The select Clause;The select Clause;The where Clause;The where Clause operators;The where Clause－ between;between;The from Clause;The from Clause;The Rename Operation;The Rename Operation;Tuple Variables（元组变量）;Tuple Variables;String Operations(字符串操作);String Operations;String Operations;Ordering the Display of Tuples元组显示顺序;4 Set Operations（集合操作）;Set Operations;示例 求选修了001或（且）002号课程的学生号 (select SNO from SC where CNO = ‘001’) union (intersect) (select SNO from SC where CNO = ‘002’);求选修了001和002号而没有选003号课程的学生号 (select SNO from SC where CNO = ‘001’ or CNO = ‘002 ‘ ) except (select SNO from SC where CNO = ‘003’ );5 Aggregate Functions（聚集函数）;Aggregate Functions;Aggregate Functions – Group By;Aggregate Functions – Group By;Aggregate Functions – Group By;Aggregate Functions – Having Clause;Aggregate Functions – Having Clause;6 Null Values(空值);Null Values;Null Values;Null Values;Null Values;7 Nested Subqueries（嵌套子查询）;SQL Server中的子查询;Set Membership（集合成员资格）;Example Query;Example Query;Example Query;Example Query;Example Query;Example Query-SQL Ser