category

Home / DeveloperSection / Category

How to optimize SQL query?
How to optimize SQL query?

SQL Query optimization is the iteratively enhancing the performance of a query in terms of execution time, the number of disk accesses, etc. Let's see how!

Oracle to MySQL: The pros and cons of migration
Oracle to MySQL: The pros and cons of migration

Admittedly, the complex manual process of migration between Oracle and MySQL is enough to deter the migration process

4 Super Fast and Easy Ways to Make Money Using the Internet
4 Super Fast and Easy Ways to Make Money Using the Internet

The Internet is not only a great place to go for information and to communicate with others but it also allows us a great opportunity to be able to

Oracle Data Integrator University Training
Oracle Data Integrator University Training

You get many benefits by Investing in Oracle Training. Millions of professionals around the world take online Training by Oracle University. That is every course is Designed for maximizing your thinking.

All you need to know about a Career in SQL
All you need to know about a Career in SQL

SQL means Structured Query Language. It is a domain-specific language which is used for communications and also manipulation of data which is stored

View in SQL
View in SQL

A view is a SQL statement which is stored in the database with a name. A view is actually a formation of a table in the form of a predefined Structured Query Language (SQL) query.

Trigger In SQL
Trigger In SQL

Triggers are store procedure, which are automatically executed or fired when some events occur like deletion, insertion of data. Triggers are database object which is attached to a table and is executed automatically.

SQL Constraints
SQL Constraints

Constraints are used to apply some rules for the record in a table. If any rule is violated between constraint and data, then the action is aborted by the constraint.

SQL Queries
SQL Queries

In previous article we have discussed about SQL and some queries. In this part we will continue on SQL Queries: Customer IdNameAddressContact  Marks

Introduction to SQL
Introduction to SQL

SQL stands for Structured Query Language. The structured query language is used to manipulate and access the databases. SQL is an ANSI (American National Standard Institute) standard.

SQL Functions
SQL Functions

These functions return a single value, calculated from the values in the column.Scalar functions return a single value, based on input data. Following are the various types of scalar functions.