abase is called the select query and is where the magic of SQL happens. Select statements can be incredibly simple or deviously complex. To select information from a database you should use the following query:
"SELECT * FROM tablename
You can select specific columns by substituting column names for the * in the example query.
PHP and SQL
SQL is a great language, however it doesn't interact with the web at all. In order to build a web page that uses a SQL database you need to use a language that interacts with the SQL and can print out HTML. The most commonly used language for this purpose is PHP. Unfortunately this guide is not long enough to teach you how to interact with your SQL server, however the following links should help you.