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

You can learn SQL fundamental concepts on YouTube. 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 before diving into text articles.

SQL Tutorial

▶ Introduction to SQL

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:

Prep Quiz

Next quiz is designed for mobile or tablet. Some questions have more than one answer correct. Don't miss the second answer! You can score 100 points in total. Be happy if you can score 80. In this case we recognize you as PL/SQL developer and you can claim your qualification certificate. The quiz does not have a time limit, but it requires you to sign-in using your Google account.
SQL Quiz

Start PL/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.

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