mySQL with RUBY and RAILS
Course: RORSQL
Duration: 5 Days
Level: I
On our website at:
http://www.verhoef-training.com/courses/RORSQL.html
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.
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.
Related Courses
Code |
Course Title |
Duration |
Level |
|
PHPMYS |
Developing Web-Sites Using PHP and MySQL |
5 Days |
I |
Details |
ROR |
Ruby and Rails |
4 Days |
II |
Details |
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.