Sage-Code Laboratory

What is SQL?

SQL stands for "Structured Query Languages". It is a briliant declarative language used for data query and manipulation. This language is ANSI standard and is implemented by many commercial and open source databases. You can use SQL for rapid developement of commands and scripts that can create and maintain a relational database.

Video Lecture

If you have the bandwith, you can watch the next video to learn SQL fundamental concepts. This film is 10 min long, it has no adds and is very informative for beginners. It was filmed by Elucian Moise in Jun 2016. Elucian is PL/SQL specialist.

SQL Tutorial

Learning MySQL

In the next tutorial you will learn about a relational databases called MySQL. We organize pages by life cycle to learn how to create, operate and maintain a database. If you are first time here, ignore the index for now and continue reading. You can use it later, if you wish to continue study after a break.

MySQL Index


Learning PL/SQL

PL/SQL is a fast procedural language derived from ADA and combined with SQL. The name comest from: Procedural Language (PL) for SQL. It enable embeded SQL to work with a full turing complete language. In next tutorial we will describe the language syntax from A to Z so you can create efficient stored procedures.

PL/SQL Index:

Scripting Editors

To edit SQL you can use a text editor. Professional developers use one of next text based IDE:


External References

After you have selected you database, you will find specific documentation for SQL and PL/SQL dialect. This is a good resource you must bookmark and study before starting your project. Notice sometimes the documentation have different versions. Make sure you learn for the version you are going to use. Maria DB and MySQL DB are very similar but Postgre SQL and Oracle SQL are different.


Read next: SQL Overview