Problem solve Get help with specific problems with your technologies, process and projects.

Learning more about data warehousing and Teradata

I'm working on Oracle (SQL and PL/SQL) right now. I want to know how this will help me to learn about data warehousing. Also, what is Teradata?

I'm working on Oracle (SQL and PL/SQL) right now. I want to know how this will help me to learn about data warehousing. What is Teradata? At this stage can I learn Teradata? According to the market where I'll be I should, after two years, be working on Teradata?
SQL is a language designed to efficiently interact with a relational database system. There are standards in place so that learning SQL for one database system means you know how to interact with another database system. That being said, not all database vendors implement every standard, so not every SQL statement will work in every database system.

PL/SQL is an Oracle-specific language. PL/SQL is Oracle's procedural extension to SQL. With PL/SQL, you can use variables, perform actions in loops, call subroutines and perform conditional (IF-THEN-ELSE) branching.

In order to be a top-notch Oracle professional, one needs to know SQL and PL/SQL pretty well. Learning SQL and PL/SQL does not mean an automatic transition to data warehousing. You must know SQL and PL/SQL to interact with the Oracle database whether it is being used as a data warehouse or an OLTP system. So if you are interested in data warehousing, learn SQL and PL/SQL.

Teradata is a company that competes with Oracle Corporation. Teradata's database system is specifically designed to hold large quantities of data. Teradata systems do not work well for OLTP systems, those with short, quick transactions. Oracle's database system is designed to meet all needs. There are many Teradata data warehouses in use today. And there are many Oracle data warehouses out there too.

I'm not sure what the market for Teradata is. I only have a passing interest in Teradata so I do not keep up on it nearly as much as I do with Oracle.

Dig Deeper on Oracle and SQL

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.