MySQL | Dataprix TI

Popular today

Don't you have a chop with useful queries to use in your daily adventures and desventures with the database? I include in this first post a…

A very powerful way to do a table's update in a SQL Server database is to link it with another table with a join, and updating the fields…

A simple way to export data from a query, table, etc.. of an oracle database to a flat file is to use the SPOOL command in SQLPlus. This…

The operator to concatenate in SQL Server is '+', but this operator is also used to add values. Being the same operator for both, the…

Data warehouse security is vital for organizations that take the huge step of collating all their important data in one place. Unauthorized…

Db2look is an utility to extract the definition of database objects.

In many cases, especially in ETL processes or data loading to a data warehouse, for example, we would rather use a single sentence or the…

I tried to create a connection in SQL Developer with a remote SQL Server database.

In a Data Warehouse there are a number of common dimensions such as Geographic and Time. I leave here a script to create the Time…

I leave here this link to a page where a small test posed to do in job interviews for database developers. Here this kind of test I do not…

Today's Top Picks for Our Readers:

Recommended by