Course Description:-

INTRODUCTION: 

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

What are the requirements?

• Knowledge of SQL
• Passion to learn

What am I going to get from this course?

• Hours of content!

What is the target audience?

• Engineering and Management students can take this course
• Anyone who wants to learn about SQL

 Benefits of online course:

·         High Quality Content

·         Learn Anywhere Anytime & at Your Pace

·         24X7 Customer Support

·         Complete Student Support throughout the Program

·         Online Video Training Material

·         Lifetime course access

CURRICULUM

Section 1: Producing Readable Output, Manipulating Data

1. Substitution Variables
2. Verify, Column, Break, Title, Btitle commands
3. Producing Readable Output with iSQL-Practical Examples
4. Producing Readable Output with iSQL- Examples DROP TRIGGER Syntax
5. After Row and After Statement Triggers

Section 2: Manipulating Data

1. Objectives and Insert Statement
2. Update, Delete and Merge
3. The UPDATE Statement Syntax
4. Database Transaction
5. ROLLBACK Statements
6. Manipulating Data-Session 8 Practical 1
7. Manipulating Data-Session 8 Practical 2
8. Manipulating Data-Session 8 Practical 3
9. Manipulating Data-Additional Examples 01
10. Manipulating Data-Additional Examples 02

Section 3: Creating and Managing Tables

1. Database Objects, Create Table
2. Tables in the Oracle Database
3. Alter Table, Drop Table
4. The SET UNUSED Option
5. Creating and Managing Tables-Practical Examples 01
6. Creating and Managing Tables-Practical Examples 02
7. Creating and Managing Tables-Additional Examples 01
8. Creating and Managing Tables-Additional Examples 02

Section 4: Including Constraints

1. Constraints, Type of Constraints and Defining Constraints
2. The UNIQUE Constraint
3. Adding, Disabling, Enabling Viewing Constraints
4. Adding, Disabling, Enabling Viewing Constraints- summary
5. Including Constraints-Practical Examples
6. Including Constraints-Additional Examples

For any query feel free to call

Mob - +918587999769