SQL Outer Joins (Using a Left,Right, and full Join)
In this video, you learn how to find matches and exceptions with outer joins.
Category: Database
Database Software Development Videos and Tutorials: MySQL, Oracle, NoSQL
Advanced ColdFusion ORM
Explore the underlying object-relational mapping (ORM) framework in ColdFusion 9. Tap into the power of Hibernate to build scalable and high-performing applications. This is a very technical session requiring advanced skills with ColdFusion.
Introduction to ColdFusion ORM
This video presents one of the most significant additions to ColdFusion development, the object-relational mapping (ORM) framework built into ColdFusion 9. Powered by the Hibernate framework, ColdFusion 9 reintroduces the rapid in rapid application deployment.
The Gunson Rules of Database Administration
It’s mostly a common-sense list of 10 or so dos and don’ts of being a DBA that I’ve realized over the years. It includes rules such as: * When someone says, “oh, just test that on the production databaseâ€, don’t. * Debugging and optimizing SQL is a fun and easy …
ActiveRelation: ActiveRecord Gets a Facelift
This week’s screencast will be a hands-on demonstration of the new ActiveRecord finder API. Read the screencast’s related article
Active Record Queries in Rails 3
Rails 3 introduces a new query interface for performing finds in Active Record. See how it works along with the changes in named scopes. http://railscasts.com/episodes/202-active-record-queries-in-rails-3