Course Description:-

INTRODUCTION:

In this course on Oracle 9i – Basic SQL and Single Row Functions, you will learn about Relational and Object Relational Database Management System. The course starts from scratch and hence a beginner can also take and enjoy this course.

The course starts with ER Modeling where we will get acquainted with Data Storage on Different Media, Relational Database Concept, Communicating with a RDBMS using SQL, Arithmetic Expressions, Character Strings and Dates etc.

What are the requirements for Oracle 9i Course?

• Ability to relate to a customer centric thinking
• Intuitive problem solving abilities
• Data Mining ability
• A PC with internet

What am I going to get from this Oracle 9i course?

• Over 16 lectures and 1 hour of content!

• To study what drives customer behavior at every stage of his lifecycle and henceforth capitalizing on his unique behavior at every time point so as to attract and retain profitable customers as well as make unprofitable customers profitable.

• We will be tracing the entire campaign management system from its origin to the end as well and will also be showing the interaction with the business at each stage.

What is the target audience for Oracle 9i Course?

• Students especially ones from the economics, finance and statistics background

• Professionals especially fresher’s as well as experienced professionals shifting their domains
• Consultants

Benefits of online course:

• High Quality Content
• Learn Anywhere Anytime & at Your Pace
• 24X7 Customer Support
• Complete Student Support Throughout The Program
• Course Completion Certificate 
• Lifetime course access

For any query feel free to call

Mob - +918587999769

CURRICULUM

Section 1: Oracle 9i Introduction

1. ER Modeling
2. Data Storage on Different Media
3. RDBMS and SQL

Section 2: Writing Basic SQL Select Statements

1. Select Statement with Column Alias and Arithmetic operators
2. Concatenation Operator, Literal, Eliminating Duplicate rows
3. SQL iSQLplus and Displaying Table Structure
4. Basic SQL Select Statements-Practical Examples
5. Writing Basic SQL Select Statements

Section 3: Restricting and Sorting Data

1. Where Clause and Comparison Conditions
2. ?Comparison Conditions
3. Logical and Order by Clause
4. Restricting and Sorting Data-Practical Examples 01
5. Restricting and Sorting Data-Practical Examples 02
6. Basic SQL Select Statements
7. Basic SQL Select Statements Continue
8. Character Function
9. Case Manipulation Function
10. Number, Arithmetic and Date Functions
11. Arithmetic with Dates
12. Conversion and RR YY Functions
13. CHAR Function with Dates
14. Nesting and General Functions
15. COALESCE Function
16. Practical Assignments
17. Practical exercise
18. Conversion Function
19. Practical Demonstration
20. Additional Examples
21. Additional Examples of Salary

Here is a sample for the course completion certificate which you will receive after complete the course. This certificate is widely accepted across industries and will boost your chances to grab the job opportunities.

Mail us at: [email protected] with below details to receive your certificate:

• Name
• Course Name
• Date of Completion
• Address