The Mother Board

Motherboards.org forums. Free tech support, motherboard ID, and more.
It is currently Fri Sep 21, 2018 12:20 pm

All times are UTC - 8 hours




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: SQL Scripts for Newbies
PostPosted: Mon Jul 23, 2007 10:09 am 
Offline
Brown Belt
Brown Belt

Joined: Fri Jan 24, 2003 11:59 am
Posts: 309
I know nothing about SQL other than the fact that my peers occassionally provide me with a SQL script to run against our databases. I would like to learn how to write these scripts against our database and I am looking for a Novice level tutorial to get me started. Can anyone advise?

_________________
Antec 900 - 650W ATX
Intel DQ35JOE
Intel Core 2 DUO Q6600 Quad Core 4gb
PC2-6400 DDR2-SDRAM UDIMM - 2x2 GB (Clocking 400mhz)
Primary: SATA 3gb/s - Hitachi HDP725050GLA360(500 gb)
External-USB: SATA 3gb/s - WDC-WD7500AACS-00ZJB0 (750 gb)
NVIDIA GeForce GTX 750 - PCIe v1.1 x16 (2.5 Gb/s) @ x16 (2.5 Gb/s)
Microsoft Windows XP Professional Build 2600 - SP-3
BIOS: JOQ3510J.86A.1143.2010.1209.0048 - 12/09/2010


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Tue Jul 24, 2007 9:28 am 
Offline
Green Belt
Green Belt

Joined: Thu Jun 27, 2002 8:11 pm
Posts: 222
http://www.w3schools.com/sql/default.asp


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Tue Jul 24, 2007 9:35 am 
Offline
Black Belt 2nd Degree
Black Belt 2nd Degree

Joined: Mon Aug 09, 2004 7:33 pm
Posts: 2741
Location: Milwaukee - Wisconsin
what kind of database do you operate?

-Roach

_________________
Lian Li Lancool First Knight Series PC-K59W
Intel Core i7-960 Bloomfield 3.2GHz
EVGA X58 FTW3 132-GT-E768-TR
EVGA GeForce GTX 1070 FTW GAMING ACX 3.0
G.SKILL Ripjaws Series 12GB (3 x 4GB)
Crucial M4 128gb SATAIII SSD x2
Crucial M4 256gb SATAIII SSD
OCZ Saber 1000 960GB Enterprise SSD
Corsair Professional Series HX850 PSU
Dell UltraSharp U2713HM 27" w/drop ceiling mount
Logitech G930 7.1 Headset
DBPOWER RGB LED Keyboard
Logitech G402 Hyperion Fury


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Wed Jul 25, 2007 10:40 am 
Offline
Brown Belt
Brown Belt

Joined: Fri Jan 24, 2003 11:59 am
Posts: 309
it is a script run against oracle

_________________
Antec 900 - 650W ATX
Intel DQ35JOE
Intel Core 2 DUO Q6600 Quad Core 4gb
PC2-6400 DDR2-SDRAM UDIMM - 2x2 GB (Clocking 400mhz)
Primary: SATA 3gb/s - Hitachi HDP725050GLA360(500 gb)
External-USB: SATA 3gb/s - WDC-WD7500AACS-00ZJB0 (750 gb)
NVIDIA GeForce GTX 750 - PCIe v1.1 x16 (2.5 Gb/s) @ x16 (2.5 Gb/s)
Microsoft Windows XP Professional Build 2600 - SP-3
BIOS: JOQ3510J.86A.1143.2010.1209.0048 - 12/09/2010


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Wed Jul 25, 2007 11:46 am 
Offline
Black Belt 2nd Degree
Black Belt 2nd Degree

Joined: Mon Aug 09, 2004 7:33 pm
Posts: 2741
Location: Milwaukee - Wisconsin
i found a SQL for Dummies book a while back that was actually pretty good... you should be able to get one at any large-sized book store, or computer specialty shops.

the above page is pretty helpful for really basic info, but if you want to understand more specifically to oracle instances you'll want to get an oracle book about queries and perhaps PL/SQL...which i find to be the most fun to work with.

-Roach

_________________
Lian Li Lancool First Knight Series PC-K59W
Intel Core i7-960 Bloomfield 3.2GHz
EVGA X58 FTW3 132-GT-E768-TR
EVGA GeForce GTX 1070 FTW GAMING ACX 3.0
G.SKILL Ripjaws Series 12GB (3 x 4GB)
Crucial M4 128gb SATAIII SSD x2
Crucial M4 256gb SATAIII SSD
OCZ Saber 1000 960GB Enterprise SSD
Corsair Professional Series HX850 PSU
Dell UltraSharp U2713HM 27" w/drop ceiling mount
Logitech G930 7.1 Headset
DBPOWER RGB LED Keyboard
Logitech G402 Hyperion Fury


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC - 8 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group