Advanced Visual Basic .NET Programming

Objective:           

Synopsis

This course gives a complete introduction to Oracle 9i's version of SQL, covering the SQL*Plus toolkit and Oracle 9i RDBMS contextual operating environment.

It is an essential building block for all users of Oracle's full technology range, including database technology, development tools, and web technologies.

The course comprehensively introduces the ANSI standard features of the Oracle 9i SQL implementation.

Course outline:

SQL*Plus and SQL   …  Logging on to SQL*Plus and Leaving SQL*Plus

• Choosing and Describing Tables

- Elements of the SQL Query

• The SQL Buffer and Query Layout         

- Editing SQL Statements

• The System Dummy Table          

- Selecting Columns

• Duplicate Information (DISTINCT)

- Sorting Information

SQL Functions …  The Concatenation Operator

• Elements of the SQL Query: Arithmetic
• Column Aliases      

- String Functions  

- Arithmetic Functions

• Date Functions       

- Mixed Functions

Advanced SQL Functions   … Nesting Different Functions

• SQL Bar Charts      

- Decode Crosstab 

- Decode with ">", "<" & "="

• Select with Minus Union and Intersect     

- Connect By Prior

Filtering Data Using Where

• Where Operators                 

- Where with Keywords

• Where and Logical Operators  

- Where and Soundex

Retrieving Data from Multiple Tables

• Joining Tables (Equi-Joins)                 

- Aliases for Table Names

• Thinking Behind Creating Joins   

- Joining Tables (Non-Equi-Joins)

• Joining Tables (Outer Joins)                 

- Joining Tables (Inner Joins)

Group By and Group By Functions

• Group Function Examples          

- Group Function with Having

Object Support - relational database

• Oracle Object Type definition      

- Nested objects

• Object constructors                             

- Objects as NULL/ attributes as NULL

• Object Tables                                     

- Type Hierarchy and Inheritance

• Abstract and Final Types            

- Object Evolution

• Propagation of Changes

Sub-Queries  ..  Basic Subqueries

• Multiple Column Subqueries                 

- Subqueries with Having

• Correlated Subqueries               

- Subquery Rules and Suggestions

Data Definition Language (DDL)            

- Create, Drop Alter Keywords

• Tables           

- Partitioning         

 - Column   

- Views       

- Synonyms Sequences

Integrity Constraints  .. Types of Constraint

• Referential Integrity          

- Defining Constraints

• Integrity Constraints and Data Dictionary     

- Alter table