Duration

1 days.

Prerequisites

There are no prerequisites for this course.

    Skills Gained

    • Use subqueries to generate query output.
    • Manipulate table data by inserting, updating, and deleting records in a table.
    • Manipulate the table structure.
    • Create views, manipulate data through views, modify the view structure, and drop views.
    • Create indices on table columns and drop inefficient indices.
    • Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction.

    Who Can Benefit?

    Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology.

      Outline for SQL Querying Fundamentals - Part 2 Training

      Course Outline

      • Using Subqueries to Perform Advanced Querying
      • Manipulating Table Data
      • Manipulating the Table Structure
      • Working with Views
      • Indexing Data
      • Managing Transactions
      02/28/2024 - 02/28/2024
      09:00 AM - 05:00 PM
      Eastern Standard Time
      Online Virtual Class
      USD $595.00
      Enroll
      03/11/2024 - 03/11/2024
      09:00 AM - 05:00 PM
      Eastern Standard Time
      Online Virtual Class
      USD $595.00
      Enroll
      03/25/2024 - 03/25/2024
      09:00 AM - 05:00 PM
      Eastern Standard Time
      Online Virtual Class
      USD $595.00
      Enroll