Ruby on Rails - Database Fundamentals
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level
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.2
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
Course Number: pg_rubr_a02_it_enus
Expertise Level
Beginner