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.
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.
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.
To edit SQL you can use a text editor. Professional developers use one of next text based IDE:
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