Databases

SQL Advanced Queries

This workshop goes beyond the basics of SQL to retrieve and modify database information. Lectures and exercises will focus on extracting and manipulating information from databases through SQL in a Microsoft SQL or Oracle environment.

Dates & Times

CourseDate & TimeLocationCost
SQL Advanced QueriesAugust 21 - 9:00 - 4:00AlbanyRegister
SQL Advanced QueriesOctober 27 - 9:00 - 4:00LathamRegister

Course Outline

Corporate and NYS discounts do not apply for this course.

References to commands are made for other environments such as Oracle and Access.

The workshop assumes that users have a basic familiarity with SQL and a basic understanding of relational database concepts.

Includes:
Comprehensive reference manual with participant guide and exercises
SQL quick reference card, illustrating differences between versions of the SQL language
Access to participant data files
Follow-up support by email or phone for an unlimited period

Lesson 1: Advanced Querying Using Subqueries

  • Search based on an unknown value
  • Search based on multiple unknown values
  • Search based on the existence of records
  • Generate output using correlated subqueries
  • Filter grouped data within subqueries
  • Perform multiple-level subqueries

Lesson 2: Manipulating Table Data

  • Insert/Append data
  • Update data
  • Delete data

Lesson 3: Manipulating the Table Structure

  • Create a simple table
  • Create a table with constraints
  • Add or drop table columns
  • Add or drop constraints
  • Modify the column definition
  • Drop tables

Lesson 4: Working with Views

  • Create a view
  • Alter views
  • Drop views

Lesson 5: Indexing Data

  • Create indexes
  • Drop indexes