Skip to content

DEV Community

SQL Commands Series' Articles

Back to Luca Liu's Series

Cover image for A Quick Review of SQL Window Functions with Examples

Luca Liu

Dec 29 '24

A Quick Review of SQL Window Functions with Examples

#sql #database #tutorial #beginners

4 min read

Cover image for A Quick Guide to SQL Data Modification Commands with Examples

Luca Liu

Jan 5

A Quick Guide to SQL Data Modification Commands with Examples

#sql #database #data #tutorial

3 min read

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

Luca Liu

Jan 6

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

#sql #database #tutorial #data

3 min read

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

Luca Liu

Jan 13

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

#sql #database #oracle #tutorial

4 min read

Cover image for SQL Performance Tuning: Best Practices for Faster Queries

Luca Liu

Jan 15

SQL Performance Tuning: Best Practices for Faster Queries

#sql #database #oracle #tutorial

3 min read

Cover image for SQL Recursive Queries - Understanding Common Table Expressions (CTEs)

Luca Liu

Jan 16

SQL Recursive Queries - Understanding Common Table Expressions (CTEs)

#sql #database #oracle #tutorial

2 min read

Cover image for SQL Transactions - COMMIT, ROLLBACK, and Savepoints with Python

Luca Liu

Jan 20

SQL Transactions - COMMIT, ROLLBACK, and Savepoints with Python

#python #database #sql #tutorial

2 min read

Cover image for Handling Dates and Times in Oracle Database

Luca Liu

Jan 21

Handling Dates and Times in Oracle Database

#sql #database #oracle #tutorial

3 min read

Cover image for Implementing Triggers in SQL - Automating Database Actions

Luca Liu

Jan 27

Implementing Triggers in SQL - Automating Database Actions

#sql #database #tutorial

3 min read