In this course you will learn how to use the SELECT statement for advanced joins and sub queries. Focus will be on “action” queries that change data and create and structure tables and views.

starstarstarstarstar

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

Upon successful completion, the student will be able to use subqueries to generate query output. Manipulate table and table structure.Create views, modify view structure, drop views. Create indexes. Mark the beginning of a transaction, roll back a transaction, and commit a transaction.

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 Table

    Create a Table with Constraints

    Modify a Table’s Structure

    Back Up Tables

    Delete Tables

4

  • Working with Views


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


5

  • Indexing Data

  • Create Indexes

    Drop Indexes

6

  • Managing Transactions

  • Create Transactions

    Commit Transactions

Audience

This course is intended for users that have a working knowledge of SQL.

Language

English

Prerequisites

Course Info

Not Your Location? Change

Cost: $ 495

Length: 1.0 day (8 hours)

Level:

For scheduling options, please chat with an expert below.

Loading...