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.
The Cloud Resume Challenge

The Cloud Resume Challenge

19
Comments 3
3 min read
Creating a user registration System Using PHP and Mysql.

Creating a user registration System Using PHP and Mysql.

9
Comments 2
1 min read
Managing resources

Managing resources

2
Comments
1 min read
Faculty Dashboard

Faculty Dashboard

9
Comments
4 min read
SQL: Intro to Wild Cards

SQL: Intro to Wild Cards

6
Comments 2
2 min read
How to change a foreign key constraint in MySQL

How to change a foreign key constraint in MySQL

18
Comments 1
3 min read
Combining SQL and Astronomy

Combining SQL and Astronomy

4
Comments 5
1 min read
Business logic in Stored Procedures?

Business logic in Stored Procedures?

6
Comments 1
2 min read
Insert multiple parents with multiple children in a single stored procedure (SQL Server)

Insert multiple parents with multiple children in a single stored procedure (SQL Server)

9
Comments
3 min read
How to Inspect the SQL Generated by Entity Framework Core using .NET Core's built in Logging

How to Inspect the SQL Generated by Entity Framework Core using .NET Core's built in Logging

31
Comments 17
2 min read
Want to Learn SQL? Here's everything you need to know

Want to Learn SQL? Here's everything you need to know

9
Comments
8 min read
Azure Functions (Serverless) + Entity Framework Core y SQL Azure

Azure Functions (Serverless) + Entity Framework Core y SQL Azure

4
Comments 2
8 min read
entity2sql

entity2sql

7
Comments
2 min read
Embedded database vs Client-Server database (on the same host) performance?

Embedded database vs Client-Server database (on the same host) performance?

3
Comments
1 min read
Data Engineering 101: Automating Your First Data Extract

Data Engineering 101: Automating Your First Data Extract

100
Comments
7 min read
Making GraphQL Magic with Sqlmancer 🧙🔮✨

Making GraphQL Magic with Sqlmancer 🧙🔮✨

9
Comments
6 min read
Basic DB Using SQL Server (Part 7) - Set Operations in SQL

Basic DB Using SQL Server (Part 7) - Set Operations in SQL

6
Comments
6 min read
Basic DB Using SQL Server (Part 6)

Basic DB Using SQL Server (Part 6)

6
Comments
5 min read
Introducing the Full Stack Typing Boilerplate: Once You ORM, You Can't Go Back!

Introducing the Full Stack Typing Boilerplate: Once You ORM, You Can't Go Back!

8
Comments 3
13 min read
Fuzzy Searching with PostgreSQL

Fuzzy Searching with PostgreSQL

80
Comments 4
6 min read
We used CosmosDB instead of a relational database, here's what we went through and learned.

We used CosmosDB instead of a relational database, here's what we went through and learned.

9
Comments 2
4 min read
Dark theme in SQL Server Management Studio

Dark theme in SQL Server Management Studio

9
Comments
2 min read
Hacker-rank SQL Median calculation

Hacker-rank SQL Median calculation

7
Comments
1 min read
My Back-end Adventures - Setting up a local database (Postgres)

My Back-end Adventures - Setting up a local database (Postgres)

9
Comments
4 min read
SQL for dummies

SQL for dummies

9
Comments
5 min read
My Back-end Adventures - Intro

My Back-end Adventures - Intro

37
Comments 5
2 min read
Dapper .NET: Custom Type Handling (aka: solve the Impedance Mismatch)

Dapper .NET: Custom Type Handling (aka: solve the Impedance Mismatch)

9
Comments 2
4 min read
SQL injection for developers

SQL injection for developers

128
Comments 5
12 min read
What is the best way store column metadata in SQLite (like, is JSON or is Date)

What is the best way store column metadata in SQLite (like, is JSON or is Date)

7
Comments 6
1 min read
Jupyter Notebooks + IBMi

Jupyter Notebooks + IBMi

14
Comments 2
4 min read
Live Annotated Coding Interviews: SQL, Python and Javascript 1:36:36

Live Annotated Coding Interviews: SQL, Python and Javascript

37
Comments 2
3 min read
Understand SQL JOIN with this simple tutorial and don't fail as I did

Understand SQL JOIN with this simple tutorial and don't fail as I did

58
Comments
5 min read
Azure SQL and Site Reliability

Azure SQL and Site Reliability

13
Comments
8 min read
What SQLite CAN actually do

What SQLite CAN actually do

33
Comments 1
3 min read
Avoid This Mistake When Restoring a TDE Protected Database to a New Server

Avoid This Mistake When Restoring a TDE Protected Database to a New Server

5
Comments
3 min read
Quick and Easy, Exactly-Once, Distributed Work Queues Using Serializable Transactions

Quick and Easy, Exactly-Once, Distributed Work Queues Using Serializable Transactions

20
Comments 4
5 min read
Exploring Column Families in CockroachDB

Exploring Column Families in CockroachDB

8
Comments
2 min read
A Primer on Relational Databases for Beginners by a Beginner

A Primer on Relational Databases for Beginners by a Beginner

6
Comments
8 min read
Getting query performance stats with PostgreSQL

Getting query performance stats with PostgreSQL

20
Comments 1
6 min read
Hierarchical Queries in SQL with C# and Entity Framework Core

Hierarchical Queries in SQL with C# and Entity Framework Core

7
Comments
1 min read
A workout routine with Oracle DEV GYM

A workout routine with Oracle DEV GYM

3
Comments 3
1 min read
SQL DB Backups to Azure Storage with Powershell

SQL DB Backups to Azure Storage with Powershell

6
Comments
2 min read
How to do upserts in Knex.js (PostgreSQL)

How to do upserts in Knex.js (PostgreSQL)

32
Comments 4
3 min read
MySQLDump.js

MySQLDump.js

4
Comments
1 min read
Sending a Text Message with SQL (IBMi)

Sending a Text Message with SQL (IBMi)

10
Comments
4 min read
Use Dash to Build BigQuery-Connected Python Web Apps

Use Dash to Build BigQuery-Connected Python Web Apps

6
Comments
3 min read
Remove Duplicate Records via SQL Server's Rank Function

Remove Duplicate Records via SQL Server's Rank Function

6
Comments 2
3 min read
Translate rails query to raw sql in rails console

Translate rails query to raw sql in rails console

8
Comments
1 min read
CSV to SQL import using Node, Express and React

CSV to SQL import using Node, Express and React

3
Comments 4
3 min read
E5 - Save Order in Database

E5 - Save Order in Database

3
Comments
3 min read
Should I install SSMS on a server running SQL Server?

Should I install SSMS on a server running SQL Server?

6
Comments 3
5 min read
Migrondi, Simple SQL migrations tool

Migrondi, Simple SQL migrations tool

9
Comments
5 min read
Getting Started with MariaDB using Docker and Node.js

Getting Started with MariaDB using Docker and Node.js

21
Comments 2
4 min read
How Often Do You Dream In Code?

How Often Do You Dream In Code?

4
Comments 8
1 min read
Learn Web Development for Free

Learn Web Development for Free

115
Comments 6
8 min read
Dapper.NET: Custom Columns Mapping

Dapper.NET: Custom Columns Mapping

5
Comments
4 min read
What's an ACID compliant database?

What's an ACID compliant database?

10
Comments
6 min read
Pocket Guide on Sequelize ORM for NodeJS

Pocket Guide on Sequelize ORM for NodeJS

17
Comments
12 min read
How to Get Started with Time-Series Data Analysis: Resources Roundup

How to Get Started with Time-Series Data Analysis: Resources Roundup

4
Comments
6 min read
60 lines of code Web crawler and search bar with Wget and Manticore

60 lines of code Web crawler and search bar with Wget and Manticore

9
Comments
7 min read
loading...