SQL stands for Structured Query Language and is the standard relational language that is supported by just about every database product. All database professionals should know how to write, troubleshoot, and optimize SQL.
Our tutorial will start with the basics of SQL, such as how to retrieve and manipulate data. Then we will move to the more advanced topics such as how to create tables and views.
With this tutorial, you should be on your way to becoming proficient in writing, executing, and optimizing SQL.
Prerequisites
There are no prerequisites for this SQL tutorial. You should be able to easily understand this tutorial and learn the basic concepts of SQL as you progress to the more advanced SQL topics.
PLSQL stands for "Procedural Language extensions to SQL", and is an extension of SQL that is used in Oracle. PLSQL is closely integrated into the SQL language, yet it adds programming constructs that are not native to SQL.
Our tutorial will start with the basics of Oracle such as how to retrieve and manipulate data. Then we will move to the more advanced topics such as how to create tables, functions, procedures, triggers, tablespaces, and schemas. We will conclude with a review of the functions that are proprietary to Oracle.
With this tutorial, you should be on your way to becoming proficient in Oracle and PLSQL.
Prerequisites
There are no prerequisites for this Oracle tutorial. You should be able to easily understand this tutorial and learn the basic concepts of Oracle as you progress to the more advanced topics.
No comments:
Post a Comment