《数据库原理（第6版）英文版》教学课件—ch03Structured Query Language.pptxVIP

Structured Query Language;Chapter Objectives;Structured Query Language;SQL Defined;SQL for Data Definition;SQL for Data Definition:CREATE;SQL for Data Definition:CREATE with CONSTRAINT I;SQL for Data Definition:CREATE with CONSTRAINT II;SQL for Data Definition:CREATE with CONSTRAINT III;SQL for Data Definition:CREATE with CONSTRAINT IV;Process SQL CREATE TABLE Statements:Microsoft SQL Server 2012;Process SQL CREATE TABLE Statements:Oracle Database 11g Release 2;Process SQL CREATE TABLE Statements:Oracle MySQL 5.5;Database Diagram in theMicrosoft SQL Server Management Studio;Primary Key Constraint:ALTER I;Composite Primary Key Constraints: ALTER II;Foreign Key Constraint:ALTER III;Adding Data:INSERT;SQL for Data Retrieval:Queries;SQL for Data Retrieval:The Results of a Query Is a Relation;SQL for Data Retrieval:Displaying All Columns;SQL for Data Retrieval:Showing Each Row Only Once;SQL for Data Retrieval:Specifying Search Criteria;Processing SQL Query Statements:Microsoft SQL Server 2012;Processing SQL Query Statements:Oracle Database 11g Release 2;Processing SQL Query Statements:Oracle MySQL 5.5;SQL for Data Retrieval:Match Criteria;SQL for Data Retrieval:Match Operators;SQL for Data Retrieval:Operator Examples;SQL for Data Retrieval:A List of Values;SQL for Data Retrieval:The Logical NOT Operator;SQL for Data Retrieval:Finding Data in a Range of Values;SQL for Data Retrieval:Allowing for Wildcard Searches;SQL for Data Retrieval:Wildcard Search Examples;SQL for Data Retrieval:Sorting the Results;SQL for Data Retrieval:Built-in SQL Functions;SQL for Data Retrieval:Built-in SQL Functions (Cont’d);SQL for Data Retrieval:Built-in Function Examples;SQL for Data Retrieval:Providing Subtotals: GROUP BY;SQL for Data Retrieval:Retrieving Information from Multiple Tables;SQL for Data Retrieval:Subquery Example;SQL for Data Retrieval:Join Example;SQL for Data Retrieval:JOIN…ON Example;SQL for Data Retrieval:LEFT OUTER JOIN Example;SQL for