7.2 Where to Go From Here

00:00

I Welcome back to Module seven. Course closing. This is Lesson one course review

00:05

and we're in the last sub lesson 1.3. Where to go from here.

00:09

So we made it to the last module lesson in the course. I really hope you enjoyed it. I really hope you learned some sequel along the way.

00:18

Now, where do we go from here, though? Well,

00:21

the best thing to Dio and the old saying practice makes perfect really applies here. You definitely want a circle back and practice some of those concepts that you either had difficulty understanding or difficulty implementing. And also, if you notice some other areas within those concepts that you want to explore, most definitely do that explore the

00:41

concepts,

00:41

take a deeper look at concurrency operations and how

00:45

to effectively control multiple users acting

00:49

accessing the same resource at the same time.

00:53

After that, after you've practiced sequel and got a really good grasp of it. And you're you're a master of the relationships, your master, that joins your master of the foreign key constraints and you can really develop a really good looking schema. The next thing you want to do is you want to get good at

01:10

best practice and standards and learn a design pattern or two. Now there's multiple reasons to do that, one of those being that it'll help in job interviews as you'll know the best answer when posed a the best way to solve a certain problem.

01:23

The next reason is those best. Those standards and design powder served a really important purpose, and that is to generate a code based that is easier to maintain. That is easy to implement features in now

01:38

that becomes much more important as an application grows in size.

01:42

If you have a small application like our CMS data base, which could correctly track articles, comments and user's data, but it really wasn't that complicated. If you did follow the standards in that application, it wouldn't be a huge deal, because you it's not a very big application, so you can quickly

02:00

follow the code that does exist in it around.

02:04

Now where it becomes a big deal is when the application grows in size, like the axiomatic a database has,

02:10

I believe

02:14

1000 or so tables,

02:16

Um, in any case, you can have production database where you have thousands of tables. And if you have followed those standards, it'll make reading those that database in those tables much more easier. And you don't have to do any of that guessing. For example, in ah, the acrobatic A database you might see two tables where you have that the account.

02:35

Ah, I D. On one and employee number on another now is to be account i d. The employee number. Are those equal? Maybe they could be. There's only one way to really to find out if the floor and key constraints stop there, and that is to just connect them via that entry point and see if the data makes sense that you're looking at. And that's not always the best way to do things that much.

02:53

It's much better to see that relationship there and just know that you have the right answer.