1.2 Course Flyover Part 2

00:00

I welcome back to model one course introduction. This is Lesson one course overview, and we're currently in sub lesson 1.3 the course flyover and this lesson. We're going to briefly go over the concepts and topics that we will discuss during the duration of this course, and there is a lot of them. So let's go ahead and get started

00:19

in the remainder of the section. We will briefly go over database engines. Some of the similarities and differences following that will go through an environment set up in both Windows and Lennox that will help you follow along and coat along in this course

00:34

and the next module module to databases. We'll go over the different database relationship, such as the one toe one, the one too many, the many too many, and how to efficiently and effectively implement those relationship types. Following that, we'll go over some skim a design concepts Ah, some e R D software that can be used to help with

00:53

development

00:54

and as an example, well, actually, look at the one toe 11 too many, many too many designed in some e R D software.

01:03

Following that lesson, we'll go through some very basic admin. Just how to back up in restore database.

01:08

Definitely useful if you're going to be

01:11

doing development.

01:12

Following that will go into some sequel, joins the inner, joined the right outer, join the left out or join the cross join as well some other topics in that section

01:23

in the next module module three sequel programming. One.

01:26

We will Go Over sequel statements. Such a select update and certain delete

01:32

queries such as

01:33

queries to include writing queries themselves some queries, complex updates, conflicts, the leads

01:38

they will take a look at views, which are virtual tables created from queries.

01:42

Next, we'll move into table expressions, which are

01:47

virtual tables that you create on the fly for use in Primary Cory's. We'll take a look at that when we get to that section.

01:53

Um, this is, of course, just of course flyover. So we're not going to any great detail on these concepts were just briefly discussing what we will be going over in. Less than five tables will look at the create statements, the primary keys, that flooring keys, the constraints, the indexes.

02:09

Don't worry if you're unfamiliar with the terminology, we will be discussing what that terminology means

02:15

as we move through the course. The point here is that we are really discussing all the different components of a data base that brings a doubt about database application together and allows it to function in a predictable manner that really works out for the user's and the developers involved.

02:31

So in the next module module, four sequel programming to go a little deeper into sequel programming concepts. We'll talk about sequel functions, the functions that come out of the box with my sequel, as well as how to define your own functions. Thio, Meet yours and very specific needs.

02:50

Well, then go into sequel procedures.

02:53

Uh, how those very from functions and when it's appropriate to use a procedure or a function next, we'll look at concurrency and transactions concurred, saying transactions deals with

03:04

efficiently and effectively sharing. Resource is thine between processes. For example, if you have two processes that are going toe update the same record in the database, you may need to make sure that that happens in the right order or that they do not overwrite each other, and we'll take a look at that in that section

03:21

next we'll move into sequel triggers, which our database actions that cur after specific events such as an insert, upbeat update or delete?

03:31

Next, we'll go into sequel events. Sequel events are processes that you can schedule on a scheduler that will happen at a specific time.

03:38

These are all useful tools that have in your database tool belt.

03:45

So in the next module module five sequel development will take a look at

03:50

the various concepts that could be used in development, such as designed patterns, how to identify requirements and then for the remainder of that module. Last will be implementing a suitable requirement

04:01

database that was developed specifically for this course. It will deal with a CMS type database in which it tracks articles, users categories and tags.

04:12

Well, then look at implementing the various features of a database that we discussed in previous lessons within that database.

04:20

Then, in Model six, sequel and applications will take a look at the various types of and talk about the various types of applications that can connect to a database to meet specific objectives. Power Bi ISA popular reporting tool that connects to many types of databases to display charting data

04:42

following the power bi I example, we'll take a look at connecting an excel to the database and again charting data

04:47

and taking a brief look at how Excel can interact with the database.

04:51

And then finally, in Module seven were at the course closing, where we will again

04:57

discuss what we learned in the course and where to go from here.