SQL: Advanced

Learning Outcomes:

• Accurately perform a query with sub queries utilizing information in the Lesson Lab.
• Using the information provided by the Instructor, perform multiple-level subqueries with 95% accuracy.
• Working with the information from the Activity Lab, successfully create, alter, and delete tables.
• Correctly create a view and manipulate data in views as directed by the Instructor using the data provided.

During this one-day second level course, students will learn how to perform advanced queries and add, update, and delete data, tables, views, and indexes.

• Advanced Querying Using Subqueries
• Filter Grouped Data Within Subqueries
• Manipulating Table Data
• Manipulating the Table Structure
• Working with Views
• Indexing Data
• Working with Transactions

SQL: Advanced

During this Advanced level the student will s earch based on an unknown value and on multiple unknown values. Compare a value with unknown values. Search based on the existence of records. Generate output using correlated subqueries. Filter grouped data within subqueries. Perform multiple-level subqueries. Insert, modify and delet data. Create a simple table and a table with constraints. Add or drop table columns. Add or drop constraints. Modify the column definition and delete tables. Create a view, manipulate data in views and modify and drop views. Create and drop indexes. Rollback transactions and commit transactions.

Class targeted to: 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.

Prerequisites: SQL: Fundamentals of Querying or equivalent knowledge.