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

Optimizing SQL Queries in Oracle

Course Summary

This course introduces SQL programmers and new Oracle database administrators to several methods to make SQL queries execute faster.

  • +

    Course Syllabus

    Optimizing SQL Queries in Oracle
    - 22m 15s

    —Introduction 0m 22s
    —Course Overview 1m 36s
    —Course Contents 3m 30s
    —Module Contents 0m 55s
    —Who Will Benefit? 1m 10s
    —Database Version 0m 38s
    —Data Used in Course 4m 36s
    —A Comment about Tablespaces 2m 36s
    —Oracle Query Optimizer 3m 27s
    —Oracle and Pluralsight Resources 1m 32s
    —Your Database Administrator 0m 58s
    —Summary 0m 49s
    Basic SQL Optimization Part I
    - 28m 25s

    —Introduction 0m 24s
    —Module Contents 1m 42s
    —Primary/Foreign Keys 3m 31s
    —Normal Forms - Part I 6m 24s
    —Normal Forms - Part II 2m 40s
    —Normal Forms - Part III 3m 52s
    —Primary/Foreign Keys REDUX 5m 43s
    —Infrequent Columns 1m 47s
    —NULLs and Space 1m 14s
    —Summary 1m 3s
    Basic SQL Optimization Part II
    - 22m 41s
    Overview of Indexes
    - 25m 3s
    B-Tree Indexes
    - 30m 18s
    Bitmap Indexes
    - 11m 58s
    Additional Index Types
    - 19m 15s
    Overview of Partitions
    - 16m 3s
    Simple Partitions
    - 23m 57s
    Composite Partitions
    - 15m 43s
    Partition/Index Interaction
    - 10m 58s

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
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