Articles Read in June

Reading time ~1 minute

Articles read in June 2013

  1. A Visual Explanation of SQL Joins.

    it explains how INNER JOIN and OUTER JOIN work in a visualized way.

  2. Difference between clustered index and non-clustered index.

    A clustered index is like a dictionary, where all words are sorted in alphabetical order in the entire book. A non-clustered index is like an index in the last pages of a book, where keywords are sorted and contain the page number to the material of the book for faster reference.

  3. What is SOA.

    SOA is supposed to solve this(hundreds of separate apps that are insufficiently integrated) by designing every app from the ground up to publish its services in a standardized, cross-platfrom manner so that other apps can access the data and don’t have to duplicate it.