'Select clause cont' diaporamas de présentation

PART 2

1.05k views • 91 slides

Chapter 5: SQL Basics

Chapter 5: SQL Basics. Information Technology Department Bryar Hassan (MSc Eng.) Bryar.hassan@kissr.edu.krd. Data Definition Language. The SQL data-definition language (DDL) allows the specification of information about relations, including: The schema for each relation.

505 views • 50 slides

Introduction to SQL

Introduction to SQL. Chapter 3: Introduction to SQL. Overview of the SQL Query Language Data Definition Basic Query Structure Additional Basic Operations Set Operations Null Values Aggregate Functions Nested Subqueries Modification of the Database. History.

436 views • 43 slides

Chapter 3: Introduction to SQL

Chapter 3: Introduction to SQL. Create Table Construct. An SQL relation is defined using the create table command : create table r ( A 1 D 1 , A 2 D 2 , ..., A n D n , (integrity-constraint 1 ), ..., (integrity-constraint k )) r is the name of the relation

347 views • 34 slides