dbForge Edge: Your Best Universal Tool for Multidatabase Challenges

MySQL, Oracle, PostgreSQL, SQL Server, Tools & technologies

Handling several database management systems simultaneously is inevitable in working on multiple...
Read More

Oracle Data Integrator: A Tutorial Guide to Get Google’s Financial Service Data

Oracle, Tools & technologies

RESTful API is a popular protocol for exchanging data between different applications and systems especially in Web applications. Most...
Read More

9 Best Practices for Writing SQL Queries

Database administation, Database development, MySQL, Oracle, Perfomance Tuning, PostgreSQL, SQL Server, Statements

If you are reading this article, most probably, you are already familiar with SQL. You know how to write basic SQL queries. There are many...
Read More

Virtual Columns and Functional Indexes

Database development, Indexes, MySQL, Oracle, PostgreSQL, SQL Server, Tables

Much too often, we see poorly written complex SQL queries running against the database tables. Such...
Read More

Structured Query Language – Importance of learning SQL

Database administation, Database development, MySQL, Oracle, PostgreSQL, SQL Server • One Comment

Computer programming language is a set of detailed instructions for computers or machines for performing specific actions. Through a...
Read More

Example of Improving Query Performance with Indexes

Database administation, Database development, Indexes, Oracle, Perfomance Tuning

In this article, we’ll look at how an index can improve the query performance. Indexes in Oracle and other databases are objects that...
Read More