uCertify

DBM4310: Advanced Data Management

(ANC-DBM4310.AD1)
Lessons
Lab
TestPrep
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Using Subqueries to Perform Advanced Querying

  • Lesson Objectives
  • Introduction
  • TOPIC A: Search Based on Unknown Values
  • TOPIC B: Compare a Value with Unknown Values
  • 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
2

Manipulating Table Data

  • Lesson Objectives
  • Introduction
  • TOPIC A: Insert Data
  • TOPIC B: Modify and Delete Data
3

Manipulating the Table Structure

  • Lesson Objectives
  • Introduction
  • TOPIC A: Create a Table
  • TOPIC B: Create a Table with Constraints
  • TOPIC C: Modify a Table's Structure
  • TOPIC D: Back Up Tables
  • TOPIC E: Delete Tables
4

Working with Views

  • Lesson Objectives
  • Introduction
  • TOPIC A: Create a View
  • TOPIC B: Manipulate Data in Views
  • TOPIC C: Create Aliases
  • TOPIC D: Modify and Delete Views
5

Indexing Data and Managing Transactions

  • Lesson Objectives
  • Introduction
  • TOPIC A: Create Indexes
  • TOPIC B: Drop Indexes
  • TOPIC C: Create Transactions
  • TOPIC D: Commit Transactions

1

Using Subqueries to Perform Advanced Querying

  • Searching for Records Based on Unknown Values
  • Searching for Records by Comparing Them with Unknown Values
  • Searching for Records Based on Their Existence in Another Table
  • Generating Output Using Correlated Subqueries
  • Filtering Grouped Data Within a Subquery
  • Generating Output Using Nested Subqueries
2

Manipulating Table Data

  • Inserting, Modifying, and Deleting Data
3

Manipulating the Table Structure

  • Creating a Table
  • Creating a Table with Constraints
  • Adding and Dropping Columns in a Table
  • Adding and Dropping Constraints in a Table
  • Modifying the Column Definition in a Table
  • Backing Up a Table
  • Deleting a Table
4

Working with Views

  • Creating Views
  • Creating Views with Schema Binding
  • Manipulating Data in Views
  • Creating Aliases
  • Modifying and Deleting Views
5

Indexing Data and Managing Transactions

  • Creating Indexes
  • Dropping Indexes
  • Creating and Comitting Transactions

Related Courses

All Courses