SQL
Download
1 / 5

SQL - PowerPoint PPT Presentation


  • 139 Views
  • Uploaded on

SQL. Introduction. SQL: Intro. “ S.Q.L. ” or “sequel” Supported by all major commercial database systems Standardized – many new features over time Interactive via GUI or prompt, or embedded in programs Declarative, based on relational algebra. SQL: Intro.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' SQL' - kesler


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

SQL

Introduction


SQL: Intro

  • “S.Q.L.” or “sequel”

  • Supported by all major commercial database systems

  • Standardized –many new features over time

  • Interactive via GUI or prompt, or embedded in programs

  • Declarative, based on relational algebra


SQL: Intro

  • Data Definition Language (DDL)

  • Data Manipulation Language (DML)

  • Other Commands

  • indexes, constraints, views, triggers, transactions, authorization, …


SQL: Intro

  • The Basic SELECT Statement

  • Select A1,A2,…,An

  • From R1,R2, …,Rm

  • Where condition


SQL: Intro

  • “S.Q.L.” or “sequel”

  • Supported by all major commercial database systems

  • Standardized –many new features over time

  • Interactive via GUI or prompt, or embedded in programs

  • Declarative, based on relational algebra


ad