Results 1 to 10 of 10

Thread: SQL Database Software - Setup and Admin

  1. #1
    Member bradlesliect's Avatar
    Join Date
    Apr 2006
    Location
    CT - SA
    Posts
    74

    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....

  2. #2
    Just Another Geek
    Join Date
    Jul 2002
    Location
    Rotterdam, Netherlands
    Posts
    3,401
    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.

  3. #3
    Only african to own a PC! Cider's Avatar
    Join Date
    Jun 2003
    Location
    Israel
    Posts
    1,683
    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

  4. #4
    Banned
    Join Date
    Aug 2001
    Location
    Yes
    Posts
    4,424
    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/

  5. #5
    AO's Filibustier Cheap Scotch Ron's Avatar
    Join Date
    Nov 2008
    Location
    Swamps of Jersey
    Posts
    378
    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.

  6. #6
    THE Bastard Sys***** dinowuff's Avatar
    Join Date
    Jun 2003
    Location
    Third planet from the Sun
    Posts
    1,253
    Sorry CSR but SQL doesn't stand for anything...

    http://antionline.com/showpost.php?p=937012&postcount=3
    09:F9:11:02:9D:74:E3:5B8:41:56:C5:63:56:88:C0

  7. #7
    AO's Filibustier Cheap Scotch Ron's Avatar
    Join Date
    Nov 2008
    Location
    Swamps of Jersey
    Posts
    378
    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.

  8. #8
    THE Bastard Sys***** dinowuff's Avatar
    Join Date
    Jun 2003
    Location
    Third planet from the Sun
    Posts
    1,253
    Quote Originally Posted by Cheap Scotch Ron View Post
    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:5B8:41:56:C5:63:56:88:C0

  9. #9
    AO's Filibustier Cheap Scotch Ron's Avatar
    Join Date
    Nov 2008
    Location
    Swamps of Jersey
    Posts
    378
    Yeah, but I'm like a wine... I get better with age.
    In God We Trust....Everything else we backup.

  10. #10
    Only african to own a PC! Cider's Avatar
    Join Date
    Jun 2003
    Location
    Israel
    Posts
    1,683
    Quote Originally Posted by Cheap Scotch Ron View Post
    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

  1. Trojans - Ports
    By GbinaryR in forum AntiVirus Discussions
    Replies: 11
    Last Post: October 30th, 2008, 09:33 AM
  2. Port List
    By ThePreacher in forum Miscellaneous Security Discussions
    Replies: 17
    Last Post: December 14th, 2006, 09:37 PM
  3. Tips
    By XTC46 in forum Site Feedback/Questions/Suggestions
    Replies: 15
    Last Post: August 24th, 2005, 07:52 PM
  4. The history of the Mac line of Operating systems
    By gore in forum Operating Systems
    Replies: 3
    Last Post: March 7th, 2004, 08:02 AM
  5. Tcp/ip
    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
  •