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
Part 1 of the syllabusपाठ्यक्रम भाग 1Unit-wise coaching with notes and doubt classes.
Unit 1: Introduction and ER ModelUnit 2: Relational Model and Relational AlgebraUnit 3: SQL
- 3
Part 2 of the syllabusपाठ्यक्रम भाग 2Unit-wise coaching with notes and doubt classes.
Unit 4: Functional Dependencies and NormalisationUnit 5: Transactions and Concurrency Control
- 4
Unit tests & assignmentsयूनिट टेस्टRegular tests in the university / board pattern.
- 5
Semester 4 exam (university / board)विश्वविद्यालय / बोर्ड परीक्षाPrevious papers and full revision before the exam.
- 6
Online tests & resultऑनलाइन टेस्ट और रिज़ल्टTake the tests online; your marks and result show in your student login and at the centre.
Syllabus · पाठ्यक्रम
1 subject · 5 chapters · 27 topics
01Unit 1: Introduction and ER Model
6 topics+
- Database system vs file system
- Data models, schema and instance
- Three-schema architecture and data independence
- DBA and database users
- ER model: entities, attributes, relationships and keys
- ER diagrams and their conversion to tables
02Unit 2: Relational Model and Relational Algebra
5 topics+
- Relations, tuples and attributes
- Keys: super, candidate, primary and foreign
- Integrity constraints
- Relational algebra: select, project, union, difference, Cartesian product, join
- Introduction to relational calculus
03Unit 3: SQL
6 topics+
- DDL commands: CREATE, ALTER, DROP
- DML commands: INSERT, UPDATE, DELETE, SELECT
- Constraints
- Aggregate functions, GROUP BY and HAVING
- Joins and subqueries
- Views
04Unit 4: Functional Dependencies and Normalisation
5 topics+
- Functional dependencies and closure
- Anomalies in un-normalised tables
- First, second and third normal forms
- Boyce-Codd normal form
- Lossless decomposition
05Unit 5: Transactions and Concurrency Control
5 topics+
- Transaction concept and ACID properties
- Schedules and serializability
- Lock-based protocols and two-phase locking
- Deadlock basics
- Recovery: log-based recovery, COMMIT and ROLLBACK
About this course
You will be able to
- Explain database concepts, architecture and data independence
- Draw ER diagrams and convert them into relational tables with keys
- Write relational algebra expressions and SQL queries including joins and aggregates
- Normalise relations up to BCNF using functional dependencies
- Explain transactions, ACID properties, concurrency control and recovery basics
Who it is for
- B.Tech second-year students (Semester 4) of Electrical and Electronics & Communication Engineering taking this science-based open elective under AKTU
- Non-CS students who want database and SQL basics for jobs and projects
What you need
- Basic computer knowledge
- Access to MySQL / SQLite / any SQL tool for practice (recommended)
Online tests & result
Practice and unit tests online; marks and result show in your student login and at the centre.
Student login →
Questions
Which syllabus is followed?
The current AKTU (Dr. A.P.J. Abdul Kalam Technical University, Lucknow) B.Tech syllabus of Basics of Data Base Management System (Semester 4 open elective). If your university or college follows a different syllabus, the centre teaches from your own university syllabus.
Is SQL practised on a computer?
Yes. SQL queries are practised on MySQL or SQLite along with theory preparation.
Is it difficult for electrical / electronics students?
No. It starts from basic concepts with simple examples such as student and employee tables.
