4. SQL - CSCI 2541 Databases
4. SQL
CSCI 2541 Database Systems & Team Projects
Wood & Chaufournier
Slides adapted from Prof. Bhagi Narahari; Silberschatz, Korth, and Sudarshan; and Ramakrishnan, Gerhke, and Lawrence
Last time...
Relational Model & Algebra
SQL DDL
SQL DML
this time...
2
SQL: Structured Query Language
The standard language for relational data
Invented by folks at IBM, esp. Don Chamberlin
Actually not a great language...
Beat a more elegant competing standard, QUEL, from
Berkeley
Separated into a DML & DDL
Data Definition (DDL) ? to define schema/tables
Define Schema
Define Constraints
Data Manipulation (DML) component based on relational algebra & calculus
GW CSCI 2541 Databases: Wood & Chaufournier
3
SQL Hello World
Create a table
CREATE TABLE Instructor ( id INT, name VARCHAR(50),
I department VARCHAR(5),
office DECIMAL(4), PRIMARY KEY (id) );
GW CSCI 2541 Databases: Wood & Chaufournier
4
SQL Hello World
Create a table
CREATE TABLE Instructor ( id INT, name VARCHAR(50), department VARCHAR(5), office DECIMAL(4), PRIMARY KEY (id)
);
Insert a row
INSERT INTO Instructor (id, name, department, office) VALUES (2, 'Roberto Finlaison', 'CIVIL', 185);
Haw
GW CSCI 2541 Databases: Wood & Chaufournier
5
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- data ypes t springer
- 4 sql csci 2541 databases
- sql injection oob channels
- example 1 not equals shortcut sas support
- t sql create function return varchar weebly
- how to convert sql from the microsoft sql server database
- example to convert xml to sql table
- sql convert to hex
- conversion of microsoft sql asp applications to postgresql
Related searches
- free research databases for students
- databases for peer reviewed articles
- educational databases for students
- understanding databases for beginners
- databases for dummies pdf
- free databases for students
- web of science databases journals
- free databases for college students
- using databases with python
- free donor databases for nonprofits
- scholarly databases for nursing
- best databases for nursing research