Time
9 hours 41 minutes
Difficulty
Intermediate
CEU/CPE
10

Video Transcription

00:00
Hi we're gonna module to This is a lesson 2.1 database engines and module to We're just gonna do a quick review and go over some basic database concepts to get in the fuel of things.
00:11
And the first lesson that we're going to go over is database engines. So what is the database engine? It's software. The specializes in the management of databases. It's a major component of the database management system or D B. M s for short
00:27
database engines. Provide the four basic data operations which are create, read, update and delete.
00:33
They're very efficient. A lot of the database engines that we are all familiar with such is my sequel or Microsoft sequel have been around for quite a bit of time, and they've had a long time to develop and mature
00:46
that race engines also provides structures to promote customized efficiency, such as implementing your own custom indexes on data tables.
00:55
They provide structures for concurrency control,
00:58
which is what happens when multiple users are working on the same data. At the same time, we can program to account for this.
01:07
Also,
01:07
database engines aimed to provide something called acid, which is Adamis ity consistent, see isolation and durability. Or, to sum it up, they tried to make the database engine as resilient as possible so that the data is not easily corrupted in the event of a
01:26
events such as power failure.
01:30
And that brings us to summary
01:33
2.1 database engines summary.
01:34
We described a database engine at a very high level,
01:38
but put simply, a database engine provides the controls for effective and efficient data storage through pragmatic interactivity. And what is some of that pragmatic interactivity? Well, that's the sequel code it's or the sequel programming that will we will be doing later on in this lesson.
01:55
So that completes this lesson, and I hope to see you 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