Database Lesson #6 of 8 - Database Administration

Dr. Soper gives a lecture on database administration. Topics covered include concurrent access / concurrency control, database security, database backup and recovery strategies, database locking (including optimistic locking, pessimistic locking, and deadlock), and database transactions.

[@Knowledge_Nuggies]

The only thing missing in this series is a video where you actually put these things into practice and navigate around an actual DBMS like MySQL or even MS Access (for simplicity) and show where and how all these concepts apply.

[@robbywood440]

I feel this comment so hard right now.

[@alabamathunder2891]

I seriously sat through these lectures and slayed a few dragons here at work, as a total amateur. I feel more like a pro now. Thank you for posting this.

[@linjiepeng3889]

Dr.Soper, you are amazing

[@DrSatti]

Thanks for sharing your knowledge. I really builds the sound foundations.

[@ArabDude123]

His voice is so mellow

[@jimc1499]

Again I really appreciate these videos thank you again.

[@terran008]

Thanks for your videos, I watch them to understand a bit more my lectures of introduction to database, my prof makes it seem kind of confusing

[@Chiexplorer]

his lectures are clear and easy to understand. Great professor in person!

[@80amnesia]

Great lecture! Thanks Dr.Soper

[@sinebiinnazo7882]

You are are a genius & i love your teaching style . Can you please give us a class on OOP in PHP?

[@pervezahmed4592]

Thanks Dr.Soper ......you r explaining in very simple i see all the lecture from 1 to 6 i didnt understand only one thing that is difference between relationship and Cardinality

[@kahsaye2006]

pervez 401 really drdd

[@khumbogama9728]

great Job Dr Soper

[@christopheropara6083]

Thanks Dr Soper

[@DaBBoSaH]

great lesson, totally enjoyed it

[@vigneshsoap123]

Quick question: Dirty read definition: When a transaction by user A reads modified data by user B that is not commited in the DB. If transaction by user A can read data that is modified by user B, doesn't that mean the data is committed?

[@vigneshsoap123]

Found good explanation here www.geeksforgeeks.org/dbms-dirty-read-in-sql/

[@nandhi19]

Thank you Dr!

[@tawaz570]

I really appreciate your teachings,you are good and now i am ready to go ahead .Please help us on xml

[@jacobstine8693]

so at 20min into the video, if they had preformed the action of reducing the inventory as a math function instead of doing the math themselves then rewriting whats there could it have worked?

[@uraaxeecaqligaaga4890]

Sir we only started transaction OT2 and we finished with no object that's the transaction in log table. May you give us explanations about that please. Thank you

[@Wiktoria556]

Thank you for the series of lessons. I just have one question regarding this video. Why a role can have 0 permissions assigned? (part 1:09:20) isn't it necessary for a role to have at least one permission to exist?

[@marianos4101]

Remember that in cardinalities, 0 is an "optional" number of entity instances. So he could simply set a One-to-Many relationship, but have in mind that there might be some cases where a role may have 0 permissions. Imagine, for some reason, that you insert a new entity called "potential candidates" for a new job role, so you enter this new entity, but let it have 0 permissions, because there shouldn't be any permissions granted to modify data to potential new users. But I'm just a brand new Database learner, so I sticked to my poor knowledge. Hope it helps.

[@zimingwang6301]

Then, how to deal with the deadlock?

[@mohamedengland8187]

good i like that

[@bateyjosue8648]

hey. me too i'm very pleased for watching this vedeos, can i find document in power point or ms word please

[@TacosYBurritos8P]

45:04 ACID - Consistent Transactions

[@felixgolindano8913]

Your class are awesome. Thanks! I have a question, how do I prevent a Lost update problem? Do you have any example?

[@mikesdailygaming]

Set speed to 1.5 or 1.75 ... you're welcome in advance

[@gg_sonxd3579]

So if a hacker manage to hack your log file too your fucked??

[@andrewstephenson9083]

$26 basketballs?! Must be a government contract.