• Servlet
  • Core Java
  • PHP
  • Struts
  • Java IO
  • SQL Tutorial
  • JSP
  • Spring
  • RubyonRails

  • <

    What is SQL?

    SQL stands for Structured Query Language.You access and manipulate databases.


    RDBMS

    RDBMS ( Relational Database Management System) is the basis for SQL, and for all modern database systems such as MS SQL Server, MySQL etc.

    The data in RDBMS is stored in database objects called tables. A table is a collection of related data entries and it consists of columns and rows.


    SQL Important Commands



  • SELECT - extracts data from a database

  • UPDATE - updates data in a database

  • DELETE - deletes data from a database

  • INSERT INTO - inserts new data into a database

  • CREATE DATABASE - creates a new database

  • ALTER DATABASE - modifies a database

  • CREATE TABLE - creates a new table

  • ALTER TABLE - modifies a table

  • DROP TABLE - deletes a table

  • CREATE INDEX - creates an index (search key)

  • DROP INDEX - deletes an index

















  • © copyright 2017-2021 Completedone pvt ltd.