structured query language sql n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Structured Query Language SQL PowerPoint Presentation
Download Presentation
Structured Query Language SQL

Loading in 2 Seconds...

play fullscreen
1 / 12

Structured Query Language SQL - PowerPoint PPT Presentation


  • 102 Views
  • Uploaded on

Fact of the Week: According to the 2010 outlook from the BLS 286,600 new Computer, Network, and Database administrator jobs will be added in the next decade. . Structured Query Language SQL. Learning Objectives. Describe and use basic SQL commands

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 'Structured Query Language SQL' - helena


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
structured query language sql

Fact of the Week:

According to the 2010 outlook from the BLS 286,600 new Computer, Network, and Database administrator jobs will be added in the next decade.

Structured Query LanguageSQL

learning objectives
Learning Objectives
  • Describe and use basic SQL commands
  • Explain how and why SQL is used, and why its important
  • Compare and contrast DML and DDL
  • Use SQL commands to create metadata structures and perform CRUD operations.
brief history of sql
Brief History of SQL
  • 1970– E. Codd develops relational database concept
  • 1974-1979–System R with Sequel (later SQL) created at IBM Research Lab
  • 1979–Oracle markets first relational DB with SQL
  • 1986–ANSI SQL standard released
  • 1989, 1992, 1999, 2003, 2007–Major ANSI standard updates
  • Current–SQL is supported by most major database vendors at 1999, 2003 and 2007

http://www.jcc.com/sql.htm

benefits of the sql standard
Benefits of the SQL standard
  • Reduced training costs
  • Productivity
  • Application portability
  • Application longevity
  • Reduced dependence on a single vendor
  • Cross-system communication

Yes. The standard helps, but each of these benefits is not as realized as other standards, such as HTML

the sql environment
The SQL Environment

Server

Instance

Catalog (db)

Catalog (db)

Schema

Schema

Objects

Instance

  • In this class we use:
  • SQL Server ist-s-students,1533
  • With the default instance
  • Each student has their own catalog (db)
  • Default schema (dbo)
sql server 2005 ist s students
SQL Server 2005: ist-s-students
  • Other Information:
    • SQL Dialect: T-SQL / Transact-SQL
    • Case Sensitive Collation?: Yes
    • System tables used to represent meta data.
    • Client / Server over TCP/IP Connect to database using:
      • host/IP, port number, logon, password
      • Client software used to manage data/meta data on server
    • Everything can be expressed in SQL!
  • Naming Rules for Objects in SQL Server:
    • Up to 128 characters long
    • Must begin with a letter
    • Can contain digits, letters, _, .
    • Spaces can be used but should be avoided.
example syntax diagrams
Example: Syntax Diagrams
  • Examples (syntactically correct???):
    • The old dog ate.
    • The fat cat walked slowly.
    • The sick, brown, ugly horse died.
    • The dog slept lazily.

THE [adjective[, …n]] {CAT|DOG|HORSE} verb [adverb].