Publications
Over 100 articles published in SQL Magazine (DevMedia) over more than a decade, covering Oracle Database, data modeling, high availability, storage, and much more.
Database — Concepts and Modeling
- Fundamental Concepts of Databases
- The History of Databases
- Relational Algebra Tutorial
- SQL Magazine 101 — Introduction to Database Design — Part 1
- SQL Magazine 102 — Introduction to Database Design — Part 2
- SQL Magazine 101 — The Ten Most Common Mistakes in Database Design — Part 1
- SQL Magazine 102 — The Ten Most Common Mistakes in Database Design — Part 2
- Data Normalization and Denormalization
- SQL Magazine 100 — Data Normalization and Denormalization — Part 2
- SQL Magazine 97 — Database: Fundamental Concepts
- Best Practices and Tips for Good Data Modeling
- SQL Magazine 44 — Pre-built Models — Implement and Use!
Database Design (Series)
- SQL Magazine 59 — Database Design — Part 1
- SQL Magazine 60 — Database Design — Part 2
- SQL Magazine 62 — Database Design — Part 3
SQL
- Unraveling SQL — Part 1
- Unraveling SQL — Part 2
- Working with Aggregate Functions in SQL — Part 1
- Working with Aggregate Functions in SQL — Part 2
- SQL Magazine 47 — SQL Magazine Challenge
- SQL Magazine 47 — SQL Magazine Challenge Answer
- SQL Magazine 30 — Company Recruits Challenge Answer
Oracle 9i
- SQL Magazine 12 — Introduction to Oracle 9i
- SQL Magazine 13 — Introduction to Oracle 9i — Part II
- SQL Magazine 14 — Oracle 9i — Part III
- SQL Magazine 13 — Integrating Oracle with MS-Access
- Oracle 9i Network Connections — Part I — Understanding Connections to the DB Server
- Oracle 9i Network Connections — Part II — Terminology and Concepts
- Oracle 9i Network Connections — Part III — Server-side Configuration
- Oracle 9i Network Connections — Part V — Configuring Local Naming (tnsnames.ora)
Oracle 10g
- SQL Magazine 19 — Oracle 10g Database — DBA Guide
- SQL Magazine 37 — Oracle 10g Express Edition
- Using Bind Variables in Oracle
- How to Use Bind Variables Correctly
Oracle — Administration and Performance
- Managing Statistics in Oracle
- Archivelog Mode in Oracle
- How to Handle the Pitfalls When Using Hints
- How to Execute Updates with the UNDO Tablespace
- High Performance with Direct Data Loading
- SQL Magazine 69 — Monitoring an Oracle Database
- SQL Magazine 70 — Cloning an Oracle Database User
- SQL Magazine 46 — Triggers in Oracle
- Today I Am a DBA — An Ode to This Professional
- Worst Practices in Databases
- Worst Practices in Database Manipulation
- How to Avoid Common Database Errors
Oracle — Upgrade 11g to 12c (Series)
Oracle — High Availability (Series)
- High Availability in Oracle Database
- High Availability in Oracle Database — Part 2
- High Availability in Oracle Database — Part 3
Oracle RAC and Virtual Machines (Series)
- Setting Up an Oracle 12c Environment on a Virtual Machine
- Oracle RAC: Installing a Virtual Machine
- Oracle RAC: Installing a Virtual Machine — Part 2
- Oracle RAC: Installing a Virtual Machine — Part 3
Oracle Partitioning (Series)
- Avoid Fragmentation with Oracle Partitioning
- SQL Magazine 105 — Oracle Partitioning
- SQL Magazine 106 — Oracle Partitioning — Part 2
- SQL Magazine 107 — Oracle Partitioning — Part 3
- SQL Magazine 108 — Oracle Partitioning — Part 4
- SQL Magazine 109 — Oracle Partitioning — Part 5
- SQL Magazine 110 — Oracle Partitioning — Part 6
- SQL Magazine 111 — Oracle Partitioning — Part 7
- SQL Magazine 112 — Oracle Partitioning — Part 8
Oracle Scheduler (Series)
- SQL Magazine 105 — Oracle Scheduler: A Complete Guide — Part 1
- SQL Magazine 106 — Oracle Scheduler — Part 2
- SQL Magazine 107 — Oracle Scheduler — Part 3
- SQL Magazine 108 — Oracle Scheduler — Part 4
- SQL Magazine 109 — Oracle Scheduler — Part 5
- SQL Magazine 110 — Oracle Scheduler — Part 6
- SQL Magazine 111 — Oracle Scheduler — Part 7
- SQL Magazine 112 — Oracle Scheduler — Part 8
Storage (Series)
- SQL Magazine 76 — Unraveling Automatic Storage Management — Part 1
- SQL Magazine 77 — Unraveling Automatic Storage Management — Part 2
- SQL Magazine 78 — Unraveling Automatic Storage Management — Part 3
- SQL Magazine 79 — Unraveling Automatic Storage Management — Part 4
- SQL Magazine 80 — Unraveling Automatic Storage Management — Part 5
- SQL Magazine 81 — Unraveling Automatic Storage Management — Part 6
All articles are available on the DevMedia platform. Access the full profile at devmedia.com.br/perfil/ricardo-rezende