Learn How to Code SQL and PL/SQL from Oracle
Alexandre Focante
Senior Solutions Engineer | DevSecOps | Database | Linux | Cloud | SQL & NoSql | Passion for Technology |
** Update from Fev/2018, they keep improving this live tool, and including in their code library many examples and use cases that can be very useful in our everyday tasks. It still worth and more valuable than never!
*********************************************************************
Hi World Out There and Oracle Professionals,
Have you ever heard about LiveSQL from Oracle ?
It's an interactive website focused in test and training of SQL and PL/SQL for anyone and provided by the Oracle Corporation. This is a very important initiative to teach how to CODE for anyone interested in learn/test/interact in SQL and PL/SQL Programming Language.
You can access the website by accessing " livesql.oracle.com". You must have an account with Oracle or you can create one right away.
The initiative covers from beginners to advanced students and professionals that uses or wants to learn coding in SQL and PL/SQL. (*)
(* PL/SQL is a Procedural Language based on SQL for Oracle Databases).
What's really interesting here about the Live SQL website is that you can Share your Code or even participate in the internal community to watch and learn from other's people code.
You can use a "SQL Worksheet" and "SQL Session" to write codes ad-hoc or even you can save your scripts for later use. You can create Database Objects like Table, Views, etc to use in your code. Also you can search for different Scripts, Tutorials and Examples that can be used as Baseline for your study and reference.
There is a " Design" session that you can create a full schema for your code. (Schema in Oracle Database means a collection of Objects like Tables, Views, etc).
The best of all this?
Is totally Free for anyone interested in Learn SQL and PL/SQL language without having to install a full database in your computer or access any server in your company. Its secure and from a simple web browser or even from your tablet or mobile you can learn how to code in those languages.
Thanks Oracle for one more initiative like this. Imagine now to teach a full class in some middle school or universities around the World using just a simple web browser!
Also, you can find all Oracle documentation for many products, including SQL and PL/SQL language at " docs.oracle.com".
Enjoy,
Alexandre Focante
(Senior Oracle Apps DBA and Oracle Certified and Technology Lover!)
Empowering Organizations to Make Informed Decisions | My passion is to bring data to life and great business relationships.
9 年THANK!!
Chief Digital Officer, City of Fort Lauderdale | Smart City Advisor | ERP | Business Transformation | Executive Advisor | Oracle | Practice Director | Mentor | Leader | Team Player | Innovator
9 年Great information! Thank you for sharing.
Thanks for sharing!
Sales Engineer at SolarWinds
9 年Excellent article Mr Focante
Senior Solutions Engineer | DevSecOps | Database | Linux | Cloud | SQL & NoSql | Passion for Technology |
9 年Jorge Adrian Gonzalez Aguirre and Michael Diamond