Access to relational data with ECTO

Build applications with relational databases with elixir


Ecto is specific domain language to write queries and interact with databases in elixir.

Undoubtedly, if you are on the path of application development with elixir, you will be down to PhoenixFramework, and you will need to use a database;Well, ECTO is the library that will facilitate the manipulation and consultation of the data.We want you to know that ECTO is not an ORM, is best known as a persistence framework, and in this training you will learn to: create databases and tables, insert data, consult data, manipulate data sets, updateSets, as well as boil, create associations and very important, handle transactions.

All this with the functional programming approach on which elixir is handled.

· Who is it directed:

This training is recommended for developers:

  • Elixir programmers who are going to start using applications in PhoenixFramework
  • Creators of components that are going to expose API’s REST
  • People who want to exploit their database Legada in a new platform
  • Elixir Developers who wish to learn to design the database of their applications
  • Alchemists who want to deepen the use of ECTO

· Pre-requirements:


  • Know the essential elements of elixir language and functional programming
  • Have knowledge of how to use an RDBMS
  • Know SQL.
  • Knowledge management of transactions in the database
  • Operate different access customers to the database
  • Learn more of a database handler

· Training content:

  • Ecto and Elixir
    • Ecto modules
    • How is Ecto organized?
    • Configuring the application
    • The repository pattern
    • The repo module
    • Running of the repo
    • Personalization of Repo
  • Essential elements of Query
    • Basic in Query
    • refining results with where
    • Working with JOINS
    • Composite Queries
    • Other ways to use wanted
  • Connecting Tables to Structions with Schemes
    • Creation of schemes
    • Writing queries with schemes
    • Insert and deleted with schemes
    • Add associations to schemes
    • Work with Associations in Queries
    • Optimizing associations
    • Deleting records with associations
    • Use of schemes to sow a base
  • making changes with ChangeSets
    • Introduction to ChangeSets
    • Casting and Filtering
    • Validating the data
    • Capturing errors
    • Using ChangESets without schemes
    • Working with Associations
  • Multiple changes with transactions and multi
    • Running traversions with functions
    • Running transactions with ecto.multi
  • making changes to the database
    • Inserting migrations
    • Running migrations
    • Rollback of migrations
    • Adding indexes
    • Changing data and table structures