Your roadmap · आपका रोडमैप
- 1
Admission & first meetingप्रवेश और पहली मुलाकातEnquire at your nearest NDSS centre, meet the teacher, fix the batch time and get your study material.
- 2
Semester 2 — subject classesसेमेस्टर 2 — विषयवार कक्षाएँEvery theory subject of the term, unit by unit, with notes, numericals and doubt classes.
Database Management System
- 3
Labs, practicals & project workलैब, प्रैक्टिकल और प्रोजेक्टExperiments / jobs / project work as in the syllabus, with practical file and viva preparation.
Database Management System Lab
- 4
Unit tests & mid-termयूनिट टेस्ट और मिड-टर्मA test after every unit and a mid-term in the university / board pattern.
- 5
Semester 2 mock testमॉक टेस्टA full mock test of all subjects before the exam, with analysis.
- 6
Semester 2 exam (university / board)सेमेस्टर / वार्षिक परीक्षाPrevious papers, important questions and full revision.
- 7
Online tests & resultऑनलाइन टेस्ट और रिज़ल्टTake the tests online; your marks and result show in your student login and at the centre.
सिलेबस · पाठ्यक्रम
2 subjects · 10 chapters · 45 topics
Database Management System5 chapters · 6 Months
Subject page →+
01Unit 1: Introduction to DBMS
5 टॉपिक+
- File system vs DBMS
- Three-level architecture and data abstraction
- Physical and logical data independence
- Database users and DBA
- DBMS architecture
02Unit 2: Data Models and ER Modelling
5 टॉपिक+
- Hierarchical, network and relational models
- Entities, attributes and relationships
- Cardinality and participation
- Weak entities, generalisation and specialisation
- ER to relational mapping
03Unit 3: Relational Model and Relational Algebra
5 टॉपिक+
- Relations, tuples and domains
- Super, candidate, primary and foreign keys
- Integrity constraints
- Selection, projection, join, set operations
- Cartesian product and division
04Unit 4: SQL
5 टॉपिक+
- DDL, DML, DCL and TCL commands
- Constraints in SQL
- Aggregate functions, GROUP BY and HAVING
- Joins and subqueries
- Views
05Unit 5: Normalisation and Transactions
5 टॉपिक+
- Functional dependencies
- 1NF, 2NF, 3NF and BCNF
- Transactions and ACID properties
- Concurrency control: locking
- Recovery basics
Database Management System Lab5 chapters · 6 Months
Subject page →+
01DDL Commands
4 टॉपिक+
- CREATE TABLE with data types
- Constraints: PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, CHECK
- ALTER, DROP and TRUNCATE
- DESCRIBE a table
02DML and Simple Queries
4 टॉपिक+
- INSERT, UPDATE and DELETE
- SELECT with WHERE, ORDER BY, DISTINCT
- LIKE, BETWEEN, IN and NULL handling
- COMMIT and ROLLBACK
03Functions, Grouping and Joins
4 टॉपिक+
- Aggregate functions
- GROUP BY and HAVING
- Inner join
- Left, right and full outer joins
04Subqueries and Views
3 टॉपिक+
- Single-row and multi-row subqueries
- Correlated subqueries
- Creating and using views
05PL/SQL Basics
5 टॉपिक+
- Structure of a PL/SQL block
- Conditions and loops
- Cursors
- Procedures and functions
- Triggers
About this course
आप यह कर पाएँगे
- Complete Database Management System syllabus with regular tests
- Complete Database Management System Lab syllabus with regular tests
यह किसके लिए है
- B.Sc Computer Science students of Semester 2 (UP State Universities NEP 2020 common minimum syllabus)
- Students preparing for BCA / MCA entrance and IT job interviews
आपको क्या चाहिए
- B.Sc Computer Science Semester 1
- Basic computer operation
Online tests & result
Practice and unit tests online; marks and result show in your student login and at the centre.
Student login →
सवाल
Which syllabus does this course follow?
It follows the UP State Universities NEP 2020 common minimum syllabus for B.Sc Computer Science, Semester 2. Where your own university's syllabus differs, the centre follows your university's syllabus and question pattern.
Which database software is used?
MySQL or Oracle (as per your university); SQL practised in the Database Management System Lab of the same semester.
Is there a test after the course?
Yes. Unit-wise multiple-choice tests and a final exam paper are included for semester exam practice.
Is MySQL or Oracle taught?
Both are similar for SQL. The centre uses the one your university practical exam uses.
How are the practicals marked?
The trainer watches each experiment and marks it on a rubric; the viva questions here prepare you for the university practical exam.
