Database Management Systems Full Course

Mark as Favorite Share
image

What Will You Learn?

Discover the basics of Database Management Systems (DBMS) – a helpful software for creating and managing databases efficiently. Perfect for college students and those gearing up for GATE and campus interviews, this course covers essential DBMS concepts. Learn how DBMS controls data duplication, enhances security, and maintains consistency in a simple way. Dive into the world of databases, essential for e-commerce and web applications, and boost your knowledge by solving past GATE questions.

About This Course

Provider: Youtube
Format: Online
Duration: 7 hours to complete [Approx]
Target Audience: Beginners
Learning Objectives: By the end of this free course, you will have a solid understanding of Database Management Systems (DBMS), learning to efficiently create, manage databases and control data redundancy
Course Prerequisites: NA
Assessment and Certification: NA
Instructor: Neso Academy
Key Topics: Database Management System, Databases, Relational Database
Topic Covered: 
  1. - Introduction to DBMS
  2. - Example of Database
  3. - Characteristics of the database approach
  4. - Actors on the scene
  5. - Workers behind the scene
  6. - Advantages of DBMS Approach
  7. - Brief history of Database Applications
  8. - When not to use DBMS
  9. - Data models, schemas, instances
  10. - Three- schema architecture and data independence
  11. - Database languages and interfaces
  12. - Database System Environment
  13. - Centralized and client-server architectures
  14. - DBMS Classification
  15. - High –Level Conceptual Data Models
  16. - Database Application Example
  17. - Entity types, entity sets, attributes, and keys
  18. - Relationship types, relational sets, roles, and structural constraints
  19. - Weak entity types
  20. - Refining ER Design
  21. - ER Diagrams, Naming conventions, design issues
  22. - Relational model concepts
  23. - Relational model constraints and relational database schemas
  24. - Update operations, transactions, constraint violations
  25. - Unary relational operations 
  26. - Relational algebra operations
  27. - Binary relational operations
  28. - Additional Relational operations
  29. - Examples of queries in relational algebra
  30. - Relational database design
  31. - SQL Data Definition and Data Types
  32. - Specifying basic constraints in SQL
  33. - Schema change statements in SQL
  34. - Basic queries in SQL
  35. - More complex SQL Queries
  36. - Insert, Delete, and Update statements in SQL
  37. - Specifying constraints as Assertion and Trigger
  38. - Additional features of SQL
  39. - Database programming issues and techniques
  40. - Embedded SQL, Dynamic SQL
  41. - Database stored procedures and SQL / PSM
  42. - Informal Design Guidelines for Relation Schemas
  43. - Functional Dependencies
  44. - Normal Forms Based on Primary Keys
  45. - General Definitions of Second and Third Normal Forms
  46. - Boyce-Codd Normal Form
  47. - Properties of Relational Decompositions
  48. - Algorithms for Relational Database Schema Design
  49. - Multivalued Dependencies and Fourth Normal Form
  50. - Join Dependencies and Fifth Normal Form; Inclusion Dependencies
  51. - Other Dependencies and Normal Forms
  52. - The ACID Properties
  53. - Transactions and Schedules
  54. - Concurrent Execution of Transactions
  55. - Lock- Based Concurrency Control
  56. - Performance of locking
  57. - Transaction support in SQL
  58. - Introduction to crash recovery
  59. - 2PL, Serializability, and Recoverability
  60. - Lock Management
  61. - Introduction to ARIES
  62. - The log
  63. - Other recovery-related structures
  64. - The write-ahead log protocol
  65. - Checkpointing
  66. - Recovering from a System Crash
  67. - Media Recovery
  68. - Other approaches and interaction with concurrency control

0 Comments

No reviews yet !!

Please login first