Handling Dates and Times in Oracle Database
January 21, 2025
Master handling dates and times in oracle database with comprehensive examples and best practices. Learn 1. SYSDATE and CURRENT_DATE, 2.
#sql#database#oracle
The newsletter
Data in the Age of AI
Exploring how AI is reshaping business intelligence, data architecture, and the way organizations work with data. Get new essays from @Jin delivered to your inbox.
Visit the publication on Substack →From the archive
Latest writing
SQL Transactions - COMMIT, ROLLBACK, and Savepoints with Python
January 20, 2025
In modern database development, tools like DataGrip make transaction handling easier by providing graphical interfaces to commit, rollback, or set savepoints.
#python#database#sql
SQL Recursive Queries - Understanding Common Table Expressions (CTEs)
January 16, 2025
Master sql recursive queries - understanding common table expressions (ctes) with practical SQL examples. This tutorial covers 1.
#sql#database#oracle
SQL Performance Tuning: Best Practices for Faster Queries
January 15, 2025
Introduction Efficient SQL queries are essential for optimal performance in Oracle databases Features complete code examples and practical implementations.
#sql#database#oracle
Mastering SQL Joins - Inner, Outer, Cross, and Self-Joins with Examples
January 13, 2025
Master mastering sql joins - inner, outer, cross, and self-joins with examples with SQL examples and best practices. Learn Introdution and Sample Tables.
#sql#database#oracle
A Guide to Manage Access in SQL - GRANT, REVOKE, and Access Control
January 6, 2025
Introduction In SQL, controlling access to database objects is crucial for ensuring data security and managing permissions effectively.
#sql#database#tutorial