Ruby on Rails - Database Fundamentals

Course details

This course covers how to use ActiveRecord to work with data in a Ruby on Rails application. It covers creating a model, adding and editing records, manipulating data, working with scopes, using forms and creating queries.

• Topic T2 Objective O3
• start the course
• Topic T6 Objective O7
• create an ActiveRecord model with Ruby on Rails
• Topic T10 Objective O11
• add data to a Ruby on Rails project database
• Topic T14 Objective O15
• seed a Ruby on Rails project database
• Topic T18 Objective O19
• define default values to ActiveRecord objects
• Topic T22 Objective O23
• alter a database using Active Record's migration features in Ruby on Rails
• Topic T27 Objective O28
• use built-in Ruby on Rails methods to display the first or last record, all of the records, or even one particular field of data in a table
• Topic T31 Objective O32
• use the delete and destroy methods in Ruby on Rails to remove records from a database
• Topic T35 Objective O36
• use the Ruby on Rails update_attributes method to edit a record and save it automatically to the database
• Topic T40 Objective O41
• compute sums, counts, and averages in the Rails console
• Topic T44 Objective O45
• the minimum and maximum values of both numeric and lexigraphical items in a table using the Rails console
• Topic T48 Objective O49
• use the ActiveRecord finder joins method to perform a join that combines the data from two tables while querying the records
• Topic T52 Objective O53
• use ActiveRecord's includes method to combine data from two or more tables and contrast it with the joins method
• Topic T57 Objective O58
• perform a search type query of a Ruby on Rails project database using a defined scope in the Rails console
• Topic T61 Objective O62
• add a parameter to a class scope method before using an argument to return different Ruby on Rails project database query results in the Rails console
• Topic T65 Objective O66
• use Active Record in Ruby on Rails to create new records in a table of data using scopes
• Topic T70 Objective O71
• examine how forms are generated in Ruby on Rails projects
• Topic T74 Objective O75
• execute a SQL query on model data using the LIKE operator in a WHERE clause in Ruby on Rails
• Topic T108 Objective O109
• manage and maintain a database using Ruby On Rails