Skip to content

DEV Community

select * from SQL

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

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Jimmy Guerrero for YugabyteDB

Aug 27 '20

SQL Tips & Tricks: Counting Rows

#postgres #yugabyte #sql #distributedsystems

5 min read

Aug 26 '20

Machete MySQL(Cheatsheet) level 1

#sql

3 min read

Katie

Aug 26 '20

Reading a datetime with miliseconds into an Oracle DATE

#database #sql #oracle #tips

2 min read

Rana Emad

Aug 24 '20

MySQL Commands You Need To Know To Create A New User

#database #sql #codenewbie #tutorial

2 min read

Abdisalan

Aug 21 '20

SQL Practice Problem to Help You Pass Your Interview

#tutorial #sql

3 min read

Aug 20 '20

Switching the offset for a UTC date in SQL Server

#sql

2 min read

fedeagripa

Aug 20 '20

Reports performance improvement

#rails #ruby #database #sql

1 min read

Helen Anderson for PopSQL

Aug 18 '20

First impressions of PopSQL’s collaborative SQL editor

#sql #database #postgres #popsql

4 min read

Aug 19 '20

Getting to know SQL Server Extended Events

#sql #performance #profiling

7 min read

Your DevOps Guy

Aug 10 '20

How to ace coding interviews. The ultimate guide.

#career #beginners #sql #python

14 min read

Aug 18 '20

Code-First ORM For Go: GORM

#go #tutorial #sql #video

3 min read

Jimmy Guerrero for YugabyteDB

Aug 18 '20

Distributed SQL Tips and Tricks – Aug 17, 2020

#yugabyte #distributedsystems #postgres #sql

4 min read

Francisco

Aug 17 '20

SQL Cheatsheet - Most Common Commands

#postgres #sql #database

13 min read

Mohammad Reza Rahimian Golkhandani

Aug 16 '20

Don't ever use LIMIT again!!!

#database #mongodb #mysql #sql

5 min read

Pacharapol Withayasakpunt

Aug 11 '20

Convince me to use SQL

#discuss #sql #changemymind #database

1 min read

Yuan Gao

Aug 15 '20

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

#python #sql #database

2 min read

Alex Antra

Aug 13 '20

Doing the Impossible, using ASSISTANT to make a SQL Linter (and how you can make it lint whatever you want)

#sql #vscode #tutorial #productivity

7 min read

Davide Mauri for Microsoft Azure

Aug 13 '20

Azure SQL for Beginners - Video Playlist

#sql #azure #beginners

1 min read

Aug 13 '20

SQL Server Profiler, underused and undervalued

#sql #performance #profiling

5 min read

Miqotes

Aug 13 '20

Why SQLite is simple to use!

#sql #activerecord

2 min read

Nicholas Summers

Aug 13 '20

DataGrip: Exporting Data as SQL Batch Inserts (and more)

#database #datagrip #sql #script

2 min read

Jimmy Guerrero for YugabyteDB

Aug 13 '20

Version Control for Distributed SQL Databases with Flyway

#yugabyte #postgres #distributedsystems #sql

6 min read

Ramzi A.

Aug 12 '20

Should I Take the Data Engineer Nano Degree?

#database #aws #python #sql

3 min read

Manish Kumar Shah

Aug 11 '20

Django Same data objects get created every time!

#python #django #sql #webdev

2 min read

Aug 8 '20

4 SQL Tips For Data Scientists And Data Analysts

#sql #database #datascience #postgres

7 min read

loading...