Programming
Aptitude
Syllabus
Interview Preparation
Interview Exp.
Off Campus
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 Advanced
- Cardinality
- Relationships
- Relationship – Cardinality
- Participation Constraint
- Weak Entity and Strong Entity
- 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
Relational Calculus
To learn better you have to start somewhere so following are the basics of DBMS that will help you clear your concepts about what DBMS comprises of.
Relational Algebra
This topic is of prime importance in DBMS since it is a little tricky to grasp. These questions are often found in the semester exams and technical rounds of various companies.
Functional Dependencies
To learn better you have to start somewhere so following are the basics of DBMS that will help you clear your concepts about what DBMS comprises of.
Transaction Control and B Trees
- Transactions and Concurrency Control :
- Indexing, B and B+ trees :
SQL
To learn better you have to start somewhere so following are the basics of DBMS that will help you clear your concepts about what DBMS comprises of.
- 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
- ALTER table in DBMS | Oracle | Pl/SQL
- DROP/TRUNCATE/RENAME table in DBMS | Oracle | Pl/SQL
- Tuple/Record in DBMS | Oracle | Pl/SQL
Queries
To learn better you have to start somewhere so following are the basics of DBMS that will help you clear your concepts about what DBMS comprises of.
- 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
- ROW in DBMS | Oracle | SQL
- TRUNCATE in DBMS | Oracle | SQL
- RENAME in DBMS | Oracle | SQL
- DROP in DBMS | Oracle | SQL
SQL Set Operations and Advanced SQL
To learn better you have to start somewhere so following are the basics of DBMS that will help you clear your concepts about what DBMS comprises of.
- SQL SET OPERATIONS IN DBMS
- ADVANCED SQL
- NULL in DBMS | Oracle | SQL
- USING VIEWS in DBMS | Oracle | SQL
- INJECTION in DBMS | Oracle | SQL
- HANDLING DUPLICATES in DBMS | Oracle | SQL
Login/Signup to comment
Really very good site seen so far ……Very helpful material thank u Prepinsta
I need to say this,Prepinsta is the best site on internet if you are looking for technical content which is trustworthy and without any misleading and confusing stuff.
Thankyou for the support and keep loving it.