SQL Server – English

Spread the love

SQL – Structure query language is a computer language which helps to store large data, manipulate and stores in relational database. It was first invented in 1974 by IBM group and commercially released by relational software which known as Oracle.

Multiple vendors created their own product and used with some modification.Microsoft database uses SQL, DBCC (database console command), Shell scripting within.

SQL developers use the SQL command, DBCC command and shell for automation task in production environment. It can be vary according to uses.

It is segregated in following section –

  • DATA TYPES
  • FUNCTIONS
  • TRIGGERS
  • ALTER
  • BASIC STATEMENTS
  • STORED PROCEDURES
  • DML and DLL
  • COMPLEX QUERY WRITING
  • WHERE/GROUPING / HAVING
  • JOIN / MAPPING
  • ALIAS
  • TEXT CRUNCHING
  • CONSTRAINTS
  • LOOP / BATCH EXECUTION
  • SYSTEM COMMANDS
  • VIEWS/STORED PROCEDURES/DEBUGGING
  • TEMP/ GLOABLE TABLE
  • INDEXES
  • SUB QUERIES/ CTE
  • DBCC
  • SYSTEM’S STORED PROCEDURES
  • CAPTURED DATA CHANGED
  • T-SQL (TRANSACTION SQL)