DEV Community

SQL Commands Series' Articles

Back to Luca Liu's Series
A Quick Review of SQL Window Functions with Examples
Cover image for A Quick Review of SQL Window Functions with Examples
luca1iu profile

A Quick Review of SQL Window Functions with Examples

#sql #database #tutorial #beginners
24
Comments 6
4 min read
A Quick Guide to SQL Data Modification Commands with Examples
Cover image for A Quick Guide to SQL Data Modification Commands with Examples
luca1iu profile

A Quick Guide to SQL Data Modification Commands with Examples

#sql #database #data #tutorial
2
Comments
3 min read
A Guide to Manage Access in SQL - GRANT, REVOKE, and Access Control
Cover image for A Guide to Manage Access in SQL - GRANT, REVOKE, and Access Control
luca1iu profile

A Guide to Manage Access in SQL - GRANT, REVOKE, and Access Control

#sql #database #tutorial #data
1
Comments
3 min read
Mastering SQL Joins - Inner, Outer, Cross, and Self-Joins with Examples
Cover image for Mastering SQL Joins - Inner, Outer, Cross, and Self-Joins with Examples
luca1iu profile

Mastering SQL Joins - Inner, Outer, Cross, and Self-Joins with Examples

#sql #database #oracle #tutorial
4
Comments
4 min read
SQL Performance Tuning: Best Practices for Faster Queries
Cover image for SQL Performance Tuning: Best Practices for Faster Queries
luca1iu profile

SQL Performance Tuning: Best Practices for Faster Queries

#sql #database #oracle #tutorial
1
Comments 1
3 min read
SQL Recursive Queries - Understanding Common Table Expressions (CTEs)
Cover image for SQL Recursive Queries - Understanding Common Table Expressions (CTEs)
luca1iu profile

SQL Recursive Queries - Understanding Common Table Expressions (CTEs)

#sql #database #oracle #tutorial
44
Comments 5
2 min read
SQL Transactions - COMMIT, ROLLBACK, and Savepoints with Python
Cover image for SQL Transactions - COMMIT, ROLLBACK, and Savepoints with Python
luca1iu profile

SQL Transactions - COMMIT, ROLLBACK, and Savepoints with Python

#python #database #sql #tutorial
1
Comments
2 min read
Handling Dates and Times in Oracle Database
Cover image for Handling Dates and Times in Oracle Database
luca1iu profile

Handling Dates and Times in Oracle Database

#sql #database #oracle #tutorial
3
Comments
3 min read
Implementing Triggers in SQL - Automating Database Actions
Cover image for Implementing Triggers in SQL - Automating Database Actions
luca1iu profile

Implementing Triggers in SQL - Automating Database Actions

#sql #database #tutorial
1
Comments
3 min read
Database Design Principles - Normalization and Denormalization
Cover image for Database Design Principles - Normalization and Denormalization
luca1iu profile

Database Design Principles - Normalization and Denormalization

#sql #database #tutorial
Comments
3 min read
SQL Advanced Functions - CASE, COALESCE, and NULLIF Explained
Cover image for SQL Advanced Functions - CASE, COALESCE, and NULLIF Explained
luca1iu profile

SQL Advanced Functions - CASE, COALESCE, and NULLIF Explained

#sql #database #tutorial
Comments
3 min read
Data Security in SQL: Encryption, Roles, and Permissions
Cover image for Data Security in SQL: Encryption, Roles, and Permissions
luca1iu profile

Data Security in SQL: Encryption, Roles, and Permissions

#database #tutorial #sql #data
Comments
2 min read