Welcome to CSC4380 Database Systems

Available Information

• Software Required for this Course and how to set up Ruby on Rails on your machine
• Learning Ruby: The best way to learn Ruby is to look at online tutorials. We simply need to learn about the syntax of the language, how to define and manipulate data. A very good tutorial can be found at: http://guides.rubyonrails.org/getting_started.html .

• Some other useful Rails and Ruby related links (courtesy of Thomas Henry)
  • http://rubyonrails.org
  • www.railscasts.com
  • www.gotapi.com
  • www.railsforum.com
  • www.addedbytes.com/cheat-sheets/ruby-on-rails-cheat-sheet/
  • www.ruby-forum.com

* Database Access, Configuration and Help

• Learning Ruby on Rails (Tutorial for version 2.3)
  • Tutorial 1, version 2.3 explores the model/view/controller architecture, introduces sessions and forms.
  • Tutorial 2, version 2.3 explores database backed models, migrations and some data validation.
  • Tutorial 3, version 2.3 explores CRUD (create, read, update and delete), more on sessions and adding data to your tables.
  • Tutorial 4, version 2.3 explores filters, flash and working with multiple classes of objects.

• Instructor: Sibel Adali, adalis at rpi.edu, Office Hours: Wednesday 3 PM - 5 PM, Thursday 11 AM - 1 PM (Lally 313)
• Class TA: Xiaohui Lu, lux3 at rpi.edu, Office Hours: Tuesday, Friday 3 PM - 5 PM (Amos Eaton 217)

Tutorials below are the old version from the previous year.

• Learning Ruby on Rails (Tutorial below is for Rails 1.2.3, there are differences between the current version and this one, so beware)
  • Tutorial 1 explores the model/view/controller architecture, introduces sessions and forms.
  • Tutorial 2 explores the use of database tables in the models.
  • Tutorial 3 explores sessions and brief introduction to access methods for database objects.
  • Tutorial 4 explores filters, flash and working with multiple classes of objects.
  • Tutorial 5 explores tables with foreign keys and the find method.
  • Tutorial 6 explores unit testing. This is a very rudimentary introduction for a large topic in itself.

CourseDatabase Web Utilities