-
ABOUT THE COURSE
This Course is Only Available On Our App
Dive-in and start learning! Get offline access to all the course contents!
No items in this section -
Description
What 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. -
Module 1 - Introduction Database Concepts
-
Module 2 - Entity–Relationship Data Model
-
Module 3 - Relational Model and relational Algebr
-
Module 4 - Structured Query Language (SQL)
- Introduction to SQL
- Data definition language
- DML ( data manipulation language )
- DRL ( Data Retrieval Language)
- Aggregate Function in SQL
- SQL Inner Joins & Left join
- SQL Right Join & Full Join
- DBMS Importance with complete strategy for Mumbai Universality
- Types of Joins in SQL
- B+ Tree Indexing
- Search and Expression Equivalance
- Indexing
- PL SQL | part 1 |
- PL SQL | part 2 |
- Query Processing And Query Optimisation [Part 1]
- Query Processing And Query Optimisation [Part 2]
- Query Processing And Query Optimisation [Part 3]
- Query Processing And Query Optimisation [Part41]
- Integrity Constraints
- Trigger
- Data Independence
-
Module 5 - Relational-Database Design
-
Module 6 - Transactions Management and Concurrence
- Concurrency Control
- Concurrency Control – Lock Based Protocol in DBMS Transaction
- Timestamp Based Protocol
- Deadlock Full concept in DBMS transaction management
- Shadow Paging in Database Recovery
- Log Based Database Recovery
- Shadow Copy Technique in Database recovery
- Transaction State and Acid Properties
- Transaction Schedule
- View Serializability
- Conflict Serializability
1 Comment
Excellent