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.
My Data Analyst Interview Journey and What I Learned

My Data Analyst Interview Journey and What I Learned

1
Comments
4 min read
What else can Stream&Kotlin evolve into?

What else can Stream&Kotlin evolve into?

6
Comments
6 min read
Connecting SQL Databases to the Cloud: PostgreSQL, MySQL, SQLite, and Cloud Integration Explained

Connecting SQL Databases to the Cloud: PostgreSQL, MySQL, SQLite, and Cloud Integration Explained

Comments 1
7 min read
Validatorian

Validatorian

Comments
4 min read
Technical Interview Questions - Part 4 - Git + SQL vs noSQL

Technical Interview Questions - Part 4 - Git + SQL vs noSQL

3
Comments
3 min read
Access Controls for Users and Roles in SQL

Access Controls for Users and Roles in SQL

Comments
6 min read
SQL Server Execution Plans

SQL Server Execution Plans

1
Comments
5 min read
Entendo a ordem de execução de uma query SQL

Entendo a ordem de execução de uma query SQL

1
Comments
2 min read
SQL for Data Validation: Implementing Business Rules and Constraints

SQL for Data Validation: Implementing Business Rules and Constraints

1
Comments
5 min read
On-Demand Refresh | Materialized Views (Mviews) in ORACLE SQL

On-Demand Refresh | Materialized Views (Mviews) in ORACLE SQL

5
Comments
3 min read
Postgres can do that? No surprise Postgres is everywhere

Postgres can do that? No surprise Postgres is everywhere

1
Comments
9 min read
UUID 🪪 or Auto Increment Integer / Serial ⚙️ as the Database Primary Key?

UUID 🪪 or Auto Increment Integer / Serial ⚙️ as the Database Primary Key?

10
Comments
3 min read
SQL Leetcode Questions

SQL Leetcode Questions

37
Comments 2
3 min read
Preventing SQL Injection (SQLi) Attacks in Drupal

Preventing SQL Injection (SQLi) Attacks in Drupal

Comments
3 min read
Concurrency Issues in SQL and Distributed Systems

Concurrency Issues in SQL and Distributed Systems

Comments
25 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.