Oracle Developer Essentials: Tables and Indexes

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.

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.

• Introduction 19mins
• Table Basics 34mins
• Table Constraints 36mins
• Table Storage Options 54mins
• Managing Tables 36mins
• Specialized Table Types 35mins
• Indexes 40mins
• Privileges and Roles 32mins
• Good Practices 19mins