SQL Querying Fundamentals with HUE - Part 2

Description

Duration

1 Days

6 CPD hours

This course is intended for

This course is for employees of Sun Life who want to expand their skills when using HUE to work with SQL databases.

Overview

Upon successful completion of this course, students will be able to better operate HUE when interacting with SQL databases.

In this course, students will learn additional skills when using HUE to interact with SQL databases.

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

Manipulating Table Data

Insert Data

Modify and Delete Data

Manipulating the Table Structure

Create a Table

Create a Table with Constraints

Modify a Table's Structure

Back Up Tables

Delete Tables

Working with Views

Create a View

Manipulate Data in Views

Create Aliases

Modify and Delete Views

Indexing Data

Create Indexes

Drop Indexes

Managing Transactions

Create Transactions

Commit Transactions