SQL example file

This file is used to create the examples described in the lectures. It should be used by "sqlite3 < student-3.sql"

Older SQL lectures

Show grouping operations.

More SQL

outer joins union queries

Example sql file

Creates a simple SQLite database. Note how referential integrity is enforced.

TU Graz: Course: 707.000 Web Science and Web Technology: Lecture 12: User Intentions and Intentional Structures on the Web II

In this lecture, we will focus on analyzing user goals in search query logs. Readings: M. Strohmaier, P. Prettenhofer, M. Lux, Different Degrees of Explicitness in Intentional Artifacts - Studying User Goals in a Large Search Query Log, CSKGOI'08 International Workshop on Commonsense Knowledge and Goal Oriented Interfaces, in conjunction with IUI'08, Canary Islands, Spain, 2008.

INFO2009 - Team 'DROP TABLE groups;

Edshare for INFO2009 coursework 2 - Team 'DROP TABLE groups;

Database lectures Part 3

More on SQL

Software Development: Testing

This presentation discusses the role and purpose of testing in the systems/Software Development Life Cycle. We examine the consequences of the 'cost curve' on defect removal and how agile methods can reduce its effects. We concentrate on Black Box Testing and use Equivalence Partitioning and Boundary Value Analysis to construct the smallest number of test cases, test scenarios necessary for a test plan.