NDSS Academy

Information Technology

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 TechnologyData Warehousing and Data MiningMobile ComputingConstitution 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 LabWeb Technology 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 · 226 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
Data Warehousing and Data Mining5 chapters · 6 Months Subject page →
01Unit 1: Data Warehousing and Multidimensional Model 6 टॉपिक
  1. Definition and components of a data warehouse
  2. Building a data warehouse and mapping to multiprocessor architecture
  3. Database system vs data warehouse
  4. Multidimensional data model and data cubes
  5. Star, snowflake and fact constellation schemas
  6. Concept hierarchy, three-tier architecture and data marts
02Unit 2: Data Warehouse Process, Technology and OLAP 4 टॉपिक
  1. Warehousing strategy and data management
  2. OLAP servers: ROLAP, MOLAP, HOLAP
  3. OLAP operations: roll-up, drill-down, slice, dice, pivot
  4. Data warehouse backup, testing and tuning
03Unit 3: Data Mining and Pre-processing 5 टॉपिक
  1. Data mining definition and functionalities
  2. Data cleaning: missing values and noisy data (binning, regression, clustering)
  3. Data integration and transformation (normalisation)
  4. Data reduction: cube aggregation, dimensionality reduction, compression, numerosity reduction
  5. Discretisation and concept hierarchy generation
04Unit 4: Classification and Association Rules 6 टॉपिक
  1. Data generalisation and attribute relevance analysis
  2. Statistical, distance-based and decision tree classification
  3. Mining class comparisons
  4. Association rules: support and confidence
  5. Apriori algorithm
  6. FP-growth
05Unit 5: Clustering and Advanced Mining 6 टॉपिक
  1. Similarity and distance measures
  2. Partitioning: K-means and K-medoids
  3. Hierarchical clustering: agglomerative, divisive, CURE, Chameleon
  4. Density based: DBSCAN, OPTICS; grid based: STING, CLIQUE
  5. Model based clustering
  6. Time series, web and spatial mining
Mobile Computing5 chapters · 6 Months Subject page →
01Unit 1: Introduction and Cellular Systems 8 टॉपिक
  1. Issues in mobile computing
  2. Wireless telephony and the cellular concept
  3. Frequency reuse and cluster size
  4. GSM air interface and channel structure
  5. Location management: HLR, VLR, hierarchical schemes
  6. Handoff
  7. Channel allocation in cellular systems
  8. CDMA and GPRS
02Unit 2: Wireless Networking 8 टॉपिक
  1. Wireless LAN overview and MAC issues
  2. IEEE 802.11
  3. Bluetooth
  4. Wireless multiple access protocols
  5. TCP over wireless
  6. Data broadcasting
  7. Mobile IP
  8. WAP architecture, protocol stack and applications
03Unit 3: Data Management in Mobile Computing 5 टॉपिक
  1. Data management issues
  2. Data replication for mobile computers
  3. Adaptive clustering for mobile wireless networks
  4. File systems for mobility (Coda)
  5. Disconnected operation: hoarding, emulation, reintegration
04Unit 4: Mobile Agents and Transactions 5 टॉपिक
  1. Mobile agent computing
  2. Security of mobile agents
  3. Fault tolerance
  4. Transaction processing in mobile environments
  5. Mobile transaction models (Kangaroo, reporting, clustering)
05Unit 5: Ad Hoc Networks 5 टॉपिक
  1. Ad hoc network characteristics and localization
  2. MAC issues in ad hoc networks
  3. Routing: GSR, DSDV, DSR, AODV, TORA
  4. QoS in ad hoc networks
  5. Applications of MANETs
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
Web Technology Lab6 chapters · 6 Months Subject page →
01HTML and CSS Pages 3 टॉपिक
  1. Home page with lists, tables, images and links
  2. Registration form
  3. External CSS and Bootstrap layout
02JavaScript and Form Validation 3 टॉपिक
  1. Form validation (name, email, password, phone)
  2. Events and DOM changes
  3. Simple calculator
03XML and AJAX 3 टॉपिक
  1. XML document for a book catalogue with DTD
  2. Displaying XML with CSS / XSLT
  3. Loading JSON / XML with AJAX
04Servlets 3 टॉपिक
  1. Setting up Tomcat
  2. Servlet reading form data with doGet and doPost
  3. Cookies and HttpSession
05JSP and JDBC 3 टॉपिक
  1. JSP with scriptlets and expressions
  2. JDBC connection to MySQL
  3. Insert, view, update and delete records
06Mini Web Application 2 टॉपिक
  1. Login and registration application with MVC
  2. Deploying the WAR file on Tomcat
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 Data Warehousing and Data Mining syllabus with regular tests
  • Complete Mobile Computing 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 Web Technology 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 Data Warehousing and Data Mining course follow?

It follows the AKTU (Dr. A.P.J. Abdul Kalam Technical University, Lucknow) B.Tech syllabus for Data Warehousing and Data Mining. 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.