Explore

EXPLORE THE CATALOGSupercharge your career with 700+ hands-on courses

View All Courses

Python

Java

JavaScript

React

Docker

Vue JS

Web Dev

DevOps

AWS

LEARNING TOOLSExplore the industry's most complete learning platform

CoursesLevel up your skills

Cloud LabsSetup-free practice with Cloud Services

Skill PathsAchieve learning goals

ProjectsBuild real-world applications

Mock InterviewsNewAI-Powered interviews

Personalized Interview PrepNewGet a custom roadmap tailored to your goals

AssessmentsBenchmark your skills

Personalized PathsGet the right resources for your goals

LEARN TO CODE

Check out our beginner friendly courses.

Pricing

For Business

Resources

NewsletterCurated insights on AI, Cloud & System Design

BlogFor developers, By developers

Free CheatsheetsDownload handy guides for tech topics

Building Database Applications in Elixir with Ecto/

...

Query Basics

Learn Ecto's query syntax.

We'll cover the following...

Query syntax

SQL based query
Ecto based query
Macro syntax

Example

Convert to SQL query
Execute the query
Look closely
Use prefixes

Try it yourself

Press + to interact

Access this course and 1400+ top-rated courses and projects.

Lifetime Discount - 50% Off

$13

$24.83/month

Preview Free Lessons→

Preview Free Lessons

Introduction to This Course

Part I: Ecto Fundamentals

Get Started with Repo

Query Your Database

Connect Tables to Elixir Structs with Schemas

Make Changes with Changesets

Make Multiple Changes with Transactions and the Multi Module

Make Changes to the Database

Build an E-learning Website Using Elixir

Part II: Ecto Applied

Add Ecto to an Elixir Application Without Phoenix

Build a REST API with Elixir and Phoenix

Work with Changesets and Phoenix Forms

Test with Sandboxes

Create and Use Custom Types

Inserting and Updating with Upserts

Optimizeing Your Application Design

Work with Embedded Schemas

Creating Polymorphic Associations

Optimize IEx for Ecto

Use Schemas Without Tables

Tune for Performance

Conclusion

Query Basics