1 / 12

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 Language SQL. Learning Objectives. Describe and use basic SQL commands

jin
Download Presentation

Structured Query Language SQL

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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

  2. 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.

  3. 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

  4. The purpose of the SQL standard

  5. 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

  6. 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)

  7. 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.

  8. My Naming Conventions

  9. SQL: Language Breakdown

  10. Workflow in SQL Mgmt Studio • Type in SQL • Highlight it • Check it (For syntax errors) • Wreck it (Execute on Server) • Once you execute “the program has run and the damage is done.” There is no undo, only redo, meaning if you delete something to get it back you must start over again.

  11. Examples • Create students table • First name, Last name, netid, Year, GPA • Inserting data • Constraints unique, check • Updating Data • Foreign key lookup table • Using the select statement

  12. On to the Demos… Structured Query Language SQL Basics

More Related