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

Introduction To Oracle SQL With Toad

Course Summary

Learn how to communicate with oracle databases using Toad for Oracle . Learn how to create,read,update and delete data.


  • +

    Course Syllabus

    • Introduction and Lab Setup
      • Introduction
      • Database Concepts Part 1
      • Database Concepts Part 2
      • Tools Required
      • Oracle 11g Download and Installation
      • Creating Account on Oracle Application Express
      • Unlocking Sample HR Schema Account
      • Populating Sample HR Schema
      • Running Sample Application
      • Toad For Oracle Download and Installation
      • Toad Database Connection Setup
      • Notepad++ Download and Installation
    • SQL Sub Languages
      • SQL Sub Languages
      • DDL CREATE PART 1
      • DDL CREATE PART 2
      • DDL ALTER ,TRUNCATE ,DROP
      • DML SELECT
      • DML INSERT
      • DML UPDATE , DELETE
    • Reading Data
      • Data Types And Constraints
      • Limiting And Sorting Data
      • Operators
      • Set Operators
      • View And Dual Table
    • Table Joins
      • Table Joins
      • Aliases
      • Equi Join
      • Non Equi Join
      • Cartesian Join
      • Outer Join
      • Self Join
    • Functions
      • Functions
      • Character Functions
      • Conversions
      • Date Functions
      • Numeric Functions
      • Group / Aggregate Functions
    • Conclusion
      • Conclusion


Course Fee:
USD 47

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
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