Introduction to Structured Query Language (SQL).pptx

Introduction to Structured Query Language (SQL).pptx

• 1.
  Introduction to Structured QueryLanguage (SQL)
• 2.
  Introduction • SQL functionsfit into two broad categories: • Data definition language • SQL includes commands to create • Database objects such as tables, indexes, and views • Commands to define access rights to those database objects • Data manipulation language • Includes commands to insert, update, delete, and retrieve data within the database tables
• 3.
  Introduction • SQL isrelatively easy to learn • Basic command set has a vocabulary of less than 100 words • Nonprocedural language • American National Standards Institute (ANSI) prescribes a standard SQL • Several SQL dialects exist