Archive

Archive for the 'SQL'

SQL - Lez. 1: Introduction and SQL statements

Requirements: No requirements

I decided to write this tutorial, divided into several classes, for the understanding of SQL, as by his instructions in a few steps we can issue commands that would otherwise need to perhaps tens of lines of code, not counting the number of variables use. Furthermore, the code we're going to write the script will be much more compact and readable by anyone. Continue reading ...

Tag: , Categories: SQL Tags: ,

SQL - Lez. 2: Data types and keywords

Requirements: no requirements

In this lecture we will present the SQL data types and provide a list of language keywords.

Data Types

There are three main types of data:

  • Numbers;
  • Characters;
  • Time;

The first category those represented by integers or floating point.
In the second category, we can enclose individual characters or strings.
In the latter case, enclose the dates, times and intervals.

Continue reading ...

Tag: , Categories: SQL Tags: ,