Time
9 hours 41 minutes
Difficulty
Intermediate
CEU/CPE
10

Video Transcription

00:00
I welcome back to module nine. This is less than 9.2 database structure review and this lesson. We're gonna discuss the different types of structures and databases that we went over. In this course. One really important structure starts off at the top of the bullet points, and that is the index's basic table component that is critical for quick database queries.
00:20
Without the index, you're doing full table scans,
00:23
which is very inefficient and scales horribly as more data is added to the database.
00:28
Next, our composite indexes helps optimize index implementation for improved performance. This occurs when it makes sense to have multiple indexes on the same table,
00:40
and that's kind of related to composite keys. You can break the database into additional logical sections. We saw two examples of that. That was the company I D. In a cume Attica. And that was a school I D. In the database that we developed for tracking students and their scores,
00:56
we can use with partitions for even mawr improve part performance. However, with partitions keep in mind, you won't only want to implement them if they make sense to implement, and they make sense when the table is very large. We're talking millions plus of records. Typically,
01:14
your biggest performance drag enquiries is going to be related to the index and not to a partition or the lack of a partition.
01:21
Next, their data types concept that exists in most programming languages. This really impacts how the engine treats a certain piece of data is the type of data that it is the database engines going to treat a in urge er differently than a string. So you have to be able to indicate which data type
01:40
the variable is.
01:42
Make sure the column data type makes sense. And finally, that brings us to partitions, partitions, break database tables and two smaller tables, and they're really Onley advisable when you have a very large table.
01:56
They're also abstracted from the sequel programmer. You may not even realize you're using a partition without running the explained command, and that brings this lesson review to a close, and I hope to see in the next thank you

Up Next

Intermediate SQL

This free course introduces the student to intermediate concepts found in the implementation and application of Structured Query Language (SQL) within professional business environments.

Instructed By

Instructor Profile Image
Kitt Parker
Instructor