- Course
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.
Intermediate
- Course
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.
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
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.
Oracle Developer Essentials: Tables and Indexes
Intermediate
Table of contents
-
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 | 27s
David Berry is a software engineer with over 15 years of experience developing applications in languages such as Java and C#. Throughout his career, he has worked extensively with enterprise database systems including Oracle and SQL Server.