SQL SQL Case Study - DML Operations

SQL Case Study - DML Operations

Catalog: SQL
Short name: DML Operations
Course start date: 2024-07-02
Paystack
Enroll Me

Description

In this course on Datetime functions, Advances DML Operations and Hirarchical Queries, you will learn about Oracle9i Datetime Functions, Enhancements and group By Clause, Advanced Subqueries, Hierarchical Retrieval, Oracle9i Extensions to DML and DDL Statements etc.

Course Duration:-3h 48m

Sections

General
0 activities

Tz_offset‚Current_date‚Current_timestamp‚Localtimestamp
Extract and Other timestamp data types
Extract and Other timestamp data types summary
Oracle9i Datetime Functions-Practical Examples 01
Oracle9i Datetime Functions-Practical Examples 02
Oracle9i Datetime Functions-Additional Practice
Group‚ Having‚ Group by‚ Rollup and Cube
Grouping Functions‚ Grouping Set
Grouping Functions‚ Grouping Set‚ Composit columns and Concatenated grouping summary
Enhancements to the GROUP BY Clause 01
Enhancements to the GROUP BY Clause 02
Enhancements to the GROUP BY Clause-Additional Examples
Multiple-Column Subqueries
Column Comparisons
Correlated Subqueries
Correlated UPDATE
summary
Advanced Subqueries-Practical Examples 01
Advanced Subqueries-Practical Examples 02
Advanced Subqueries-Additional Example 01
Advanced Subqueries-Additional Example 02
Hierarchical Queries
Walking the Tree From the Bottom Up
Hierarchical Queries_summary
Hierarchical Retrieval-Practical Examples
Hierarchical Retrieval-Additional Examples
Review of the UPDATE Statement
Ranking Rows With the Level
Pivoting Insert‚ External Tables
Creating an External Table
create table summary
Course Certificate
Secure Video
31
Certificate
1
Cost: 5000
Enroll Me

Tag

Course Duration:-3h 48m