Basics of SQL Query

BASIC SQL


CHAPTER 4 (6/E)
CHAPTER 8 (5/E)




1

,LECTURE OUTLINE
 SQL Data Definition and Data Types
 Specifying Constraints in SQL
 Basic Retrieval Queries in SQL
 Set Operations in SQL




2

, BASIC SQL
 Structured Query Language
 Considered one of the major reasons for the commercial success of
relational databases
 Statements for data definitions, queries, and updates
• Both DDL and DML
• Core specification plus specialized extensions
 Terminology:
Relational Model SQL
relation table
tuple row
attribute column
 Syntax notes:
• Some interfaces require each statement to end with a semicolon.
• SQL is not case-sensitive.




3