What is SQL - SQL Introduction - What is SQL Database ?
Introduction to SQL
- SQL- Structured Query Language, is like a powerful language for talking to databases. Imagine you have a huge filing cabinet (the database) with neatly organized drawers (tables). SQL is the language you use to ask questions, add new stuff, update existing things, or remove stuff from these drawers
What Can SQL do?
- Execute queries against a database
- Retrieve data from a database
- Insert records into a database
- Update records within a database
- Delete records from a database
- Create new databases
- Define new tables within a database
- Establish stored procedures in a database
- Create views in a database
- Set permissions on tables, procedures, and views
Implementing SQL in Your Website
- To create a website displaying data from a database, you'll require:
- An RDBMS database program (e.g., MS Access, SQL Server, MySQL)
- Utilize a server-side scripting language such as PHP or ASP
- Employ SQL for retrieving the desired data
- Use HTML/CSS to style the page