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.
DDL CommandsDML and Simple QueriesFunctions, Grouping and JoinsSubqueries and ViewsPL/SQL Basics
- 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.
सिलेबस · पाठ्यक्रम
1 subject · 5 chapters · 20 topics
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
आप यह कर पाएँगे
- Create, alter and drop tables with primary key, foreign key, unique, not null and check constraints
- Insert, update and delete records and write SELECT queries with conditions and sorting
- Use aggregate functions, GROUP BY, HAVING and joins
- Write subqueries and create views
- Write simple PL/SQL blocks, procedures and triggers
यह किसके लिए है
- B.Sc Computer Science students of Semester 2 (UP State Universities NEP 2020 common minimum syllabus)
- Students preparing for the university practical exam and viva
आपको क्या चाहिए
- Studying the theory paper Database Management System
- MySQL or Oracle installed (the centre's lab can be used)
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.
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.
