| Author |
Topic |
|
thandavakarumuri
Starting Member
1 Post |
 Posted - 2007-02-19 : 14:02:43
|
| Hi Gurus, I am new to this forum and new to SQL Server skill. I have good experience with Oracle9i and Oracle11i. Now am searching for jobs in USA. Here am finding some requirements are with SQL Server. Since am new to SQL Server am not able to handle the interviews sucessfully. Can any one help me in learning basics of sql server? Please send me any materials(soft copy in word format of pdf format) and some good web sites. I would be appreciated your great help.Thanks & Regards,Tandava Krishna |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-19 : 17:01:42
|
| "*Very Urgent Help*"<Yawn> |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2007-02-20 : 08:12:02
|
quote:
<Yawn>
Oh come on, he only used one pair of asterisks and no uppercase or exclamation points. That deserves some recognition for restraint.  My first suggestion, as always, is to read SQL Server Books Online. I'll let you type that into Google if you must.As far as jobs go, find ones where they use both Oracle and SQL Server, or are converting one to the other, and where your Oracle knowledge is more useful. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-02-20 : 09:01:46
|
what is Oracle 11i? isn't their latest release 10g?
www.elsasoft.org |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-20 : 09:06:18
|
| http://www.dba-oracle.com/oracle_applications/Oracle_11i.htmPeter LarssonHelsingborg, Sweden |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-02-20 : 09:29:14
|
| My suggestion: Read a book on SQL Server. Just do it. Sit down, get comfy, go through it. It is so important to be made aware of the basic concepts in any technology before you start messing around with it. Most books do a great job of slowly introducing you to the technology and concepts and all that and working SQL into the examples. Any time I use any new technology, I tend to go to the library, grab a book, and read it. You can skip lots of stuff and certainly just skim most of it, just make sure that you understand the core concepts.- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
abundant_lyfe
Starting Member
10 Posts |
Posted - 2007-02-20 : 10:42:50
|
| And don't get mixed up between MySQL and T-SQL, as I am. O'Reilly has a book on 'Learning SQL on SQL Server 2005' |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-02-20 : 12:48:51
|
quote:
Originally posted by Peso
http://www.dba-oracle.com/oracle_applications/Oracle_11i.htm
ok, but that's not the db server as far as I can tell. oracle.com says the latest release of the relational server is 10g.
www.elsasoft.org |
|
|
|
Taurkon
Starting Member
26 Posts |
Posted - 2007-02-20 : 15:17:06
|
| If you are a hands on person as I am, download a trial version of MS SQL Server and install it on your workstation/laptop. Then, take some of your Oracle projects and convert them to SQL Server projects. Create the tables, re-write a few of the more complicated stored procedures, and convert some of the complex queries you ran against the former Oracle Database into SQL Server queries. I just finished this exercise with my team as they were all Oracle guys with no SQL Server experience. They were able to pick it up pretty quickly. Also, when you do run into some road bumps, then post them here. |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2007-02-20 : 17:30:45
|
quote:
Originally posted by jezemine
quote:
Originally posted by Peso
http://www.dba-oracle.com/oracle_applications/Oracle_11i.htm
ok, but that's not the db server as far as I can tell. oracle.com says the latest release of the relational server is 10g.
www.elsasoft.org
That must be some kind of joke right, they can't be serious?Or the sad thing is that they are serious.Either way it was quite funny...quote:
The migration to Oracle11i is extremely complex and risky. In addition to the risk of unavailability, the Oracle 11i upgrade involves changes to thousands of programs. Even after the Oracle 11i migration, there may be dozens of patches to apply, and each patch must be applied in proper sequence.Even more risky is the change to the end-user . Oracle 11i has numerous functional changes, and dozens of mission-critical business processes must be validated.etc. etc.
I REALLY feel like upgrading now ---Edit: omg they are serious!!!btw, just got to love this quote from the oracle site:"You Don't Have to Worry About Security - Oracle is Unbreakable"  |
|
|
|
|
*Very Urgent Help*