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

Learning SQL For Oracle

Course Summary

A beginners guide to learning SQL for Oracle


  • +

    Course Syllabus

    • Introduction To Oracle SQL
      • Important - Download These First - Working Files
      • 0102 What Is SQL?
      • 0103 Relational Databases Explained - Part 1
      • 0104 Relational Databases Explained - Part 2
      • 0105 How To Query Data From A Database
      • 0106 The Difference Between SQL And PL/SQL
      • 0107 Setting Up An Oracle Apex Account
      • 0108 Running SQL Using Oracle Apex
      • 0109 Assignment 1
      • 0110 Assignment 1 - Solution
      • 0111 How To Access Your Working Files
    • Basic SQL Select Statement
      • 0201 Retrieving All Data From A Table
      • 0202 Retrieving Some Data From A Table
      • 0203 Restricting The Retrieval Of Rows From A Table
      • 0204 Using Mathematical And Text Expressions
      • 0205 Sorting The Results Using Column Names
      • 0206 Assignment 2
      • 0207 Assignment 2 - Solution
    • Restricting Data - The Basics
      • 0301 What Is A Primary Key?
      • 0302 Comparison Operators
      • 0303 Logical Operators
      • 0304 Dealing With Null Values
      • 0305 Sorting The Results Using Column Position
      • 0306 Assignment 3
      • 0307 Assignment 3 - Solution
    • Joining Tables - The Basics
      • 0401 What Is A Foreign Key?
      • 0402 Inner Joins With The Using Clause
      • 0403 Joins With The On Clause
      • 0404 Joins And The Order Of Processing
      • 0405 Assignment 4
      • 0406 Assignment 4 - Solution
    • Summarizing Data
      • 0501 Aggregate Functions
      • 0502 The Count Functions
      • 0503 The Min And Max Functions
      • 0504 The Avg And Sum Functions
      • 0505 Concatenating Data
      • 0506 Aggregates - Order Of Processing
      • 0507 Assignment 5
      • 0508 Assignment 5 - Solution
    • Joining Multiple Tables
      • 0601 Many-To-Many Relationships - Part 1
      • 0602 Many-To-Many Relationships - Part 2
      • 0603 Join Multiple Tables With The Using Clause
      • 0604 Join Multiple Tables With The On Clause
      • 0605 Eliminating Duplicate Rows From The Results
      • 0606 Sorting The Results Using Column Aliases
      • 0607 Assignment 6
      • 0608 Assignment 6 - Solution
    • Data Subsets
      • 0701 Using The Group By Clause
      • 0702 Using The Having Clause
      • 0703 Having With Compound Conditions
      • 0704 Assignment 7
      • 0705 Assignment 7 - Solution
    • Restricting Data - Advanced Concepts
      • 0801 Using The In Operator
      • 0802 Using The Between Operator
      • 0803 Using The Like Operator For Pattern Matching
      • 0804 Outer Joins
      • 0805 Assignment 8
      • 0806 Assignment 8 - Solution
    • Using Subqueries - The Basics
      • 0901 How Do Subqueries Work?
      • 0902 Subqueries With The In Operator
      • 0903 Subqueries Using A Comparison Operator
      • 0904 Subqueries Vs. Joins
      • 0905 Using A Subquery Vs. A Self-Join
      • 0906 Assignment 9
      • 0907 Assignment 9 - Solution
    • Data Modeling - The Basics
      • 1001 How Data Is Organized In A Relational Database
      • 1002 The Entity-Relationship Approach
      • 1003 Normalization Guidelines - Part 1
      • 1004 Normalization Guidelines - Part 2
      • 1005 Assignment 10
      • 1006 Assignment 10 - Solution
    • Creating Tables And Manipulating Data
      • 1101 Creating Tables - Part 1
      • 1102 Creating Tables - Part 2
      • 1103 Specifying Keys
      • 1104 The Check Constraint
      • 1105 Creating Indexes
      • 1106 Modifying And Removing Tables
      • 1107 More Constraints
      • 1108 Adding Data To A Table
      • 1109 Changing Data In A Table - Part 1
      • 1110 Changing Data In A Table - Part 2
      • 1111 Removing Data From A Table
      • 1112 Assignment 11
      • 1113 Assignment 11 - Solution
    • Single-Row Functions
      • 1201 String Functions - Part 1
      • 1202 String Functions - Part 2
      • 1203 Number Functions
      • 1204 Date Functions
      • 1205 Limiting Rows And The Dual Table
      • 1206 Assignment 12
      • 1207 Assignment 12 - Solution
    • Creating And Using Views
      • 1301 Creating And Using Views
      • 1302 Set Operators
      • 1303 Assignment 13
      • 1304 Assignment 13 - Solution
    • Database Management
      • 1401 Transaction Management
      • 1402 Concurrency Control
      • 1403 Security Considerations
      • 1404 Stored Procedures And Triggers
      • 1405 Database Integrity
      • 1406 Assignment 14
      • 1407 Assignment 14 - Solution
    • Legacy SQL Techniques
      • 1501 Implicit Joins
      • 1502 Subqueries With Modifiers
      • 1503 Subqueries Using The Exists Clause
      • 1504 Assignment 15
      • 1505 Assignment 15 - Solution
    • Conclusion
      • 1601 Difference Between Oracle And Other SQLs
      • 1602 SQL In A Programming Language
      • 1603 Embedded SQL
      • 1604 What Is Next?


Course Fee:
USD 99

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