Skip to Scheduled Dates

Course Overview

In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process.

Who Should Attend

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

Course Objectives

Upon successful completion of this course, students will be able to:

• 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.

Course Prerequisites

• SQL Querying Fundamentals - Part 1

Course Outline