NDSS Academy

Computer Science & Engineering

B-Tech · Semester 5

6 महीनेअवधि 9Subjects 47Chapters ऑनलाइनTests & result
अभी पूछताछ करें Nearest centre Syllabus PDF

Your roadmap · आपका रोडमैप

  1. 1
    Admission & first meetingप्रवेश और पहली मुलाकात

    Enquire at your nearest NDSS centre, meet the teacher, fix the batch time and get your study material.

  2. 2
    Semester 5 — subject classesसेमेस्टर 5 — विषयवार कक्षाएँ

    Every theory subject of the term, unit by unit, with notes, numericals and doubt classes.

    Database Management SystemDesign and Analysis of AlgorithmWeb TechnologyStatistical ComputingMachine Learning TechniquesConstitution of India, Law and Engineering
  3. 3
    Labs, practicals & project workलैब, प्रैक्टिकल और प्रोजेक्ट

    Experiments / jobs / project work as in the syllabus, with practical file and viva preparation.

    Database Management System LabDesign and Analysis of Algorithm LabMini Project or Internship Assessment-II
  4. 4
    Unit tests & mid-termयूनिट टेस्ट और मिड-टर्म

    A test after every unit and a mid-term in the university / board pattern.

  5. 5
    Semester 5 mock testमॉक टेस्ट

    A full mock test of all subjects before the exam, with analysis.

  6. 6
    Semester 5 exam (university / board)सेमेस्टर / वार्षिक परीक्षा

    Previous papers, important questions and full revision.

  7. 7
    Online tests & resultऑनलाइन टेस्ट और रिज़ल्ट

    Take the tests online; your marks and result show in your student login and at the centre.

सिलेबस · पाठ्यक्रम

9 subjects · 47 chapters · 230 topics

Database Management System5 chapters · 6 Months Subject page →
01Unit 1: Introduction and ER Model 6 टॉपिक
  1. Database system vs file system
  2. DBMS architecture, data models, schema and instances
  3. Data independence, DDL and DML
  4. ER model: entities, attributes, relationships, mapping constraints
  5. Keys: super, candidate, primary
  6. Generalisation, aggregation and reduction of ER diagrams to tables
02Unit 2: Relational Model, Relational Algebra and SQL 6 टॉपिक
  1. Relational model and integrity constraints (entity, referential, domain, key)
  2. Relational algebra
  3. Tuple and domain relational calculus
  4. SQL: DDL, DML, operators, sub-queries and aggregate functions
  5. Joins, union, intersect, minus, views and indexes
  6. Cursors, triggers and procedures in PL/SQL
03Unit 3: Database Design and Normalisation 6 टॉपिक
  1. Functional dependencies and closure
  2. 1NF, 2NF, 3NF and BCNF
  3. Lossless join and dependency preserving decomposition
  4. Multivalued dependencies and 4NF
  5. Join dependencies and 5NF
  6. Alternative approaches to database design
04Unit 4: Transaction Processing and Recovery 6 टॉपिक
  1. Transaction concept and ACID properties
  2. Schedules: conflict and view serializability, precedence graph
  3. Recoverable and cascadeless schedules
  4. Log-based recovery and checkpoints
  5. Deadlock handling
  6. Distributed databases: data storage, concurrency control
05Unit 5: Concurrency Control 6 टॉपिक
  1. Lock-based protocols and two-phase locking
  2. Timestamp ordering protocol
  3. Validation based protocol
  4. Multiple granularity locking
  5. Multiversion schemes and recovery with concurrent transactions
  6. Case study of Oracle
Design and Analysis of Algorithm5 chapters · 6 Months Subject page →
01Unit 1: Introduction, Sorting and Recurrences 5 टॉपिक
  1. Algorithms, analysis and growth of functions
  2. Shell sort, quick sort, merge sort and heap sort
  3. Comparison of sorting algorithms
  4. Sorting in linear time: counting, radix, bucket sort
  5. Recurrences: substitution, recursion tree and master method
02Unit 2: Advanced Data Structures 5 टॉपिक
  1. Red-black trees
  2. B-trees
  3. Binomial heaps
  4. Fibonacci heaps
  5. Tries and skip lists
03Unit 3: Divide and Conquer and Greedy Methods 4 टॉपिक
  1. Divide and conquer: sorting, searching, Strassen's matrix multiplication, convex hull
  2. Greedy method: fractional knapsack, optimal reliability allocation
  3. Minimum spanning trees: Prim's and Kruskal's
  4. Single-source shortest paths: Dijkstra's and Bellman-Ford
04Unit 4: Dynamic Programming, Backtracking and Branch and Bound 5 टॉपिक
  1. Dynamic programming: 0/1 knapsack, LCS, matrix chain multiplication
  2. All-pairs shortest paths: Warshall's and Floyd's
  3. Resource allocation problem
  4. Backtracking: n-queens, graph colouring, Hamiltonian cycle, sum of subsets
  5. Branch and bound: travelling salesman problem
05Unit 5: Selected Topics 5 टॉपिक
  1. Algebraic computation and fast Fourier transform
  2. String matching: naive, Rabin-Karp, KMP
  3. P, NP, NP-hard and NP-complete problems
  4. Approximation algorithms
  5. Randomised algorithms
Web Technology5 chapters · 6 Months Subject page →
01Unit 1: Introduction to Web and HTML 6 टॉपिक
  1. History of the web and internet, web development strategies
  2. Protocols: HTTP, HTTPS, FTP, DNS
  3. Web browsers and web servers
  4. HTML document structure, elements and attributes
  5. Lists, tables, images, links, forms and frames
  6. HTML5 semantic elements
02Unit 2: CSS, Bootstrap and XML 6 टॉपिक
  1. CSS syntax, selectors, specificity and box model
  2. CSS positioning, Flexbox and responsive design
  3. Bootstrap grid and components
  4. XML syntax and well-formed documents
  5. DTD and XML Schema
  6. XSLT and XML parsers (DOM, SAX)
03Unit 3: JavaScript, DOM and AJAX 5 टॉपिक
  1. JavaScript basics: variables, operators, functions
  2. Objects, arrays and events
  3. DOM manipulation और form validation
  4. JSON
  5. AJAX with XMLHttpRequest and fetch
04Unit 4: Servlets and Database Connectivity 5 टॉपिक
  1. Servlet architecture and life cycle
  2. Handling GET and POST requests
  3. Request dispatching and redirects
  4. Cookies and session tracking
  5. JDBC drivers, Connection, Statement and PreparedStatement
05Unit 5: JSP and Web Application Development 6 टॉपिक
  1. JSP architecture and life cycle
  2. JSP elements: directives, scriptlets, expressions, declarations
  3. Implicit objects and JavaBeans
  4. JSTL and expression language
  5. MVC architecture with Servlet and JSP
  6. Deploying a web application on Tomcat
Statistical Computing5 chapters · 6 Months Subject page →
01Unit 1: Descriptive Statistics 5 टॉपिक
  1. Types of data and scales of measurement
  2. Frequency distributions and graphs
  3. Mean, median and mode
  4. Range, variance and standard deviation
  5. Skewness and kurtosis
02Unit 2: Probability and Distributions 5 टॉपिक
  1. Probability, conditional probability and Bayes' theorem
  2. Random variables, expectation and variance
  3. Binomial and Poisson distributions
  4. Normal distribution
  5. Sampling distributions and central limit theorem
03Unit 3: Statistical Inference 5 टॉपिक
  1. Point and interval estimation
  2. Hypothesis testing, type I and type II errors
  3. z-test and t-test
  4. Chi-square test
  5. F-test and one-way ANOVA
04Unit 4: Correlation and Regression 6 टॉपिक
  1. Scatter diagram and Karl Pearson's correlation
  2. Spearman's rank correlation
  3. Simple linear regression by least squares
  4. Multiple linear regression
  5. Coefficient of determination and residual analysis
  6. Introduction to logistic regression
05Unit 5: Statistical Computing with R and Python 5 टॉपिक
  1. R basics: vectors, data frames, functions
  2. Python: NumPy, pandas, SciPy and statsmodels
  3. Data import, cleaning and visualisation (ggplot2, matplotlib)
  4. Random number generation and simulation
  5. Monte Carlo methods and bootstrap
Machine Learning Techniques5 chapters · 6 Months Subject page →
01Unit 1: Introduction to Machine Learning 6 टॉपिक
  1. Learning and types of learning
  2. Well-defined learning problems and designing a learning system
  3. History of machine learning
  4. Overview of ML approaches: ANN, clustering, RL, decision trees, Bayesian networks, SVM, GA
  5. Issues in machine learning; data science vs machine learning
  6. Overfitting, underfitting and bias-variance
02Unit 2: Regression, Bayesian Learning and SVM 6 टॉपिक
  1. Linear regression
  2. Logistic regression
  3. Bayes theorem, concept learning and Bayes optimal classifier
  4. Naive Bayes and Bayesian belief networks
  5. EM algorithm
  6. SVM: hyperplane, margin, kernels (linear, polynomial, Gaussian)
03Unit 3: Decision Trees and Instance-based Learning 6 टॉपिक
  1. Decision tree learning and inductive bias
  2. Entropy and information gain, ID3
  3. Issues in decision trees: overfitting, pruning
  4. k-nearest neighbour learning
  5. Locally weighted regression and radial basis function networks
  6. Case-based learning
04Unit 4: Artificial Neural Networks and Deep Learning 6 टॉपिक
  1. Perceptron and multilayer perceptron
  2. Gradient descent and delta rule
  3. Back-propagation
  4. Self-organising maps
  5. Deep learning and CNN: convolution, activation, pooling, fully connected layers
  6. Applications of CNN
05Unit 5: Reinforcement Learning and Genetic Algorithms 6 टॉपिक
  1. Reinforcement learning task and examples
  2. Markov decision process
  3. Q-learning function and algorithm
  4. Genetic algorithm components and cycle
  5. Selection, crossover and mutation
  6. Genetic programming and applications
Constitution of India, Law and Engineering5 chapters · 6 Months Subject page →
01Unit 1: Constitution of India - Making, Preamble and Salient Features 6 टॉपिक
  1. Constituent Assembly and making of the Constitution
  2. Preamble and its key words
  3. Salient features of the Constitution
  4. Fundamental rights (Articles 12 - 35)
  5. Directive principles of state policy
  6. Fundamental duties (Article 51A)
02Unit 2: Union and State Executive, Legislature and Judiciary 5 टॉपिक
  1. President, Prime Minister and Council of Ministers
  2. Parliament: Lok Sabha and Rajya Sabha, law making and money bills
  3. Governor, Chief Minister and State legislature
  4. Supreme Court and High Courts, writs and judicial review
  5. Local self-government and the Election Commission
03Unit 3: Indian Legal System and Engineering Contracts 5 टॉपिक
  1. Sources of law and hierarchy of courts
  2. Civil and criminal law basics
  3. Indian Contract Act 1872: essentials of a valid contract
  4. Engineering contracts, tenders and arbitration
  5. Law of torts and professional negligence
04Unit 4: Intellectual Property Laws and Right to Information 5 टॉपिक
  1. Patents: patentability and term
  2. Copyright and software protection
  3. Trademarks, designs and geographical indications
  4. Right to Information Act 2005
  5. Consumer protection basics
05Unit 5: Business Organisations, Labour Laws and E-Governance 5 टॉपिक
  1. Sole proprietorship, partnership, LLP and companies
  2. Companies Act 2013 basics
  3. Labour laws and labour codes: wages, safety and social security
  4. Information Technology Act and e-governance
  5. Digital India services
Database Management System Lab6 chapters · 6 Months Subject page →
01DDL and Constraints 3 टॉपिक
  1. CREATE, ALTER, DROP, TRUNCATE and RENAME
  2. Primary key, foreign key, unique, not null, check and default
  3. Creating a student-course database
02DML and Queries 4 टॉपिक
  1. INSERT, UPDATE and DELETE
  2. SELECT with WHERE, BETWEEN, IN, LIKE and ORDER BY
  3. Aggregate functions with GROUP BY and HAVING
  4. COMMIT, ROLLBACK and SAVEPOINT
03Joins, Sub-queries and Views 5 टॉपिक
  1. Inner, left, right and full outer joins
  2. Self join
  3. Nested and correlated sub-queries
  4. UNION, INTERSECT and MINUS
  5. Creating and using views and indexes
04PL-SQL: Procedures, Functions and Cursors 5 टॉपिक
  1. PL-SQL block structure and variables
  2. Conditional and loop statements
  3. Stored procedures and functions
  4. Explicit cursors and cursor attributes
  5. Exception handling
05Triggers 3 टॉपिक
  1. Row-level and statement-level triggers
  2. BEFORE and AFTER triggers
  3. Audit trigger for salary updates
06Database Design Mini Project 4 टॉपिक
  1. ER diagram for a library / hospital / college system
  2. Reducing ER to tables
  3. Normalising to 3NF
  4. Writing queries for reports
Design and Analysis of Algorithm Lab6 chapters · 6 Months Subject page →
01Sorting and Searching 4 टॉपिक
  1. Insertion, selection and heap sort
  2. Counting sort
  3. Linear and binary search
  4. Measuring running time for n = 1000 to 10000
02Divide and Conquer 4 टॉपिक
  1. Merge sort
  2. Quick sort with randomised pivot
  3. Finding maximum and minimum
  4. Strassen's matrix multiplication
03Greedy Algorithms 4 टॉपिक
  1. Fractional knapsack
  2. Activity selection
  3. Prim's minimum spanning tree
  4. Kruskal's minimum spanning tree with union-find
04Dynamic Programming 4 टॉपिक
  1. 0/1 knapsack
  2. Longest common subsequence
  3. Matrix chain multiplication
  4. Floyd-Warshall all-pairs shortest paths
05Backtracking 3 टॉपिक
  1. N-queens problem
  2. Sum of subsets
  3. Graph colouring
06Graph Algorithms 4 टॉपिक
  1. BFS and DFS
  2. Dijkstra's shortest path
  3. Bellman-Ford algorithm
  4. Topological sort
Mini Project or Internship Assessment-II5 chapters · 6 Months Subject page →
01Topic or Internship Selection 3 टॉपिक
  1. Identifying an interest area and a guide / industry mentor
  2. Choosing a feasible mini project topic or internship organisation
  3. Getting departmental approval
02Synopsis and Planning 4 टॉपिक
  1. Problem statement and objectives
  2. Literature / product survey
  3. Methodology, tools and resources
  4. Timeline (Gantt chart) and expected outcomes
03Execution of Work / Training 4 टॉपिक
  1. Carrying out design, coding, fabrication, survey or site work
  2. Daily diary / log book
  3. Weekly review with guide or mentor
  4. Testing, observations and results
04Report Writing 4 टॉपिक
  1. Report format as per university guidelines
  2. Certificate, acknowledgement, abstract and contents
  3. Chapters: introduction, work done, results, conclusion
  4. References and plagiarism check
05Presentation and Viva 4 टॉपिक
  1. Preparing a 10 - 15 minute presentation
  2. Demonstration of model / software / photographs
  3. Answering viva questions
  4. Final assessment by the departmental committee

About this course

आप यह कर पाएँगे

  • Complete Database Management System syllabus with regular tests
  • Complete Design and Analysis of Algorithm syllabus with regular tests
  • Complete Web Technology syllabus with regular tests
  • Complete Statistical Computing syllabus with regular tests
  • Complete Machine Learning Techniques syllabus with regular tests
  • Complete Constitution of India, Law and Engineering syllabus with regular tests
  • Complete Database Management System Lab syllabus with regular tests
  • Complete Design and Analysis of Algorithm Lab syllabus with regular tests

यह किसके लिए है

  • B.Tech Computer Science & Engineering, Information Technology students of Semester 5 (AKTU)
  • Students of other universities studying the same subject who want unit-wise coaching

आपको क्या चाहिए

  • Data Structure and Discrete Structures (Semester 3)
  • Basic programming knowledge
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 the Database Management System course follow?

It follows the AKTU (Dr. A.P.J. Abdul Kalam Technical University, Lucknow) B.Tech syllabus for Database Management System. If your own university's syllabus differs, the centre follows your university syllabus.

Will this help in the university examination?

Yes. Teaching is unit-wise as per the AKTU scheme, with previous-year question practice, MCQ tests and doubt sessions before the semester exam.

Is SQL practice included?

Yes. SQL queries are practised on MySQL / Oracle along with the theory, which also prepares you for the DBMS lab and placement tests.

Which syllabus does the Design and Analysis of Algorithm course follow?

It follows the AKTU (Dr. A.P.J. Abdul Kalam Technical University, Lucknow) B.Tech syllabus for Design and Analysis of Algorithm. If your own university's syllabus differs, the centre follows your university syllabus.

Are algorithms traced step by step?

Yes. Every algorithm is traced on an example (tables, trees, graphs) the way AKTU asks it in the exam, along with its complexity.

Which syllabus does the Web Technology course follow?

It follows the AKTU (Dr. A.P.J. Abdul Kalam Technical University, Lucknow) B.Tech syllabus for Web Technology. If your own university's syllabus differs, the centre follows your university syllabus.

Will I be able to make a website after this course?

Yes. Along with the theory each unit includes small hands-on examples, ending with a complete Servlet-JSP-database application.

Which syllabus does the Statistical Computing course follow?

It follows the AKTU (Dr. A.P.J. Abdul Kalam Technical University, Lucknow) B.Tech syllabus for Statistical Computing. If your own university's syllabus differs, the centre follows your university syllabus.

Download the syllabus (PDF)

Tell us who you are — your copy is made with your name, and our counsellor can help you choose the right course and centre.

Want to join right away? अभी पूछताछ करें — our centre will call you.