Structured Query Language (SQL): Introduction.

This is the introduction to a series that will discuss SQL, the widely known language used for relational databases. The Structured Query Language (SQL), a very popular one for interacting with DBMSs (Data Base Management Systems), was developed in the 70s and is currently the standard in the database market. This language, SQL, is used in relational databases, and involves the DB’s definition operations (such as data manipulation). Therefore, knowing this language’s intricacies is an important professional asset for people working in programming and database administration.

Even though it is the standard language for databases, relational or otherwise, SQL has undergone a few specific changes over the years, and depending on the database it can present distinct resources. DBMSs are then the programs you will use to manage the stored data. Among them are Microsoft’s SQL Server, Oracle, and Microsoft Access, which is a desktop database that can be employed in smaller applications. These are some of the DBMSs available in the market, but they are most definitely not the only ones you can use in your project. Extensive content about those and others are available online from various different sources.

After this introduction, in the related articles below, we will continue discussing this language, firstly by demonstrating a few SQL procedures and tips for the SQL Server database. Then, we will also discuss specific topics regarding Elipse E3 and the databases with which it has native connection (SQL Server, Oracle, and Access).

From Elipse E3’s version 6.5 on, we have also included native connection to PostgreSQL and MySQL databases.