What is Database Language- SQL stuff?

Discussion in 'MySQL' started by designventures, Feb 7, 2009.

  1. #1
    Am always wondering.. What is a database SQL/Oracle / VB++ language and how is database labguage different from Programming languages like C/C++, Java

    Can anyone explain in detail different languages, its type & uses? What are Major languages should you learn...

    Ok If you were suppose to learn ONLY 2 Languages..which Language do you think will make you Multi Tasking?

     
    designventures, Feb 7, 2009 IP
  2. crivion

    crivion Notable Member

    Messages:
    1,669
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    210
    Digital Goods:
    3
    #2
    You should learn
    PHP and MYsql
    or
    ASP.net with mS sql

    A programming language is some code
    A database its an engine where you store some fields laters to be manipulated by that programming lang : like you would store something in a textfile and will save it to have it later

    hopefully this helps
     
    crivion, Feb 7, 2009 IP
  3. mmerlinn

    mmerlinn Prominent Member

    Messages:
    3,197
    Likes Received:
    819
    Best Answers:
    7
    Trophy Points:
    320
    #3
    A DB language is a language specifically written to manipulate DB data. C languages are general purpose programming languages that are not very well suited for manipulating DB data even though you can 'force' them to do that job.

    One of the languages I would learn is some sort of DB language and the other one some sort of general programming language.

    The DB language I use is FoxPro, which probably has the LARGEST INSTALLED database count of all languages, since FP has been around longer than any other commonly used DB language in use today. And it will continue to be a major DB engine at least until 2015 when MicroShaft quits selling & supporting it. At some point down the road, FP will be overtaken by newer languages, but I don't see that happening for many more years.

    Regardless, I will be using FP at least for another decade because it is one of the most versatile languages I have ever seen. After over 14 years of using FP, I have yet to find something that I need done that it cannot do.

    Currently, I am using FP

    1) for DB manipulation,
    2) for writing of other programs in ANY language (you can even use FP to write other DB programs),
    3) for generation of HTML/Javascript webpages,
    4) for scraping webpages from the internet,
    5) for scraping CSV and similar files,
    6) and for generation of eBay pages.

    Most DB languages either cannot be used or are a pain to use for ANYTHING other than DB manipulation.

    Because of the versatility of FP, I have never had any need to learn any general programming language since acquiring FP. Before FP, I was proficient in BASIC, but have not used BASIC in over 10 years. Although I would probably learn one of the C languages if I decided I needed it to supplement FP.
     
    mmerlinn, Feb 7, 2009 IP