- SQL Basic
- SQL HOME
- SQL Intro
- SQL Syntax
- SQL Select
- SQL Distinct
- SQLWhere
- 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 functions
- SQL Functions
- SQL avg()
- SQL count()
- SQL first()
- SQL last()
- SQL max()
- SQL min()
- SQL sum()
- SQL Group By
- SQL Having
- SQL ucase()
- SQL lcase()
- SQL mid()
- SQL len()
- SQL round()
- SQL now()
- SQL format()
|
||||
|
SQL is a standard language for accessing and manipulating databases..
What Is SQL?
What Can SQL do?
SQL is a Standard - BUT...Although SQL is an ANSI (American National Standards Institute) standard, there are many different versions of the SQL language. However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner. Note: Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!
Using SQL in Your Web SiteTo build a web site that shows some data from a database, you will need the following:
RDBMSRDBMS stands for Relational Database Management System. RDBMS is the basis for SQL, and for all modern database systems like MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access. The data in RDBMS is stored in database objects called tables. A table is a collections of related data entries and it consists of columns and rows.
|
||||