Don't like banners? Log in and we will make sure you see no banners. For free.
No cover art

Udemy - Relational Database Management System(RDBMS) - Complete Pack

Other
Size
765 MB
Seeders
0
Leechers
0
Files
49
Category
Other
Added
at 1:26am GMT+1
Infohash
f542713d0877808cd3aa0308685c322e9cb64c3e
Direct linkTorrent fileDownload now
Don't like banners? Log in and we will make sure you see no banners. For free.

Description
Relational Database Management System(RDBMS) : Complete Pack



https://FreeCourseWeb.com

Last Update: 12/2021
Duration: 2h 17m | Video: .MP4, 1280x720 30 fps | Audio: AAC, 44.1 kHz, 2ch | Size: 764 MB
Genre: eLearning | Language: English

Learn RDBMS concepts from scratch and deep dive.
What you'll learn:
Describe the fundamental elements of relational database management systems.
Explain the basic concepts of relational data model, entity-relationship model, relational database design, relational algebra and SQL.
Design ER-models to represent simple database application scenarios
Improve the database design by normalization.
Requirements
No Prerequisites.
Description
Course Objectives:
The objective of the course is to present an introduction to database management systems, with an emphasis on how to organize, maintain and retrieve - efficiently, and effectively - information from a DBMS.
Learning Outcomes:
Upon successful completion of this course, students should be able to:
• Describe the fundamental elements of relational database management systems
• Explain the basic concepts of relational data model, entity-relationship model, relational database design, relational algebra and SQL.
• Design ER-models to represent simple database application scenarios
• Convert the ER-model to relational tables, populate relational database and formulate SQL queries on data.
• Improve the database design by normalization.
• Familiar with basic database storage structures and access techniques: file and page organizations, indexing methods including B tree, and hashing.

UNIT- I
Database System- concepts and architecture: Data modelling using the Entity Relationship (ER) modelling and Enhanced Entity Relationship (EER) modelling, Specialization and Generalization.
UNIT-II
The Relational Model: Relational database design using ER to relational mapping, Relational algebra and relational calculus, Tuple Relational Calculus, Domain Relational Calculus, SQL.
UNIT-III
Database design theory and methodology: Functional dependencies and normalization of relations, Normal Forms, Properties of relational decomposition, Algorithms for relational database schema design.
UNIT-IV
Transaction processing concepts: Schedules and serviceability, Concurrency control, Two Phase Locking Techniques, Optimistic Concurrency Control, Database recovery concepts and techniques.
UNIT-V
Data Storage and indexing: Single level and multi level indexing, Dynamic Multi level indexing using B Trees and B+ Trees, Query processing and Query Optimization, Introduction to database security.
Important information before you enroll!
Once enrolled, you have unlimited, 24/7, lifetime access to the course (unless you choose to drop the course during the first 30 days).
You will have instant and free access to any updates I'll add to the course - video lectures, additional resources, quizzes, exercises.
You will benefit from my full support regarding any question you might have 7 days a week.
Check out the promo video at the top of this page and some of the free preview lectures in the curriculum to get a taste of my teaching style and methods before making your decision.
--------------------------------------------------------------------------------------------------------------------------------------

Who this course is for
Academic Students
Competitive Exams Aspirants
GATE CS/IT
Willing to Learn

File list
  • Udemy - Relational Database Management System(RDBMS) - Complete Pack
  • ~Get Your Files Here !/1. Functional Dependency (FD)/1. Functional Dependency Introduction, Examples.mp4 120.3 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/1. Functional Dependency Introduction, Examples.srt 17.4 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/10. Application 2 Finding keys in a relation - Example 1 & 2..mp4 42.6 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/10. Application 2 Finding keys in a relation - Example 1 & 2..srt 10.3 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/11. Application 2 Finding keys in a relation - Example 3 & 4..mp4 12 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/11. Application 2 Finding keys in a relation - Example 3 & 4..srt 5.1 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/12. Application 2 Finding keys in a relation - Example 5 & 6..mp4 9.4 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/12. Application 2 Finding keys in a relation - Example 5 & 6..srt 3.6 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/13. Application 2 Finding keys in a relation - Example 7 & 8..mp4 7.2 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/13. Application 2 Finding keys in a relation - Example 7 & 8..srt 2.9 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/14. Application 2 Finding keys in a relation - Example 9 & 10..mp4 21.7 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/14. Application 2 Finding keys in a relation - Example 9 & 10..srt 6.7 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/15. Application 2 Finding keys in a relation - Example 11 & 12..mp4 22.6 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/15. Application 2 Finding keys in a relation - Example 11 & 12..srt 6.5 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/16. Application 2 Finding keys in a relation - Example 13 & 14..mp4 17.7 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/16. Application 2 Finding keys in a relation - Example 13 & 14..srt 5.4 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/17. Application 3 Equivalence of Functional Dependencies - Example 1.mp4 43 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/17. Application 3 Equivalence of Functional Dependencies - Example 1.srt 9.2 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/18. Application 3 Equivalence of Functional Dependencies - Example 2.mp4 14.5 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/18. Application 3 Equivalence of Functional Dependencies - Example 2.srt 4.7 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/19. Application 3 Equivalence of Functional Dependencies - Example 3.mp4 9 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/19. Application 3 Equivalence of Functional Dependencies - Example 3.srt 2.9 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/2. Types of Functional Dependencies Trivial and Non-Trivial FD's..mp4 34.6 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/2. Types of Functional Dependencies Trivial and Non-Trivial FD's..srt 5.1 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/20. Application 3 Equivalence of Functional Dependencies - Example 4.mp4 19.1 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/20. Application 3 Equivalence of Functional Dependencies - Example 4.srt 5.2 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/21. Application 4 Irreducible set and Algorithm..mp4 42.2 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/21. Application 4 Irreducible set and Algorithm..srt 8.6 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/22. Application 4 Irreducible set - Example 1.mp4 37.9 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/22. Application 4 Irreducible set - Example 1.srt 9.1 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/23. Application 4 Irreducible set - Example 2..mp4 35.4 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/23. Application 4 Irreducible set - Example 2..srt 9.2 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/3. FD Example..mp4 54.2 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/3. FD Example..srt 8.3 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/4. Inference Rules.mp4 64.5 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/4. Inference Rules.srt 10.4 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/5. Attribute Closure Example 2.mp4 29.8 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/5. Attribute Closure Example 2.srt 9.5 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/6. Attribute Closure Example 3.mp4 33.4 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/6. Attribute Closure Example 3.srt 10.5 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/7. Attribute Closure Example 4.mp4 15.8 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/7. Attribute Closure Example 4.srt 6.1 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/8. Applications of Attribute Closure.mp4 9.9 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/8. Applications of Attribute Closure.srt 4.7 KB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/9. Application 1 Finding additional FD's.mp4 10.3 MB
  • ~Get Your Files Here !/1. Functional Dependency (FD)/9. Application 1 Finding additional FD's.srt 4.3 KB
  • ~Get Your Files Here !/2. Normalization/1. Normalization Introduction and types..mp4 57.7 MB
  • ~Get Your Files Here !/2. Normalization/1. Normalization Introduction and types..srt 8.7 KB
  • ~Get Your Files Here !/Bonus Resources.txt 386 B

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
2.5 GB02