DBMS (DataBase Management System)
Learn DBMS
DBMS again is very important subject of computer science courses and is well asked in various placement exams both in the online tests as MCQ’s and also in Interviews for various companies. Most Data Science companies have DBMS as requirement for you to learn.
ER Models
- ER Data Model Basics concepts. (Attributes, relationships, Entities)
- Entity-Relationship model
- Entity-Relationship Model Advanced
- Cardinality
- Relationships
- Participation Constraint
- Weak Entity and Strong Entity
- ER diagram representation.
- Generalization Specialization and Aggregation
Relational Database Model
- Codd’s Rule
- RDBMS
- Relational Data Model
- Keys in the Relational Model
- Keys in DBMS
- Primary Key in DBMS | Oracle | SQL
- Foreign Key in DBMS | Oracle | SQL
- Candidate Key in DBMS | Oracle | SQL
- Super Key in DBMS | Oracle | SQL
- Alternate Key in DBMS | Oracle | SQL
- Composite Key in DBMS | Oracle | SQL
- Non-Prime Attribute
- SQL Constraints
- Default in DBMS | Oracle | SQL
- Not Null in DBMS | Oracle | SQL
- Unique in DBMS | Oracle | SQL
- Check-in DBMS | Oracle | SQL
- Key Constraints in DBMS | Oracle | SQL
- Domain constraints in DBMS | Oracle | SQL
- Mapping constraints
- ER to Relational Model Conversion
Algebra and Dependencies
Normalisation
- Introduction Normalisation
- Normal Forms
- Joins in DBMS | SQL
- Dependency Preserving Decomposition
- Lossless Join Decomposition
- Lossless Join and Dependency Preserving Decomposition
Transaction Control and B Trees
- Transactions and Concurrency Control :
- Introduction(including transaction concurrency and Deadlock)
- ACID Properties in DBMS | Oracle | SQL
- Concurrency Control Protocols – Lock-Based Protocol
- Conflict Serializability
- View Serializability
- Recoverability of Schedules
- Indexing, B and B+ trees :
- 1.Indexing and its Types
- B-Tree Introduction
- B-Tree Insert
- B-Tree Delete
Important SQL Queries
- SQL
- Predicate in DBMS | Oracle | Pl/SQL
- SQL -Operators in DBMS | Oracle | Pl/SQL
- SQL- Expressions in DBMS | Oracle | Pl/SQL
- CREATE Table in DBMS | Oracle | Pl/SQL
- DROP/TRUNCATE/RENAME table in DBMS | Oracle | Pl/SQL
- Tuple/Record/Row in DBMS | Oracle | Pl/SQL
- Queries:-
- SELECT in DBMS | Oracle | SQL
- INSERT in DBMS | Oracle | SQL
- WHERE in DBMS | Oracle | SQL
- AND & OR in DBMS | Oracle | SQL
- UPDATE in DBMS | Oracle | SQL
- DELETE in DBMS | Oracle | SQL
- LIKE in DBMS | Oracle | SQL
- ORDER BY in DBMS | Oracle | SQL
- GROUP BY in DBMS | Oracle | SQL
- DISTINCT in DBMS | Oracle | SQL
- ADVANCED SQL
- NULL in DBMS | Oracle | SQL
- USING VIEWS in DBMS | Oracle | SQL
- HANDLING DUPLICATES in DBMS | Oracle | SQL
- INJECTION in DBMS | Oracle | SQL
————————————————————
added by trishaank
- SQL Alter in DBMS
- Drop/Truncate/Rename in DBMS
- SQL aggregate functions in DBMS
SQL SET OPERATIONS IN DBMS
- UNION-UNION ALL
- INTERSECT
- MINUS
Please Login/Signup to comment