SQL (Structured Query Language)
Let's Talk to a Database!
by D1J1T — in MySQL — Updated: Mar 1, 2014 at 9:41 am
The goal of the article is to provide a simple overview of the features of SQL.
*** If you are new to programming and your goal is to learn this language, I'd recommend
learning HTML first. SQL is often used in a web page in conjunction with several
other languages, the least of which is HTML. A scripting language like PHP, ASP, or JSP is also used
to deliver SQL code to and from a database. Though the syntax may be simple, the implementation
requires other skills. ***
SQL is a language (and an ANSI standard) used to access relational databases.
It uses a server-side scripting language like PHP, ASP, JSP to communicate with a database such as MySQL,
SQL Server, or MS Access.
Main SQL Functions
These include:
- SELECT
- INSERT
- UPDATE
- DELETE
- CREATE
- ALTER
- DROP
SQL is vital for programs (web scripts) to communicate with a database on a web server. It delivers the basic functions listed above via the server to the database and allows the scripting language to execute or display results.
SQL can create database tables and populate them with data. In conjunction with a server-side scripting language, SQL can display data on a web page based on relevant conditions delivered by a script.
If you find these articles to be helpful, I could always use another cup of coffee! Social media likes/+1s are also much appreciated. Thanks for reading!