Databases in Ruby on Rails: Advanced Concepts

Course details

This course covers how to use advanced features to work with Ruby on Rails databases. It covers star schemas, lists and calendar tables, multi-valued dimensions as well as columnar databases. It also covers working with the InnoDB engine as well as managing deadlocks, scan locks and concurrency.

• start the course
• demonstrates the uses of Star Schemas and explain an example showing Fact and Dimension tables
• up a range of models through the use of a Star Schema
• use a star schema in a Ruby on Rails application for warehouse type queries
• represent a child table of objects as an ordered list in Ruby on Rails
• use Ruby on Rails to build a Calendar table with multiple fields, and use code to insert data into the table
• create a table for multi-valued dimensions in Ruby on Rails
• write a query for data stored as multi-valued dimensions in a database in Ruby on Rails
• work with a columnar database using Ruby on Rails.
• set up the InnoDB engine in Ruby on Rails to support transactions that the default MySQL storage engine otherwise doesn't support
• work with InnoDB locking in Rails using a transaction and a controller
• resolve deadlocks when working with databases in Ruby on Rails
• uses various tools and ways to avoid table scans and negate table locks in Ruby on Rails databases
• outline ways to efficiently deploy multi-threaded Ruby on Rails applications on a multi-threaded server and a multi-process server.
• fine tune your application to effectively deal with concurrent requests in Ruby on Rails
• a unique key constraint and then have the Ruby on Rails model validate it with a couple of simple commands
• index a Ruby on Rails database variable as a foreign key
• create and use a Star Schema