Time
7 hours 36 minutes
Difficulty
Beginner
CEU/CPE
3

Video Transcription

00:00
All right, Welcome back to model one course introduction. This is lesson to database engines and we're in the first and only sub lesson 2.2 database engine overview.
00:10
So what is a database while a database, if we look up the definition is a structure set of data held in a computer,
00:18
especially one that is accessible in various ways. Now that definition definition is very broad and would cover a lot of things. For example, you could put a bunch of data in excel and then call it a database. You could put a lot of data in a note pad and then call it a database
00:35
because essentially becoming just that a structured set of data held in the computer.
00:40
Now, what is a database engine? Well, a database engine. If we look up the definition of that, we get kind of a complicated definition.
00:49
So a database engine or storage engine is the underlying software component that a database management system D B. M s uses to create, read of dating, delete crowd
00:59
data from a database, so
01:02
toe put that much more simply.
01:04
Database engine is simply software that manages a database.
01:10
So there are a lot of those out there. There's my sequel, which we're going to be working with in this course. There's Microsoft sequel. There's the
01:18
IBM
01:19
database.
01:21
There's the fire base that Google has. There are some other ones as well. So
01:26
which database should you learn or which database engines should you learn? Well,
01:32
we're actually kind of lucky that there are standards being pushed out with respect to what structured query language should support. And B,
01:41
what does that mean? That means that if you get really good at sequel in one database,
01:46
you'll be able to take a lot of what you know, into another database and acclamation to that database very quickly. Now, you might not get very specific questions correct right out the bit of the outer gate, because in one database you might have called a
02:01
a specific type of joint a Cartesian join, and then in another database that might have called it a cross joint. And if you've never thought of it as a cross joint, of course you're not aware of that. And so you see it and then you're like, OK, I know what that is. It's just that we call that something else over there.
02:16
So that means, is that we can learn and get really good at sequel in one engine and take a lot of what we've learned and apply in another engine pretty quickly. So just to give you an example,
02:27
let me pull up a query that we will use later on. In this course. This is a query written for my sequel
02:34
against the ACU Matic, a database they gets installed later as well,
02:38
so this will run in my sequel.
02:40
This is currently running against my sequel
02:43
now, like
02:45
Take This and I copy
02:47
this query
02:50
and I go
02:54
into Microsoft sequel, which is now where we are right now, and I paste that Cleary.
03:01
I see a red squiggly line, but only one now. I just tried to run this query. I'll get there.
03:07
You don't say. The type sign is not defined system time,
03:10
which is the underlying word here. So signed is a type of energy or or number,
03:15
and Microsoft sequel doesn't call it that.
03:20
So to make this compatible with Microsoft's equal, we only need to change one thing. We need to change that sign to an imager
03:27
now, if we run it,
03:29
it'll work.
03:30
In fact, there's a way we could make this quarry working either database with no changes. We just give her the cast statement,
03:39
and this will still run.
03:44
Now we take it back into my sequel
03:47
and just paste it
03:49
in there as is.
03:51
It'll still run.
03:53
So both of these queries produce the same results and
03:57
send the data base engine the equivalent command, and we get the expected results, which are the same back shows how similar the sequel statements are between my sequel on Microsoft's equal and the same is true for Oracle and IBM. A lot of times you could potentially take the exact same query that you've written,
04:17
copy it and paste it into the other database. Another database will run just fine. Now there are other nuances, such as the cast statement as well as the limit one. For example,
04:30
if we, ah want to only get one record back,
04:34
we have to put limit one
04:36
in
04:38
my sequel and we get one record back. But if we wanted the same effects
04:43
and Microsoft sequel,
04:45
we select top one
04:49
and we get the same effect.
04:51
So there are little differences. Differences such as that, but the relationships stay the same. The 121212 many, many, many Cartesian products. They might give it a different name, like in one database. They might call it a cross joint,
05:04
but once you understand that, you'll recognize it is the same thing and adjust accordingly.
05:11
So that completes this lessons on database engines. We briefly describe what a database is. What a database engine is. Database is just a
05:19
basically a safe set of data, and it's very broad. Could include text documents, excel or databases them stata base engine data themselves. And then we discuss database Engine, which is software that specialized end out of a storage or crowd operations, which stands for create of date delete.
05:38
Basically putting that in the database.
05:41
The leading data, if necessary, and updating data
05:44
as well as retrieving it.
05:45
And we looked at how similar the sequel can be
05:48
can be between two different database engines
05:51
and why getting good at sequel in one database engine gives you a lot of ability and other database engines that follow the structure. Query language constructs is, well,
06:00
new ways that completes this lesson, and I hope to see you in the next thank you

Up Next

Introduction to SQL

This introductory SQL training teaches SQL core concepts that can be applied in professional environments. Once students complete this course, they will be able to query and interact with an SQL database, and know how to design database schemas.

Instructed By

Instructor Profile Image
Kitt Parker
Instructor