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 SQL - Learning by Example

Course Summary

Learn how to query and manage data in the Oracle Database Using SQL. Practical, concept-building examples and quizzes.


  • +

    Course Syllabus

    • Introduction to the course and Promo video
      • Important stuff about the course
    • Setting up the environment
      • Tools of the trade - Introduction
      • Client Server
      • Oracle virtual box and developer VM
      • Setting up the database in the VM
      • Alternatives to Virtual Machine
      • SQL*Plus
    • (Select part 1) Let's write some SQL! Selecting data
      • Select statement : The very basics
      • Basic Select and Describe
      • Data Types
      • Data types Quiz
      • Aliases, Primary keys and unlocking other accounts
      • Chapter 3 Quiz
    • (select part-2) Grants, Filters, Groups and more.
      • Grants/Privileges - Accessing someone else's objects
      • Filtering data - "where clause" in SQL
      • Groups and aggregates - part 1
      • Groups and Aggregates - Part -2
      • Sorting Data - "Order by" Clause in Oracle
    • (select part-3) Oracle functions and SQL
      • Introduction to Oracle functions
      • Character and Numeric functions in Oracle
      • Date and Time functions in Oracle
      • Conversion Functions in Oracle
      • Null handling functions in Oracle
      • Conditional Logic functions in Oracle
      • Oracle Functions - Programming exercises
    • (Select part-4) Joins, Sub queries and more advanced SQL
      • Normalization
      • Introduction to Joins, Inner-joins (part-1)
      • Inner joins (Contd..), Self joins, and Cartesian Joins
      • Outer Joins
      • ANSI vs Oracle Syntax
      • Joins Quiz
      • Joins programming exercises
      • Subqueries
      • Set Operators
    • Creating and modifying objects (DDL commands)
      • Introduction to DDL statements
      • CREATE tables (and other objects)
      • Modifying objects - the alter command
      • Dropping objects (DROP Command)
    • Data Manipulation - Basic DML
      • Transaction Control in Oracle
      • the INSERT Statement
      • the UPDATE Statement
      • the MERGE statement
      • the DELETE statement
      • Oracle's TRUNCATE statement


Course Fee:
USD 20

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