Curriculum
- 8 Sections
- 51 Lessons
- 24 Weeks
Expand all sectionsCollapse all sections
- ABOUT THE COURSE.course-payment { float: right; display: inline-block; position: relative; margin-bottom: 40px; display: none; } /*! CSS Used from: Embedded */ *, ::after, ::before { box-sizing: border-box; border-width: 0; border-style: solid; border-color: #e5e7eb; } ::after, ::before { --tw-content: ''; } h2 { font-size: inherit; font-weight: inherit; } a { color: inherit; text-decoration: inherit; } h2, p { margin: 0; } :disabled { cursor: default; } *, ::before, ::after { --tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; --tw-rotate: 0; --tw-skew-x: 0; --tw-skew-y: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-ring-offset-width: 0px; --tw-ring-offset-color: #fff; --tw-ring-color: rgb(59 130 246 / 0.5); --tw-ring-offset-shadow: 0 0 #0000; --tw-ring-shadow: 0 0 #0000; --tw-shadow: 0 0 #0000; --tw-shadow-colored: 0 0 #0000; } .mx-auto { margin-left: auto; margin-right: auto; } .mb-2 { margin-bottom: 0.5rem; } .mb-4 { margin-bottom: 1rem; } .mb-6 { margin-bottom: 1.5rem; } .mr-2 { margin-right: 0.5rem; } .max-w-screen-sm { max-width: 640px; } .max-w-screen-xl { max-width: 1280px; } .rounded-lg { border-radius: 0.5rem; } .bg-primary-700 { --tw-bg-opacity: 1; background-color: rgb(29 78 216 / var(--tw-bg-opacity)); } .bg-white { --tw-bg-opacity: 1; background-color: rgb(255 255 255 / var(--tw-bg-opacity)); } .px-4 { padding-left: 1rem; padding-right: 1rem; } .px-5 { padding-left: 1.25rem; padding-right: 1.25rem; } .py-2.5 { padding-top: 0.625rem; padding-bottom: 0.625rem; } .py-8 { padding-top: 2rem; padding-bottom: 2rem; } .text-center { text-align: center; } .text-4xl { font-size: 3rem; line-height: 2.5rem; } .text-sm { font-size: 0.875rem; line-height: 1.25rem; } .font-extrabold { font-weight: 800; } .font-light { font-weight: 300; } .font-medium { font-weight: 500; } .leading-tight { line-height: 1.25; } .tracking-tight { letter-spacing: -0.025em; } .text-gray-500 { --tw-text-opacity: 1; color: rgb(107 114 128 / var(--tw-text-opacity)); } .text-gray-900 { --tw-text-opacity: 1; color: rgb(17 24 39 / var(--tw-text-opacity)); } .text-white { --tw-text-opacity: 1; color: rgb(255 255 255 / var(--tw-text-opacity)); } .hover\:bg-primary-800:hover { --tw-bg-opacity: 1; background-color: rgb(30 64 175 / var(--tw-bg-opacity)); } .focus\:outline-none:focus { outline: 2px solid transparent; outline-offset: 2px; } .focus\:ring-4:focus { --tw-ring-offset-shadow: var(--tw-ring-inset) 0 0 0 var(--tw-ring-offset-width) var(--tw-ring-offset-color); --tw-ring-shadow: var(--tw-ring-inset) 0 0 0 calc(4px + var(--tw-ring-offset-width)) var(--tw-ring-color); box-shadow: var(--tw-ring-offset-shadow), var(--tw-ring-shadow), var(--tw-shadow, 0 0 #0000); } .focus\:ring-primary-300:focus { --tw-ring-opacity: 1; --tw-ring-color: rgb(147 197 253 / var(--tw-ring-opacity)); } @media (min-width: 640px) { .sm\:py-16 { padding-top: 4rem; padding-bottom: 4rem; } } @media (min-width: 768px) { .md\:text-lg { font-size: 1.5rem; line-height: 1.75rem; } } @media (min-width: 1024px) { .lg\:px-6 { padding-left: 1.5rem; padding-right: 1.5rem; } } .imgdata { width: 35% } @media (max-width: 767px) { .imgdata { width: 40% } }0
- DescriptionWhat you’ll Learn:
Data modelling using the entity-relationship and developing database designs.
Use of Structured Query Language (SQL) and learn SQL syntax.
Apply normalization techniques to normalize the database
Understand the needs of database processing and learn techniques for controlling the consequences of concurrent data access.
Description:
This course provides starting from the roots, the fundamentals of a database systems thereby learning to design Design and draw ER and EER diagram for the real life scenario. Converting conceptual model to relational model and formulate relational algebra queries. Talking to our very own database using SQL!!
Learning query optimization techniques like normalization and lastly dealing with transaction, concurrency & recovery.
Join in to learn Database Management System, equally important from the academic as well as real-world knowledge.
Modules Covered:
Introduction to Database Concepts
Entity-Relationship data Model
Relational Model and relational Algebra
Structured Query Language (SQL)
Relational Database Design
Transactions Management and Concurrency.1 - Module 1 - Introduction Database Concepts5
- Module 2 - Entity–Relationship Data Model2
- Module 3 - Relational Model and relational Algebr5
- Module 4 - Structured Query Language (SQL)21
- 6.1Introduction to SQL7 Minutes
- 6.2Data definition language10 Minutes
- 6.3DML ( data manipulation language )7 Minutes
- 6.4DRL ( Data Retrieval Language)7 Minutes
- 6.5Aggregate Function in SQL9 Minutes
- 6.6SQL Inner Joins & Left join7 Minutes
- 6.7SQL Right Join & Full Join6 Minutes
- 6.8DBMS Importance with complete strategy for Mumbai Universality8 Minutes
- 6.9Types of Joins in SQL10 Minutes
- 6.10B+ Tree Indexing10 Minutes
- 6.11Search and Expression Equivalance10 Minutes
- 6.12Indexing8 Minutes
- 6.13PL SQL | part 1 |8 Minutes
- 6.14PL SQL | part 2 |8 Minutes
- 6.15Query Processing And Query Optimisation [Part 1]11 Minutes
- 6.16Query Processing And Query Optimisation [Part 2]9 Minutes
- 6.17Query Processing And Query Optimisation [Part 3]6 Minutes
- 6.18Query Processing And Query Optimisation [Part41]3 Minutes
- 6.19Integrity Constraints7 Minutes
- 6.20Trigger8 Minutes
- 6.21Data Independence7 Minutes
- Module 5 - Relational-Database Design6
- Module 6 - Transactions Management and Concurrence11
- 8.1Concurrency Control9 Minutes
- 8.2Concurrency Control – Lock Based Protocol in DBMS Transaction8 Minutes
- 8.3Timestamp Based Protocol11 Minutes
- 8.4Deadlock Full concept in DBMS transaction management12 Minutes
- 8.5Shadow Paging in Database Recovery12 Minutes
- 8.6Log Based Database Recovery8 Minutes
- 8.7Shadow Copy Technique in Database recovery5 Minutes
- 8.8Transaction State and Acid Properties5 Minutes
- 8.9Transaction Schedule7 Minutes
- 8.10View Serializability5 Minutes
- 8.11Conflict Serializability9 Minutes
Introduction to DBMS Basic Concept
Next