Online Free Education in India - vrakshacademy: Index

Model Papers
Sno	Subjects
1	Programming & Problem Solving / Basic Computer Engineering (BCE)-I
1	Basic Computer Engineering (BCE)-II
2	Theory Of Computation (TOC)
4	Topic..

Tutorials
Sno	Subjects
1	Software Engineering (SE)
2	Analysis Design of Algorithm (ADA)
4	Basic Computer Engineering
5	Database Management System
6	Data Structure

Lab Assignment
Sno	Subjects
1	Software Engineering (SE)
2	Analysis Design of Algorithm (ADA)
3	Data Structure (DS)
4	Block Chain Technologies
5	Image Processing
6	Image Processing & Computer Vision
7	DBMS

MODEL PAPERS
C-Programming \| Programming and Problem Solving
Sno	TOPICS
1	MODEL PAPER 1
2	MODEL PAPER 2
3	MODEL PAPER 3
4	MODEL PAPER 4
5	Topic..

INDEX
Database Management System
Sno	TOPICS
1	Important terms regarding DBMS About Primary Key About Super Key About Candidate Key Schema Data In-dependency Codd's 12 Rules in DBMS
2	Data Models
3	System Architecture of DBMS
4	ER-Diagram
5	Aggregation, Specilization & Generalization
6	Topic..

SYLLABUS
Sno	University
1	LNCT University Btech CSE I Semester - Syllabus
2	LNCT University Btech CSE II Semester - Syllabus
3	LNCT University Btech CSE III Semester - Syllabus
4	LNCT University Btech CSE IV Semester - Syllabus
5	LNCT University Btech CSE V Semester - Syllabus
6	LNCT University Btech CSE VI Semester - Syllabus
7	LNCT University Btech CSE VII Semester - Syllabus
8	LNCT University Btech CSE/AIML VIII Semester - Syllabus

INDEX
MCQs For Primary Classes
SNO	TOPICS
1	Moral Science Class-5
2	Moral Science Class-1
3	Computer Class-5
4	Computer Class-1
5	GK Class-1
6	GK Class-5
7	EVS Class-1
8	Hindi Class-5
9	Hindi Class-1
10	English Class-5
11	English Class-5
12	English Class-5
13	English Grammar Class-1
14	English Litrature Class-1
15	Social Studies Class-5
16	Keep Smilling

INDEX
Programming in C++
SNO	TOPICS
1	Properties of OOPs
2	Calling Method Definition and Implementation Concept
3	Data Abstraction Concept and implementation
4	Data Encapsulation Concept and implementation
5	Inline Function Concept and implementation
6	Constructor & Destructor
7	Function Overloading and Operator Overloading
8	Operator Overloading
9	Type Conversion in C++
10	Inheritance
11	New Topic ..

INDEX
C Language
SNO	TOPICS
1	C Programming -Introduction
2	How to draw Flowchart ?
3	C Programming Basic
4	Data Type in C Language
5	Constants in C Language
6	Variables in C Language
7	What is the Structure of Program in C ?
8	Know about Library Function in C
9	How many operators in C ? Bitwise Operators in C
10	Creating and Compiling Process in C
11	How to use Decision Control Statements, Break, Continue, Exit, Goto in C ?
12	Know about Loop Control Structure in C
13	Know about Function in C
14	Array in C
15	Structure in C
16	Know about Pointers in C
17	Pointers and Functions in C
18	Pointers and Arrays in C
19	Pointers to Pointers in C
20	Command Line Arguments in C
21	Dynamic Memory Allocation
22	File Handling in C
23	C Programs with Output - Practice Questions for Beginners

INDEX
Computer System Organization
SNO	TOPICS
1	Number Systems and their Conversions
2	Logic Gates
3	Karnaugh's Map (K-Map)
4	Introduction of Computer Organization
5	Addressing Modes
6	Common Bus System Concept
7	Control Unit

SNO	TOPICS
INDEX
SQL CONCEPT
#	SQL Using Oracle
1	What is SQL ?
2	How to write Select Statement in SQL ?
3	How to use Concatenation Operator in SQL ?
4	How to use Where Clause in SQL ?
5	How to use Comparision Conditions in SQL ?
6	How to use Logical Condition in SQL ?
7	Create tables named Employee. Department, Salary, Implement all DDL commands on it.
8	On the Employee Table use the many faces of SELECT command.
9	On a table perform WHERE CLAUSE, HAVING, GROUP BY, ORDER BY, IN, NOT IN, BETWEEN.
10	Create a database implementing Primary and Foreign Key.
11	Implement I/O Constraints and Business Rule constraints on the database created above.
12	Perform Nested Queries on table STUDENT.
13	Perform different types of JOINS on any two tables.
14	Create VIEWS, SEQUENCES and SYNONYMS on a table.
15	Use of SAVEPOINT, ROLLBACK and COMMIT command.
16	Find the DepartNo and Department name for each employee.
17	Display the Name , Location , Department , of Employees whose salary > 1500.
18	Show all employee in details.
19	Show the List showing employees with their Annual Salary , Grade , DepartNo and DepartName.
20	Show Employee Details of Grade 1.
21	Show Employee Details whose salary >15000 and who are clerk.
22	Find employee name, Depart No, Depart Name.
23	Display the depatment who has no employee.
24	Find Average Salary for each Job.
25	Find all Departments that have more than 2 employees.
26	Find the employee having maximum salary in each Department.
27	Find Average salary of employee working in each Departments.
28	Find the employee name who earn Min salary.
29	Find the employee name who earn lowest salary in each department.
30	Find highest salary for each job.
31	Find the most recently hired employee in each department.
32	Which department has the highest remuneration bill.
33	Find second highest salary of employee.
34	Display EmpName like 'Amit' and Salary like '5000'
35	Find the Length of each Employee name
36	Create an employee table having followint attributes (Empno number type, EmpName String type, Salary decimal type,Bonus decimal type, DeptNo number type, DeptName string type) With Empno as primary Key.
37	Find the Length of each Employee name.
38	Insert 5 rows in the above Employee table.
39	Update Bonus of employee will become 10% of salary whose salary is Less than 50000.

SNO	TOPICS
INDEX
NETWORKING CONCEPT
1	OSI MODEL
2	Switching Technique Concept
3	Circuit Switching Concept
4	Datagram Packet Switching Concept
5	Virtual Circuit Packet Switching Concept
6	Message Switching Concept
7	ALOHA Protocol
8	Relation Between Pure and Slotted Aloha
9	Find Mean Number of Frame Required To Attempt a Frame in Aloha
10	Carrier Sense Multiple Access/Collision Detection (CSMA)/CD
11	Detection of Error using OSI Model
12	Cyclic Redundancy Checking (CRC)
13	Data Link Layer Protocols Part-1
14	Data Link Layer Protocols Part-2
15	Congestion Control
16	Congestion Control Algorithms
17	Routing and Routing Algorithms
18	Inter Networking Concept

SNO	TOPICS
INDEX
THEORY OF COMPUTATION
1	TOC-Introduction
2	Concept of Finite Automata
3	Representation of Finite Automata
4	Concept of Epsilon\|Null value
5	Construction of Finite Automata
6	Finite Automata with Epsilon Moves
7	Minimization of Finite Automata
8	DFA-Deterministic Finite Automata
9	NDFA\|NFA - Non Deterministic Finite Automata
10	NDFA to DFA Conversion
11	NDFA to DFA Conversion with Epsilon
12	NFA to DFA Conversion (Short cut method)
13	NFA to DFA Conversion
14	Regular Expression (RE)
15	Conversion of RE to FA
16	Conversion of FA to RE
17	Rule For Constructing Arden's Equation
18	Grammar - Introduction
19	CNF-Normal Form of Grammar
20	GNF-Normal Form of Grammar
21	Type of Grammar
22	Moore and Mealy Machine
23	Turing Machine with Examples
24	Mathematical Induction
25	Theorems 1.Regular expression (R.E) is closed under union operation. 2.Regular language are closed under concatenation OR If L1 and L2 are regular than L1L2 are also regular. 3. Regular expression is closed under kleen closure. 4. Regular expression is closed under positive closure. 5. Construct an finite automata which accept a string does not end with 0 and 1's OR If L is regular than L' is also regular OR Regular language / Expression are closed under compliment .
26	Pumping Lemma

SNO	TOPICS
INDEX
ANALYSIS DESIGN OF ALGORITHM
1	Analysis Design of Algorithm (ADA) \| Introduction
9	Divide And Conquer Strategy Introduction
2	Heap and Heap Sort Concept
7	Merge Sort
8	Binary Search
10	Strassen's Matrix Multiplication
3	Greedy Strategy \| Introduction
4	Knapsack Problem Using Greedy Approach
5	Job Sequencing with timeline Using Greedy Approach
6	Minimum Spanning Tree (MST) Using Greedy Approach
11	Optimal Merge Problem Using Greedy Approach
23	Huffman Coding Using Using Greedy Approach
12	Dijkstra Algorithm Using Greedy Approach
13	B Tree
14	Depth First Search (DFS)
15	Breadth First Search (BFS)
16	INORDER Traversing Technique
17	POSTORDER Traversing Technique
18	PREORDER Traversing Technique
19	2-3 Tree
20	Binary Search Tree (BST)
21	Threaded Binary Search Tree
22	B++ Tree
24	Dynamic Programming \| Introduction
25	Multistage Graph Using Dynamic Programming
26	0/1 Knapsack Using Dynamic Programming

SNO	TOPICS
INDEX
UNIX OPERATING SYSTEM CONCEPT
1	Unix Command Part 1
2	Unix Command Part 2
3	Concept of Pipeline and Unix Command Part - 3
4	Know about user Privileges in Unix
5	Foreground and Background Process in Unix
6	Shell Programming Basic in Unix part - 1
7	Shell Programming Basic in Unix part - 2
8	Shell Programming Basic in Unix part - 3

SNO	TOPICS
INDEX
DATA STRUCTURE CONCEPT
1	Bubble Sort
2	Insertion Sort
3	Quick Sort
4	Selection Sort
5	Heap Sort
6	Interpolation Sort
7	Shell Sort
8	Redix Sort
9	Searching Concept
10	Linked List Concept
11	Singly Linked List - Insertion
12	Singly Linked List - Deletion
13	Doubly Linked List - Insertion
14	Doubly Linked List - Deletion
15	Circular Linked List - Insertion
16	Circular Linked List - Deletion
17	Stack Concept Infix to Postfix Using Stack
18	Simple Queue
19	Circular Queue
20	Dequeue \| Doubly Ended Queue
21	Tree Concept
22	B Tree Concept
23	B+ Tree Concept
24	Binary Search Tree (BST)
25	2-3 Tree Concept
26	Threaded BST
27	Spanning Tree
28	INORDER Traversing Technique
29	PRE ORDER Traversing Technique
30	POST ORDER Traversing Technique
31	Depth First Search (DFS)
32	Breadth First Search (BFS)
33	Dijkstra Algorithm
34	New Topic..Comming Soon

Model Papers

Tutorials

Lab Assignment

MODEL PAPERS

C-Programming | Programming and Problem Solving

INDEX

Database Management System

SYLLABUS

INDEX

MCQs For Primary Classes

INDEX

Programming in C++

INDEX

C Language

INDEX

Computer System Organization

INDEX

SQL CONCEPT

On a table perform WHERE CLAUSE, HAVING, GROUP BY, ORDER BY, IN, NOT IN, BETWEEN.

Create a database implementing Primary and Foreign Key.

Implement I/O Constraints and Business Rule constraints on the database created above.

Perform Nested Queries on table STUDENT.

Perform different types of JOINS on any two tables.

Create VIEWS, SEQUENCES and SYNONYMS on a table.

Use of SAVEPOINT, ROLLBACK and COMMIT command.

Find the most recently hired employee in each department.

Which department has the highest remuneration bill.

Find second highest salary of employee.

Display EmpName like 'Amit****' and Salary like '****5000'

Find the Length of each Employee name

Create an employee table having followint attributes (Empno number type, EmpName String type, Salary decimal type,Bonus decimal type, DeptNo number type, DeptName string type) With Empno as primary Key.

Find the Length of each Employee name.

Insert 5 rows in the above Employee table.

Display EmpName like 'Amit' and Salary like '5000'