We may earn an affiliate commission when you visit our partners.
Agaba Philip
The Oracle database is one of the most popular relational database management systems in the world. This course teaches you the basics of storage management in Oracle, including segment deferment, table compression, and resumable space allocation.
A thorough knowledge of Oracle’s storage hierarchy is necessary for successful administration of the Oracle database.
In this course, Managing Storage with Oracle, you will learn the skills you need to manage Oracle’s logical storage components.
First, you will learn about the logical and physical storage hierarchy.
Read more
The Oracle database is one of the most popular relational database management systems in the world. This course teaches you the basics of storage management in Oracle, including segment deferment, table compression, and resumable space allocation.
A thorough knowledge of Oracle’s storage hierarchy is necessary for successful administration of the Oracle database.
In this course, Managing Storage with Oracle, you will learn the skills you need to manage Oracle’s logical storage components.
First, you will learn about the logical and physical storage hierarchy.
Read more
The Oracle database is one of the most popular relational database management systems in the world. This course teaches you the basics of storage management in Oracle, including segment deferment, table compression, and resumable space allocation.
A thorough knowledge of Oracle’s storage hierarchy is necessary for successful administration of the Oracle database.
In this course, Managing Storage with Oracle, you will learn the skills you need to manage Oracle’s logical storage components.
First, you will learn about the logical and physical storage hierarchy.
Next, you will explore segment creation, extent allocation, and space management within allocated blocks.
Finally, you will learn how to save space by compressing data.
By the end of this course, you will have a solid understanding of storage management in Oracle and the knowledge to help you mitigate space wastage in your Oracle systems, as well as reduce space related failures to a minimum.
This course is no longer available. Find something similar by browsing:
Oracle Database
Storage Management
Segment Deferment
Table Compression
Resumable Space Allocation
Register for this course and see more details by visiting:
OpenCourser.com/course/tmad8t/managing
What's inside
Syllabus
Traffic lights
Traffic lights
Read about what's good
what should give you pause and
possible dealbreakers
Covers fundamentals of database storage management, crucial for Oracle database administration
Learning from experienced instructor Agaba Philip ensures quality
In-depth exploration of Oracle's storage hierarchy and its significance
Practical knowledge on managing space within allocated blocks
Techniques for data compression and space optimization
Course requires background knowledge in Oracle database
Save this course
Create your own learning path.
Save this course to your list so you can find it easily later.
Save
Save
Reviews summary
Oracle storage: clear concepts, practical insights
According to students, this course offers a largely positive experience for those seeking to understand Oracle database storage. Learners consistently praise the instructor's clear explanations and evident expertise, making complex topics like segment deferment and data compression accessible. Many found the course provided immediate, actionable insights that could be applied directly to work, particularly for saving space. However, some learners noted a significant lack of hands-on labs or practical exercises, wishing for more interactive experience beyond demonstrations. It is generally considered a strong foundation or a great way to refresh existing knowledge, though some beginners felt it assumes a degree of prior Oracle knowledge.
Offers a comprehensive overview of Oracle's logical storage components.
"This course is an excellent starting point for anyone looking to understand Oracle storage."
"Overall, a solid foundation."
"Perfect for refreshing my Oracle storage knowledge. The course is concise, covers essential topics..."
"I learned a lot about storage hierarchy and reducing space wastage from this course."
Provides valuable insights for real-world Oracle space management.
"The examples were highly practical. I feel much more confident managing space now."
"This course provided immediate, actionable insights. I've been struggling with space issues at work..."
"I've applied several techniques to my work already, resulting in noticeable improvements."
"I learned practical space-saving techniques that are immediately useful for my job."
Instructor excels at simplifying complex Oracle storage concepts.
"The instructor explains complex concepts like segment deferment and table compression very clearly."
"The instructor's depth of knowledge is evident."
"The explanations are precise, and the instructor's expertise shines through."
"I found the explanations mostly clear and easy to follow, making difficult topics understandable."
A few examples could benefit from being updated to current standards.
"I wish there were more updated examples, some felt a bit dated."
"While the core information is sound, some practical scenarios felt slightly behind current practices."
Better suited for those with some existing Oracle fundamentals.
"The course covers the basics, but it assumes a bit too much prior knowledge for a 'basics' course. As a beginner, I found myself pausing frequently to research terms."
"It's okay if you already know Oracle fundamentals."
"This course is ideal if you have a foundational understanding of Oracle database concepts already."
A common criticism is the absence of practical, interactive exercises.
"Some parts felt a bit rushed, and I would have liked more hands-on labs to practice."
"I really missed practical exercises beyond just watching demos."
"The course lacked hands-on exercises crucial for learning database management. It felt like watching a long presentation..."
"I wish there were more interactive components; purely theoretical learning is less effective for me."
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Managing Storage with Oracle with these
activities:
Review the basics of data storage
Show steps
Review the principles of data storage and database systems to strengthen your foundation for understanding Oracle storage management.
Browse courses on
Data Storage
Show steps
-
Revisit concepts of data structures and file systems.
-
Review the relational data model and its implementation.
Explore relational database management systems
Show steps
Help strengthen existing knowledge of relational database management systems. This will make it easier to apply new knowledge in this course.
Browse courses on
Relational Database Management Systems
Show steps
-
Review basic concepts of relational databases, such as tables, columns, and rows.
-
Explore different types of relational database management systems, such as Oracle, MySQL, and PostgreSQL.
Review Oracle Database Concepts
Show steps
This book covers the fundamental concepts of Oracle databases, providing a strong foundation for this course.
View
Oracle9i
on Amazon
Show steps
-
Read chapters 1-3 to gain an overview of Oracle databases.
-
Review chapters 4-6 to understand Oracle data types and storage structures.
Six other activities
Expand to see all activities and additional details
Show all nine activities
Compile Oracle storage management resources
Show steps
Gather and organize resources on Oracle storage management will help solidify understanding and provide easy reference materials.
Show steps
-
Create a folder or document to store resources.
-
Collect relevant articles, tutorials, and documentation from the web.
-
Add notes and annotations to enhance your understanding.
Follow Oracle documentation tutorials
Show steps
Completing guided tutorials provides additional support and reinforces concepts learned in the course.
Show steps
-
Visit the Oracle documentation website.
-
Search for tutorials on topics relevant to the course.
-
Follow the tutorials step-by-step to learn about Oracle database features.
Create a sample database
Show steps
Building a sample database will provide hands-on experience and help apply the concepts learned in the course.
Show steps
-
Design the database schema for a simple application.
-
Create the database and tables using Oracle SQL Developer.
-
Populate the database with sample data.
Attend an Oracle workshop or conference
Show steps
Attending workshops or conferences provides an opportunity to learn from experts and engage in discussions on Oracle storage management.
Show steps
-
Research upcoming Oracle workshops or conferences.
-
Register for an event that aligns with your learning goals.
-
Actively participate in sessions and ask questions.
Attend an Oracle storage management workshop
Show steps
Participate in a workshop led by industry experts to gain practical insights, learn best practices, and enhance your understanding of Oracle storage management.
Show steps
-
Research and identify relevant workshops.
-
Register for a workshop that aligns with your learning goals.
-
Attend the workshop and actively engage in discussions and hands-on exercises.
Practice Oracle SQL queries
Show steps
Complete repetitive exercises will enhance understanding and strengthen practical SQL query writing skills.
Show steps
-
Use Oracle SQL Developer to write queries to retrieve data from tables.
-
Practice writing queries to filter, sort, and group data.
-
Complete online exercises or quizzes to test your understanding of SQL syntax.
Review the basics of data storage
Show steps
Review the principles of data storage and database systems to strengthen your foundation for understanding Oracle storage management.
Browse courses on
Data Storage
Show steps
Show steps
Show steps
- Revisit concepts of data structures and file systems.
- Review the relational data model and its implementation.
Explore relational database management systems
Show steps
Help strengthen existing knowledge of relational database management systems. This will make it easier to apply new knowledge in this course.
Browse courses on
Relational Database Management Systems
Show steps
Show steps
Show steps
- Review basic concepts of relational databases, such as tables, columns, and rows.
- Explore different types of relational database management systems, such as Oracle, MySQL, and PostgreSQL.
Review Oracle Database Concepts
Show steps
This book covers the fundamental concepts of Oracle databases, providing a strong foundation for this course.
View
Oracle9i
on Amazon
Show steps
Show steps
Show steps
- Read chapters 1-3 to gain an overview of Oracle databases.
- Review chapters 4-6 to understand Oracle data types and storage structures.
Six other activities
Expand to see all activities and additional details
Show all nine activities
Compile Oracle storage management resources
Show steps
Gather and organize resources on Oracle storage management will help solidify understanding and provide easy reference materials.
Show steps
Show steps
Show steps
- Create a folder or document to store resources.
- Collect relevant articles, tutorials, and documentation from the web.
- Add notes and annotations to enhance your understanding.
Follow Oracle documentation tutorials
Show steps
Completing guided tutorials provides additional support and reinforces concepts learned in the course.
Show steps
Show steps
Show steps
- Visit the Oracle documentation website.
- Search for tutorials on topics relevant to the course.
- Follow the tutorials step-by-step to learn about Oracle database features.
Create a sample database
Show steps
Building a sample database will provide hands-on experience and help apply the concepts learned in the course.
Show steps
Show steps
Show steps
- Design the database schema for a simple application.
- Create the database and tables using Oracle SQL Developer.
- Populate the database with sample data.
Attend an Oracle workshop or conference
Show steps
Attending workshops or conferences provides an opportunity to learn from experts and engage in discussions on Oracle storage management.
Show steps
Show steps
Show steps
- Research upcoming Oracle workshops or conferences.
- Register for an event that aligns with your learning goals.
- Actively participate in sessions and ask questions.
Attend an Oracle storage management workshop
Show steps
Participate in a workshop led by industry experts to gain practical insights, learn best practices, and enhance your understanding of Oracle storage management.
Show steps
Show steps
Show steps
- Research and identify relevant workshops.
- Register for a workshop that aligns with your learning goals.
- Attend the workshop and actively engage in discussions and hands-on exercises.
Practice Oracle SQL queries
Show steps
Complete repetitive exercises will enhance understanding and strengthen practical SQL query writing skills.
Show steps
Show steps
Show steps
- Use Oracle SQL Developer to write queries to retrieve data from tables.
- Practice writing queries to filter, sort, and group data.
- Complete online exercises or quizzes to test your understanding of SQL syntax.
Career center
Learners who complete Managing Storage with Oracle will develop knowledge and skills
that may be useful to these careers:
Cloud Architect
Cloud Architect
Cloud Architects design and implement cloud computing solutions. They may work in a variety of industries, including finance, healthcare, and retail. Those seeking to enter this field are advised to take this course on Managing Storage with Oracle, as it will help them build a foundation in cloud computing and architecture.
Big Data Architect
Big Data Architect
Big Data Architects design and implement big data solutions. They may work in a variety of industries, including finance, healthcare, and retail. Those seeking to enter this field are advised to take this course on Managing Storage with Oracle, as it will help them build a foundation in big data management and architecture.
Enterprise Architect
Enterprise Architect
Enterprise Architects design and implement enterprise-wide IT solutions. They may work in a variety of industries, including finance, healthcare, and retail. Those seeking to enter this field are advised to take this course on Managing Storage with Oracle, as it will help them build a foundation in enterprise architecture and IT management.
Data Warehouse Architect
Data Warehouse Architect
Data Warehouse Architects design and implement data warehouses. They may work in a variety of industries, including finance, healthcare, and retail. Those seeking to enter this field are advised to take this course on Managing Storage with Oracle, as it will help them build a foundation in data warehouse design and implementation.
Database Architect
Database Architect
Database Architects design and implement databases. They may work in a variety of industries, including finance, healthcare, and retail. Those seeking to enter this field are advised to take this course on Managing Storage with Oracle, as it will help them build a foundation in database design and implementation.
Web Developer
Web Developer
Web Developers design and develop websites. They may work in a variety of industries, including finance, healthcare, and retail. Those seeking to enter this field are advised to take this course on Managing Storage with Oracle, as it will help them build a foundation in database management and web development.
Data Scientist
Data Scientist
Data Scientists use their expertise in math, statistics, and computer science to extract insights from data. They may work in a variety of industries, including finance, healthcare, and retail. Those seeking to enter this field are advised to take this course on Managing Storage with Oracle, as it will help them build a foundation in data management and analysis.
Software Engineer
Software Engineer
Software Engineers design, develop, and maintain software applications. They may work in a variety of industries, including finance, healthcare, and retail. Those seeking to enter this field are advised to take this course on Managing Storage with Oracle, as it will help them build a foundation in database management and software development.
Systems Analyst
Systems Analyst
Systems Analysts design, develop, and implement computer systems. They may work in a variety of industries, including finance, healthcare, and retail. Those seeking to enter this field are advised to take this course on Managing Storage with Oracle, as it will help them build a foundation in database management and systems analysis.
Data Analyst
Data Analyst
Data Analysts use their expertise to collect, analyze, and interpret data in order to help make informed decisions. They may work in a variety of industries, including finance, healthcare, and retail. Those seeking to enter this field are advised to take this course on Managing Storage with Oracle, as it will help them build a foundation in data management and analysis.
Information Technology Manager
Information Technology Manager
Information Technology Managers oversee the planning, implementation, and maintenance of computer systems and networks. They may work in a variety of industries, including finance, healthcare, and retail. This course on Managing Storage with Oracle may be useful for those seeking to enter this field, as it will help them build a foundation in database management and IT management.
Computer Network Architect
Computer Network Architect
Computer Network Architects design and implement computer networks. They may work in a variety of industries, including finance, healthcare, and retail. This course on Managing Storage with Oracle may be useful for those seeking to enter this field, as it will help them build a foundation in database management and network architecture.
Technical Support Specialist
Technical Support Specialist
Technical Support Specialists provide technical support to users of computer software and hardware. They may work in a variety of industries, including finance, healthcare, and retail. This course on Managing Storage with Oracle may be useful for those seeking to enter this field, as it will help them build a foundation in database management and technical support.
Information Security Analyst
Information Security Analyst
Information Security Analysts are responsible for protecting an organization's computer systems and networks from unauthorized access, use, disclosure, disruption, modification, or destruction. This course on Managing Storage with Oracle may be useful for those seeking to enter this field, as it will help them build a foundation in data security.
Database Administrator
Database Administrator
Database Administrators are responsible for the day-to-day operation and maintenance of databases. They ensure that databases are running smoothly and efficiently, and that data is protected and secure. This course on Managing Storage with Oracle may be useful for those seeking to enter this field, as it will help them build a foundation in Oracle database management.
For more career information including salaries, visit:
OpenCourser.com/course/tmad8t/managing
Reading list
We've selected nine books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Managing Storage with Oracle.
Of the three books listed so far, this one is the most relevant to the course's topic of storage management. It provides a comprehensive overview of storage management techniques in Oracle, including segment deferment, table compression, and resumable space allocation - topics that are covered in the course.
A comprehensive reference guide for Oracle database administrators, covering a wide range of topics.
A comprehensive guide to Oracle database administration, covering all essential topics in a clear and concise manner.
Provides a comprehensive guide to SQL tuning for Oracle databases, including techniques for optimizing queries and reducing execution time.
Is focused on backup and recovery of Oracle Database 12c, including storage management. It valuable resource for experienced Oracle DBAs who want to ensure the safety of their data.
Provides a deep dive into performance optimization techniques for Oracle databases, including storage management. It valuable resource for experienced Oracle DBAs who want to improve the performance of their systems.
Practical guide to Oracle Database 12c administration. It covers a wide range of topics, including storage management. This book valuable resource for anyone who wants to learn more about Oracle Database administration.
Provides a concise and accessible reference to Oracle Database 12c. It includes a chapter on storage management.
Is an introduction to Oracle Database. It covers a wide range of topics, including storage management. This book valuable resource for anyone who wants to learn more about Oracle Database.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/tmad8t/managing
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2025 OpenCourser