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.
What have the STORED PROCEDURES ever done for us?

What have the STORED PROCEDURES ever done for us?

15
Comments 6
4 min read
Adventures in SQL Source Control with SSDT

Adventures in SQL Source Control with SSDT

13
Comments 2
7 min read
T-SQL CRUD procedures auto-generator

T-SQL CRUD procedures auto-generator

39
Comments 2
4 min read
Why you must add relational database development to your toolkit

Why you must add relational database development to your toolkit

5
Comments
5 min read
The Best MYSQL Courses for Beginners

The Best MYSQL Courses for Beginners

12
Comments
5 min read
Using the IFS variable to do things with CSV files

Using the IFS variable to do things with CSV files

5
Comments
5 min read
Optimize multiple INSERTs (for Oracle)

Optimize multiple INSERTs (for Oracle)

7
Comments 4
3 min read
How to Synchronize relational databases with Dotmim.Sync

How to Synchronize relational databases with Dotmim.Sync

23
Comments 6
5 min read
User management for Node.js & MySQL using Sequelize and PassportJS

User management for Node.js & MySQL using Sequelize and PassportJS

35
Comments 6
8 min read
API data persistence with relational databases

API data persistence with relational databases

10
Comments
3 min read
SQL Story of unbroken chains of events (daily/weekly streaks)

SQL Story of unbroken chains of events (daily/weekly streaks)

21
Comments 2
7 min read
Introduction to Profiling and Optimizing SQL Queries for Software Engineers

Introduction to Profiling and Optimizing SQL Queries for Software Engineers

14
Comments 2
11 min read
Complete MySQL Course: Beginner to Advanced

Complete MySQL Course: Beginner to Advanced

30
Comments
1 min read
Notes on Migrating from MS SQL Server to PostgreSQL

Notes on Migrating from MS SQL Server to PostgreSQL

9
Comments
8 min read
API data persistence with relational databases

API data persistence with relational databases

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