SQL Basics (SQL 4 beginners)

  1. Alias - Alias is a shorten name for a table (sometime even a function) that can be used in queries.
  2. JOIN - Let’s find out what is a JOIN and how to use it. The main difference between JOIN and UNION operator is that union combines results vertically, while the JOIN combines result's horizontally. There are different types of JOIN-s depending on the business need and we will discuss about them. Since the databases should be normalized it is essential to use joins to get details for some records.
  3. Keys - A database key provides the possibility to identify, access and update information in a database table. A key is a single field (column) or combination of multiple fields. Its purpose is to access or retrieve data rows from table according to the requirement. The keys are defined in tables to access or sequence the stored data quickly and smoothly. They are also used to create links between different tables.
  4. Normalization - Database normalization is a process used to organize a database into tables and columns. The idea is that a table should be about a specific topic and that and only supporting topics included. Normalization is a systematic approach of decomposing tables to eliminate data redundancy.
  5. NULL - When talking about values in database world there are three possible states. The three states are: there is a value, there is not a value (empty) and the value is NULL (unknown). Let's find out more about the NULL value.
  6. UNION - Let’s find out what is a UNION and what’s the difference between the UNION and the UNION ALL operators. The main difference between UNION and JOIN operator is that union combines results vertically. In simple words, the UNION operator returns results from two or more queries in one result set.
  7. View - A database View is nothing else than a stored query! When you create a database view (CREATE VIEW), the database engine stores the input query and give him a specified name. When you query the view, the database engine take the stored definition of the query and execute it with added statements by you (e.g. ORDER BY, WHERE, etc.) and execute it.