Business Analysis Blog – Techcanvass
Helping you become a better business analyst
LEARN SQL in Detail: SQL tutorial, DECODE in ORACLE, SQL Tutorial for Business Analysts.
This is the third and the concluding part of the SQL tutorial for business analysts. In the first part of this SQL tutorial for Business analysts, you learnt about the basics of a database system and SQL. In the second part of this SQL tutorial for business analysts, you learnt about INSERT, DELETE and CREATE TABLE commands.
In this concluding part, you are going to learn about SELECT command.
SQL is an important skill for every entry level business analyst. In this SQL tutorial for business analysts, you will learn the basics of SQL including database fundamentals, SQL structure and SELECT command. This is a 3-part tutorial series.
In this SQL tutorial on DECODE, we are going to learn about Decode command in SQL (only applicable for Oracle). Every database system has some special and useful SQL commands. Oracle has an extremely powerful command known as DECODE. Please note that, using DECODE command is only possible in Oracle.
This is the second part of SQL Tutorial for beginners. In this first part of this SQL tutorial for beginners, you learnt about the basics of a database system and SQL.
In this part, we are going to learn about CREATE TABLE & INSERT/DELETE commands. These commands are SQL commands and are used to interact with the database. We are going to use W3 School Online SQL editor in this tutorial, so keep it open in another tab in your browser.
by 
