Introduction to SQL

September 7

Responsible: A. Belikov

Lecture outline

To use a database efficiently, or to build your own database, it is necessary to have some knowledge of the database management systems and how to interact with one. This lecture will introduce the main query language for databases, SQL, and give an overview of how databases operate and how to interact with them through programs.

Lecture copies

You can download a copy of the lectures as a pdf copy, or an original PowerPoint presentation.

Add-on to the lecture (JOIN SQL statements in mySQL with examples) is in pdf or ppt.

Book suggestions

Book suggestions - basic:

• MySQL manual webpage.
• Kline, K, SQL in a nutshell, O'Reilly, 2004, ISBN:0-596-00481-8
• Dyer R., MySQL in a nutshell, O'Reilly, 2008, ISBN:978-0-596-51433-4

More advanced books:

• David Maier, The Theory of Relational Data Bases,Financial Times Prentice Hall, 1983