+- Softwarez.Info - Software's World! (https://softwarez.info)
+-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone)
+--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials)
+--- Thread: Database Management Systems Part 4 : Transactions (/Thread-Database-Management-Systems-Part-4-Transactions)
Database Management Systems Part 4 : Transactions - SKIKDA - 08-18-2023
![[Image: bTnc.jpg]](https://pikky.net/medium/bTnc.jpg)
Last updated 2/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 15.01 GB | Duration: 7h 13m
Learn Transactions in Database Management Systems as DBMS forms a core subject of computer science
What you'll learn
You will become very familiar with transactions in database management
You will be able to challenge the interviewer on questions related to transactions
You will view Computer Science in a different dimension
You will be able to answer all questions of exams like GATE,PGEE,ISRO (after completing all parts of DBMS course
You will be able to get a top grade in your Database Management systems course in your Bachelor's degree
Understand how transactions work in computer systems
Requirements
Have a PC with internet connection
Absolutely no prerequisites for this course
Description
You've just stumbled upon the most in-depth Database management Course Series online. With over 7000 students enrolled and 1200+ 5 star reviews to date in the area of computer science, my computer science courses are enjoyed by students from 117 countries. Whether you want to:- build the skills in database management- build the skills in transactions which is part of college curriculum in computer science- crack interview questions on transactions topic of database management system.- or just understand online transactions work today...this complete course on Transactions is the course you need to do all of this, and more.Are you aiming to get a degree in the area of computer science as a topper ? This course is designed to give you the skills you need to answer any question on Transactions in Database Management Systems . By the end of the course you will understand Transactions topic of Database Management System extremely well and be able to answer any question on these topics for interview, academics.Lots of students have been successful with getting their first job or a promotion after going through my courses on computer science.Why choose this course over others ?The reality is that there is a lot of Database Management courses out there. It's in the hundreds. Why would you choose my courses ?The number one reason is its simplicity. According to many students in udemy, my courses are simple to understand as I always teach concepts from scratch in a simple language.The second reason is you get a mentor for computer science through this course. I get lot of doubts from students regarding their career in computer science like which elective subject to choose, which book to refer, etc. The third reason is, you are not just watching my videos, you can also ask doubts if you get one while watching the lectures. Which text book should you refer ?I have used Database System Concepts by Korth. Its a great textbook. You can follow it. But I have referred lot of other textbooks like Navathe, Sudharshan etc. So its upto you on which textbook to choose. You can choose any textbook which you are comfortable with but follow a standard author book. If you complete this course, you will find it much easier to understand these textbooks. But anyway if you complete this course with good detailed notes, you don't need to read any textbook as I am reading them for you and giving the contents in an easy to understand manner.Why should you take this course?You will be joining over 7000 students who are already enrolled in my courses.There are 2000+ reviews left by students. My Courses are rated as the best course to learn computer science for beginners.What makes this course a standout?Like you, thousands of others were frustrated and fed up with incomplete Youtube tutorials which assume you already know a bunch of stuff and also bulk textbooks able to send even the most intuitive person to sleep.Like you, they were tired of low-quality lessons, poorly explained topics and all-round confusing info presented in the wrong way. That's why so many find success in my courses. It's designed in a simple manner so that anybody will be able to understand. What if I have questions?You can ask questions anytime using the Q/A section or through personal messages. I take it very seriously and answer these questions in a detailed manner with simple english words so that anybody can understand it. Student Quote: "Everything you always wanted to know about OS but were afraid to ask"...And Vignesh Sekar gives the right answers" by Claus Kaliba.There's no risk either!You either end up with Database Management skills, learn other core computer subjects, get placed in top notch companies or research areas or you try the course and simply get all your money back if you don't like it.You literally can't lose.Ready to get started ?Enrol now using the "Add to Cart" button on the right, and get started on your way to computer science. See you on the inside (hurry, Database Series is waiting!)
Overview
Section 1: Introduction
Lecture 1 Introduction to Transactions
Section 2: Concurrent Execution vs Serial Execution
Lecture 2 Need for Concurrent Execution of Transactions
Lecture 3 Inconsistency Problem due to Concurrent Execution
Section 3: States and Properties of a Transaction
Lecture 4 States of a Transaction
Lecture 5 ACID Properties
Section 4: Schedules
Lecture 6 Schedules and their types
Section 5: Problems due to Concurrent Schedules
Lecture 7 Lost Update Problem
Lecture 8 Dirty Read Problem
Lecture 9 Unrepeatable Read Problem
Lecture 10 Phantom Read Problem
Lecture 11 Problem
Section 6: Counting Schedules
Lecture 12 Number of serial schedules possible with n transactions
Lecture 13 Number of Concurrent schedules possible
Section 7: Schedules based on Recoverability
Lecture 14 Recoverable vs Non Recoverable Schedules
Lecture 15 Cascadeless vs Cascading Schedules
Lecture 16 Difference between Cascadeless and Recoverable Schedules
Lecture 17 Problem
Lecture 18 Strict Schedule
Lecture 19 Recoverable vs Cascadless vs Strict
Lecture 20 Important Point
Section 8: Schedules based on Serializability : Conflict Serializability
Lecture 21 Equivalence of two or more schedules
Lecture 22 Conflicting actions
Lecture 23 Conflict Equivalence and Equivalence of Schedules
Lecture 24 Conflict Serializability of a schedule
Lecture 25 Important Point
Lecture 26 Problems on Conflict Equivalence and Conflict Serializability
Lecture 27 Test for Conflict Serializability using precedence graph
Lecture 28 Finding Order of Serializability
Lecture 29 Finding Number of Conflict Serializable Schedules
Lecture 30 Problem
Lecture 31 More Examples
Section 9: Schedules based on Serializability : View Serializability
Lecture 32 View Equivalence and View Serializability - Why they work
Lecture 33 Problem 1
Lecture 34 Problem 2
Lecture 35 Problem 3
Lecture 36 Problem 4
Lecture 37 Problem 5
Lecture 38 Problem 6
Lecture 39 Problem 7
Section 10: Bonus Section
Lecture 40 Bonus : How to proceed further
Anybody who needs to learn transactions from scratch,Anybody who wants to pursue a career in Computer Science,Anybody who has Database Management Systems in the Bachelor's degree,Anybody who is preparing for interview in product based companies,If you are preparing for exams like GATE , PGEE , BITS HD , ISRO ,..etc,If you are a Computer Science Engineer,If you are a software professional
Buy Premium Account From My Download Links & Get Fastest Speed.