Oracle Developer Essentials: Tables and Indexes

Pluralsight

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 Description

This course introduces the most fundamental of data structures in an Oracle database: the table. Learn how to define tables, declare columns, define constraints on tables, important storage options you need to know about, and global temporary tables and external tables. You'll also learn about privileges and roles in Oracle, which are essential for granting appropriate permissions in your database. This course will also teach you best practices for building tables in your database, and how to create and use indexes for efficient data access.

Course Description

This course introduces the most fundamental of data structures in an Oracle database: the table. Learn how to define tables, declare columns, define constraints on tables, important storage options you need to know about, and global temporary tables and external tables. You'll also learn about privileges and roles in Oracle, which are essential for granting appropriate permissions in your database. This course will also teach you best practices for building tables in your database, and how to create and use indexes for efficient data access.

+
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

—Introduction 1m 9s
—Primary Keys 3m 30s
—Defining Primary Keys 5m 1s
—Row ID 1m 30s
—Foreign Keys 4m 7s
—Demo: Primary and Foreign Keys 2m 38s
—On Delete Cascade and Deferred Constraints 5m 10s
—Demo: Deferred Constraints 3m 13s
—Check Constraints 4m 4s
—Disabling Constraints 1m 5s
—To Use or Not Use Constraints 4m 30s
—Summary 0m 37s

Table Storage Options
- 54m 47s

—Introduction 2m 0s
—Data Blocks 4m 6s
—How Oracle Accesses Data 3m 28s
—Ordering of Data in Tables 1m 45s
—Tablespaces Introduction 3m 52s
—Assigning Objects to Tablespaces 2m 57s
—High Water Mark 3m 24s
—High Water Mark Impacts 2m 37s
—PCTFREE 4m 2s
—PCTUSED 2m 7s
—Row Migration 6m 19s
—Guidance on Setting PCTFREE 4m 39s
—Freelists 3m 59s
—Row Chaining 4m 19s
—Avoiding Row Chaining 3m 20s
—Summary 1m 45s

Managing Tables
- 36m 58s

—Introduction 1m 3s
—Introducing the Oracle Data Dictionary 2m 49s
—Useful Data Dictionary Views 7m 16s
—Database Statistics 4m 20s
—Dropping a Table 1m 34s
—Making a Table Read Only 1m 17s
—Renaming a Table 2m 4s
—Demo: Renaming a Table 2m 43s
—Renaming Columns 0m 58s
—Adding Columns 3m 49s
—Demo: Adding Columns 2m 23s
—Dropping Columns 3m 10s
—Changing a Column Data Type 2m 27s
—Summary 0m 59s

Specialized Table Types
- 35m 16s

—Introduction 1m 22s
—Global Temporary Tables 4m 22s
—Demo: Temporary Tables in Oracle 3m 58s
—External Tables Introduction 2m 28s
—Oracle Directory Objects 5m 53s
—Using an External Table to Import a Fixed Width Data File 7m 47s
—Using an External Table to Import a CSV File 6m 38s
—External Table Resources 1m 51s
—Summary 0m 52s

Indexes
- 40m 23s

—Overview 1m 24s
—What Is an Index? 6m 24s
—Creating Standard B-Tree Indexes 2m 35s
—Unique Indexes 2m 47s
—Demo: Creating and Using B-Tree Indexes 4m 50s
—Function Based Indexes 3m 44s
—Demo: Creating and Using a Function Based Index 3m 53s
—Bitmap Indexes 7m 15s
—Defining Bitmap Indexes 1m 6s
—Advice to Consider When Creating Indexes 5m 5s
—Summary 1m 16s

Privileges and Roles
- 32m 32s

—The Need for Multiple Users 4m 55s
—GRANT and REVOKE 2m 3s
—Object Privileges 2m 8s
—Column Level Privileges 4m 19s
—Demo: Assigning Object Privileges 5m 7s
—Privileges on Stored Procedures 6m 13s
—Database Roles 3m 22s
—Basic Security Practices 4m 20s

Good Practices
- 19m 58s

—Introduction 1m 11s
—Naming Conventions 6m 15s
—Creating Comments for Tables and Columns 2m 46s
—Demo: Creating Comments for Tables and Columns 3m 12s
—The Single Responsibility Principle for Tables and Columns 6m 1s
—Summary 0m 31s

Course Fee:

USD 29

Course Type:	Self-Study
Course Status:	Active
Workload:	1 - 4 hours / week

This course is listed under Data & Information Management , Digital Media & Games and Server & Storage Management Community

Attended this course? Write a Review

Course Fee:

USD 29

Course Type:	Self-Study
Course Status:	Active
Workload:	1 - 4 hours / week

IT Career Development Platform

Oracle Developer Essentials: Tables and Indexes

Pluralsight

Course Summary

Course Description

Course Description

Course Syllabus

Course Type:

Course Status:

Workload:

Oracle

Data dictionary

Bitmap

B-tree

Cluster Shared Volumes (CSV)

Attended this course? Write a Review

Course Type:

Course Status:

Workload: