Walk Lightly on this PLANET and yet leave such a FOOTPRINT that cannot be erased for thousands of Years..!!!
Visit Codstech for Cyber Security related Posts !

Visitors

SQL





  • Introduction to SQL

What is SQL?
===========
SQL is a standard language for accessing databases.
  • SQL stands for Structured Query Language
  • SQL lets you access and manipulate databases
  • SQL is an ANSI (American National Standards Institute) standard
Where to type SQL Queries ?
========================You can use WAMP server .The link is WAMP  , or can download SQL from here .

RDBMS is the basis for SQL, and for all modern database systems (Refer the link 
Introduction to DBMS / RDBMS )
without SQL or any other knid of Databases, we can't store informations.
  1. Introduction to DBMS / RDBMS
  2. Command line interface & GUI interface
  3. SQL - Some Examples
Quick reference Useful Commmands at a glance  
(SQL - Quick reference)


(A) Some basics of SQL

  1. SQL-create Database & Table
  2. SQL-Statements
  3. Starting SQL Commands 
  4. SQL "SELECT" STATEMENT
  5. SQL " SELECT DISTINCT " STATEMENT
  6. SQL "WHERE" Clause
  7. SQL " AND & OR "Operators
  8. SQL "ORDER BY" Keyword
  9. SQL "INSERT INTO" Statement
  10. SQL "UPDATE" Statement
  11. SQL "UPDATE" Statement

(B) Advanced SQL

(Progressing....)

(C) Comands in MySQL
  1. MySQL introduction