category
Home / DeveloperSection / Category
MindStick NoSQL vs. SQL Databases: What to know?
SQL and NoSQL databases each provide their own advantages and disadvantages. Learn more about each one, including their structures, scalability, and use cases.
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
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
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
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
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
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
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
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
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
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
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.