Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Storage
Discover how to utilize and maximize database storagePreview the first lesson free — get full access to all 3 lessons.
Beginner Provider : Daniel Hanks 3 Lessons · 4m in Arabic, German, English, Spanish, French, Portuguese, Urdu, Chinese
Course Description
This course will explore the concept of storage. You’ll learn about how data is stored, and the structure used for database storage. You’ll also be introduced to the concept of Indexes, and then learn to build your own index.
Using the software downloaded, you’ll learn about the existing index that already exists within the sample database. The lesson will discuss what advantages that index can bring to a database. You’ll then learn about the difference between a clustered and non-clustered index and about the options given to a user to work with the index. You are then given the opportunity to create a new index.
What You'll Learn
- Learn how data is stored and how databases are stored
- Examine the structure used for database storage and database storage semantics
- Apply indexes and explore the existing index within the sample database
- Distinguish between clustered and non-clustered indexes and the options for working with them
- Build and create your own new index
- Understand the advantages an index can bring to a database
Key Takeaways
- The course explores how data is stored and the structure used for database storage.
- It introduces the concept of indexes and guides learners to build their own index.
- Using the downloaded software, learners examine the existing index within the sample database and the advantages it brings.
- The course explains the difference between a clustered and a non-clustered index and the options a user has to work with an index.
- Learners are given the opportunity to create a new index.
Frequently Asked Questions
What does this course cover?
It explores the concept of storage, including how data is stored, the structure used for database storage, indexes, the difference between clustered and non-clustered indexes, and how to build your own index.
What skills will I gain from this course?
The course covers Computer Data Storage, Data Storage, Database Indexes, Database Storage Structures, Object Storage, and Structured Storage.
What lessons are included?
The course includes three lessons: Database Storage: Data, Structure and Semantics; Indexes; and Creating Indexes.
Will I get hands-on practice creating an index?
Yes. Using the downloaded software you examine the existing index in the sample database, and you are given the opportunity to create a new index.
What is the difference between a clustered and non-clustered index covered here?
The course teaches the difference between a clustered and a non-clustered index and the options given to a user to work with the index, though the specific distinctions are presented within the lesson content.
