danIT Posted January 23, 2007 Posted January 23, 2007 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 Posted January 23, 2007 Posted January 23, 2007 Solaris is free http://www.opensolaris.org/os/ or try any linux distro. - what SQL ? mssql, postgresql, sybase, oracle ?
webman Posted January 23, 2007 Posted January 23, 2007 Keith Brown has an extensive MySQL tutorial section on his website (inlcluding basic *nix web server configuration).
CyberNerd Posted January 23, 2007 Posted January 23, 2007 FreeTDS will talk MSSQL from Linux/Unix http://www.freetds.org/ Probably can be done through php/python etc
theriver Posted January 23, 2007 Posted January 23, 2007 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/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en) although I have never used them . . . .
CyberNerd Posted January 23, 2007 Posted January 23, 2007 @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.
CyberNerd Posted January 23, 2007 Posted January 23, 2007 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 Posted February 14, 2007 Author Posted February 14, 2007 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
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now