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 Developer Essentials: Tables and Indexes

Course Summary

This course covers the essentials of creating and managing tables in your Oracle database, including naming tables, defining columns, creating constraints and granting permissions. It also covers the basics of indexes, which are essential for efficiently accessing data in your tables.


  • +

    Course Syllabus

    Introduction
    - 19m 1s

    —Course Overview 3m 30s
    —Motivation 3m 3s
    —Terminology 5m 15s
    —Course Conventions and Resources 1m 58s
    —Oracle Resources 4m 35s
    —Summary 0m 37s
    Table Basics
    - 34m 43s

    —What Is a Table? 3m 9s
    —Creating Tables 2m 56s
    —Naming Tables and Columns 5m 31s
    —Demo: Naming Tables and Columns 4m 34s
    —Defining Columns 2m 27s
    —Null, Not Null, and Default Values 2m 28s
    —Demo: Null and Default Values 3m 24s
    —Choosing Between Null and Default Values 4m 51s
    —Virtual Columns 4m 50s
    —Summary 0m 27s
    Table Constraints
    - 36m 38s
    Table Storage Options
    - 54m 47s
    Managing Tables
    - 36m 58s
    Specialized Table Types
    - 35m 16s
    Indexes
    - 40m 23s
    Privileges and Roles
    - 32m 32s
    Good Practices
    - 19m 58s


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

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