Fundamentals of Database Systems

Mark as Favorite Share
image

What Will You Learn?

This free course will introduce the basics of database systems. In addition to the traditional relational database systems, it will also introduce briefly the new paradigm of NoSQL databases used in big data systems. The topics will cover all important aspects including normalization, query processing and transactions.

About This Course

Provider: NPTEL
Format: Online
Duration: 18 hours to complete [Approx]
Target Audience: Beginners
Learning Objectives: Upon completion this free course, you will gain a comprehensive understanding of database systems, encompassing traditional relational databases and emerging NoSQL paradigms, and acquire essential knowledge in normalization, query processing, and transactions.
Course Prerequisites: NA
Assessment and Certification: NA
Instructor: IIT Kanpur
Key Topics: Database, NoSQL, DBMS
Topic Covered: 
  2. - Introduction to Database
  3. - Relational Data Model
  4. - RelationalAlgebra:Basic Operators
  5. - RelationalAlgebra:Additional Operators
  6. - RelationalAlgebra: Updates
  7. - Entity-Relationship Diagram
  8. - SQL: Creation and Basic Query Structure
  9. - SQL:Basic Operations
  10. - SQL:Aggregate and Grouping
  11. - SQL: Nested Subqueries and Sets
  12. - SQL: Updates and Joins
  13. - SQL:Views and Triggers
  14. - Database Normalization: Functional
  15. - Dependencies
  16. - Database Normalization: 1NF and 2NF
  17. - Database Normalization: 3NF
  18. - Database Normalization:BCNF
  19. - Database Normalization: Multi-valued Dependencies
  20. - Physical Design
  21. - Indexing:Basics and Hashing
  22. - Indexing:B-tree and B+-tree
  23. - Query Processing:Selection
  24. - Query Processing:Sorting
  25. - Query Processing:Basic Nested Loop Join
  26. - Query Processing:Block and Indexed Nested
  27. - Loop Joins
  28. - Query Processing: Merge and Hash Joins
  29. - Query Optimization:Equivalent Expressions
  30. - Query Optimization: Joins
  31. - Query Optimization: Joins
  32. - Query Optimization:Estimating Sizes
  33. - Database Transactions: Definition of Transactions
  34. - Database Transactions: Features of Transactions
  35. - Recovery Systems: Types of Recovery Systems
  36. - Recovery Systems: Log-based Schemes
  37. - Transaction Schedules: Conflicts and Aborts
  38. - Transaction Schedules:Serializability
  39. - Transaction Schedules: Recoverability
  40. - Concurrency Control Protocols: Two-phase
  41. - Locking Protocols
  42. - Concurrency Control Protocols: Timestamp Ordering Protocol
  43. - Concurrency Control Protocols: Multiple
  44. - Granularity Locks
  45. - Concurrency Control Protocols: Deadlock
  46. - Prevention
  47. - NoSQL: CAP Theorem and BASE Properties
  48. - NoSQL: Types of NoSQLSystems
  49. - Graph Databases
  50. - Big Data

0 Comments

No reviews yet !!

Please login first

Course Tags
Database Course Top Free Course On Database Fundamentals of Database Systems Learn Database Database Course by IIT NPTEL Database Course