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.
jOOQ - a short guide

jOOQ - a short guide

16
Comments
8 min read
Codeigniter custom helper functions which will increase your productivity

Codeigniter custom helper functions which will increase your productivity

23
Comments 2
2 min read
Updating a table from another table

Updating a table from another table

8
Comments 3
1 min read
Understanding SQL Server Isolation Levels through example

Understanding SQL Server Isolation Levels through example

11
Comments
6 min read
For the 1024 time – DateTime has no format!

For the 1024 time – DateTime has no format!

11
Comments 2
2 min read
ORM vs Query Builders vs Raw SQL

ORM vs Query Builders vs Raw SQL

28
Comments 8
2 min read
GraphQL with Postgres views and materialized views

GraphQL with Postgres views and materialized views

6
Comments
5 min read
6 Common Sequelize Queries Explained in SQL

6 Common Sequelize Queries Explained in SQL

6
Comments
4 min read
How I passed 70-761 T-SQL exam

How I passed 70-761 T-SQL exam

10
Comments 2
3 min read
How to Load Data into an SQL database: From simple inserts to bulk loads

How to Load Data into an SQL database: From simple inserts to bulk loads

45
Comments
3 min read
SQL Subqueries in action

SQL Subqueries in action

21
Comments 3
8 min read
Understanding MySQL Index Basics

Understanding MySQL Index Basics

9
Comments 5
2 min read
A more controllable random string generator function for SQL Server

A more controllable random string generator function for SQL Server

8
Comments
3 min read
Stop using offset pagination

Stop using offset pagination

9
Comments
3 min read
Cleaning and Transforming Data with SQL

Cleaning and Transforming Data with SQL

17
Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.