Table Design | CompTIA IT Fundamentals+ (FC0-U61)

Table Design | CompTIA IT Fundamentals+ (FC0-U61) | Part 29 of 38

Рет қаралды 9,863

Күн бұрын

In this episode, Don Pezet and Ronnie Wong dive into table design. They talk about what elements make up a table, such as schema, rows, records, fields, columns, and constraints. They also take a look at what kind of data can be stored in a database. Then they put it together, and discuss how the elements are linked together.
---
This episode is part of ITProTV's engaging online IT training course for the CompTIA IT Fundamentals+ certification. IT Fundamentals+ is an entry level certification designed to introduce users to basic computer principles. ITF+ helps professionals decide whether a career in IT is right for them, and helps to develop a broader understanding of IT concepts.
----
CompTIA IT Fundamentals+ exam objectives PDF: go.itpro.tv/it-fundamentals-e...
----
Did you know that ITProTV is CompTIA's Official Video Training Provider? Get more advanced online IT training today. Start learning free at ITProTV: go.itpro.tv/start-learning-now
----
Connect with ITProTV:
Facebook: / itprotv
Twitter: / itprotv
Instagram: / itpro.tv
LinkedIn: / itprotv
Reddit: / itprotv
#CompTIA #ITFundamentals #ExamPrep
IT skills & certification training that’s effective & engaging. Binge-worthy learning for IT teams & individuals with thousands of hours of on-demand video courses led by top-rated trainers. New content added daily. Start free on www.itpro.tv

Пікірлер: 21

@mrlinklink 2 жыл бұрын

Genuinely great material. ITProTV isn't just another coaching channel that tap dances around the subject. They actually get down into the weeds and show you what the subject is with great examples and explanations. Thank you for putting this series together. It is really helpful for someone looking to pivot into IT. Interested in learning more about what other services ITProTV offers given that your free content is really good. Specifically what kind of hands on/labs you offer.

@stevenjewell460 Жыл бұрын

Don P is perfect educator!

@rookieee9929 2 жыл бұрын

Hey Don! After watching this video, I think I will consider Database Administrator as a career that I will take! I'm still a first year college student :)

@laurencealfonso4166 4 жыл бұрын

Thank you for this video. Don seems really a nice person that if you have an argument with him, 99% it is your fault.

@ITProTv 4 жыл бұрын

His wife disagrees, but you're right for anyone else.

@karaboiisetatii785 11 ай бұрын

😂

@enbocadelobo 4 жыл бұрын

Excellent content! Thank you, guys.

@ITProTv 4 жыл бұрын

Thanks for watching!

@remuspierre8965 3 жыл бұрын

I'm learning a lot on this video

@ITProTv 3 жыл бұрын

Thanks for learning with us!

@henryjb46 4 жыл бұрын

Hi Ron / Don, I have a random question. During the talk it reminded me of Playstation Network names and for years users could not change them. Users were stuck with the same name they probably chose when they were 13 or had start a new profile but loose all of your trophies ( In-game rewards ). The reasoning Playstation said it took over a decade to fix was the fact the system was not built to change the names. After the long context my question is would the database table setup have to do with that issue? Or am I way off base? Just curious.

@ITProTv 4 жыл бұрын

Sony is somewhat known for their lack of foresight and planning on their Playstation Network. In their scenario, they were most likely using the user ID as the unique identifier for each account. Best practices, on the other hand, is to assign each account an ID number or GUID as their unique identifier. From there, the user ID just becomes another data point tied to the GUID and can easily be changed without losing records. It's easy enough to do if you plan for it from the beginning. It is very difficult to change afterwards. I have seen similar mistakes where people used table row numbers as identifiers. -Don

@WishfulWalkingVideos 2 жыл бұрын

This is the one lesson where I couldn't pay attention 😥😥

@stevenjewell460 Жыл бұрын

So when we edit names like Smith-Johnson to Smith; the effect we have is defragmentation?

@prabhjotsingh5801 3 жыл бұрын

Is adding a primary/foreign key DDL or DML? Thank you!

@ITProTv 3 жыл бұрын

It's usually part of database design which would be a DDL.

@IllusionKillerr 3 жыл бұрын

Do you do anything on Strings Floats and Boolean examples i mean I got killed with databases and app development on this test

@ITProTv 3 жыл бұрын

We go into far more depth in our SQL courses on the ITProTV website. I am surprised to hear that you got such in-depth questions on it. Typically the database and programming questions on the exam are very superficial. Either the exam has changed or you got a very unfortunate draw from the random question pool. If you would like a quick summary you can view all of the SQL data types here: www.w3schools.com/sql/sql_datatypes.asp

@sscoconut1265 3 жыл бұрын

did you pass bro?