Database Management Systems CSEP 544

Database Management Systems

CSEP 544

Lecture 3: SQL

Relational Algebra, and Datalog

CSEP 544 - Fall 2017

1

Announcements

? HW2 due tonight (11:59pm)

? PA3 & HW3 released

CSEP 544 - Fall 2017

2

HW3

? We will be using SQL Server in the cloud (Azure)

¨C Same dataset

¨C More complex queries J

? Logistics

¨C You will receive an email from invites@

to join the ¡°Default Directory organization¡± --- accept it!

¨C You are allocated $100 to use for this quarter

¨C We will use Azure for two HW assignments

¨C Use SQL Server Management Studio to access the DB

? Installed on all CSE lab machines and VDI machines

CSEP 544 - Fall 2017

3

Scythe

CSEP 544 - Fall 2017

4

Plan for Today

? Wrap up SQL

? Study two other languages for the relational data

model

¨C Relational algebra

¨C Datalog

CSEP 544 - Fall 2017

5

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download