Sometimes we need to backup a procedure, a package, a function, etc. (the so-called metadata) so that we can see its code or keep it somewhere so that we can restore it if necessary. In this article we will see… read more
How to write advanced SQL queries
In a previous article we analyzed what SQL (Structured Query Language) is and how it is used with basic examples. In this article we will see its more advanced functions. The code is written with the Transact-SQL extension… read more
What are SQL Joins and how tables are related to each other
Relational databases rely on relationships between their entities (tables and views). However, in order to be able to call associated records from two or more tables / views above, we must somehow declare with which field... read more
How do we backup a database that is in no-archive-log mode in Oracle
In this article we will analyze what it takes to take an offline backup of an Oracle database that is in no-archive-log mode. As the base does not keep the redo logs as an archive, we do not have the option for online... read more
What is a Data Warehouse?
In this article we will analyze what Data Warehouse is, what it consists of and what is its usefulness. In the age of IT, managing the ever-increasing data is becoming more and more difficult. We want to leverage the data… read more
How do we load files (csv, txt) into Oracle database
It is possible to import files like csv and txt into an oracle database table. There are two similar ways. Using SQL*Loader or using External Table. Their mode of operation is similar, but depending on the case, it is more suitable... read more
What is Oracle Data Guard
Data Guard is Oracle's database solution for high availability and disaster recovery. In the article we will analyze how it works and the types it has. In its use we define our production base as primary… read more
What is SQL and what can it do?
We have seen what databases are but in order to use them we must somehow be able to export or import data from them. How is this possible? With Structured Query Language or SQL. It is her main… read more
How databases are stored and what indexes are
We have seen what a relational database is and that our entities are logical objects called tables. But how are they stored “physically” in an RDBMS (relational database management system)? Tables as objects are stored and… read more
