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.
Understanding ACID Properties with SQL Transactions

Understanding ACID Properties with SQL Transactions

1
Comments
3 min read
SQL Commands Explained: DDL vs DML vs DQL vs DCL vs TCL

SQL Commands Explained: DDL vs DML vs DQL vs DCL vs TCL

1
Comments
3 min read
A simplified definition of an ORM

A simplified definition of an ORM

Comments
2 min read
Database VIEW tutorial

Database VIEW tutorial

Comments
3 min read
Database Normalization

Database Normalization

8
Comments 1
3 min read
From Kafka to Clean Tables: Building a Confluent Snowflake Pipeline with Streams & Tasks

From Kafka to Clean Tables: Building a Confluent Snowflake Pipeline with Streams & Tasks

4
Comments 1
10 min read
Understanding the Difference Between Tables and Views (Bite-size Article)

Understanding the Difference Between Tables and Views (Bite-size Article)

Comments
4 min read
SQL JOIN

SQL JOIN

Comments
3 min read
How to Create Custom Data Types in DbSchema

How to Create Custom Data Types in DbSchema

7
Comments
3 min read
SQL Query optimization techniques

SQL Query optimization techniques

Comments
3 min read
🚀 My Python Practice – Day 1

🚀 My Python Practice – Day 1

1
Comments 1
1 min read
🚀 Learning Update

🚀 Learning Update

1
Comments
1 min read
Understanding Databases: SQL, NoSQL, Schemas,DDL, and DML

Understanding Databases: SQL, NoSQL, Schemas,DDL, and DML

1
Comments
4 min read
Stop Juggling SQL Scripts: Introducing Zync, the Database Package Manager

Stop Juggling SQL Scripts: Introducing Zync, the Database Package Manager

3
Comments 3
4 min read
How AI Helped a Developer Master SQL Server Performance Optimization Without DBA Training

How AI Helped a Developer Master SQL Server Performance Optimization Without DBA Training

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