Blog Details

What is SQL?

<h2>* <span style="text-decoration: underline;">What is SQL?</span></h2>
<ul>
<li>SQL stands for <strong>Structured Query Language</strong></li>
<li>SQL lets you <strong>access and manipulate</strong> databases</li>
<li>SQL is an <strong>ANSI (American National Standards Institute) standard</strong></li>
</ul>
&nbsp;
<h2>* <span style="text-decoration: underline;">What Can SQL do?</span></h2>
<ul>
<li>SQL can execute<strong> queries</strong> against a<strong> database</strong></li>
<li>SQL can retrieve data from a <strong>database</strong></li>
<li>SQL can <strong>insert records</strong> in a database</li>
<li>SQL can <strong>update records</strong> in a database</li>
<li>SQL can <strong>delete records</strong> from a database</li>
<li>SQL can <strong>create</strong> new databases</li>
<li>SQL can <strong>create new tables</strong> in a database</li>
<li>SQL can <strong>create stored procedures</strong> in a database</li>
<li>SQL can <strong>create views</strong> in a database</li>
<li>SQL can set permissions on<strong> tables, procedures, and views</strong></li>
</ul>
&nbsp;
<h2>* <span style="text-decoration: underline;">Using SQL in Your Web Site</span></h2>
To build a web site that shows data from a database, you will need:
<ul>
<li>An RDBMS <strong>database program</strong> (i.e. MS Access, SQL Server, MySQL)</li>
<li>To use a <strong>server-side scripting language</strong>, like PHP or ASP</li>
<li>To use <strong>SQL to get the data you want</strong></li>
<li>To use <strong>HTML / CSS</strong></li>
</ul>
&nbsp;