SQL SQL Case Study - Output with iSQL

SQL Case Study - Output with iSQL

Catalog: SQL
Short name: Output with iSQL
Course start date: 2024-07-02
Paystack
Enroll Me

Description

In this course on Producing Readable Output, Manipulating Data, Creating table with constraints, you will learn about Producing Readable Output with iSQL*Plus, Manipulating Data, Creating and Managing Tables, Including Constraints etc.


In this course you will be learning in detail about the following topics:

• Producing Readable Output with iSQL*Plus

Objectives

Substitution Variables

Using the & Substitution Variable

Character and Date Values with Substitution Variables

Specifying Column Names, Expressions, and Text

Defining Substitution Variables

DEFINE and UNDEFINE Commands

Course Duration:-3h 49m

Sections

General
0 activities

Substitution Variables
Verify‚Column‚Break‚Ttitle‚Btitle commands
Producing Readable Output with iSQL-Practical Examples
Producing Readable Output with iSQL- Examples
Objectives and Insert Statement
Update‚ Delete and Merge
The UPDATE Statement Syntax
Database Transaction
ROLLBACK Statements
Manipulating Data-Session 8 Practical 1
Manipulating Data-Session 8 Practical 2
Manipulating Data-Session 8 Practical 3
Manipulating Data-Additional Examples 01
Manipulating Data-Additional Examples 02
Database Objects‚ Create Table
Tables in the Oracle Database
Alter Table ‚ Drop Table
The SETUNUSED Option
Creating and Managing Tables-Practical Examples 01
Creating and Managing Tables-Practical Examples 02
Creating and Managing Tables-Additional Examples 01
Creating and Managing Tables-Additional Examples 02
Constraints‚ Type of Constraints and Defining Contraints
The UNIQUE Constraint
Adding‚ Disabling ‚ Enabling Viewing Constraints
Adding‚ Disabling ‚ Enabling Viewing Constraints- summary
Including Constraints-Practical Examples
Including Constraints-Additional Examples
Course Certificate
Secure Video
28
Certificate
1
Cost: 5000
Enroll Me

Tag

Course Duration:-3h 49m