unix and sql commands

danIT · 23-01-2007, 03:20 PM

I need to learn SQL and unix commands, the basic user to average user level. Where can i get a distribution of unix to test them out aswel?

CyberNerd · 23-01-2007, 03:27 PM

Solaris is free http://www.opensolaris.org/os/
or try any linux distro. - what SQL ? mssql, postgresql, sybase, oracle ?

webman · 23-01-2007, 03:30 PM

Keith Brown has an extensive MySQL tutorial section on his website (inlcluding basic *nix web server configuration).

danIT · 23-01-2007, 03:42 PM

mssql sorry?

thanks for the links

CyberNerd · 23-01-2007, 03:53 PM

FreeTDS will talk MSSQL from Linux/Unix
http://www.freetds.org/

Probably can be done through php/python etc

theriver · 23-01-2007, 05:15 PM

If it's MSSQL you are wanting to learn, you may as well learn the environment too - download the SQL Server Express edition. The GUI is very helpful when setting out.

http://msdn.microsoft.com/vstudio/express/sql/

You can also download example databases: (http://www.microsoft.com/downloads/d...displaylang=en) although I have never used them . . . .

CyberNerd · 23-01-2007, 06:26 PM

@theriver
Why limit yourself to one technology ? You don't need to learn 'the environment' to learn SQL. It is clearly more wise to able to implement technology on a variety of platforms. The same with scripting, why learn to do something that is only applicable to one platform (that will get outdated very quickly) when you could learn a competing, and often more robust technology that enables you to use it on a variety of platforms - far more logical and better transferable skills IMO.

NetworkGeezer · 23-01-2007, 07:24 PM

What's that Cyber, even on Windows?

CyberNerd · 23-01-2007, 07:47 PM

yep,

including windows, naturally I prefer OSS stuff, tends to be better for *all* O/S's - another new reactionary scripting language is scheduled for vista sp1 - mid 2007

danIT · 14-02-2007, 02:19 PM

can anyone help me this unix?

The sql stuff will just be basic selects. moves etc

but the unix will be a bit more in depth?

i supposse im a bit mystified by it all, i need to know unix i presume i need to know the commands and the basis of these commmands

Welcome, Register for free! or Login below:
User Name		Remember Me?
Password

23-01-2007, 03:20 PM	#1
danIT Join Date: Apr 2006 Location: UK Posts: 533 Thanks: 17 Thanked 14 Times in 11 Posts Rep Power: 9	unix and sql commands I need to learn SQL and unix commands, the basic user to average user level. Where can i get a distribution of unix to test them out aswel?

23-01-2007, 03:27 PM	#2
CyberNerd Join Date: Jan 2006 Posts: 3,451 Thanks: 49 Thanked 151 Times in 124 Posts Rep Power: 39	Re: unix and sql commands Solaris is free http://www.opensolaris.org/os/ or try any linux distro. - what SQL ? mssql, postgresql, sybase, oracle ?

23-01-2007, 03:30 PM	#3
webman Join Date: Nov 2005 Location: County Durham Posts: 5,678 Thanks: 106 Thanked 87 Times in 71 Posts Blog Entries: 1 Rep Power: 38	Re: unix and sql commands Keith Brown has an extensive MySQL tutorial section on his website (inlcluding basic *nix web server configuration).

23-01-2007, 03:42 PM	#4
danIT Join Date: Apr 2006 Location: UK Posts: 533 Thanks: 17 Thanked 14 Times in 11 Posts Rep Power: 9	Re: unix and sql commands mssql sorry? thanks for the links

		EduGeek.net Forums > General > General Chat
unix and sql commands

23-01-2007, 03:53 PM	#5
CyberNerd Join Date: Jan 2006 Posts: 3,451 Thanks: 49 Thanked 151 Times in 124 Posts Rep Power: 39	Re: unix and sql commands FreeTDS will talk MSSQL from Linux/Unix http://www.freetds.org/ Probably can be done through php/python etc

23-01-2007, 05:15 PM	#6
theriver Join Date: Apr 2006 Posts: 48 Thanks: 2 Thanked 0 Times in 0 Posts Rep Power: 0	Re: unix and sql commands If it's MSSQL you are wanting to learn, you may as well learn the environment too - download the SQL Server Express edition. The GUI is very helpful when setting out. http://msdn.microsoft.com/vstudio/express/sql/ You can also download example databases: (http://www.microsoft.com/downloads/d...displaylang=en) although I have never used them . . . .

23-01-2007, 06:26 PM	#7
CyberNerd Join Date: Jan 2006 Posts: 3,451 Thanks: 49 Thanked 151 Times in 124 Posts Rep Power: 39	Re: unix and sql commands @theriver Why limit yourself to one technology ? You don't need to learn 'the environment' to learn SQL. It is clearly more wise to able to implement technology on a variety of platforms. The same with scripting, why learn to do something that is only applicable to one platform (that will get outdated very quickly) when you could learn a competing, and often more robust technology that enables you to use it on a variety of platforms - far more logical and better transferable skills IMO.

23-01-2007, 07:24 PM	#8
NetworkGeezer Join Date: Feb 2006 Posts: 1,194 Thanks: 0 Thanked 1 Time in 1 Post Rep Power: 0	Re: unix and sql commands What's that Cyber, even on Windows?

23-01-2007, 07:47 PM	#9
CyberNerd Join Date: Jan 2006 Posts: 3,451 Thanks: 49 Thanked 151 Times in 124 Posts Rep Power: 39	Re: unix and sql commands yep, including windows, naturally I prefer OSS stuff, tends to be better for all O/S's - another new reactionary scripting language is scheduled for vista sp1 - mid 2007

14-02-2007, 02:19 PM	#10
danIT Join Date: Apr 2006 Location: UK Posts: 533 Thanks: 17 Thanked 14 Times in 11 Posts Rep Power: 9	Re: unix and sql commands can anyone help me this unix? The sql stuff will just be basic selects. moves etc but the unix will be a bit more in depth? i supposse im a bit mystified by it all, i need to know unix i presume i need to know the commands and the basis of these commmands

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mac OSX Leopard now offically Unix	Geoff	*nix	2	01-08-2007 11:50 PM
Server 2003 run commands.	starscream	Networks	3	26-06-2007 10:49 AM
Know your UNIX admins	ITWombat	Jokes/Interweb Things	0	09-04-2007 04:36 PM
VLAN Simulator - Commands	Nij.UK	Networks	1	20-02-2007 02:27 PM
Avantis CDServe shortcut commands	WithoutMotive	How do you do....it?	2	18-07-2006 10:36 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search Thread
Show Printable Version Email this Page	Search Thread: Advanced Search

Register now for FREE and post messages!
Username: Password: Confirm Password: E-Mail: Confirm E-Mail: Birthday: Image Verification I agree to forum rules

General Chat forum sponsored by