Sage-Code Laboratory

Database Management

Creating and maintaining relational databases requires SQL. This is a 5'th generation, declarative, domain specific programming language. It stands for Structured Query Language. You can use SQL with a CLI app or you can embed SQL in application developement.

Video Lecture

If you have the bandwidth, you can watch the next video to learn SQL fundamental concepts. This film is 10 min long, it has no ads and is very informative for beginners. It was filmed by Elucian Moise in Jun 2016. Yet is good enaugh for you to get started.

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


Prep Quiz

Next quiz is designed for mobile or tablet. It has 20 questions, 100 points. Some questions have more than one answer correct. Don't miss the second answer! The quiz does not have a time limit, but it requires you to sign-in using your Google account.
SQL Quiz

SQL Quiz

Privacy Terms: We record your name with the test results on Google drive. If you take more than 80% we will recognize your skill and will endorse you on Linked-in. If you don't agree, you can use name: Anonymous but then we can't endorse your new skills.

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:


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