SQL_ Advanced Querying

Document Sample
SQL_ Advanced Querying Powered By Docstoc
					SQL: Advanced Querying
SQA ONE DAY COURSE DESCRIPTION Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes. PREREQUISITES SQL: Fundamentals of Querying or equivalent knowledge. AUDIENCE Students enrolling in this course should understand the basics of querying a database with the SQL command language. They should be comfortable issuing SELECT queries against one or more tables and understand query concepts, such as joins. PERFORMANCE-BASED OBJECTIVES Upon successful completion of this course, students will be able to:        
       

Query with subqueries. Add data to a database. Change and delete data from a database. Create, alter, and delete tables. Create tables with constraints. Create view, alter and delete views. Manipulate data through views Create and delete indexes.
          

Use subqueries to search based on an unknown value Use subqueries to search based on multiple unknown values Use subqueries to compare a value with unknown values Use subqueries to search based on the existence of records Generate output using correlated subqueries Filter grouped data with subqueries Perform multiple-level subqueries Insert data using “insert into” and “select into” CALC/Canterbury Corp. Modify data Delete data Create a simple table Create a table with constraints Add or delete table columns Add or delete constraints Modify a column definition Delete tables Create a view Modify and delete views Manipulate data in views

~ 400 Lanidex Plaza ~ Parsippany, NJ 07054

P: 973-781-9300 ~ F: 973-781-0939 ~

SQL: Advanced Querying Page 2 of 2


Create and drop indexes

CALC/Canterbury Corp.

~ 200 Lanidex Plaza ~ Parsippany, NJ 07054

P: 800-638-2252 ~ P: 973-515-6940 ~ F: 973-781-0939 ~