3 replies to this topic

[kpmfazal]

Hi All,

I am a college student from India and electronics is my stream of study but have most interest on Programming.

I have some basic programming knowledge on C/C++, but I have some doubts.

1. I wanted to do some certification in Oracle Database, I have found there is 3 Certification areas within it, such as Oracle Database Administration, Application Development and Implementation [ refer: Oracle University Select country ]

2. What is the difference between MYSQL and Oracle Database and PL/SQL?

3. I have seen some are telling use ORacle DB at backend while developing ASP.NET Internet Forms and Applications ?

4. What really is a Oracle 11g Database ? If we can create form using Oracle 11G suite , why they use .NET for development ?

PLEASE:: I know some questions will be very silly, if I get an elaborate explanation it will be helpful.

[WingedPanther]

1. there's no question here.

2. MySQL and Oracle handle security in rather different ways. They also have different ways of handling dates, and some of the more advanced concepts such as triggers. Generally, the concept exists in both, but the syntax will vary. PL/SQL is an extension of SQL that is specific to Oracle.

3. When using .NET applications, it is very common that you will need to use some sort of database application. Oracel, Microsoft SQL Server, MySQL, Firebird, PostGRESQL, SQLite, and many others are all viable options, depending on the needs.

4. 11g is the version of Oracle server/client. I haven't figured out the pattern to the letter on the end, but I have worked with Oracle 8i, 9i, 10g, and 11g. They're basically the same with various improvements here or there. It's kind of like the difference between SQL Server 2000, 2005, and 2008.

The real reason it's worthwhile to be familiar with Oracle is this: many large corporations that are willing to spend MILLIONS of dollars on software use Oracle for their databases. If you can write your software to use Oracle as the database, then you have the potential to get some large contracts. SQL Server, because it costs about half as much, tends to be used by smaller corporate environments, though some are still quite willing to spend MILLIONS of dollars.

[kpmfazal]

Thanks a lot for your reply.

I forgot to include the question sorry for that,

1. My Question is, which is the better certification option to do ((I wanted to do some certification in Oracle Database, I have found there is 3 Certification areas within it, such as Oracle Database Administration, Application Development and Implementation [ refer: Oracle University Select country ] ))

[WingedPanther]

1) it really depends on what you want to do with it. Database Administration is concerned with security rules, backups, etc, whereas development and implementation is about programming and knowing how to properly format dates, how to handle nulls/empty strings, etc.