Final Review(1)

Final Review(1) - Final Review Jinie Pak Department of...

Info iconThis preview shows pages 1–14. Sign up to view the full content.

View Full Document Right Arrow Icon
Final Review Jinie Pak Department of Information Systems UMBC
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Coverage Chapter 7 Chapter 8 Chapter 11 pp. 462-476 Chapter 13 pp. 556-597 All lecture material and in-class discussion
Background image of page 2
Introduction to SQL Understand SQL Environment Describe the three types of SQL language Create, update, and drop tables using DDL Define constraints using DDL Understand what is a view and why view Use DCL to grant/revoke object privileges Use SQL DML commands to manipulate a single table: Query (Read) Modification (Write)
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
SQL Environment Catalog A set of schemas that constitute the description of a database Schema The structure that contains descriptions of objects created by a user (base tables, views, constraints) Data Definition Language (DDL) Commands that define a database, including creating, altering, and dropping tables and establishing constraints Data Manipulation Language (DML) Commands that maintain and query a database Data Control Language (DCL) Commands that control a database, including administering
Background image of page 4
SQL Data Definition Language (DDL) Define the database. CREATE, ALTER, or DROP a base TABLE or VIEW. Data Manipulation Language (DML) Manipulate the data in an existing database. SELECT, INSERT, UPDATE, or DELETE data. Data Control Language (DCL) Control user access to an existing database.
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Default value Domain constraint Controlling the values in attributes
Background image of page 6
Primary key of parent table Identifying foreign keys and establishing relationships Foreign key of dependent table
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
DML: SUMMARY SELECT: projection FROM : Choose Table WHERE: selection GROUP BY HAVING ORDER BY
Background image of page 8
SELECT Example Find products with standard price less than $275 SELECT PRODUCT_NAME, STANDARD_PRICE FROM PRODUCT_V WHERE STANDARD_PRICE < 275; Table 7-3: Comparison Operators in SQL
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
SELECT Example– Qualifying Results by Categories Using the HAVING Clause For use with GROUP BY SELECT CUSTOMER_STATE, COUNT(CUSTOMER_STATE) FROM CUSTOMER_V GROUP BY CUSTOMER_STATE HAVING COUNT(CUSTOMER_STATE) > 1; Like a WHERE clause, but it operates on groups (categories), not on individual rows. Here, only those groups with total numbers greater than 1
Background image of page 10
SQL DCL Two major types GRANT OR REVOKE system privileges User’s ability to CREATE, MODIFY and ELIMINATE database objects GRANT OR REVOKE object privileges User’s ability to ADD, DELETE, CHANGE or VIEW objects You will only learn the second type
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Advanced SQL Describe why and how to create indexes Understand and apply one types of basic PL/SQL: trigger Use the SQL commands to manipulate multiple tables JOIN UNION INTERSECT DIFFERENCE Use IN and EXISTS to perform nested queries
Background image of page 12
Figure 8-2 Visualization of different join types with results returned in shaded area
Background image of page 13

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 14
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/28/2012 for the course IS 410 taught by Professor Chen,z during the Fall '08 term at UMBC.

Page1 / 42

Final Review(1) - Final Review Jinie Pak Department of...

This preview shows document pages 1 - 14. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online