SQL tutorials and SQL Introduction

SQL tutorials




SQL is the standard computer language used to access and process the database.
In this tutorial, you will learn how to use SQL to access and process data in a data system, including MySQL, SQL Server, Access, Oracle, Sybase, DB2, and so on.

Each chapter example

Each chapter provides a simple SQL simple example.

Examples

SELECT * FROM Websites ;
This tutorial’s SQL is tested in MySQL.
This tutorial uses the Websites table in the SQL file: websites.sql .
This tutorial uses the access_log table SQL file: access_log.sql .
This tutorial uses the application table for the SQL file: apps.sql .
Now start learning SQL!

SQL Quick Reference Manual

A quick reference manual for SQL, you can print it in your pocket and view it at any time.
SQL Quick Reference Manual

SQL data type

Describes the data types and scopes of Microsoft Access, MySQL, and SQL Server.

SQL Introduction


SQL is the standard computer language used to access and process the database.

What is SQL?

  • SQL, refers to the structure of the query language, the full name is Structured Query Language.
  • SQL allows you to access and process the database.
  • SQL is an ANSI (American National Standards Institute) standard computer language.

What can SQL do?

  • SQL for database execution queries
  • SQL retrieves data from the database
  • SQL can insert a new record in the database
  • SQL can update the data in the database
  • SQL can delete records from the database
  • SQL can create a new database
  • SQL can create new tables in the database
  • SQL can create stored procedures in the database
  • SQL can create a view in the database
  • SQL can set permissions for tables, stored procedures, and views

SQL is a standard – but …

Although SQL is an ANSI (American National Standards Institute) standard computer language, there are still many different versions of the SQL language.
However, in order to be compatible with the ANSI standard, they must be in a similar way to jointly support some of the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE, etc.).
Lamp Note: In addition to the SQL standard, most SQL database programs have their own proprietary extensions!


Use SQL on your website

To create a website that displays data in the database, you need to:
  • RDBMS database programs (such as MS Access, SQL Server, MySQL)
  • Use a server-side scripting language, such as PHP or ASP
  • Use SQL to get the data you want
  • Use HTML / CSS

RDBMS

RDBMS refers to relational database management system, full name Relational Database Management System.
RDBMS is the foundation of SQL, and it is also the foundation of all modern database systems, such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.
The data in the RDBMS is stored in a database object called a table.
A table is a collection of related data items, consisting of columns and rows.

Leave a Reply

Your email address will not be published. Required fields are marked *