A New York State Certified Woman-Owned Business Enterprise
BEAHIVE Training in Downtown Albany!
MicroKnowledge, Inc.
21 British American Blvd.
Latham, NY 12110
Phone: 518.786.1181
Fax: 518.786.6221
SQL Advanced Queries
Description:
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 environment.
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 6: Indexing Data
- Create indexes
- Drop indexes
