Course Hero Logo

Chapter 7 Basic SQL.pptx - Chapter 7 Basic SQL- Structured...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 7 out of 46 pages.

Chapter 7 Basic SQL- Structured Query Language1
Learning Objectives:Understand basic commands and functions of SQLUnderstand the use of SQL for data administration (to create tables and indexes)Understand the use of SQL for data manipulation (to add, modify, delete, and retrieve data)Understand the use of SQL to query a database for useful information2
Introduction to SQLWhat SQL can do?SQL can execute queries against a databaseSQL can retrieve data from a databaseSQL can insert records in a databaseSQL can update records in databaseSQL can delete records in databaseSQL can create new databasesSQL can create new tables in a databaseSQL can create stored procedures in a databaseSQL can create views in databaseSQL can set permissions on tables, procedures and views3
SQL statementSQL IS NOT CASE SENSITIVE LANGUAGE4
Data Definition Language (DDL)DDL manages table and index structure. The most basic items of DDL:CREATE– create an object (i.e. table) in the databaseDROP– deletes an object in the database, usually irretrievablyALTER– modifies the structure of an existing object in various ways, for example, adding a column to an existing table5
Data Manipulation Language (DML)

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 46 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Summer
Professor
N/A
Tags

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture