Lecture 9 - SQL - annotated

Lecture 9 - SQL - annotated - "Stand firm in your refusal...

Info icon This preview shows pages 1–3. Sign up to view the full content.

1 “Stand firm in your refusal to remain conscious during algebra. In real life, I assure you, there is no such thing as algebra.” -- Fran Lebowitz, Social Studies SQL: Structured Query Language INFO/COM S 230: Intermediate Web Design and Programming SQL “Real” database queries How do we really pose queries to a relational DBMS? Industry standard: using the language SQL. • Soon: How to use SQL via the MySQL DBMS. • After that: How to use SQL from PHP via MySQL. • For now: How to write SQL queries. …via relational algebra To do this, we’ll show how we can implement each of the relational algebra operators in SQL. SQL basics: selection and projection Easy PDF Creator is professional software to create PDF. If you wish to remove this line, buy it now.
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.