All about SQL web programming

Asked By Emily Haist 10 points N/A Posted on - 04/08/2012

Hi techyv,

What is SQL web language?

Can you show me some example code using SQL?

Thanks techyv.

• Status: Open
• Question Views: 898
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: ProgScripting Languages

Best Answer by prenith

Go To Solution

Best Answer

Best Answer

Answered By prenith 0 points N/A #102236

All about SQL web programming

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.

About prenith

Questions
0

Answers
3

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 04/08/2012
• Question Category: ProgScripting Languages

Answered By Sharath Reddy 590495 points N/A #102237

All about SQL web programming

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.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 02/27/2013
• Question Category: ProgScripting Languages