Ruby on Rails - Database Fundamentals

This course covers how to use Active Record 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