Short Description
Learn RDBMS concepts from scratch and deep dive
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.
ALL THE BEST FOR YOUR BRIGHT FUTURE.
Check: Data Science course