Ruby on Rails - Database Fundamentals

Overview/Description
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.

Target Audience
Programmers who want to use ActiveRecord to manipulate data in a Ruby on Rails application

Prerequisites
None

Expected Duration (hours)
1.0

Lesson Objectives

Ruby on Rails - Database Fundamentals

• start the course
• create an ActiveRecord model with Ruby on Rails
• add data to a Ruby on Rails project database
• seed a Ruby on Rails project database
• define default values to ActiveRecord objects
• alter a database using Active Record's migration features in Ruby on Rails
• 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
• use the delete and destroy methods in Ruby on Rails to remove records from a database
• use the Ruby on Rails update_attributes method to edit a record and save it automatically to the database
• compute sums, counts, and averages in the Rails console
• the minimum and maximum values of both numeric and lexigraphical items in a table using the Rails console
• use the ActiveRecord finder joins method to perform a join that combines the data from two tables while querying the records
• use ActiveRecord's includes method to combine data from two or more tables and contrast it with the joins method
• perform a search type query of a Ruby on Rails project database using a defined scope in the Rails console
• 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
• use Active Record in Ruby on Rails to create new records in a table of data using scopes
• examine how forms are generated in Ruby on Rails projects
• execute a SQL query on model data using the LIKE operator in a WHERE clause in Ruby on Rails
• manage and maintain a database using Ruby On Rails