Skip to content
Navigation menu
Search
Powered by
Search
Algolia
Search
Log in
Create account
DEV Community
Close
select * from SQL
Follow
Hide
Posts on tips and tricks, using and learning about SQL for database development and analysis.
Posts
Left menu
👋
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
Materialized Views in SQL | Best Explanation
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 12
Materialized Views in SQL | Best Explanation
#
sql
#
data
#
webdev
#
database
5
reactions
Comments
Add Comment
3 min read
Difference between GROUP BY and DISTINCT in SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 12
Difference between GROUP BY and DISTINCT in SQL
#
sql
#
database
#
oracle
#
fullstack
Comments
Add Comment
1 min read
Materialized View in SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 12
Materialized View in SQL
#
sql
#
data
#
database
#
fullstack
Comments
Add Comment
5 min read
RAISE_APPLICATION_ERROR and PRAGMA EXCEPTION_INIT in PLSQL EXCEPT HANDLING
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 12
RAISE_APPLICATION_ERROR and PRAGMA EXCEPTION_INIT in PLSQL EXCEPT HANDLING
#
beginners
#
sql
#
oracle
#
fullstack
1
reaction
Comments
Add Comment
3 min read
Convert CSV Data into Multilevel JSON #eg56
Judy
Judy
Judy
Follow
Oct 12
Convert CSV Data into Multilevel JSON #eg56
#
sql
#
json
#
csv
#
esproc
5
reactions
Comments
Add Comment
1 min read
Aggregate function & Windows functions
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 12
Aggregate function & Windows functions
#
sql
#
database
#
oracle
#
fullstack
Comments
Add Comment
2 min read
SQL vs. NoSQL: Key Differences, Use Cases, and Choosing the Right Database for Your Project
Aditya Pratap Bhuyan
Aditya Pratap Bhuyan
Aditya Pratap Bhuyan
Follow
Oct 10
SQL vs. NoSQL: Key Differences, Use Cases, and Choosing the Right Database for Your Project
#
sql
#
nosql
#
database
Comments
Add Comment
5 min read
B-tree index in ORACLE SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 9
B-tree index in ORACLE SQL
#
sql
#
backend
#
fullstack
#
database
Comments
Add Comment
2 min read
Concurrency Issues in SQL and Distributed Systems
Adam Furmanek
Adam Furmanek
Adam Furmanek
Follow
for
Metis
Oct 9
Concurrency Issues in SQL and Distributed Systems
#
sql
#
database
#
distributedsystems
Comments
Add Comment
25 min read
Sequence in SQL | PART 2
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 8
Sequence in SQL | PART 2
#
sql
#
beginners
#
tutorial
#
devops
Comments
Add Comment
3 min read
Understanding SQL Queries: A Beginner’s Guide pt1
marco cabrera
marco cabrera
marco cabrera
Follow
Oct 8
Understanding SQL Queries: A Beginner’s Guide pt1
#
sql
#
sqlserver
#
tutorial
#
learning
Comments
Add Comment
4 min read
Partitioning in Oracle SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 8
Partitioning in Oracle SQL
#
sql
#
beginners
#
devops
#
opensource
Comments
Add Comment
2 min read
B-Tree Index and Bitmap Index in ORACLE SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 8
B-Tree Index and Bitmap Index in ORACLE SQL
#
sql
#
beginners
#
fullstack
#
programming
Comments
Add Comment
2 min read
Criando um Simulador de Banco de Dados em Rust: Parsing, Compilação e Execução de Consultas SQL
Rafael Toledo
Rafael Toledo
Rafael Toledo
Follow
Oct 7
Criando um Simulador de Banco de Dados em Rust: Parsing, Compilação e Execução de Consultas SQL
#
rust
#
sql
Comments
Add Comment
3 min read
Using a PostgreSQL enum for state
Brian Douglas
Brian Douglas
Brian Douglas
Follow
Oct 7
Using a PostgreSQL enum for state
#
sql
#
postgres
#
postgressql
Comments
Add Comment
2 min read
Relationships in databases
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 11
Relationships in databases
#
sql
#
database
#
fullstack
#
oracle
8
reactions
Comments
Add Comment
2 min read
SQL 101: Introduction to Structured Query Language
Brigit Melbride
Brigit Melbride
Brigit Melbride
Follow
Oct 7
SQL 101: Introduction to Structured Query Language
#
sql
1
reaction
Comments
Add Comment
3 min read
Oracle SQL - Cardinality & Cost
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 6
Oracle SQL - Cardinality & Cost
#
sql
#
beginners
#
programming
#
tutorial
6
reactions
Comments
Add Comment
2 min read
CPU SIMULATOR
Brandon(Zoobob5)
Brandon(Zoobob5)
Brandon(Zoobob5)
Follow
Oct 10
CPU SIMULATOR
#
python
#
sql
#
github
#
git
1
reaction
Comments
4
comments
1 min read
Creating a backup table in ORACLE SQL
