SQL server exams - Help Needed to Discover SQL

Author

Help Needed to Discover SQL

2000-10-22, 9:20 pm

Greetings all you SQL boffins,

Ok I've been in this networking milarky for the past 10 years, Ive got my MCP's MCNE SCO ACE & Compaq ASE. However; one thing still eludes me, that being SQl. I know what it means and Im armed with 2 servers with SQL 7.0 & Sp2, my only problem is what on earth can I do with it? How can I do it? and whats the exam like?

Before any of you out there give me jip over this just let me say this.

I'm thick when it comes to data bases, networking 1000% no problem.

Thus I would very much appreciate some help in this casam of knowledge if at all possible.

Many thanks in advance.

Yeti

------------------
Yeti-GBR1
email: Yeti@zerg.com

Yes I'm a Blizzard Brood War Veteran.

2000-11-07, 3:48 pm

Damn it people.

Does no one here like helping others in there quest for knowledge?

Yeti the Insane

2000-12-04, 4:56 pm

Hey Yeti,

I read a lot of your posts in the MCSE NT 4 forum, so I think I know where you are coming from. I got all of my core tests doen for my MCSE, but my main goal was to go for MCDBA, which pays well nationwide, as far as I can tell. I'm taking TCP/IP soon as my elective for MCDBA, and then will take 28 & 29 to get my MCDBA. After that I'm thinking about taking 19 to just finish up the entire SQL track (and that would make my choice of TCP/IP useless, so I am wondering whether I should just stop studying TCP/IP and go straight for SQL). I haven't got the entire home test-network converted from NT 4 to SQL just yet, but when I do, I plan to make web-based input query forms, and just try to open some large-scale practive forms. I have a couple of friends who are DB whiz's (I used to work at NCR - makers of Teradata, and I also have ties with iVillage - hey have a moderately big client database), so it looks like I will try to get a feel for the job through them. I know this didn't nswer your questions, but at least you know that there's somebody else out there in your shoes. Good luck.

2000-12-04, 5:43 pm

Greetings MCSEWannabe,

Thanks for the info, it's encouraging to know that I am not alone in this quest. BTW where in the world are you? USA? UK? HG? Where?

I'd like to exchange ideas, concepts and well anything really to do with MS SQL or anything else as I have all these resources(Servers) at home doing jack all, well ok 1 Win2k AS,1 SQL, 1 IIS4, 2 Proxy, 1SCO, 1 NW4.11, 1 NW5.1, 1 OS/2 I think that covers it..? Nope 5 workstations, 3 W98, 1Win2K Prof and 1 Linux. Problem is so many toys and not enough time to play

(Perks of being a Manager I suppose

Ok enough babble, I'll catch you later.

Thanks again,
Yeti the Thankful

2000-12-06, 5:48 am

Hey Yeti, I might be able to help, my icq # is 59231815

2000-12-08, 12:59 pm

SQL is easy. It's mainly some very somple statements used to extract data from tables. Few languages could be simpler. Email me or get my on ICQ and maybe I'll be able to help you some more. For example, if you were trying to get information from a table called "Customer" and you needed an address, first and last name based upon a customer id, you could do a call like this:

SELECT LAST_NAME, FIRST_NAME, ADDRESS
FROM PROD.CUSTOMER
WHERE CUST_ID = '123456789'

This call would return a results table containing one customer, since CUST_ID would be a key field (i.e., it would be unique). It's very simple stuff.

Sponsored Links