MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Your Database Is Your Friend

Course Summary

Databases have endured a lot of flak from the Rails camp, but they can do some pretty fantastic things. We can make our software better by spending some time to get to know them. Your database wants to be your friend.

  • +

    Course Syllabus

    ● Introduction
        ◦ What is this?
        ◦ Logistics
    ● Data Modelling
        ◦ Introduction
        ◦ The Unexpected Nil
        ◦ Nil versus Empty String
        ◦ ActiveRecord Validation
        ◦ Not Nil Database Migration
        ◦ The Unexpected Nil: Recap
        ◦ The Missing Parent
        ◦ ActiveRecord has_many options
        ◦ Foreign Keys
        ◦ Cascading Deletes
        ◦ Schema.rb and Foreigner gem
        ◦ The Missing Parent: Recap
        ◦ Duplicate Data
        ◦ Resolving Duplicates
        ◦ Retrying Duplicate Exceptions
        ◦ One-to-one Relationships
        ◦ Duplicate Data: Recap
        ◦ Polymorphic Associations
        ◦ Converting to Separate Tables
        ◦ Reactive Integrity Tests
        ◦ Wrapping Up
    ● Concurrency
        ◦ Introduction
        ◦ A Development Environment for Concurrency
        ◦ Concurrent Requests Primer
        ◦ Concurrency and Unique Constraints
        ◦ Concurrency and Foreign Keys
        ◦ Thinking Concurrently
        ◦ Optimistic Locking Introduction
        ◦ Optimistic Locking with ActiveRecord
        ◦ Counters
        ◦ Optimistic Locking Recap
        ◦ Pessimistic Locking
        ◦ Pessimistic Locking Recap
        ◦ Concurrency in the Real World
        ◦ Combined Locking Example
        ◦ Acts as List
        ◦ Isolation Levels
        ◦ Summary
    ● Reporting
        ◦ What is reporting?
        ◦ Introduction to Star Schemas
        ◦ Creating a Star Schema
        ◦ Using a Star Schema
        ◦ Calendar Tables
        ◦ Multi-valued Dimensions: Creating
        ◦ Multi-valued Dimensions: Querying
        ◦ Columnar Databases
        ◦ Summary
    ● Appendix: MySQL
        ◦ Introduction
        ◦ Handling Invalid Data
        ◦ InnoDB Locking
        ◦ Deadlocks
        ◦ Scan Locks
        ◦ Summary


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Related Posts:

Security, Trust and Assurance Registry (STAR)


Star schema






Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top