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
Work planकार्य योजनाStep by step with your guide / trainer.
SQL Basics and DDLDML and ConstraintsQueries and FunctionsJoins, Subqueries and ViewsDatabase Design Mini Exercise
- 3
File, report & vivaफ़ाइल, रिपोर्ट और वाइवाPractical file / report checked, mock viva before the final one.
- 4
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 · 19 topics
01SQL Basics and DDL
3 topics+
- Installing MySQL and using the command line client
- Data types
- CREATE, ALTER, DROP, TRUNCATE and RENAME table
02DML and Constraints
3 topics+
- INSERT, UPDATE and DELETE
- Primary key, foreign key, unique, not null, check and default constraints
- COMMIT, ROLLBACK and SAVEPOINT
03Queries and Functions
5 topics+
- SELECT with WHERE, BETWEEN, IN, LIKE
- ORDER BY
- Aggregate functions - COUNT, SUM, AVG, MIN, MAX
- GROUP BY and HAVING
- String, numeric and date functions
04Joins, Subqueries and Views
4 topics+
- Inner join, left and right outer join, self join
- Nested subqueries with IN and EXISTS
- Creating and using views
- Set operations - UNION
05Database Design Mini Exercise
4 topics+
- Drawing an ER diagram for a library or student database
- Converting the ER diagram to tables
- Normalisation up to 3NF
- Users, GRANT and REVOKE
About this course
You will be able to
- Create, alter and drop tables using SQL DDL commands with proper data types
- Insert, update, delete and retrieve records using SQL DML commands
- Apply primary key, foreign key, unique, not null and check constraints
- Write queries using WHERE, ORDER BY, GROUP BY, HAVING and aggregate functions
- Write join queries, subqueries and create views
- Design a small database from an ER diagram and normalise its tables
Who it is for
- Diploma Computer Science & Engineering students of Semester 3 (BTEUP)
- Diploma IT students preparing for the DBMS practical exam
What you need
- Basic computer operation and the theory of DBMS (taught in the same semester)
- MySQL or Oracle installed on the lab computer
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 BTEUP Diploma CSE Semester 3 DBMS Lab list. Where your college lab list differs, the centre follows your own syllabus.
MySQL or Oracle?
Practice is done on MySQL; the SQL is standard, and Oracle differences are pointed out where your college uses Oracle.
Is viva preparation included?
Yes. Viva questions on SQL commands, keys and normalisation are practised with every experiment.
