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 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 37sTable 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 27sTable Constraints- 36m 38sTable Storage Options- 54m 47sManaging Tables- 36m 58sSpecialized Table Types- 35m 16sIndexes- 40m 23sPrivileges and Roles- 32m 32sGood Practices- 19m 58s
