Standard Query Language (SQL) Features.ppt

3/26/2012

Database Systems Session 6 ? Main Theme Standard Query Language (SQL) Features Dr. Jean-Claude Franchitti

New York University Computer Science Department Courant Institute of Mathematical Sciences

Presentation material partially based on textbook slides Fundamentals of Database Systems (6th Edition) by Ramez Elmasri and Shamkant Navathe Slides copyright ? 2011

1

Agenda

1 Session Overview 2 Basic SQL 3 Data Manipulation Language for Relational DBs 4 Data Definition Language for Relational DBs 5 Summary and Conclusion

2

1

Session Agenda

Session Overview Basic SQL Data Manipulation Language Summary & Conclusion

3/26/2012

3

What is the class about?

Course description and syllabus:

? ?

Textbooks:

? Fundamentals of Database Systems (6th Edition) Ramez Elmasri and Shamkant Navathe Addition Wesley ISBN-10: 0-1360-8620-9, ISBN-13: 978-0136086208 6th Edition (04/10)

4

2

Icons / Metaphors

Information Common Realization Knowledge/Competency Pattern Governance Alignment Solution Approach

Agenda

1 Session Overview 2 Basic SQL 3 Data Manipulation Language for Relational DBs 4 Data Definition Language for Relational DBs 5 Summary and Conclusion

3/26/2012

55

6

3

3/26/2012

Agenda

Basic SQL SQL Data Definition and Data Types Schema and Catalog Concepts in SQL The CREATE TABLE Command in SQL Attribute Data Types and Domains in SQL Specifying Constraints in SQL Basic Retrieval Queries in SQL INSERT, DELETE, and UPDATE Statements in SQL Additional Features of SQL

7

Basic SQL

SQL language

Considered one of the major reasons for the commercial success of relational databases

SQL

Structured Query Language Statements for data definitions, queries, and updates (both DDL and DML) Core specification Plus specialized extensions

8

4

SQL Data Definition and Data Types

Terminology:

Table, row, and column used for relational model terms relation, tuple, and attribute

CREATE statement

Main SQL command for data definition

3/26/2012

9

Schema and Catalog Concepts in SQL (1/2)

SQL schema

Identified by a schema name Includes an authorization identifier and descriptors for each element

Schema elements include

Tables, constraints, views, domains, and other constructs

Each statement in SQL ends with a semicolon

10

5

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download