What is the use of SQL in websites designing? What is the main purpose of using SQL?

7 replies
What is the use of SQL in websites designing? What is the main purpose of using SQL?
#designing #main #purpose #sql #websites
  • Profile picture of the author David Beroff
    Why don't you click on the link in your signature and find out?
    Put MY voice on YOUR video: AwesomeAmericanAudio.com
    {{ DiscussionBoard.errors[10640107].message }}
  • When you create interactive websites, SQL or database queries are used to store and retrieve data from databases to display on the website which is used to interact with site users.
    [ Pure SSD ][ Shared, Reseller, Dedicated Server Hosting ] - [ MECHANICWEB.COM ]
    [ LiteSpeed | CloudLinux | MariaDB | cPanel | Malware Scan | Softaculous | SpamExperts ]
    {{ DiscussionBoard.errors[10640746].message }}
  • Profile picture of the author Thoughtgrid
    In this SQL used to refer a database you use database,you use database in website store collected data you fetch the data back end database the spread of dynamic websites world wide web is largely due to the possibility due to their content handled through database
    {{ DiscussionBoard.errors[10830672].message }}
  • Profile picture of the author Claire Anderson
    When you have large amount of data that you need to store and keep secure then you create database, to store that data. But to manage that data and perform operation on that data stored in the database, you need DBMS or Database Management System.

    DBMS is collection of software that are used to perform addition, subtraction, deletion and insertion operations on the database or in other words it manages the database. Example of DBMS are mysql and oracle etc.

    Now you have a database where the data is stored and the DBMS to manage the database, but to perform the deletion or insertion operations in the database, you also need a language which is called SQL. Structure Query Language (SQL) queries are used to perform different operations in the database. Without this language you cannot communicate with the database.
    {{ DiscussionBoard.errors[10830930].message }}
  • Profile picture of the author asadul549
    SQL is structured query language which is used to create website user database or data management system. In that case it also can be the question that what's the difference between SQL & MySQL?
    sorry, I don't know!
    {{ DiscussionBoard.errors[10831576].message }}
  • Profile picture of the author Badaudio
    SQL is used for storing data in a database, plain and simple. It is not associated with the aesthetic design of the website per se.
    {{ DiscussionBoard.errors[10867186].message }}
  • Profile picture of the author Hatuko
    As an additional note to what has already been said, SQL is a standard and there are various dialects compatible with one or another database system, all sharing most things in common. However SQL can only be used with relational databases such as Postgres, MySQL, etc. Other, non relational database systems can be queried with SQL-like languages or entirely different ways.
    {{ DiscussionBoard.errors[10870105].message }}

Trending Topics