Working with Databases in Ruby on Rails

Course details

This course covers how to work with databases in Ruby on Rails. It covers data models, referential integrity, record validation, and optimistic and pessimistic locking.

• Topic T2 Objective O3
• start the course
• Topic T6 Objective O7
• create and use a basic CRUD in Ruby on Rails
• Topic T10 Objective O11
• create various data models in a Ruby on Rails database
• Topic T14 Objective O15
• implement one-one relationships between two ActiveRecord models
• Topic T18 Objective O19
• link one database in Ruby on Rails to multiple other tables using a has_many relationship
• Topic T22 Objective O23
• use the joins keyword or the includes keyword to query two Ruby on Rails databases that have a has_many relationship
• Topic T26 Objective O27
• up a polymorphic association in Active Record by generating models, declaring the association, and modifying the migrate
• Topic T31 Objective O32
• examine a foreign key for an has_many relationship association in Ruby on Rails
• Topic T35 Objective O36
• manage foreign keys in Ruby on Rails databases
• Topic T39 Objective O40
• ensure referential integrity in Ruby on Rails databases
• Topic T44 Objective O45
• identify the three main reasons duplicate data might be added to a Ruby on Rails database
• Topic T48 Objective O49
• resolve duplication in a Ruby on Rails database by writing a validation rule in the model, as well as by adding an index to the database
• Topic T52 Objective O53
• recap on how avoid duplication in Ruby on Rails databases and use the Consistency Fail gem
• Topic T57 Objective O58
• add validation rules to the ActiveRecord in a Ruby on Rails database
• Topic T61 Objective O62
• handle invalid data in a Ruby on Rails database
• Topic T65 Objective O66
• migrate a not_null database in Ruby on Rails
• Topic T69 Objective O70
• outline the difference between an empty string and a nil value in Ruby on Rails
• Topic T74 Objective O75
• overview how to implement optimistic locking in a Rails application
• Topic T78 Objective O79
• implement optimistic locking in a Rails application
• Topic T82 Objective O83
• use the internal counter with Optimistic Locking in Ruby on Rails
• Topic T86 Objective O87
• review the implementation of optimistic locking in a Rails application
• Topic T91 Objective O92
• overview pessimistic locking and the different types of pessimistic locks you