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