Easy Tutorial
Sql Having Sql Func Mid Sql Between Sql Drop Sql Wildcards Sql Join Inner Sql Join Full Sql Func Lcase Sql Where Sql Join Sql Func Round Sql Primarykey Sql Func First Sql Func Len Sql Distinct Sql Func Ucase Sql Function Sql Delete Sql Autoincrement Func Curtime Sql Update Sql Isnull Func Date Sub Sql Constraints Sql Intro Sql Dates Sql Select Into Sql Hosting Sql Create Table Sql Func Format Sql View Sql Func Count Sql Index Sql Like Sql Datatypes General Sql Datatypes Func Convert Sql Func Avg Sql Foreignkey Sql Func Sum Sql Join Right Func Curdate Sql Alias Sql Union Func Date Add Sql Groupby Sql Summary Sql In Sql Null Values Sql Syntax Sql Tutorial Sql Insert Into Select Sql And Or Sql Join Left Sql Func Now Func Date Sql Top Index Sql Create Db Sql Unique Sql Check Func Extract Sql Alter Sql Notnull Func Now Sql Select Sql Insert Sql Func Max Sql Exists Sql Func Min Func Date Format Func Datediff Mysql Func Getdate Sql Orderby Func Datediff Sql Func Last Sql Create Index Func Dateadd Sql Quickref Func Datepart
❮ Sql Constraints Sql Dates ❯

Introduction to SQL

SQL (Structured Query Language) is used to manage relational database management systems (RDBMS). SQL's scope includes data insertion, querying, updating, and deletion, database schema creation and modification, and data access control.

What is SQL?

What can SQL do?

SQL is a Standard - But...

Although SQL is an ANSI (American National Standards Institute) standard computer language, there are different versions of the SQL language.

However, to be compliant with the ANSI standard, they must support the main commands in a similar manner (such as SELECT, UPDATE, DELETE, INSERT, WHERE).

| | Note: Apart from the SQL standard, most SQL database programs have their own proprietary extensions! | | --- | --- |

Using SQL on Your Website

To create a website that displays data from a database, you need:

RDBMS

RDBMS stands for Relational Database Management System.

RDBMS is the basis for SQL and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.

Data in RDBMS is stored in database objects called tables.

A table is a collection of related data entries and consists of columns and rows.

❮ Sql Constraints Sql Dates ❯