Free

No student enrolled

Oracle 11g – SQL & PL/SQLis the entry point to start your career on Oracle Technologies. This course also serves as the basis for other Oracle technology courses like Oracle DBA, Oracle Developer, and Oracle Applications Technical Consultant etc…

What you will learn?

This course provides students with comprehensive understanding of Oracle Technologies in general and SQL, PL/SQL Languages in specific. Students will learn how to use SQL language to interact with Databases and PL/SQL to write more complex and data intensive programs

Who can attend?

  • Any graduate planning to start career in database technologies

Suggested Pre-requisites

  • This is a starter course and hence no specific prerequisites
  • Basic computer operating knowledge is desirable
  • Introduction to DBMS 

    0/4
    • Approach to Data Management, File and File System
    • Disadvantages of file base data management
    • Database Terminology
    • Database Models – Hierarchal Model,Network Model,Relational Model
  • Introduction to RDBMS 

    0/8
    • Features of RDBMS
    • Advantages of RDBMS over FMS & DBMS
    • E.F Codd Rules for RDBMS
    • Normalization Process
    • Client server Technology
    • Oracle Corporation Products
    • Oracle Versions about SQL & SQL*PLUS
    • Difference between OLTP & OLAP
  • Sub Language Commands 

    0/5
    • Data Definition Language(DDL)
    • Data Retrieval Language (DRL)
    • Data Manipulation Language (DML)
    • Transaction Control Language (TCL)
    • Database Security and Privileges (DCL)
  • Introduction to SQL 

    0/9
    • Schema & Schema Objects
    • Oracle Data Types
    • DDL Commands
    • DML Command
    • DRL Commands
    • Operators
    • Arithmetic and Logical Operators
    • Set Operators (UNION, UNION ALL, INTERSECT, MINUS)
    • Special Operators – IN (NOT IN), BETWEEN (NOT BETWEEN), LIKE (NOT LIKE), IS NULL (IS NOT NULL)
  • Built-in Functions 

    0/6
    • Arithmetic Functions
    • Character Functions
    • Date functions
    • Conversion Functions
    • Aggregate Functions
    • General Functions
  • Grouping the result of a query 

    0/2
    • Using Group by and Having Clause of DRL Statement
    • Using Order by clause

0.00 average base on 0 ratings

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Write a review

  • Please wait...