4.5 SQL (Structured Query Language)

SQL (Structured Query Language) is a standard language for accessing and manipulating databases, and is an ANSI (American National Standards Institute) standard. It can execute queries against a database, retrieve data, insert records, update records and even delete records. In addition it can create new databases, new tables in those databases, create stored procedures, create views in a database and set permissions on those tables, procedures and views.

To build web sites showing data from a database would require several components:

• An RDBMS (Relational Database Management System) database program like MS Access, SQL Server or MySQL;
• A server-side scripting language such as PHP or ASP;
• SQL;
• HTML & CSS.

Most databases contain tables that contain rows of data. SQL statements can be used for accessing and manipulating this data. As you can see though, SQL is only a part of the process involved in using database information on a website. And although SQL is an ANSI standard, there are many different versions of the SQL language. However, they all support the major commands in a similar manner.

• 1.0 Search Engine Optimisation
• 1.1 Internal Ranking Factors
• 1.2 External Ranking Factors
• 1.3 Getting inbound links
• 1.4 Submitting to Search Engines
• 1.5 SEO Bad Practice
• 2.0 Web Standards
• 2.1 DTD
• 2.2 Choosing a DTD
• 2.3 Validating Pages
• 3.0 Web Summary
• 4.0 Other Web Languages
• 4.1 Javascript
• 4.2 XML
• 4.3 ASP
• 4.4 PHP
• 4.5 SQL
• 5.0 Monetizing Websites