TechGuru

In this article we discuss following: SQL Optimize query tips Why Triggers are not Good SQL Optimize query is a highly rated skill in current IT sector. With invention of Relational Database models, demand of Data manipulation and Management also increased. This lead to formulation of a universal language to serve mankind - SQL.  SQL stands for Structured Query Language. SQL is basic language in order to communicate with a RDBMS. Data is present in various inter-connected tables inside a database. Different joining conditions are applied and data is presented in form of crisp Information. SQL: SQL works with famous RDBMS engines such as MS Sql Server, Oracle, MySql and IBM Informix etc etc. Data Manipulation (DML) and Data Definition (DDL) are two basic operations performed using SQL on a database. A basic query to read first 10 records from Customer table is :                               ...