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 11g - Learn Oracle SQL by Examples

Course Summary

This course is a combination of Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II


  • +

    Course Syllabus

    • Oracle SQL 11g
      • Introduction and Objectives
      • SELECT Statement, Retrieving Data
      • Retrieve Data From Database
      • Retrieve Data Continues
      • SQL Functions
      • SQL Functions Demo
      • Introduction to sql session-7
      • Introduction to sql session-8
      • Character-Manipulation Functions, Number function, MOD function
      • DATE Functions
      • DATE Functions Continues
      • General Functions
      • NVL Function
      • NVL2 Function
      • NULLIF, COALESCE, CASE, DECODE Functions
    • Reporting Aggregated Data Using Group Function
      • Group Functions
      • AVG, SUM, MIN, MAX, COUNT, DISTINCT, GROUP BY Functions
      • Illegal Queries, HAVING, Nesting Group Functions
    • Using set operators
      • Using set operators
    • Displaying data from Multiple Tables
      • Obtaining Data from Multiple Tables, Joins
      • Joins and Types of Joins
      • Displaying data from Multiple Tables Demo Continues
      • Outer Joins and Natural Joins
      • SQL Statement for OUTER JOINS
      • NATURAL JOINS
    • Oracle Architecture
      • Oracle Architecture
      • Oracle Archicture Part-2
      • Oracle Archicture Part-3
    • Creating Sample Tables
      • Constraints
      • Sample Tables, Course Table
      • FACULTY Table, Batches Table
      • Primary Key Constraints, Foreign Key Constraints
      • Creating Sample Tables
      • Creating Sample Tables Continues
    • Changing Structure and Data
      • ALTER TABLE
      • Modifying Attributes of Existing Columns
      • Manipulating Data
      • Changing Structure and Data Part 4
    • Grouping Data
      • Group By clause
      • GROUP BY and WHERE clause
      • HAVING Clause
      • ROLLUP and CUBE
    • Joining Tables
      • Joining Tables
      • Joins and Alias
      • Self Joins
      • Join Tables
      • Joining Tables Continues
    • Schema Objects(Views , Sequence , synonyms)
      • Database Objects
      • Advantages of Views
      • Creating a View
      • Creating a Complex View
      • Sequences
      • Sequences, Index
    • Using Subqueries to Solve Queries
      • Using Subquery to solve a Problem
      • Multiple Row Subqueries
    • Managing Objects with Data Dictionary Views
      • Data Dictionary Structures
      • Column Information


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