Incident and Disaster Response
28:23
2 жыл бұрын
Firewalls: Firewall Policy Example
2:06
Host Hardening: Introduction
4:57
2 жыл бұрын
Host Hardening: Patching
5:00
2 жыл бұрын
Host Hardening: Users and Groups
4:51
Host Hardening: Security Baselines
3:55
Host Hardening: Permissions
4:56
2 жыл бұрын
Host Hardening: Group Policy Objects
3:35
Application Security: Code Injection
7:50
Application Security: Other Attacks
6:35
Application Security: Protections
4:00
Application Security: Introduction
5:29
Data Protection: Introduction
8:31
2 жыл бұрын
Data Protection: Backing Up
13:49
2 жыл бұрын
Data Protection: Fuzzing with ZAP
3:10
Data Protection: Secure Deletion
5:13
Forensics: Introduction
14:33
2 жыл бұрын
Пікірлер
@HemantaShrestha-zm7dc
@HemantaShrestha-zm7dc 4 күн бұрын
how would you describe unary many to many relationship on table , in context of referencing ?
@HemantaShrestha-zm7dc
@HemantaShrestha-zm7dc 4 күн бұрын
how would you describe unary many to many relationship on table , in context of referencing ?
@DustinOrmond
@DustinOrmond 4 күн бұрын
In this example, an item has many items (call a component) and each component (item) may be in many items. Therefore, we would need an associative entity because of the many to many relationship.
@fouz1245
@fouz1245 14 күн бұрын
Thanks a lot, as a beginner to this concept why is Customer ID not the Primary key?
@DustinOrmond
@DustinOrmond 10 күн бұрын
Because it is determined by order_id. It is a primary key of the relation CUSTOMER, but not in 1NF.
@robyee3325
@robyee3325 26 күн бұрын
Thanks!
@Aneix12
@Aneix12 Ай бұрын
Very clear explanation
@TheAbsoluteSir
@TheAbsoluteSir Ай бұрын
I think a game can definitely be within multiple seasons in a different year! However, within the same year, a game will only ever be in one season, like how Basketball is in winter. I feel like either answer is fine, but you have to make sure you have words between tables to help understand the relationship/
@pretender1971
@pretender1971 Ай бұрын
Dear Justin, Thank you so much for the brilliant videos on Normalization. It is the best resources and explanation about Normalization out there. I am using these videos to teach Normalization to my students in Year 12 Computer Science over here in Australia. I was wondering if you could share some Normalization exercises that you use at Uni for your students. It is very hard to find good flat file to normalize to 3NF with answer key. I would appreciate if you could share a few Normalization exercises similar to the examples that you use in your videos. With Thanks Regards
@VinhLeang-dj9ef
@VinhLeang-dj9ef Ай бұрын
how to proxy work
@forheuristiclifeksh7836
@forheuristiclifeksh7836 2 ай бұрын
0:10
@kartikkumar-xh1if
@kartikkumar-xh1if 2 ай бұрын
great video 👍
@kartikkumar-xh1if
@kartikkumar-xh1if 2 ай бұрын
clear explanation, thank you
@nalimawlana
@nalimawlana 2 ай бұрын
thanks sir keep going
@nielcaspillo5803
@nielcaspillo5803 2 ай бұрын
what application did you use to create database that you crated directory may I know?
@DustinOrmond
@DustinOrmond 2 ай бұрын
I created my own server that runs all this. I haven't made it public yet.
@wickedwater24
@wickedwater24 2 ай бұрын
Explained extremely well, thanks a lot for this playlist
@AlexLucard
@AlexLucard 3 ай бұрын
OMG Speak up
@DustinOrmond
@DustinOrmond 3 ай бұрын
I am sorry you are experiencing issues. The volume seems fine on my end even at 50%.
@felipemurta9160
@felipemurta9160 3 ай бұрын
audio is completely fine lmao
@mariandapotgieter470
@mariandapotgieter470 4 ай бұрын
Thank you for this video, this is really going to help me with my studies
@imwinniedr
@imwinniedr 4 ай бұрын
Underrated, thanks
@MikeKm-hd1ve
@MikeKm-hd1ve 4 ай бұрын
Clear and concise!! Thank you
@eliknowsbest4946
@eliknowsbest4946 4 ай бұрын
This is a great video thank you
@ii7mdj_353
@ii7mdj_353 4 ай бұрын
Came here for education. Thanks Dustin!
@phoenixHen-fh5mj
@phoenixHen-fh5mj 5 ай бұрын
dick and balls
@bobburke4336
@bobburke4336 5 ай бұрын
Very well presented . Thanks for sharing.
@Spaceoholic_2005
@Spaceoholic_2005 5 ай бұрын
Thank u for the explanation it's useful for my seminar
@nezhabouguerza8743
@nezhabouguerza8743 5 ай бұрын
thanks
@user-kh9ee4oo7p
@user-kh9ee4oo7p 5 ай бұрын
excuse me sir, I tried to register on your website, it asked me for a netID I tried different things could you please provide me netID or how to do it?
@DustinOrmond
@DustinOrmond 5 ай бұрын
Unfortunately, I only allow students access right now. In the future, I may open it up to the public.
@user-kh9ee4oo7p
@user-kh9ee4oo7p 5 ай бұрын
@@DustinOrmond Oh alright and thank you so much for the courses
@user-kh9ee4oo7p
@user-kh9ee4oo7p 5 ай бұрын
For multivalued attributes how it becomes one-to-many, I think it should be many-to-many because An employee can have multiple skills and A skill may be owned by many employees Also in the nurse and care center example is it the care center the optional or the nurse regarding to erd
@DustinOrmond
@DustinOrmond 5 ай бұрын
Multi-valued attributes don't become one-to-many. The employee_skill table essentially serves as an associative entity where you can have an employee with multiple skills and a skill can pertain to multiple employees: employee_id skill 1 router 1 table saw 2 router 2 mitre saw The care center is on the optional side. In essence, a nurse may or may not be in charge of a care center.
@user-kh9ee4oo7p
@user-kh9ee4oo7p 5 ай бұрын
@@DustinOrmond but nurse is the optional right? because it may be in charge of care center and the care center is mandatory because it’s must be charged or managed by a nurse
@DustinOrmond
@DustinOrmond 5 ай бұрын
@@user-kh9ee4oo7p The cardinalities of the relationship state that a nurse can optionally manage a care center, but each care center is only managed by one nurse. So, yes what you are saying is true in your last two sentences. In other words, you read it like this, "A nurse optionally manages one care center (the optional-one cardinality touching the care center), and a care center is managed by one and only one nurse (the mandatory-one cardinality next to nurse)."
@user-kh9ee4oo7p
@user-kh9ee4oo7p 5 ай бұрын
@@DustinOrmond That’s mean the care center is total participation and nurse partial participation so that a nurse is the optional one and the care center is the mandatory because each instance must take part in the relationship
@DustinOrmond
@DustinOrmond 5 ай бұрын
@@user-kh9ee4oo7p Yes.
@user-kh9ee4oo7p
@user-kh9ee4oo7p 5 ай бұрын
In my college they taught us that we have weak entities my question is Should I just not use it? Also Should I use surrogate key instead of composite primary key and why?
@DustinOrmond
@DustinOrmond 5 ай бұрын
Yes, weak entities exist but they are such a small use case. I have slides that talk about them, but I do not have lecture videos. In fact, I choose not to focus on these because the time is better spent on other topics. You choose whether to use a surrogate or a composite. The surrogate is often easier, and I tend to use a surrogate in all cases where the composite is 3+ attributes.
@user-kh9ee4oo7p
@user-kh9ee4oo7p 5 ай бұрын
@@DustinOrmond Thank you so much, actually I use Django and I can only use surrogate key and Could you please tell me where can I find these slides?
@user-kh9ee4oo7p
@user-kh9ee4oo7p 5 ай бұрын
Thank you so much, actually this short course is very useful, and I want you to advise me please where to go next to master ERD..
@DustinOrmond
@DustinOrmond 5 ай бұрын
I recommend you think of a personal aspect in your life or data that you (or someone you know) normally track and model the database that would exist related to this data. Applying the concept to a real situation will help you learn leaps and bounds more than other arbitrary exercises.
@Abaadio
@Abaadio 5 ай бұрын
Thank you, simple and short video. very helpful
@krisztiantamasi1493
@krisztiantamasi1493 5 ай бұрын
Thank you so much!
@user-eo8hh7yf6g
@user-eo8hh7yf6g 5 ай бұрын
Awesome video.
@guneyfatma
@guneyfatma 5 ай бұрын
why did you put quotation marks on order?
@DustinOrmond
@DustinOrmond 5 ай бұрын
This is actually a tick mark and not a quote. The tick mark is the key above the tab key on your keyboard. The word "order" is a reserved keyword used in ORDER BY. Therefore, without the tick mark, running the query would fail.
@guneyfatma
@guneyfatma 5 ай бұрын
@@DustinOrmond thank a lot for your help. I got it 🙏
@TriNguyenuc-jc3fp
@TriNguyenuc-jc3fp 5 ай бұрын
This is so helpful. Keep up the good work, Dustin!
@mosawo5491
@mosawo5491 6 ай бұрын
so transitional dependency is C or all A,B and C ?
@DustinOrmond
@DustinOrmond 6 ай бұрын
It is A -> B -> C, not just C.
@MdIbrahim-qg1nj
@MdIbrahim-qg1nj 6 ай бұрын
Thanks for useful information
@adriannafenee7885
@adriannafenee7885 7 ай бұрын
Thanks, Dustin! This is exactly what I needed for today's exam. I dont know why those crows feet were giving me such a hard time but thank you for this breakdown! LOL
@bongkiyungalabee2858
@bongkiyungalabee2858 7 ай бұрын
Where was this video, I mean I have been struggling with this and getting more confuse with other KZfaq videos but this right here is magic, thank you sir
@enviousshade1770
@enviousshade1770 8 ай бұрын
why do you sound like chris chan it took me a while to concentrate because of this😂😂
@peternydahl6150
@peternydahl6150 8 ай бұрын
This helped me so much indeed. Thanks a lot! Great video! 👍👍👍
@kabs1681
@kabs1681 8 ай бұрын
why is the Code considered a Primary Key?
@DustinOrmond
@DustinOrmond 8 ай бұрын
Because code determines fine is a functional dependency.
@AbdinurKhalif
@AbdinurKhalif 9 ай бұрын
I wish I had seen your channel before I spent much time understanding this concept. Expert decomposition.
@huda5450
@huda5450 9 ай бұрын
I have a midterm tommorow on this chapter and you honestly put together everything , it made sense, it had all the content I needed to learn. thank you so much truly. It is hard enough to find content when you are a university student and i appreciate your efforts!! :) stay blessed. 😁
@yasmeenabdelazime769
@yasmeenabdelazime769 9 ай бұрын
How it was🥺?!
@JohnBuildWebsites
@JohnBuildWebsites 9 ай бұрын
On line 50, where you have `Count(o.order_id)` I've recently been shown it is more performant to NOT use the primary key if other non null fields exist, with `Count(o.*)` actually being perfectly fine despite myths to the contrary. Something to do with PK fields beings stored in a more robust format that has some additional overhead.
@DustinOrmond
@DustinOrmond 9 ай бұрын
Interesting. Thanks for bringing this to my attention. I will look into it.
@devakinandan7659
@devakinandan7659 9 ай бұрын
I'd argue that players might not always need coaching and might self train as well, so it is probably optional-many. Anyways, excellent video, made me understand the concept pretty well. Thank you, justin
@DustinOrmond
@DustinOrmond 9 ай бұрын
This could definitely be a way to model this. Each database may be designed slightly different depending on the assumptions that are made.
@devakinandan7659
@devakinandan7659 9 ай бұрын
@@DustinOrmond ahh thanks mate. Reckon we got to take the ideal scenario for such cases
@chantel2689
@chantel2689 10 ай бұрын
THANK YOU KING 👑
@trygvemb
@trygvemb 10 ай бұрын
What program did you use to draw those tables in. It looked like a super helpfull tool to get an overview when working with databases
@DustinOrmond
@DustinOrmond 10 ай бұрын
It is my own custom built application which isn't publicly available yet.
@vaishnavi461
@vaishnavi461 10 ай бұрын
this was really helpful! Thank you so much :)
@user-mr9yf9de1d
@user-mr9yf9de1d 10 ай бұрын
Better than my $60k a year private college professors
@AnjeMae
@AnjeMae 11 ай бұрын
Thank you so much. Your playlist on normalization is so easy to follow and understand :)
@AnjeMae
@AnjeMae 11 ай бұрын
Thank you :)