SQL Querying Fundamentals - Part 2

Course Overview

1. Using Subqueries to Perform Advanced Querying

• Search Based on 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

2 . Manipulating Table Data

• Insert Data
• Modify and Delete Data

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
• Back Up Tables
• Delete Tables

4. Working with Views

• Create a View
• Manipulate Data in Views
• Create Aliases
• Modify and Drop Views

5. Indexing Data

• Create Indices
• Drop Indices

6. Managing Transactions

• Create Transactions
• Commit Transactions

Prerequisites

To ensure your success, we recommend you first take the following Logical Operations courses, or have equivalent skills and knowledge:

• SQL Level 1: Fundamentals of Querying

Course Comments

This course expands on SQL Level 1: Fundamentals of Querying by adding insert, update and delete SQL statements.  The course also examines the uses of indexes and transactions.

The SQL information is ANSI standards and can be applied to any RDBMS, including DB2, Oracle, SQL/Server, Sybase, etc.

You may also be interested in our Microsoft Querying Class:  Writing Analytical Queries for Business Intelligence- Course 55232