Search⌘ K
AI Features
Home
Courses
The Art of PostgreSQL

Introduction to Writing SQL Queries

Explore the fundamentals of writing SQL queries within application code, including best practices for formatting, debugging, and maintaining code. Understand the role of ORM, business logic considerations, and the importance of indexing strategies for effective database interactions with PostgreSQL.

We'll cover the following...

Now, we’re going to learn how to write SQL queries. There are several ways to accomplish this, both from the SQL syntax and semantics points of view, which will be covered later. Here, we want to address how to write SQL queries as part of our application code.

Object-relational mapping (ORM)

Some developers prefer to use an ...