Hi @north_celt, and welcome!
As usual, the answer is “it depends” - as much on your learning style as anything.
I’d probably start with the PragProg books - Programming Phoenix or Programming Phoenix LiveView. They are now both a bit behind state of the art - e.g. building components etc is a lot better than a year ago - but they will give you a good idea of the conceptual models. The first one covers more database stuff (i.e. Ecto), but, unlike the second one, it doesn’t cover LiveView and, IMO, LiveView is the way forward. LiveView is a much simpler programming model and sets you up for the some of the power of Erlang / Elixir / Phoenix - real-time interactive web apps.
The “generators” for Phoenix / LiveView will also allow you to see how to put things together. If you commit a skeleton Phoenix project to source control, run a generator and look at the diffs, you should start to see how things hang together. mix phx.gen.live — Phoenix v1.8.8 is probably the key one - it will generate UI, Ecto schemas, database migrations and tell you how to update the router.
Some Ecto recipes can be found in the Ecto Cookbook: The Little Ecto Cookbook - Dashbit ebooks. You have to cough up an email address for it, but it’s in safe hands - Dashbit is the consulting organisation founded by José Valim, the original creator of Elixir.
I didn’t come from the Ruby camp when I started out with Elixir, so getting my head around some of the DSLs brought in by the libraries took a bit of digging around. Examples include defining Ecto schema, router entries, plug pipelines. If you want to go deep on this, there’s a “Metaprogramming Elixir” book from pragprog that explains all! It was written by Chris McCord who originally wrote Phoenix.
Finally, for a general overview of the power of Erlang/Elixir, it is hard to go past Saša Jurić’s content - https://www.youtube.com/watch?v=JvBT4XBdoUE is probably the most information dense talk you will ever see on the power of Erlang & Elixir, and “Elixir in Action” from Manning Books is well worth a read when you want to go the next step in taking advantage of all that the platform has to offer.