Oracle SQL Training

Posted by Shrikant Mohanty
1
Education & Training
Jul 23, 2015
218 Views
Image
In this course on Oracle SQL Training, you will learn about Producing Readable Output with iSQL*Plus, Manipulating Data, Creating and Managing Tables, Including Constraints etc.

The course starts from scratch and hence a beginner can also take and enjoy this course.

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

 

 

  • CURRICULUM

Section 1: Oracle 9i Introduction

1    ER Modeling
2    Data Storage on Different Media
3    RDBMS and SQL
4    Select Statement with Column Alias and Arithmatic operators
5    Concatination Operator,Literal, Eliminating Duplicate rows
6    SQL iSQLplus and Displaying Table Structure
7    Basic SQL Select Statements-Practical Examples
8    Writing Basic SQL Select Statements
9    Where Clause and Comparison Conditions
10    ​Comparison Conditions
11    Logical and Order by Clause
12    Restricting and Sorting Data-Practical Examples 01
13    Restricting and Sorting Data-Practical Examples 02
14    Basic SQL Select Statements
15    Basic SQL Select Statements Continue
16    Character Function
17    Case Manipulation Function
18    Number, Arithmatic and Date Functions
19    Arithmetic with Dates
20    Conversion and RR YY Functions
21    CHAR Function with Dates
22    Nesting and General Functions
23    COALESCE Function
24    Practical Assignments
25    Practical exercise
26    Conversion Function
27    Practical Demonstration
28    Additional Examples
29    Additional Examples of Salary
Comments
avatar
Please sign in to add comment.
Advertise on APSense
This advertising space is available.
Post Your Ad Here
More Articles