Building Database Applications in Elixir with Ecto

Exercise: Create Queries in Ecto

Explore how to write Ecto queries that retrieve all albums associated with a given artist. Understand how to construct and execute efficient database queries in Elixir to solve real coding challenges.

We'll cover the following...

Problem statement
Coding challenge

1.Introduction to This Course

2.Part I: Ecto Fundamentals

3.Get Started with Repo

4.Query Your Database

5.Connect Tables to Elixir Structs with Schemas

6.Make Changes with Changesets

7.Make Multiple Changes with Transactions and the Multi Module

8.Make Changes to the Database

Project

9.Part II: Ecto Applied

10.Add Ecto to an Elixir Application Without Phoenix

Project

11.Work with Changesets and Phoenix Forms

12.Test with Sandboxes

13.Create and Use Custom Types

14.Inserting and Updating with Upserts

15.Optimizeing Your Application Design

16.Work with Embedded Schemas

17.Creating Polymorphic Associations

18.Optimize IEx for Ecto

19.Use Schemas Without Tables

20.Tune for Performance

21.Conclusion

Exercise: Create Queries in Ecto