DATA Base

SQL Tutorial

The 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 records stored in a database such as updating records, deleting records, creating tables, viewing and modifying and so on.

SQL is just a query language; This 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 is for structured query language.
  • It is designed to manage data in a relational database management system (RDBMS).
  • It is pronounced as S-Q-L or sometimes See-Qwell.
  • SQL is a database language, it is used for database creation, deletion, wrenching and modifying rows, etc.
  • SQL is based on relational algebra and tuple relational calculus.

All DBMSs such as MySQL, Oracle, MS Access, Sybase, Informix, PostgreSQL and SQL Server use SQL as the database database language.

Why SQL is required?

SQL Required:

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

What SQL does?

  • With SQL, we can query our database in many ways using statements like English.
  • With SQL, a user can access data from a relational database management system.
  • This allows the user to describe the data.
  • This allows the user to define data in the database and manipulate it when needed.
  • This allows the user to create and drop databases and tables.
  • This allows the user to create a visible, stored procedure, function in the database.
  • This allows the user to set permissions on tables, processes, and views.

SQL Index


SQL Tutorial

  • Introduction to SQL
  • SQL Syntax
  • SQL Data Types
  • SQL Operators

SQL Database

  • SQL CREATE Database
  • SQL DROP Database
  • SQL RENAME Database
  • SQL SELECT Database

SQL Table

  • What is Table
  • SQL TABLE Variable
  • SQL CREATE TABLE
  • SQL DROP TABLE
  • SQL DELETE TABLE
  • SQL RENAME TABLE
  • SQL TRUNCATE TABLE
  • SQL COPY TABLE
  • SQL TEMP TABLE
  • SQL ALTER TABLE

SQL Insert

  • INSERT Statement
  • INSERT INTO Values
  • INSERT INTO SELECT
  • INSERT Multiple Rows

SQL Select

  • SELECT Statement
  • SQL SELECT UNIQUE
  • SQL SELECT DISTINCT
  • SQL SELECT COUNT
  • SQL SELECT TOP
  • SQL SELECT FIRST
  • SQL SELECT LAST
  • SQL SELECT RANDOM
  • SQL SELECT AS
  • SQL SELECT IN
  • SQL SELECT Multiple
  • SQL SELECT DATE
  • SQL SELECT SUM
  • SQL SELECT NULL

SQL Clause

  • SQL WHERE
  • SQL AND
  • SQL OR
  • SQL WITH
  • SQL AS

SQL Order By

  • ORDER BY Clause
  • ORDER BY ASC
  • ORDER BY DESC
  • ORDER BY RANDOM
  • ORDER BY LIMIT
  • ORDER BY Multiple Cols

SQL Update

  • UPDATE Statement
  • SQL UPDATE JOIN
  • SQL UPDATE DATE

SQL Delete

  • DELETE Statement
  • SQL DELETE TABLE
  • SQL DELETE ROW
  • SQL DELETE All Rows
  • DELETE Duplicate Rows
  • SQL DELETE DATABASE
  • SQL DELETE VIEW
  • SQL DELETE JOIN

SQL Join

  • SQL JOIN
  • SQL Outer Join
  • SQL Left Join
  • SQL Right Join
  • SQL Full Join
  • SQL Cross Join

SQL Keys

  • Primary Key
  • Foreign Key
  • Composite Key
  • Unique Key
  • Alternate Key

Difference

  • SQL vs NoSQL

PL/SQL Tutorial

  • PL/SQL Tutorial

Interview

  • SQL Interview
  • PL/SQL Interview

Quiz

  • SQL Quiz

Leave a Reply

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