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.
SQL Tips & Tricks: Counting Rows

SQL Tips & Tricks: Counting Rows

5
Comments
5 min read
Machete MySQL(Cheatsheet) level 1

Machete MySQL(Cheatsheet) level 1

7
Comments
3 min read
Reading a datetime with miliseconds into an Oracle DATE

Reading a datetime with miliseconds into an Oracle DATE

6
Comments
2 min read
MySQL Commands You Need To Know To Create A New User

MySQL Commands You Need To Know To Create A New User

10
Comments 1
2 min read
What's your experience with text IDs in SQL database?

What's your experience with text IDs in SQL database?

16
Comments 9
1 min read
Reports performance improvement

Reports performance improvement

7
Comments
1 min read
Getting to know SQL Server Extended Events

Getting to know SQL Server Extended Events

26
Comments
7 min read
SQL Practice Problem to Help You Pass Your Interview

SQL Practice Problem to Help You Pass Your Interview

18
Comments 6
3 min read
How to ace coding interviews. The ultimate guide.

How to ace coding interviews. The ultimate guide.

80
Comments
14 min read
Code-First ORM For Go: GORM

Code-First ORM For Go: GORM

9
Comments
3 min read
Distributed SQL Tips and Tricks – Aug 17, 2020

Distributed SQL Tips and Tricks – Aug 17, 2020

2
Comments
4 min read
SQL Cheatsheet - Most Common Commands

SQL Cheatsheet - Most Common Commands

18
Comments 1
13 min read
Don't ever use LIMIT again!!!

Don't ever use LIMIT again!!!

6
Comments 1
5 min read
Convince me to use SQL

Convince me to use SQL

29
Comments 17
1 min read
Alembic: setting a column to nullable=False if it already has data in it

Alembic: setting a column to nullable=False if it already has data in it

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