Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.
In this course, you will work with advanced queries to manipulate and index tables. You will also create transactions so that you can choose to save or cancel the data entry process.
You will:
Topic A: Search Based on Values from a Subquery
Topic B: Compare Values from a Subquery
Topic C: Search Based on the Existence of Records
Topic D: Generate Output Using Correlated Subqueries
Topic E: Filter Grouped Data Within Subqueries
Topic F: Perform Multiple-Level Subqueries
Topic A: Insert Rows
Topic B: Modify and Delete Data
Topic A: Create a Table
Topic B: Create a Table with Constraints
Topic C: Modify a Table's Structure
Topic D: Delete Tables
Topic A: Create a View
Topic B: Manipulate Data in Views
Topic C: Modify and Delete Views
Topic A: Create Indexes
Topic B: Drop Indexes
Topic A: Define Transactions
Topic B: Commit Transactions