Results 1 to 8 of 8

Thread: Getting started with SQL - help

  1. 12-17-2003, 11:15 AM #1
    tisme1020
    tisme1020 is offline Registered User
    Join Date
    Dec 2003
    Location
    Connecticut
    Posts
    5

    Question Getting started with SQL - help

    A little history .. I'm a mainframe programmer and need to to a bit of updateing. I picked up an SQL book to learn and then found this wonderful site!

    Now PLEASE correct me if I am wrong with this... Oracle is a 'database' structure that SQL programs access to get info? And what is the difference between PL/SQL and SQL?

    Thank you in advance to any and all comments/directions of correction.
    Reply With Quote Reply With Quote
  2. 12-17-2003, 02:03 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    What is the site?

    Basically Oracle, SQL Server, MYSQL, DB2 etc are database engines. All of them support ANSI standard SQL. SQL is a query language used to access data from those database engines.


    If you like to learn about sql here are some links you can refer to....

    ANSI SQL
    http://www.sqlcourse.com/
    http://sqlcourse2.com/

    SQL Server
    http://www.mssqlserver.com/tsql/
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 12-17-2003, 02:31 PM #3
    tisme1020
    tisme1020 is offline Registered User
    Join Date
    Dec 2003
    Location
    Connecticut
    Posts
    5
    The wonderful site I was referring to was the sqlcourse.com; I found the link that brought me here!

    Just a few more and I will get on with my sql studies...

    In reference to the data base engines, do they all funtion pretty much the same? Is one easier to understand than the others?; or does it not matter?

    And also what is PL/SQL?


    Thank you so much for your help.
    Reply With Quote Reply With Quote
  4. 12-17-2003, 02:42 PM #4
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    PL/SQL is for oracle. It is programming language with SQL.

    It is like stored procedures in SQL and Sybase

    Simple words - you put a bunch of sql statements to gether and get data or manipulate data.

    Basic function of all database engines are same. The follow the 12 CODD rules.
    But every RDBMS has it owns additional features properties performance and limits.

    What you want to become - developer/DBA/architect/analysis? or why you want to know about databases?

    The answers to that will give us an idea in which direction that we can guide you.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  5. 12-17-2003, 05:44 PM #5
    tisme1020
    tisme1020 is offline Registered User
    Join Date
    Dec 2003
    Location
    Connecticut
    Posts
    5
    My questions on the data bases was to have a better understanding of what I did not understand; thanks to you I am not confused about all that.

    What I would like to do is develope/program. The book I bought: "Introduction to SQL, 3rd edition, mastering the relational database language", by Rick van der Lans.

    I'm guessing I'm on the track?
    Reply With Quote Reply With Quote
  6. 12-17-2003, 06:42 PM #6
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    you are.

    Below link will help you in guiding you step by step

    ANSI SQL
    http://www.sqlcourse.com/
    http://sqlcourse2.com/
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  7. 12-17-2003, 09:20 PM #7
    tisme1020
    tisme1020 is offline Registered User
    Join Date
    Dec 2003
    Location
    Connecticut
    Posts
    5
    Thanks a bunch!!!

    I will keep you posted on how things go!

    You were the best help!!
    Reply With Quote Reply With Quote
  8. 12-17-2003, 09:21 PM #8
    tisme1020
    tisme1020 is offline Registered User
    Join Date
    Dec 2003
    Location
    Connecticut
    Posts
    5
    Thanks a bunch!!!

    You were the best help!!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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