Course Overview
In this 1-day class, students will work with advanced queries to manipulate and index tables. Students will also create transactions so you can save or cancel the data entry process.
Course Objectives
- 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 Should Attend?
Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology.
Course Prerequisites
- SQL Querying Fundamentals – Part 1
Agenda
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