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.
What you'll learn
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.
Table of contents
- Introduction 2m
- Data Blocks 4m
- How Oracle Accesses Data 3m
- Ordering of Data in Tables 2m
- Tablespaces Introduction 4m
- Assigning Objects to Tablespaces 3m
- High Water Mark 3m
- High Water Mark Impacts 3m
- PCTFREE 4m
- PCTUSED 2m
- Row Migration 6m
- Guidance on Setting PCTFREE 5m
- Freelists 4m
- Row Chaining 4m
- Avoiding Row Chaining 3m
- Summary 2m
- Introduction 1m
- Introducing the Oracle Data Dictionary 3m
- Useful Data Dictionary Views 7m
- Database Statistics 4m
- Dropping a Table 2m
- Making a Table Read Only 1m
- Renaming a Table 2m
- Demo: Renaming a Table 3m
- Renaming Columns 1m
- Adding Columns 4m
- Demo: Adding Columns 2m
- Dropping Columns 3m
- Changing a Column Data Type 2m
- Summary 1m
- Overview 1m
- What Is an Index? 6m
- Creating Standard B-Tree Indexes 3m
- Unique Indexes 3m
- Demo: Creating and Using B-Tree Indexes 5m
- Function Based Indexes 4m
- Demo: Creating and Using a Function Based Index 4m
- Bitmap Indexes 7m
- Defining Bitmap Indexes 1m
- Advice to Consider When Creating Indexes 5m
- Summary 1m
About the author
David Berry is a software engineer with over 15 years of application development experience. He started developing software in Java 1.0 using an Oracle 7 backend. Making the switch to Microsoft .NET when it was released, he has worked with every version of .NET since. He has also worked with every version of Oracle since Oracle 7 and ever version of SQL Server since SQL Server 7. His experience spans a broad range of industries including semiconductors, financial services, insurance an gove... more