SQL & MYSQL Tutorial for Beginners | Introduction

SQL & MYSQL Tutorial for Beginners | Introduction

SQL is a database computer language designed for the retrieval and management of data in a relational database.

SQL stands for Structured Query Language. This tutorial will give you a quick start to SQL. It covers most of the topics required for a basic understanding of SQL and to get a feel of how it works.

Related searches for SQL & MYSQL Tutorial

Introduction to SQL

SQL stands for Structured Query Language

SQL lets you access and manipulate databases

SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987

SQL tutorial provides basic and advanced concepts of SQL. Our SQL tutorial is designed for beginners and professionals.

SQL (Structured Query Language) is used to perform operations on the records stored in the database such as updating records, deleting records, creating and modifying tables, views, etc.

SQL is just a query language; it is not a database. To perform SQL queries, you need to install any database, for example, Oracle, MySQL, MongoDB, PostGre SQL, SQL Server, DB2, etc.

 

What is SQL?

  • SQL stands for Structured Query Language.
  • It is designed for managing data in a relational database management system (RDBMS).
  • It is pronounced as S-Q-L or sometime See-Qwell.
  • SQL is a database language, it is used for database creation, deletion, fetching rows, and modifying rows, etc.
  • SQL is based on relational algebra and tuple relational calculus.
  • All DBMS like MySQL, Oracle, MS Access, Sybase, Informix, PostgreSQL, and SQL Server use SQL as standard database language.

 

Why SQL is required

SQL is required:

  • To create new databases, tables and views
  • To insert records in a database
  • To update records in a database
  • To delete records from a database
  • To retrieve data from a database

 

What SQL does

  • With SQL, we can query our database in several ways, using English-like statements.
  • With SQL, a user can access data from a relational database management system.
  • It allows the user to describe the data.
  • It allows the user to define the data in the database and manipulate it when needed.
  • It allows the user to create and drop database and table.
  • It allows the user to create a view, stored procedure, function in a database.
  • It allows the user to set permission on tables, procedures, and views.

 

What Can SQL do?

SQL can execute queries against a database

SQL can retrieve data from a database

SQL can insert records in a database

SQL can update records in a database

SQL can delete records from a database

SQL can create new databases

SQL can create new tables in a database

SQL can create stored procedures in a database

SQL can create views in a database

SQL can set permissions on tables, procedures, and views

 

Using SQL in Your Web Site

To build a web site that shows data from a database, you will need:

  • An RDBMS database program (i.e. MS Access, SQL Server, MySQL)
  • To use a server-side scripting language, like PHP or ASP
  • To use SQL to get the data you want
  • To use HTML / CSS to style the page

 

Related searches for SQL & MYSQL Tutorial

Tags:,

One Comment

Add a Comment

Your email address will not be published.