'Create table person' presentation slideshows

SQL Unit 10 Creating Tables, Adding Constraints, and Defining Indexes

SQL Unit 10 Creating Tables, Adding Constraints, and Defining Indexes. Kirk Scott. 10.1 The Keyword CREATE 10.2 Background on General Constraints 10.3 Syntax for General Constraints 10.4 What are Indexes? 10.5 Syntax for Indexes. 10.1 The Keyword CREATE. 10.1.1 Creating Tables.

924 views • 81 slides

SQL Unit 10 Creating Tables, Adding Constraints, and Defining Indexes

SQL Unit 10 Creating Tables, Adding Constraints, and Defining Indexes. Kirk Scott. 10.1 The Keyword CREATE 10.2 Background on General Constraints 10.3 The Primary Key Constraint 10.4 The Uniqueness Constraint 10.5 The Not Null Constraint 10.6 The Foreign Key Constraint

922 views • 81 slides

OODB and XML

574 views • 42 slides

Correlated Queries

Correlated Queries. A nested query that requires the subquery to be evaluated many times; once for each value in the outer query. Example: Find movies whose title appears more than once. SELECT title FROM Movie AS Old WHERE year < ANY ( SELECT year

275 views • 22 slides

Aggregation

189 views • 18 slides