oracle or sql?

Question

what exactly is the difference between oracle and SQL. and which is better from job prospect. plz give me dsome info
ty

Answer 1

SQL

this is Structured Query Language.

it is, as the name indicates, a language to retrieve from and manipulate data in a (relational) database.



Oracle

Oracle is the 2nd largest software company in the world, after Makes $h!t and their most renown product is their database, which you can access with SQL.



but this is the case for almost every database, SQL-Server / Adaptive Server Enterprise from Sybase, MySQL, Progress, Ingres, DB2 / UDB from IBM and many more.



thus, knowing SQL usually is a prerequisite to be a database administrator, but in itself is hardly worth anything, on the labor market, mostly because SQL is only a minute part of the database administrator job.



thus, get a good look at SQL and move on to Oracle, which is, indeed, the most commonly used database.



be aware, however, that becoming a database administrator requires a lot more then SQL.

Answer 2

For entry-level, go with MS SQL. Not that it's a better system, just that I think it's a better bet for somebody in your (presumable) position. Here's why:



As others have pointed out, SQL is a language. You probably mean Microsoft's annoyingly-named Microsoft SQL Server (2xxx) which is not a server but an application (a database engine) with deep server hooks which runs on Microsoft Server (2xxx), a server OS. Ugh.

So MS SQL and Oracle (which runs on various server OSs) are two database engines which can host your database instances, which is wehere the interesting part of database operations begins.



SQL is implemented differently inOracle and MS SQL, but it remains the same language. Think of the two as different dialects.



For job prospects, I would say that MS SQL is more likely to be productive (meaning get you a job) for an entry-level applicant, which it sounds like you would be. Not only is it more common, but the educational resources are far easier to come by. Oracle may (or may not anymore, things are changing) be more used in big-iron, Fortune 500 situations, but MS SQL can commonly be seen powering the inventory needs of a local chain or even a large individual store. Don;t get me wrong, MS SQL can scale up to ridiculously large just as well as Oracle (to my eye), but you are asking about differences, not similarities. You won't find many small shops running Oracle, and maybe not even medium (regional). SO while Oracle is a great and robust product with a lot of features missing* from MS SQL, so does MS SQL have a larger installed base and the most modern accessorized SQL, called "T-SQL" (Google that for a LOT more information). Both of these make me view Oracle as a great option for somebody who already knows a bit about SQL itself and the issues which arise in trying make databases actually work for the company and the customers, not just theoretically in the classroom SQL sense. This is where the actual Server OS and the middle ground of DBA work makes its real money.

See, anybody can get good at SQL, but making the SQL translate into satisfaction means dealing with the rest of the system. This skill set is better developed in a single-vendor environment with the massive educational resources available to Microsoft practitioners. Later on I would recommend learning Oracle as an extension of your solid skill base.

So, the two systems are not exclusive, but easily support a progression in learning. You can do it either way, but I think that the MS SQL route will yield better results early on.



*Both languages have progressed much, but some of the more praiseworthy special features are more common in the installed base of legacy versions of Oracle.

Answer 3

Different companies. Different programs that do the same thing. Oracle means that you are more specialized. SQL is everywhere. People who do Oracle usually know SQL, but people who do SQL don't know Oracle very much. They are good for job prospects if you are certified and can develop programs and not just manage them.



I think Oracle is a little cheaper than SQL, not sure.

Answer 4

sq. is in basic terms a language. in case you go with to artwork interior the worldwide of relational databases, then you could desire to first get a stable understanding of the relational variety and how it is used in sq.. those foundations are the comparable for all relational databases (Oracle, sq. Server, MYSQL, Postgres etc). Then there are obvious considerable adjustments interior the dialects used via each and every database (incredibly while it is composed of stored innovations), and much extra considerable adjustments of their inner implementations (truly interior the way the look after concurrency and consistency, i.e. locking and transaction isolation). so a procedures as employment, i could say the two sq. Server and Oracle are extensively used. the main considerable distinction is that sq. Server locks you interior the Microsoft worldwide (it is wonderful if it is what you go with) while you will discover Oracle used in a miles better diversity of structures (living house windows, Linux, Solaris, HP-UX; AIX, etc). additionally Oracle has a tendency for use for extra suitable, venture-serious applications, while sq. Server has a tendency for use extra for much less complicated departmental applications.