473,597 Members | 2,804 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ORACLE or SQL SERVER (MS) ?

Which would be a more useful relational database server to learn
nowadays: MS SQL SERVER or ORACLE?

Thanks!
Jul 20 '05 #1
35 3488
By "useful" I take it you mean which has the best career prospects.

Both are leading, industry standard RDBMSs with good career opportunities.
Oracle is the acknowledged market leader. SQLServer is sometimes claimed to
have the fastest growing market share.

It's often said that Oracle database professionals earn more than their
SQLServer counterparts. Salary surveys and advertised opportunities (at
least the ones I see in the UK) tend to back this up, although obviously
salary levels are subject to many other factors as well.

The decision on which is most useful to you will depend on your
qualifications, experience, intended career and the opportunities available
in the area and industry in which you would like to work. Research job
opportunities in your areas of interest to help you decide. Unfortunately in
the IT industry the only constant is change - the market could look very
different in 2 years time and nobody can predict it with any degree of
certainty.

(off-topic cross-postings ignored)

--
David Portas
------------
Please reply only to the newsgroup
--

"English Teacher" <En************ @ModernEnglish. com> wrote in message
news:b0******** *************** **@posting.goog le.com...
Which would be a more useful relational database server to learn
nowadays: MS SQL SERVER or ORACLE?

Thanks!

Jul 20 '05 #2
Hi

The choice of which database system to learn will to some extent be
determined on why you wish to learn it. In general there is a lot of
relational theory that is universal and writing good SQL and doing correct
design is not linked to the vendor of the database system. There will be
system specific features that will improve performance on a given RDBMS, but
the knowledge of how proprietary this is is important.

In general I think that SQL Server is the better system regarding ease of
setup and the hardware required to run the system and would therefore have
the edge, but if you are looking for multiplatform capabilities then Sybase,
DB2 or Oracle may be alternatives to consider.

John
"English Teacher" <En************ @ModernEnglish. com> wrote in message
news:b0******** *************** **@posting.goog le.com...
Which would be a more useful relational database server to learn
nowadays: MS SQL SERVER or ORACLE?

Thanks!

Jul 20 '05 #3
English Teacher wrote:
Which would be a more useful relational database server to learn
nowadays: MS SQL SERVER or ORACLE?

Thanks!

If the choice is strictly academic and you have no commercial purpose in
min it really doesn't matter
so just get the one that costs you the least. Not sure if you can get
SQL Server for free but Oracle
can be downloaded for free from oracle.com and the full commercial CD
package purchased from
http://store.oracle.com for $39.95 USD.

If you have a commercial intent then choose the product that best meets
that goal. If you are looking
for industrial strenght security, stability, ability to run on Linux or
UNIX etc. that might lead you in one
direction. Other choices might lead you elsewhere.

But why on earth do you think posting this to rec.woodworking is a good
use of the usenet? Please
do not cross-post to irrelevant groups. I have taken the liberty to
remove them from this thread so as
not to continue the misuse.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.wash ington.edu
(replace 'x' with a 'u' to reply)

Jul 20 '05 #4
If you want it EASY & quick - go with SQL Server

You like to read technical stuff & think & research & LEARN - go with Oracle
,rec.woodworkin g,rec.photo.dig ital,rec.photo. equipment.35mm

Ahh...forgettab outit then ....do SQL Server....you'l l definitely have more
time for these hobbies...

"English Teacher" <En************ @ModernEnglish. com> wrote in message
news:b0******** *************** **@posting.goog le.com... Which would be a more useful relational database server to learn
nowadays: MS SQL SERVER or ORACLE?

Thanks!

Jul 20 '05 #5
Robert C wrote:
If you want it EASY & quick - go with SQL Server

You like to read technical stuff & think & research & LEARN - go with Oracle
,rec.woodwor king,rec.photo. digital,rec.pho to.equipment.35 mm


Ahh...forgetta boutit then ....do SQL Server....you'l l definitely have more
time for these hobbies...

"English Teacher" <En************ @ModernEnglish. com> wrote in message
news:b0******* *************** ***@posting.goo gle.com...

Which would be a more useful relational database server to learn
nowadays: MS SQL SERVER or ORACLE?

Thanks!

I think one could make a reasoned argument that to do good work in SQL
Server also requires
a bit of heavy lifting. The fact that many don't bother to do it doesn't
mean that what they build
is anything other than mediocre.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.wash ington.edu
(replace 'x' with a 'u' to reply)
Jul 20 '05 #6
En************@ ModernEnglish.c om (English Teacher) wrote in message news:<b0******* *************** ***@posting.goo gle.com>...
Which would be a more useful relational database server to learn
nowadays: MS SQL SERVER or ORACLE?

This poster is a well known troll. Reply at your own risk.
Jul 20 '05 #7

"Noons" <wi*******@yaho o.com.au> wrote in message
news:73******** *************** ***@posting.goo gle.com...
En************@ ModernEnglish.c om (English Teacher) wrote in message

news:<b0******* *************** ***@posting.goo gle.com>...
Which would be a more useful relational database server to learn
nowadays: MS SQL SERVER or ORACLE?

This poster is a well known troll. Reply at your own risk.


shhh
Jul 20 '05 #8
Daniel Morgan (da******@x.was hington.edu) writes:
Not sure if you can get SQL Server for free


Not completely, but there is a 120-day evaluation version available.
See item 6 on http://www.microsoft.com/sql/downloads/topdownloads.asp.

--
Erland Sommarskog, SQL Server MVP, so****@algonet. se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #9

"Erland Sommarskog" <so****@algonet .se> wrote in message
news:Xn******** *************@1 27.0.0.1...
Daniel Morgan (da******@x.was hington.edu) writes:
Not sure if you can get SQL Server for free
Not completely, but there is a 120-day evaluation version available.
See item 6 on http://www.microsoft.com/sql/downloads/topdownloads.asp.


And the developer's edition is now fairly cheap as I recall.


--
Erland Sommarskog, SQL Server MVP, so****@algonet. se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Jul 20 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
4029
by: Ton | last post by:
I have a question about connectivity between different databases. Oracle, DB2400 and SQL_server. It is easy to integrate application products that are running on different DB platforms? What products can be used to achieve this? Our consultant is mentioning .NET but then we have to run everything on SQL server. Currently we are running on Oracle but our third party generic applications are first developed for SQL server and later...
10
3513
by: Andrea M. Segovia | last post by:
Hello, I am a newbie to Oracle databases.... We have a visualization front-end tool connected to an Oracle back-end database on a Tru64 UNIX server. We also have clients with MS access databases who would like to share their data using this visualization tool but do not want to import their data into the Oracle server back-end.
13
3298
by: BigDaDDY | last post by:
Um yeah....In case you haven't figured it out, Microsoft sucks. I'm going to be kicked back in my chair eating popcorn and watching football 10 years from now, while all you clowns are scrambling to rewrite all your code because Microsoft upgraded all their crap and nothing you wrote 10 years earlier works. It doesn't take a rocket scientist to figure out that Microsoft is unreliable. Try opening an Excel 95 spreadsheet you wrote in...
11
17032
by: Rosco | last post by:
Does anyone have a good URL or info whre Oracle and Access are compared to one another in performance, security, cost etc. Before you jump on me I know Oracle is a Cadillac compared to Access the Ford Fairlane. I need this info to complete a school project. Thanks.
0
5770
by: ʹ | last post by:
ORA-03114: not connected to ORACLE && MS's Bug?? DataBase:Oracle 817 using OracleClient,net framework 1.1 I'm using ADO.Net in C# with Oracle 817. and following is my public data access class. using System.Data.OracleClient;
8
14362
by: danbredy | last post by:
Hi, I'm attempting to connect to an Oracle database using SQL Server 2005 Express (OS is Windows XP Professional) and having absolutely no luck. Here is the information SQL Plus gives me about the database when I log in - Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options
2
4222
by: egoldthwait | last post by:
I need to convert a 17mb access 2000 db to Oracle and house it in a Citrix farm. The issue: we have never converted an Access Db to Oracle but can probably use Oracle's Workbench to assist with this. Also - the citrix folks do not want us to keep the FE in Access as the queries and other activities consume a lot of power. The users will be in 3 different offices across the globe all accessing the 1 Oracle DB in Citrix. Does anyone have...
42
6725
by: Paul | last post by:
Anyone know where I can find some good resources to help us choose between SQL and Oracle ( Progress Openedge as well ) . Any comments on what you would choose ?? We are creating a new Warehouse Management System which wil manage our very large inventory. Anyway comments suggestions welcome Thanks Paul
7
4353
by: D. Patrick | last post by:
I need to connect to an Oracle database. I've never done it before. I see that with framework 1.1 you had to download ODP.NET from Oracle's site in order for the framework classes to even work. I tried that quickly, but the file is 400 MB, and the the installation asks for all kinds of things in order to install. Now I'm very confused. a) Do you still need ODP.NET with framework 2.0? b) Do you need to download and install other...
1
4915
by: jonl | last post by:
Hi, I was devloping on a remote corporate web server(MS XP) building webapps using simple asp. I then moved the code to my desktop(MS 2000) which also has a webserver and encountered connectivity errors. This is connecting to Oracle (9.2 on a solaris sparc 5.8) using MSDAORA. As far as I can tell both the remote webserver and the desktop use the same tnsnames file (on the lan). The databases being accessed are remote to both webservers. ...
0
7894
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8392
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8262
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
5847
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5437
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
3894
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
3938
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1500
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1245
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.