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

Course Summary

Learn the basics of using the SQL language on an Oracle database with these easy-to-follow lessons and examples.


  • +

    Course Syllabus

    • Introduction and Setup
      • Introduction
      • Tools and Concepts
      • Oracle Client Download
      • Oracle Client Install
      • How To Install Oracle On A Mac
      • Java JDK Download
      • Java JDK Install
      • SQL Developer Download
      • SQL Developer Setup
      • SQL Developer Connection Setup
    • Viewing Data
      • Viewing Data - SELECT statement (Part 1)
      • SQL Developer - Create New User
      • SQL Developer - Create and Populate Tables
      • Viewing Data - SELECT statement (Part 2)
      • Viewing Data - Operators, DISTINCT and NULL
      • SQL Data Types
      • Viewing Data - Restricting and Sorting (Part 1)
      • Viewing Data - Restricting and Sorting (Part 2)
    • Functions
      • Functions - Strings
      • Functions - Numbers
      • Working with Dates and Times
      • Functions - Dates
      • Functions - Conversion
      • Aggregate Functions
    • More SELECT Concepts
      • Table Aliases and Joins
      • Joins Part 2
      • Set Operators
      • Translate, Decode and Case
      • Subqueries - Single Row
      • Subqueries - Multiple Row
    • DML - Data Manipulation Language
      • DML - Insert
      • DML - Update
      • DML - Delete and TRUNCATE
    • Objects
      • DDL - Object Types
      • DDL - Create Table and Constraints
      • DDL - Alter and Drop Table
    • Conclusion
      • Conclusion


Course Fee:
USD 77

Course Type:

Self-Study

Course Status:

Active

Workload:

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
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