DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Raw SQL or ORM. Which one is better?
shohams profile

Raw SQL or ORM. Which one is better?

#database #api #architecture #sql
1
Comments
6 min read
SQL | Database Query Optimization with Examples
hbolajraf profile

SQL | Database Query Optimization with Examples

#microsoft #sql #database #productivity
Comments
2 min read
SQL | Database Query Optimization with Common Table Expressions
hbolajraf profile

SQL | Database Query Optimization with Common Table Expressions

#microsoft #sql #database #cte
3
Comments
2 min read
Introducing Vitorm: The Perfect Balance of Simplicity and Power in ORM for NetCore
lithwang profile

Introducing Vitorm: The Perfect Balance of Simplicity and Power in ORM for NetCore

#netcore #database #sql
Comments 1
5 min read
How to Effectively Use the ALL Keyword in SQL Server Queries
amr-saafan profile

How to Effectively Use the ALL Keyword in SQL Server Queries

#sql #sqlserver #database
Comments
6 min read
Tell me, like I'm 5, why SQLynx is better than Data Grip?
tom8daafe63765434221 profile

Tell me, like I'm 5, why SQLynx is better than Data Grip?

#sql
1
Comments
1 min read
Window Functions in SQL
johnkyalo profile

Window Functions in SQL

#sql #datascience #database #data
6
Comments 1
1 min read
SQL Server: How to Use the ADD Keyword for Schema Changes
amr-saafan profile

SQL Server: How to Use the ADD Keyword for Schema Changes

#sql #sqlserver #database
Comments
3 min read
Top 7 Websites to Learn SQL for Free 2024
ladanovnick profile

Top 7 Websites to Learn SQL for Free 2024

#sql
2
Comments
3 min read
Interview questions for a java developer with 3 year of experience
javafullstackdev profile

Interview questions for a java developer with 3 year of experience

#programming #tutorial #java #sql
6
Comments
2 min read
How to Efficiently Copy or Update Tables Across Schemas in PostgreSQL on RDS Without Downtime?
manu_v_devops profile

How to Efficiently Copy or Update Tables Across Schemas in PostgreSQL on RDS Without Downtime?

#postgres #devops #sql #productivity
1
Comments
1 min read
Exceptions and Commit in PostgreSQL PL/pgSQL vs. Oracle PL/SQL
franckpachot profile

Exceptions and Commit in PostgreSQL PL/pgSQL vs. Oracle PL/SQL

#postgres #sql #database #yugabytedb
19
Comments 3
3 min read
PostgreSQL. How to move old historical records from your main table to a separate table?
dm8ry profile

PostgreSQL. How to move old historical records from your main table to a separate table?

#database #howto #postgres #sql
5
Comments
4 min read
SQL- Commands intro
madhuraj9030 profile

SQL- Commands intro

#beginners #programming #sql #sqlserver
4
Comments 1
2 min read
Choosing the Right Database for Your Project
nziokidennis profile

Choosing the Right Database for Your Project

#database #sql #nosql #development
14
Comments 2
9 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.