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.
Author Name: David Berry
Author Description:
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
Table of Contents
- 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
User Reviews
Be the first to review “Oracle Developer Essentials: Tables and Indexes”
Related Products
Error and Uncertainty in Google Sheets
Learn to distinguish real differences from random noise, and explore psychological crutches we use that interfere with our rational decision making.
Understanding GDPR
Gain a clear understanding of GDPR principles and how to set up GDPR-compliant processes in this comprehensive course.
Creating PostgreSQL Databases
Learn how to create a PostgreSQL database and explore the structure, data types, and how to normalize databases.
Data Privacy and Anonymization in Python
Learn to process sensitive information with privacy-preserving techniques.
Intermediate Data Modeling in Power BI
Master data modeling in Power BI.
Introduction to Databases in Python
In this course, you'll learn the basics of relational databases and how to interact with them.
There are no reviews yet.