Database Systems Session 6 Main Theme Standard Query ...

Database Systems

Session 6 ? Main Theme

Standard Query Language (SQL) Features

Dr. Jean-Claude Franchitti

New York University Computer Science Department Courant Institute of Mathematical Sciences

Presentation material partially based on textbook slides Fundamentals of Database Systems (6th Edition) by Ramez Elmasri and Shamkant Navathe

Slides copyright ? 2011 and on slides produced by Zvi Kedem copyight ? 2014

1

Agenda

1 Session Overview 2 Basic SQL 3 Data Manipulation Language for Relational DBs 4 Data Definition Language for Relational DBs 5 Summary and Conclusion

2

Session Agenda Session Overview Basic SQL Data Manipulation Language Summary & Conclusion

3

What is the class about?

Course description and syllabus:

? ?

Textbooks:

? Fundamentals of Database Systems (6th Edition) Ramez Elmasri and Shamkant Navathe Addition Wesley ISBN-10: 0-1360-8620-9, ISBN-13: 978-0136086208 6th Edition (04/10)

4

Icons / Metaphors

Information Common Realization Knowledge/Competency Pattern Governance Alignment Solution Approach

5 5

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

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

Google Online Preview   Download