Latest News
INFO2120/INFO2820 - Database Systems 1 - is a unit suited for students focussed on IT (both in CS and IS streams), and it is also aimed at non-majors who want to learn a valuable set of skills in dealing with large amounts of valuable data.
The lectures take place on Mondays, 9:00am - 11:00am, in the Eastern Avenue Lecture Theatre (level 2) and on Tuesdays, 1pm, in Carslaw Lecture Thatre CAR 159 starting on 2 March 2009.
The tutorials start a week later, on 9 March 2009. They will take place Mondays and Tuesdays in the School of IT Laboratories.
- [21.06.2009]
- Remember: Final Exam tomorrow (MONDAY, 22 June) at 3PM in MacLaurin Hall! (Please verify in your MyUni portal and check also your seat number there - the examination office runs this exam, not me, so no guarantee from my side on any scheduling information!)
Furthermore: Assignment marks have been published and submissions returned in WebCT. And the advanced class slides are now completely available both here and in WebCT.
Good luck for your exam. - [01.06.2009]
- The UoS review slides are now online. This was the last lecture today - there will be no Tuesday lecture tomorrow, but we run the tutorials still this week to discuss assignment and example exam questions.
Many thanks to everyone. Wish you all the best for the final exam which takes place 22 June (Monday) at 3pm. UR - [22.05.2009]
- New: On the assignments page, there are several new FAQs, Java tutorials, revised data sets and astronomy scenario descriptions for all assignments (DB-Design, DB-Porg, and DB-Advanced).
- [21.05.2009]
- New: A collection of DB Design Assignment - data loading tips
- [18.05.2009]
- A data loading script for the db-design assignment is now available on this website.
- [12.05.2009]
- Details for the practical assignments are published!. The assignments is due in week 12 (tutorials).
- [11.05.2009]
- QUIZ 3 is on this week! Deadline is Sunday, 17 May, 11pm.
Please also sign-up for assignment teams in WebCT! (cf. Signup Sheets on WebCT's info2120 start page) - [03.05.2009]
- NEW: HOW TO install and run DataBrowser (a freeware SQL editor).
- [29.04.2009]
- QUIZ 2 (SQL) is on this week!> Deadline is Sunday, 3 May, 11pm.
Please check the discussion forum in WebCT for clarifications on some of the questions; e.g. query SQL-12 has changed and the details are given on WebCT.
I also made my feedback for the mid-semester surveys available on WebCT. - [04.04.2009]
- Slides are up for this week, including updated slides on triggers.
Please dont forget the Quiz deadline tomorrow (5.4.) 11pm! - [31.03.2009]
- Updated slides on Relational Divions for todays Tuesday lecture; we will leave triggers for week 6 and re-iterate nested queries, division and assertions.
- [29.03.2009]
- Unit-of-study Outline is now online and the quiz and assignment dates have been published.
Lecture notes for week 5 are now online. - [22.03.2009]
- Lecture notes for week 4 are now online.
- [14.03.2009]
- Lecture notes for week 3 are now online and the lecture slides for last week (W2) have been updated. Lecture recordings of the last two weeks are available on the USYD eLearning.
- [08.03.2009]
- Lecture notes for week 2 are now online and note that the lecture notes for last week have been updated. We have also finalised our tutor team for this year: The 2h tutorial/labs will be run by Audrey Quah, Sophie Troy, Raymes Khoury, Tim Dawborn and Paul Yoo.
- [27.02.2009]
- Welcome to our new course website!