All about SQL web programming

Asked By 10 points N/A Posted on -
qa-featured

Hi techyv,

What is SQL web language?

Can you show me some example code using SQL?

Thanks techyv.

SHARE
Best Answer by prenith
Best Answer
Best Answer
Answered By 0 points N/A #102236

All about SQL web programming

qa-featured

Summary on SQL

  • The full form of SQL is Structured Query Language.
  • SQL allows users to  access and manipulate databases.
  • It is a standard  based on ANSI (American National Standards Institute)

What Can SQL do?

  • Execution of  queries against a database.
  • Retrieval of  data  from a database.
  • Insertion of records in a database.
  • Updating of records in a database.
  • Deletion of  records from a database.
  • Creation of new databases.
  • Creation of  new tables in a database.
  • Through SQL, it's possible for stored procedures to be created.
  • In the database, views can be created/modified.
  • Setting of necessary permissions on tables, procedures, and views as and when needed.

Like most programming languages, there are  different versions of the SQL language, although its specifically an ANSI standard. The different versions have supported the major commands in almost same manner as to be compliant to ANIS standard. In addition to the SQL standard, many of SQL database programs also have their own specific and proprietary extensions.

For use SQL in any website, the following things are needed:

  • An RDBMS database program (i. e. MS Access, SQL Server, MySQL).
  • A server-side scripting language, like PHP or ASP.
  • SQL.
  • HTML / CSS.
Answered By 590495 points N/A #102237

All about SQL web programming

qa-featured

SQL is the standard language for accessing databases.

To learn how to use SQL to access and manipulate data in SQL Server, MySQL, Sybase, Access, Oracle, DB2, and other database systems, please visit w3schools SQL Tutorial.

Here are some of the SQL commands or functions that you can learn:

SQL Basic

  • SQL Syntax
  • SQL Select
  • SQL Distinct
  • SQL Where
  • SQL And & Or
  • SQL Order By
  • SQL Insert
  • SQL Update
  • SQL Delete

SQL Advanced

  • SQL Top
  • SQL Like
  • SQL Wildcards
  • SQL In
  • SQL Between
  • SQL Alias
  • SQL Joins
  • SQL Inner Join
  • SQL Left Join
  • SQL Right Join
  • SQL Full Join
  • SQL Union
  • SQL Select Into
  • SQL Create DB
  • SQL Create Table
  • SQL Constraints
  • SQL Not Null

SQL Functions

  • SQL avg()
  • SQL count()
  • SQL first()
  • SQL last()
  • SQL max()
  • SQLmin()
  • SQL sum()
  • SQL Group By
  • SQL Having
  • SQL ucase()

The site also offers a demo for you to learn the basics easily.

Click on the link to visit the site and learn from some of the given basic examples.

Related Questions