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 and Relational Databases Explained (By a Non-Developer)

SQL and Relational Databases Explained (By a Non-Developer)

62
Comments 4
7 min read
What is SQL?

What is SQL?

2
Comments 1
2 min read
What is Database?

What is Database?

2
Comments
1 min read
SQL Vs Oracle – Which One Is Better?

SQL Vs Oracle – Which One Is Better?

3
Comments
4 min read
Experiences with coding (SQL based DBs)

Experiences with coding (SQL based DBs)

1
Comments
3 min read
Never Trust User Input

Never Trust User Input

7
Comments 4
3 min read
Database Normalisation (1st-4th N.F.) using an example

Database Normalisation (1st-4th N.F.) using an example

7
Comments
5 min read
What exactly does Indexing in a Database do?

What exactly does Indexing in a Database do?

114
Comments 4
2 min read
Anonymous PL/SQL to write a CSV from SQL

Anonymous PL/SQL to write a CSV from SQL

2
Comments
3 min read
ORA-29283 hello world

ORA-29283 hello world

2
Comments
2 min read
Top 10 SQL Queries to Prepare for Interviews

Top 10 SQL Queries to Prepare for Interviews

16
Comments
3 min read
Let's stop being stupid about security

Let's stop being stupid about security

5
Comments
4 min read
Top Trends in Web Development in 2021

Top Trends in Web Development in 2021

36
Comments 4
3 min read
Promises, Node, Tedious, Azure SQL. Oh My!

Promises, Node, Tedious, Azure SQL. Oh My!

16
Comments
4 min read
How to see a history of queries ran on a SQL server

How to see a history of queries ran on a SQL server

19
Comments 2
2 min read
How to Send a Complex Type List of Objects to SQL Server

How to Send a Complex Type List of Objects to SQL Server

14
Comments 4
5 min read
MySQL

MySQL

4
Comments 4
1 min read
Django ORM Optimization Tips #4 recursive query

Django ORM Optimization Tips #4 recursive query

34
Comments
2 min read
A PostgreSQL-Compatible, Distributed SQL Cheat Sheet: The Basics

A PostgreSQL-Compatible, Distributed SQL Cheat Sheet: The Basics

4
Comments
5 min read
Set up Extended Events in SQL Server

Set up Extended Events in SQL Server

3
Comments 1
5 min read
Introduction to full-text operators and basic search

Introduction to full-text operators and basic search

7
Comments 2
10 min read
Analyzing Data Without Complicated ETLs For Data Scientists

Analyzing Data Without Complicated ETLs For Data Scientists

27
Comments
6 min read
The best way to synchronize (one way) a table in SQL Server

The best way to synchronize (one way) a table in SQL Server

8
Comments
4 min read
Running SQL Migrations Before Booting Docker Compose Services

Running SQL Migrations Before Booting Docker Compose Services

12
Comments
4 min read
Getting Started with IntelliJ IDEA and Distributed SQL

Getting Started with IntelliJ IDEA and Distributed SQL

5
Comments
6 min read
loading...