DEV Community

loading...

select * from SQL

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

👋 Sign in for the ability sort posts by top and latest.
SQL Performance Resources

SQL Performance Resources

Reactions 2 Comments
10 min read
SQL - NOT REALLY LANGUAGE.

SQL - NOT REALLY LANGUAGE.

Reactions 3 Comments
2 min read
CS50x 2021 - WEEK 7 (SQL)

CS50x 2021 - WEEK 7 (SQL)

Reactions 2 Comments
2 min read
Understanding Data and Databases 101

Understanding Data and Databases 101

Reactions 6 Comments
4 min read
How to Run Spark SQL on Encrypted Data

How to Run Spark SQL on Encrypted Data

Reactions 4 Comments
6 min read
Additional Column for Incremental Numbering in SQL

Additional Column for Incremental Numbering in SQL

Reactions 5 Comments 2
1 min read
Want to convert any SQL Query to Mongo DB Query - Shortcut

Want to convert any SQL Query to Mongo DB Query - Shortcut

Reactions 2 Comments
1 min read
JSON + MariaDB: How Hybrid Data Models Allow You to Have Your Cake and Eat It Too

JSON + MariaDB: How Hybrid Data Models Allow You to Have Your Cake and Eat It Too

Reactions 6 Comments
10 min read
Rapidly Build Prototypes With Your Team Using Repl.it, Airtable, and Sync Inc

Rapidly Build Prototypes With Your Team Using Repl.it, Airtable, and Sync Inc

Reactions 4 Comments
8 min read
SQL Injection in Java

SQL Injection in Java

Reactions 5 Comments
2 min read
Security Checklist - More than 70 security items to validate your database

Security Checklist - More than 70 security items to validate your database

Reactions 12 Comments
2 min read
SQL Server Recovery Models: A Quick Guide

SQL Server Recovery Models: A Quick Guide

Reactions 4 Comments
7 min read
The Art of Mapping Globals to Classes 1 of 3

The Art of Mapping Globals to Classes 1 of 3

Reactions 3 Comments
7 min read
Types of organization of records in files

Types of organization of records in files

Reactions 2 Comments
1 min read
Musings about Database Indexes

Musings about Database Indexes

Reactions 5 Comments
4 min read
My Favorite Free SQL Courses for Beginners

My Favorite Free SQL Courses for Beginners

Reactions 42 Comments
12 min read
Airbnb Properties in Australia

Airbnb Properties in Australia

Reactions 5 Comments
7 min read
Create a Query Builder with PHP and SQL

Create a Query Builder with PHP and SQL

Reactions 3 Comments 3
3 min read
SQL & database monthly wrap up - July 2021

SQL & database monthly wrap up - July 2021

Reactions 17 Comments 1
2 min read
jOOQ on YugabyteDB

jOOQ on YugabyteDB

Reactions 2 Comments
5 min read
Arctype connects to YugabyteDB

Arctype connects to YugabyteDB

Reactions 2 Comments
6 min read
SQL query builders

SQL query builders

Reactions 3 Comments 2
5 min read
Creating a CRUD App using Flask and SqlAlchemy

Creating a CRUD App using Flask and SqlAlchemy

Reactions 2 Comments