Tutorialink
  • Tutorials
    • C Language
    • CPP
    • Data Structure
    • JAVA
    • PHP
    • DBMS
    • JavaScript
  • Questions
    • Python Questions
    • JavaScript Questions
    • Java Questions
    • PHP Questions
    • SQL Questions
  • About Us
  • Contact Us
  • Login / Sign up
    • Login
    • Sign-up

DBMS

  1. Home
  2. DBMS


DBMS
"Database Management System"

Introduction to DBMS
  • Introduction to DBMS
  • Definitions related to dbms
  • DA and DBA
  • Functions and responsibilities of DBAs
  • Advantage and Disadvantages of File-oriented system
  • Advantage and Disadvantages of DBMS
Database System Architecture
  • DBMS Architecture
  • Three-level ANSI SPARC Database Architecture
  • Data Independence
  • Mappings
  • Structure Components and Functions of DBMS
  • Data Models
Introduction to SQL
  • Data types
  • Database language
  • Operators
Advanced SQL
  • Transactional Control
  • DCL Commands
  • Synonym
  • Types of locks
  • Sequences
  • Index
  • Views
PL / SQL and Triggers
  • Basics of PL/SQL
  • Datatypes and Advantages of PL/SQL
  • Control Structures
  • Exceptions
  • Cursors
  • Procedures and Functions
  • Packages
  • Triggers
Functional Dependency and Decomposition
  • Basics of Functional Dependency
  • Functional Dependency Diagram and Examples
  • Full functional dependency(FFD)
  • Redundant functional dependencies
  • Closures of a set of functional dependencies
  • Decomposition
  • Dependency-Preserving Decomposition
Normalization
  • Basics of Normalization
  • Normal Forms
Transaction Processing
  • Introduction to transaction concepts
  • Concurrency control
  • Methods for Concurrency control

 

 

contact info

Email : contact@tutorialink.com

Web : tutorialink.com

Tutorialink

  • About Us
  • Contact Us
  • Terms & Conditions

Job Partner

  • Jooble

Questions

  • Python Questions
  • JavaScript Questions
  • Java Questions
  • PHP Questions
  • SQL Questions

Brilliantly

SAFE!

tutorialink.com

Content & Links

Verified by Sur.ly

2022

© Tutorialink.com - 2025