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

Mastering Oracle Database 12c SQL by example

Course Summary

Plug into the next gen cloud databases! Take your learning to the next level and become a top skilled SQL developer.


  • +

    Course Syllabus

    • Course Introduction
      • Course Objectives
      • The basics of SQL
      • Getting familiar with Relational Database Management concepts
      • The HR and OE Relational Models
    • Retrieving Data
      • The SELECT statement
      • Customizing data output
      • Section 2 Quiz - Retrieving Data
    • Restricting and Sorting Data
      • Restricting Data
      • Comparison and Logical Operators
      • Sorting Data
      • Section 3 - Restricting and Sorting data
    • Customizing Output Data
      • Single-Row Functions
      • Character, Numeric and Datetime functions
      • Using Conversion functions
      • Creating Conditional Expressions
      • Section 4 - Customizing Output Data
    • Aggregating Data
      • Aggregate Functions
      • Manipulating groups of data
      • Section 5 - Aggregating Data
    • Retrieving Data from Multiple tables
      • Joining Tables - Overview -
      • Equijoins and Non-Equijoins
      • Additional join methods
      • Section 6 - Retrieving data from multiple tables
    • Using Subqueries
      • Subqueries Overview
      • Single-Row and Multiple-Row Subqueries
      • Multiple-Column Subqueries
      • Combining Multiple Queries
      • Section 7 - Using Subqueries
    • Manipulating Data
      • Data Manipulation Language (DML) Overview
      • Managing Transactions
    • Manipulating Database Objects
      • Managing table structure
      • Managing Constraints
      • Using Views
      • Manipulating Sequences
      • Manipulating Indexes
    • Using the Data Dictionary
      • Data Dictionary Overview
      • How to use the Data Dictionary
    • Oracle Database 12c - SQL New Features
      • Oracle Database 12c – SQL new features
      • Course Summary


Course Fee:
USD 99

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