-
May 6th, 2009, 11:21 AM
#1
Member
SQL Database Software - Setup and Admin
Hi,
I have never used or looked at SQL software in my life. I would like to learn SQL Server but don't know which is better - MySQL or MS SQL? What is the difference between the two?
I have downloaded and installed MySQL 6.0(is this the latest version?) and I now need to learn how to install and set it up? Anyone know where I can get such material that can assist with the learning?
Let me know.
Thank you,
.....I rather not say....
-
May 6th, 2009, 12:44 PM
#2
The difference between MySQL and SQL server?
MySQL is open source and free to use. SQL Server is the database server made by MS, expensive and closed source.
Both use SQL; Structured Query Language. Both use the same syntax to create queries (with some minor differences).
Are you installing MySQL on linux/bsd or Windows? Not that it really matters once it's installed, they all work the same.
http://dev.mysql.com/tech-resources/...sql_intro.html
Last edited by SirDice; May 6th, 2009 at 12:46 PM.
Oliver's Law:
Experience is something you don't get until just after you need it.
-
May 6th, 2009, 01:03 PM
#3
I have never really used SQL but to support it I just installed 2005/2008 express which is free from MS and play with that.
We use it for software we support.
DSL is giving hassels today but i dont have a link.
I see you are in Capetown so try the local ftp - ftp://ftp.agasa.co.za. If you are using Internet solutions as your backbone the DL from MS is mirrored at akamai so it will be a local download if you are using a local only account. If you are using SAIX (telskum) then its a 50/50 gamble if it will be mirrored.
You can PM me as we live in the same area and we can chat if you like.
Cheers.
The world is a dangerous place to live; not because of the people who are evil, but because of the people who don't do anything about it.
Albert Einstein
-
May 6th, 2009, 02:24 PM
#4
SQL Server is the database server made by MS, expensive and closed source.
He's just trying to learn; he can get the Express version for free: http://www.microsoft.com/express/sql/
-
May 6th, 2009, 04:34 PM
#5
Clarification (OK, I know... soapbox... but SQL is my thing. I will be brief): The term SQL has a couple of meanings. Technically speaking, SQL (Structured Query Language) is a programming language used to access relational databases (RDBMS). SQL can also be used to generically refer to RDBMS. e.g. It's a SQL DB.
To confuse the matter a bit, Microsoft named their RDBMS (based on Sybase) product, SQL Server. Other widely used RDBMS include DB2, oracle, Sybase, mysql. There are many differences between these RDBMS.
SQL (the language) can be used to manipulate data in RDMS (e.g. queries). This is called DML (Data Manipulation Language). SQL can also be used to manage (e.g. create, update, delete) database objects. This is called DDL (Data Definition Language).
If you want to learn Structured Query Language (SQL) from an application programmer (e.g. focus on DML or queries) perspective, then either mysql or MS SQL will suffice. As mentioned ^, the syntax on queries will vary slightly (most SQL engines have customized their syntax. However ANSI SQL will work across most DBMS). I would lean towards the Microsoft offering, because the Dev Studio is nice, especially in 2005/2008 and I am assuming you have windoze desktop. As Neg pointed out, the Express version will be fine for learning.
The MS SQL Site has plenty of docs to get u started. Install is a snap.
http://www.microsoft.com/sqlserver/2...s/default.aspx
Also, google "SQL primer" and you will find an abundant number of sites with basics.
Good Luck.
In God We Trust....Everything else we backup.
-
May 6th, 2009, 04:55 PM
#6
09:F9:11:02:9D:74:E3:5B 8:41:56:C5:63:56:88:C0
-
May 6th, 2009, 06:48 PM
#7
Sorry CSR but SQL doesn't stand for anything...
lol...
News to me. I would be curious to know where you got the quote.
When I worked for IBM (long time ago), I met the IBMers that that developed the first version of SQL which was based on Dr Codd's System R Internal Research Project. The first version of SQL was developed at IBM by Andrew Richardson, Donald C. Messerly and Raymond F. Boyce in the early 1970s. This version, initially called SEQUEL (Structured English Query Language), was designed to manipulate and retrieve data stored in IBM's original relational database research/internal product, System R. IBM was granted a patent for their version of SQL (Structured Query Language) in 1985, while the SQL language was not formally standardized until 1986 by the American National Standards Institute (ANSI) as SQL-86.
P.S....
So technically, SQL doesn’t stand for anything ‘cause IBM’s lawyers say so…
How do you know when a lawyer is lying?... His lips are moving.
Last edited by Cheap Scotch Ron; May 6th, 2009 at 07:04 PM.
Reason: patent filed in 1983. granted in 1985. as per google patent search
In God We Trust....Everything else we backup.
-
May 7th, 2009, 04:10 PM
#8
Originally Posted by Cheap Scotch Ron
I met the IBMers that that developed the first version of SQL
Holy **** man you ARE old! lol
Where did I get that quote...
I don't remember. It was in some corse text but I can't remember what class.
09:F9:11:02:9D:74:E3:5B 8:41:56:C5:63:56:88:C0
-
May 7th, 2009, 05:29 PM
#9
Yeah, but I'm like a wine... I get better with age.
In God We Trust....Everything else we backup.
-
May 8th, 2009, 02:51 PM
#10
Originally Posted by Cheap Scotch Ron
Yeah, but I'm like a wine... I get better with age.
haha?
The world is a dangerous place to live; not because of the people who are evil, but because of the people who don't do anything about it.
Albert Einstein
Similar Threads
-
By GbinaryR in forum AntiVirus Discussions
Replies: 11
Last Post: October 30th, 2008, 09:33 AM
-
By ThePreacher in forum Miscellaneous Security Discussions
Replies: 17
Last Post: December 14th, 2006, 09:37 PM
-
By XTC46 in forum Site Feedback/Questions/Suggestions
Replies: 15
Last Post: August 24th, 2005, 07:52 PM
-
By gore in forum Operating Systems
Replies: 3
Last Post: March 7th, 2004, 08:02 AM
-
By gore in forum Newbie Security Questions
Replies: 11
Last Post: December 29th, 2003, 08:01 AM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|