The Structured Query Language (SQL) is used to communicate with a database, therefore it is more than useful for our projects. To be more precise, TNation employees used SQL statements to perform tasks, such as to update data on a database, or retrieve data from a database. In other words, it is used for storing, manipulating and retrieving data in databases. However, Structured Query Language tutorial covers enormous amount of options that can be used to accomplish almost everything that one needs to do with a database, so we divided the material into several series of workshops.
This was the second SQL workshop, which was focused on several issues: primary keys, foreign keys, indexes, views, sub-queries, functions, procedures and triggers.
Uroš Stepanović, developer and the lecturer of the workshop, provided many possible options in the most efficient way to use this structured query language. Our employees gained skills for managing data held in a relational database management system.
The major benefit of the workshop is that this domain-specific language can be used in various number of database systems, such as MySQL, SQL server, Microsoft SQL Server, Oracle, Sybase, Informix, Access, Ingres,Postgres, etc.
The next Structured Query Language workshop for the TNation employees is planned to be held soon.