CompSci516 Database Systems .edu
CompSci 516
Database Systems
Lecture 4
SQL
Instructor: Sudeepa Roy
Duke CS, Fall 2019
CompSci 516: Database Systems
1
Announcements
? Lab-1 makeup instructions sent on piazza
? Please respond by 3 pm today if you have missed the lab
? Let me know if you are still not on piazza ? HW1 will be posted after the class
? On sakai (data is already there) ? Deadlines in stages ? First deadline on 09/17
Duke CS, Fall 2019
CompSci 516: Database Systems
2
Today's topic
? Finish SQL ? RC
? Next week:
? Tuesday: Guest Lecture by Junyang Gao: RA ? Thursday: Lab on RA
Duke CS, Fall 2019
Acknowledgement:
The following slides have been created adapting the
instructor material of the [RG] book provided by the authors
ComDpr.SRcia5m16a:kDraisthabnaasne SaynsdtemDsr. Gehrke.
3
Nulls and Views in SQL
Duke CS, Fall 2019
CompSci 516: Database Systems
4
Null Values
? Field values in a tuple are sometimes
? unknown, e.g., a rating has not been assigned, or ? inapplicable, e.g., no spouse's name ? SQL provides a special value null for such situations.
Duke CS, Fall 2019
CompSci 516: Database Systems
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
- the relational model edu
- the relational model
- chapter 4 advanced sql date and time data types in sql
- to char function with dates
- sql data types and schemas integrity constraints
- sql computer science
- sql constraints and triggers week 12
- compsci516 database systems edu
- oracle sql language quick reference
- sql constraints and triggers week 11
Related searches
- minecraft edu edition
- minecraft edu download free
- minecraft edu edition recipes
- minecraft edu mod download
- minecraft edu launcher download
- minecraft edu free download
- alsde edu contacts
- edu perfect
- edu minecraft launcher
- database analyst vs database administrator
- database management systems list
- database developer vs database architect