TAILIEUCHUNG - Lecture Database concepts (3rd Edition): Chapter 3 - David M. Kroenke, David J. Auer

Chapter 3 - Structured Query Language. After completing this unit, you should be able to: Learn basic SQL statements for creating database structures, learn SQL statements to add data to a database, learn basic SQL SELECT statements and options for processing a single table, learn basic SQL SELECT statements for processing multiple tables with subqueries,. | Structured Query Language Chapter Three DAVID M. KROENKE and DAVID J. AUER DATABASE CONCEPTS, 3rd Edition Chapter Objectives Learn basic SQL statements for creating database structures Learn SQL statements to add data to a database Learn basic SQL SELECT statements and options for processing a single table Learn basic SQL SELECT statements for processing multiple tables with subqueries Learn basic SQL SELECT statements for processing multiple tables with joins Learn SQL statements to modify and delete data from a database Learn SQL statements to modify and delete database tables and constraints 3- Structured Query Language Structured Query Language Acronym: SQL Pronounced as “S-Q-L” [“Ess-Que-El”] Also pronounced as “Sequel” Originally developed by IBM as the SEQUEL language in the 1970s SQL-92 is an ANSI national standard adopted in 1992 3- SQL Defined SQL is not a programming language, but rather a data sub-language SQL is comprised of: A data definition language (DDL) Used to define database structures A data manipulation language (DML) Data definition and updating Data retrieval (Queries) There are other SQL functions not covered in this chapter Concurrency control [See Chapter 6] Transaction control [See Chapter 6] 3- SQL for Data Definition The SQL data definition statements include CREATE To create database objects ALTER To modify the structure and/or characteristics of database objects DROP To delete database objects 3- SQL for Data Definition: CREATE Creating database tables The SQL CREATE TABLE statement CREATE TABLE EMPLOYEE( EmpID Integer PRIMARY KEY, EmpName Char(25) NOT NULL ); 3- SQL for Data Definition: CREATE with CONSTRAINT I Creating database tables with PRIMARY KEY constraints The SQL CREATE TABLE statement The SQL CONSTRAINT keyword CREATE TABLE EMPLOYEE( EmpID Integer NOT NULL, EmpName Char(25) NOT NULL CONSTRAINT Emp_PK PRIMARY KEY(EmpID) ); 3- SQL for Data Definition: CREATE with CONSTRAINT II Creating database tables

• Cơ sở dữ liệu
• Database concepts
• Lecture Database concepts
• Database fundamentals
• Database design
• Database management
• Structured Query Language
• Database system concepts
• Lecture Database system concepts
• Database systems
• Database languages
• Database system architectures
• Relational database design
• Database administration
• Database processing environment
• Relational databases
• Relational model
• Data modeling
• Representing weak entities
• Query optimization
• Transaction state
• Concurrency control
• Recovery system
• Data analysis
• Information retrieval
• Parallel databases
• Distributed databases
• Advanced application development
• Advanced data types
• Advanced transaction processing
• Relational model
• Basic query structure
• Dynamic SQL
• Tuple relational calculus