mySQL with RUBY and RAILS

Course:  RORSQL
Duration:  5 Days
Level:  I
Course Summary

This course provides a comprehensive study of building internet-based relational database applications with the SQL and RUBY languages, and the mySQL database product. The class includes coverage of using the SQL language and some administrative advice about the mySQL product. The class includes lecture, discussion, and practical and progressive "hands-on" workshops. It also studies the RAILS application development, testing, and deployment environment for creation of internet applications which view and update relational database data.

« Hide The Details
Topics Covered In This Course

Introduction to the Rails environment

  • Characteristics of "agile" development
  • Installing RUBY and RAILS under your operating system
  • Back-end relational database support
  • The RAILS application and philosophy
  • Overview of MVC: the Model-View-Controller framework
  • Starting and running a sample application
  • Using digg
  • Testing and debugging applications
  • mySQL tools in Rail

The Ruby Language

  • Review of Object-Oriented Design Methodology
  • Objects, variables, classes, methods, instantiation, scope, encapsulation, and inheritance – implemented as Ruby conventions
  • RUBY commands and IRB – Interactive Ruby
  • Core (built-in) Ruby classes and modules
  • Collections, arrays, hashes, strings, numbers, and constants
  • Operators and Iterators
  • Conditional logic (If, Case, Unless, While, For, Until, Break, Redo, Next, Retry, etc)
  • Working with Blocks
  • Creating and calling Methods
  • Exception classes and error handling

The mySQL Relational Database environment

  • Using the mySQL client program
  • Starting and stopping mySQL
  • Connecting and disconnecting from mySQL
  • Specifying connection parameters with Option Files
  • Setting up mySQL user accounts
  • Obtaining and using metadata
  • Importing and exporting data
  • Designing transactions in Ruby programs
  • mySQL-based session management techniques
  • Working with the CGI::Session class

The SQL Language

  • Coding SELECT, INSERT, UPDATE, and DELETE statements
  • Using aggregate and scalar functions
  • Error handling options
  • Cursor management
  • Event-driven capabilities in SQL
  • Transaction management issues

Database Management and ActiveRecord

  • ActiveRecord models and Ruby classes
  • mySQL database object creation commands
  • Rails-friendly SQL code
  • Data integrity in the relational database model
  • Validates_method
  • Automatic and custom migrations

ActionController and ActionView

  • Understanding controllers and views and how they interact
  • Rendering commands
  • RHTML templating
  • Master and partial templates
  • Erb: Embedded Ruby
  • Layouts and the user interface
  • Working with Forms under Rails: form helper methods and ActionPack
  • RJS templates and AJAX
  • Scaffolding in Rails

Project Automation and Rails Plugins

  • Review of available plugins
  • Plugin repositories

Debugging, Testing, and Production deployment

  • The Ruby test framework
  • Session management
  • User authentication and login
  • Fixtures
  • Unit testing
  • Integration testing
  • Your production environment
  • Capistrano
What You Can Expect

At the end of this course, delegates will have a clear understanding of how to use the SQL and RUBY languages, and will come away with knowledge and experience with using SQL and RUBY in the RAILS environment, in order to agilely and rapidly implement and test both simple and moderately complex applications.

Who Should Take This Course

Developers who wish to utilize RUBY, RAILS, and the SQL language to develop internet front-end interfaces to relational database back-end objects.

Recommended Prerequisites

Experience with at least one other application development language is necessary. Prior exposure to object-oriented principles is desirable. Prior experience with SQL and some RDBMS is also desirable.

Training Style

A mix of instructor-led lecture and discussion, along with a series of hands-on workshops of progressively escalating complexity will be used to produce understanding, confidence, and real experience.

« Hide The Details
Related Courses
Code Course Title Duration Level
Developing Web-Sites Using PHP and MySQL
5 Days
Ruby and Rails
4 Days

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]