MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Oracle 12C - Oracle Training

Course Summary

This course is for Developer's and is created on Oracle 12c. Oracle on Cloud is the future of Oracle.

  • +

    Course Syllabus

    • Introduction
      • Introduction to Oracle SQL
    • Oracle Database Design Concepts
      • Basic Relational Database Concepts
      • SQL Data Types
    • Installation of Oracle and Client tools
      • Downloading the Software
      • Installation of Oracle
      • Installation of SQL*Plus and Oracle Client Software
      • Oracle Developer Download and Installation
      • Download of Java - JDK 7 and its setup
      • Toad for Oracle Installation
    • Connecting to Oracle Database
      • Connection to Oracle using SQL Developer
      • Connection to Oracle using Sqlplus
      • Oracle Enterprise Manager
      • Conept of Listener in Oracle
      • Download and setup of Examples for Oracle Training
    • Basics of Security
      • Creation of Users in Oracle Database
      • Create connection and Grant Roles and privileges to the Users
    • Creating a Database
      • Create Table
      • Describe Table
      • Alter table
    • Keys and Constraints
      • Primary and Unique Keys
      • Foreign keys
      • Check Constraints
    • Simple Queries
      • Select statements
      • Select with Where clause
    • Insert, Update and Delete in Oracle
      • Insert data into Table
      • Updates in Oracle Database
      • Delete in Oracle
    • Conditional Operators
      • OR, AND and AND and OR operator
      • Like Operator Operator
      • IN and BETWEEN operators
    • Functions
      • Number functions
      • Mathematical Functions
      • SUM, AVG, MIN, MAX functions
      • String Functions
      • Date Functions
    • Grouping data
      • Distinct Clause in Oracle
      • Order by
      • Group By
      • Having clause
    • Union, Joins and Sub Queries
      • Unions in Oracle SQL
      • Joins
      • Sub-queries
    • Create database objects statements
      • Index
      • Views
      • Creating a View by Joining Multiple Tables
      • Synonym
      • Sequence
    • DCL - Data control Language
      • Creation of User with Different Options
      • Roles
      • Grant and Revoke Access
      • Change passwords in Oracle
    • Drop or Delete statements
      • Drop table
      • Drop index
      • Drop view
      • Drop Synonym
    • Oracle Net
      • tnsnames.ora file
      • listener.ora file
    • Conclusion
      • Conclusion

Course Fee:
USD 99

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top