SQL

SQL: Understanding JOINS

SQL JOINS are required when you want to match values from different tables and get the common result out of it. Depending upon various criteria we can used different joins mainly INNER Join, LEFT OUTER Join, RIGHT OUTER Join and FULL OUTER Join. Let us explore each of these type of joins in detail Data […]

SQL: Understanding basics with CRUD Operation

Introduction to SQL SQL or Structured Query Language is the language we use to work with the Relational database. Although the syntax differs from vendor to vendor, but moreover the structure of the language is same. What’s better way to learn a language than actually using it to perform some operation. CRUD Create, Retrieve, Update […]