- Duration: 1 Hour
Course details
This course covers how to use advanced features to work with Ruby on Rails databases. It covers star schemas, lists and calendar tables, multi-valued dimensions as well as columnar databases. It also covers working with the InnoDB engine as well as managing deadlocks, scan locks and concurrency.
- start the course
- demonstrates the uses of Star Schemas and explain an example showing Fact and Dimension tables
- up a range of models through the use of a Star Schema
- use a star schema in a Ruby on Rails application for warehouse type queries
- represent a child table of objects as an ordered list in Ruby on Rails
- use Ruby on Rails to build a Calendar table with multiple fields, and use code to insert data into the table
- create a table for multi-valued dimensions in Ruby on Rails
- write a query for data stored as multi-valued dimensions in a database in Ruby on Rails
- work with a columnar database using Ruby on Rails.
- set up the InnoDB engine in Ruby on Rails to support transactions that the default MySQL storage engine otherwise doesn't support
- work with InnoDB locking in Rails using a transaction and a controller
- resolve deadlocks when working with databases in Ruby on Rails
- uses various tools and ways to avoid table scans and negate table locks in Ruby on Rails databases
- outline ways to efficiently deploy multi-threaded Ruby on Rails applications on a multi-threaded server and a multi-process server.
- fine tune your application to effectively deal with concurrent requests in Ruby on Rails
- a unique key constraint and then have the Ruby on Rails model validate it with a couple of simple commands
- index a Ruby on Rails database variable as a foreign key
- create and use a Star Schema
About New Horizons Lebanon
As changes in technology have accelerated, it’s become even more essential for people to master technology to be productive, invaluable employees who optimize, program and invent solutions—and even grow companies of their own. With over 300 centers in 60 countries, New Horizons is the world’s largest independent IT and Business training company. Over the past 35 years, New Horizons has delivered a full range of IT and business skills/Management training through innovative learning methods that have transformed businesses and helped over 35 million students reach their goals. New Horizons Lebanon branch was established in 1996.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Introduction to TESOL Course CentralUSD 23
USD 100Duration: Upto 1 Hour - USD 49Duration: 1 To 2 Months