Domain – Software Technology
Code Course Title Course Type Credits Pre-requisites
DEST0401 Oracle Database Theory+ 4 Data Base
Administration and Practice Management
SQL System
DEST0201 Problem Solving Practice 4 Data Structure
through Coding and C
Programming /
Programming
for problem
solving –
Java(old)/
Object Oriented
Programming
through
Java(New)
DEST0402 Linux and Lamp Theory+ 4 Nil
Administration Practice
DEST0403 Testing and Test Theory+ 4 Nil
Automation Practice
DEST0404 Web Services using Theory+ 4 Programming
Java Practice for problem
solving –
Java(old)/
Object Oriented
Programming
through
Java(New)
DEET0800 Internship Practice 4
DEET0300 Project Project 6
Total Credits 30
Page |1
Oracle Database Administration and SQL
Course Title Code Type of T-P-PJ Prerequisite
Course
Oracle Database DEST0401 Theory+ 2-2-0 Data Base
Administration and SQL Management
Practice
System
Course Objective:
● This course provides an exhaustive coverage of SQL Admin to understand the
architecture and processes of the Oracle database
Learning Outcome:
● After the end of the course the student will learn to create, execute and perform complex
maintenance related operations using the Oracle database
Evaluation Criteria:
Internal Component % of Marks Method of Assessment
Examination Internal Theory 20 Written examination
Internal Practice 30(20+10) Lab work + Learning Record
External External Theory 30 Written examination
Examination External Practice 20 Lab work
Total 100
Course outline
Module-I: Introduction (15 Hours)
Types of DB Users, Tasks of DBA Exploring the Oracle Database Architecture: Databases
and Instances, Oracle Database Structures, Oracle Processes, Oracle Memory Structures
Installing and Running Oracle Software: Tools for Creating Databases, Creating a Database,
Planning the Database, Server Processes and Clients, Application Servers and Web Servers As
Clients, Oracle Data Structure, Data Design. BI Publisher: Technology and Architecture
Module-II: Schema Management (10 Hours)
Oracle Schemas, Oracle Tables, Data Dictionary Views for Managing Tables, Oracle Indexes,
Managing Database Integrity Constraints, Using Views, Using Triggers
Page |2
Module - III: Oracle Security, Auditing and Compliance (15 Hours)
Usernames, Privileges, Groups, and Roles, Security Privileges, DBA, SYSDBA, and SYSOPER,
Restricting Data Access, Policies, Security and Application Roles and Privileges, Distributed
Database and Multitier Security, Encryption, Security Backup, Introduction to Auditing and
Compliance, Automatic Workload Repository, Oracle Database Vault Option, Auditing Database
Usage
Module - IV: User Management and Database Security (12 Hours)
Managing Users, The Database Resource Manager, Controlling Database Access (Privileges in
an Oracle Database, Using Views and Stored Procedures to Manage Privileges, DBA Views for
Managing Users, Roles, and Privileges), Database Authentication, Enterprise User Security,
Database Security
Module - V: Loading and Transforming Data, Database Recovery (12 Hours)
Overview of Extraction, Transformation, and Loading Oracle Transaction Management:
Oracle Transactions, Transaction Properties, Transaction Concurrency Control, Back Up:
Backing Up Oracle Databases, Important Backup Terms, Performing Database Recovery: Types
of Database Failures, The Oracle Recovery Process
Module-VI: Introduction to SQL (12 Hours)
Introduction to Relational Databases, SQL: An Overview, Creating a Database: Creating,
Changing, and Dropping Tables, Constraining the Values of Your Data, Maintaining Referential
Integrity, Entering, Deleting and Changing Data
Module – VII: SQL Queries (15 Hours)
Using SQL to Retrieve Information from Tables, Using IN, BETWEEN, LIKE, IS NULL, and
Aggregate functions, Working with Expressions, Querying Multiple Tables at once, Placing
queries inside one another, Using sub-query operators, Merging multiple queries More That
Can Be Done With Data: Introducing Views, Changing values through views, Determine who
can do what, Transaction and Concurrency, How a SQL database is kept in order
Text Books:
1. Expert Oracle Database 11g Administration, Sam R. Alapati, APress
Online Source(active on 25th June):
2. https://docs.oracle.com/cd/E11882_01/server.112/e25494.pdf
Page |3
Problem Solving Through Coding
Course Title Code Type of T-P-PJ Prerequisite
Course
Problem Solving DEST0201 Practice 0-4-0 Data Structure and C
Through Coding Programming /
Programming for
problem solving –
Java(old)/ Object
Oriented Programming
through Java(New)
Course Objective:
● Hand-execute simple programs, showing how input data is processed, output data is
produced, and how the values of internal variables change.
● Amend existing programs to adjust or correct their functionality.
● Analyze simple problems involving text, numbers and graphics, producing a top-level
plan with refinements.
Learning Outcome:
● Apply programming concepts, using a functional programming language, to solve
problems.
● Employ student centered learning, critical thinking, creativity and problem solving skills
to complete individual and collective tasks.
● Use the error messages of the compiler to identify and correct mistakes in program
syntax.
Evaluation Systems:
Internal Examination Component % of Marks Method of Assessment
Internal Practice 50 (40+10) Lab work + Learning Record
External Examination External Practice 50 Lab work
Total 100
Course outline
Module I: Simple problems (12 Hours)
1. Largest between five numbers.
Page |4
2. Sum of digits of a number.
3. Display the prime numbers between intervals.
4. Abundant Number, automorphic number, Armstrong number.
5. Swap number in cyclic order using call by reference.
Page |5
Module II: String Concepts (8 Hours)
1. Reverse a sentence.
2. Remove all character in a string except alphabet.
Module III: Math Functions (12 Hours)
1. Calculate the standard deviation.
2. Find GCD using Recursion.
3. Roots of a quadratic equation.
4. Polynomial equation.
5. Differential solution.
6. Print Pascal’s Triangle.
Module IV: Sorting and sequencing (10 Hours)
1. Sort elements in lexicographical order.
2. Sort an array of 0’s, 1’s and 2’s in linear time complexity.
3. Run length encoding
Module V: Complex problems (12 Hours)
1. Design flying character screen saver.
2. Designing of a digital clock.
3. Creation of own header file.
4. Design an age calculator.
5. Calculate difference between two time periods.
6. Validation of date.
7. Programs Using Pointers
8. Stack and Queue
9. Single, Double and Circular Linked List
Module VI: Gaming utilities (12 Hours)
1. Tic-Tac-Toe game
2. Random generator number.
Page |6
Module VII: System oriented problems (15 Hours)
1. Format/extract IP addresses octets.
2. Round robin problem
3. Job sequence problem
4. Finding the class of an IP address.
Reference:
Online Source (active on 25th June 2019):
1. https://www.includehelp.com/c-programs/advacnce-c-examples.
2. https://www.amazon.in/Expert-C-Programming-Deep-Secrets-ebook
Page |7
Linux and LAMP Administration
Course Title Code Type of T-P-PJ Prerequisite
Course
Linux and LAMP DEST0402 Theory+ 2-2-0 Nil
Administration
Practice
Course Objective:
The Course offers instruction in installation, support, and administration of a LINUX
Operating system in both server and workstation configurations.
Content includes LINUX and Web server installation, system startup/shutdown, hardware
configuration, disk and file system structure, package management, TCP/IP networking,
system management and security, X-Windows usage and configuration, user
management
Learning Outcome:
Use advanced LINUX commands and utilities for system administration
Create user and group accounts and secure system resources
Evaluation Criteria:
Internal Component % of Marks Method of Assessment
Examination Internal Theory 20 Written examination
Internal Practice 30(20+10) Lab work + Learning Record
External External Theory 30 Written examination
Examination External Practice 20 Lab work
Total 100
Course outline
Module I: Structure of Linux (12 Hours)
Development of Linux, Linux Distributions, Structure of Linux Operating System, File System
Hierarchy, Command line File management , Creating, Viewing and Editing Text Files using VI
editor ,Common Linux Commands Manage Local Linux Users and Groups , File-system
Permissions , Accessing File Systems, Monitoring & Managing Processes, Analyzing and
Storing Logs, Managing Networking, Managing Software using RPM.
Page |8
Module II: Regular Expressions (12 Hours)
Regular Expressions, SED, AWK, GREP
Module III: Shell Scripting Basics (10 Hours)
Basic Shell scripting, Advance Shell scripting
Module IV: File and Kernel Management (12 Hours)
File System Backup , Controlling Services and Daemons , Scheduling Future Tasks , Access
Control Lists , SELinux Security , Basic firewall configuration, Adding Disks, Partitions and
File System , Managing Logical Volume Management , Kernel Management , Run Levels
Module V: Web Services ( 12 Hours)
IPv4 and IPv6, Managing DNS for Servers, Configuring Email Transmission, Boot Process,
Network File Sharing, SAMBA , Apache HTTPD Web Service , backup
Module VI: LAMP (Linux, Apache, MySQL, PHP) (15 Hours)
Administration, Installation, Configuration, Apache: Apache Overview, What is "Apache" and
what does it do? Other web servers, Versions of Apache. Apache httpd - Sourcing, Installation,
Testing: Downloading Apache., Selecting a user account under which to run Apache, Initial
mandatory, configuration, Testing your installation, Running apache as a daemon. Further httpd
Configuration: Available Modules and turning them on and off, Associating file extensions with
modules. Apache httpd - virtual hosts: Virtual Hosts, Setting up so the browser can see multiple
hosts, configuring virtual hosts. Apache httpd - log files and log tools: Configuring the access
and error logs, making logs available to the web site owner. Tools to analyze log files.
Module VII: MySQL and PHP (12 Hours)
Install MySQL, Configuring and Securing MySQL, Set the root password, Launch at reboot,
View users, User hosts, Add a database user, Grant database user permissions, Create a database,
Testing MySQL, Connecting to & Disconnecting from the MySQL Server, Allow remote access,
Start the mysql shell. Add the PHP repository, Install php, Testing PHP, Install PHP Modules,
Speed up PHP by using an op code cache, Test PHP Processing on your Web Server, Access the
database through PHP
Online Source (active on 25th June 2019):
1. https://www.linode.com/docs/tools-reference/linux-system-administration-basics/
2. https://blog.udacity.com/2015/03/step-by-step-guide-install-lamp-linux-apache-mysql-python-
ubuntu.html
Page |9
Testing and Test Automation
\Course Title Code Type of T-P-PJ Prerequisite
Course
Testing and Test DEST0403 Theory+ 2-2-0 Nil
Automation Practice
Course Objective:
● Develop methods and procedures for software development that can scale up
for large systems and that can be used to consistently produce high-quality
software at low cost and with a small cycle time
● Students will learn how to use available resources to develop software, reduce
cost of software and how to maintain quality of software
● Methods and tools of testing and maintenance of software’s
Learning Outcome:
● Apply modern software testing processes in relation to software development
and project management
● Create test strategies and plans, design test cases, prioritize and execute them
● Contribute to efficient delivery of software solutions and implement
improvements in the software development processes
Evaluation Systems:
Internal Component % of Marks Method of Assessment
Examination Internal Theory 20 Written examination
Internal Practice 30(20+10) Lab work + Learning
Record
External External Theory 30 Written examination
Examination External Practice 20 Lab work
Total 100
P a g e | 10
Course outline
Module I: End-to-End Functional Manual Testing (12 Hours)
Basics of Manual Testing – Concepts, types, tools Automation Testing Vs Manual Testing, Unit
Testing, Integration Testing, System Testing, Sanity Vs Smoke Testing, Regression Testing and
Non-functional Testing Live Project introduction - Getting customer’s requirements, Creating
SRS, Creating Test Plan, Test Plan Execution
Module II: Test Scenario Writing (12 Hours)
Test Scenario Writing , Write a Test Plan Document from Scratch, Test Execution , Bug
Tracking and Test Sign off ,Software Testing Course
Module III: STLC (08 Hours)
Software Testing Life-Cycle (STLC): STLC Phases, Entry and Exit Criteria, SDLC Vs STLC
Module IV: Web Testing (12 Hours)
Web Application Testing, Cross-browser Testing, Test Case Management: Sample Test Case
Template, Requirements Traceability Matrix (RTM) - Test Coverage ,Test Data Management,
Automation Testing using Selenium: Introduction to Selenium, Basics of Selenium
Automation Testing, Selenium Web Driver and its contrast operation with RC, Web Driver
Basics : First Selenium Web Driver Script: JAVA Code Example, Locators in Selenium IDE:
CSS Selector, DOM, XPath, Link Text, ID, Find Element and Find Elements in Selenium Web
Driver, Selenium Form Web Element: TextBox, Submit Button, sendkeys(), click()
Module V: Selenium - Web Driver Essentials (10 Hours)
How to Select Check Box and Radio Button in Selenium Web Driver, How to Click on Image in
Selenium Web driver, How to Select Value from Drop Down using Selenium Web driver, Locate
Elements by Link Text & Partial Link Text in Selenium Web driver, Mouse Click & Keyboard
Event: Action Class in Selenium Web driver
Module VI: Selenium - File Handling Essentials (12 Hours)
How to Upload & Download a File using Selenium Web driver, XPath in Selenium Web
Driver: Alert & Popup Window Handling in Selenium Web Driver, How to Handle Web Table
P a g e | 11
in Selenium Web Driver, Handling Dynamic Web Tables Using Selenium Web Driver, Desired
Capabilities in Selenium Web Driver, How to Verify Tooltip using Selenium Web Driver, How
to Find All/Broken links using Selenium Web driver, Gecko (Marionette) Driver Selenium:
Download, Install, Use with Firefox
Module VII: Testing (12 Hours )
Test NGl: Annotations, Framework, Examples in Selenium, Test NG Groups: Include, Exclude
with Example, Test NG @Test Priority in Selenium, Parallel Execution in Selenium: Session
Handling & Test NG Dependency, Test NG: How to Run Multiple Test Suites in Selenium,
TestNG Listeners in Selenium: ITest Listener & ITest Result Example, How to Execute
Failed Test Cases in TestNG: Selenium WebDriver, TestNG Report Generation in Selenium
Web Driver, Customize, PDF & Email TestNG Reports in Selenium Web Driver
Online Source (active on 25th June 2019):
1. https://s1.demo.opensourcecms.com/wordpress/
2. https://book.theautomatedtester.co.uk/
P a g e | 12
Web Services Using JAVA
Course Title Code Course Type T-P- PJ Prerequisite
Web Services DEST0404 Theory + 2-2-0 Programming for problem
Using JAVA Practice solving – Java(old)/ Object
Oriented Programming
through Java(New)
Course Objective:
● Learn the industry oriented coding on Java with web application development using the
concept Spring Framework, JSON, AngularJS etc. Understand the factors in transitioning
from manual to automation testing
Learning Outcome:
● Able to use Spring framework, AngularJS in project development.
● Industry ready as java programmer in web applications.
Evaluation Systems:
Internal Examination Component % of Marks Method of Assessment
Internal Theory 20 Written examination
Internal Practice 30(20+10) Lab work + Learning Record
External External Theory 30 Written examination
Examination External Practice 20 Lab work
Total 100
Course outline
Module I: Spring Framework (15 Hours)
What is Spring; Architecture; Environment Setup; Hello Example, Spring Modules, Spring Core:
Bean; Bean Scope; Bean Life Cycle; IOC container; Dependency Injection; Spring Core
Annotations, Spring AOP: Terminologies; Types of Advice, Spring JDBC: JdbcTemplate;
CRUD operation
P a g e | 13
Module II: Spring MVC (15 Hours)
Spring MVC: Architecture; DispatcherServlet; Required Configuration; Controller; Form
Handling; Page Redirect; Exception Handling, Spring Security
Module III: Maven, RESTFUL (24 Hours)
Maven: Overview; POM file; Spring Initializer; Working with Eclipse, Postman,
Web Service: Introduction; SOAP; RESTFUL, Basics of RESTful Design: What is REST?
Principles of REST style; Benefits of REST style; Resource; URI; Representation Types: XML,
JSON; HTTP Request & Response, REST and MIME types, REST and HTTP methods, HTTP
Status Code
Module IV: Spring JPA and Hibernate (24 Hours)
Hibernate Architecture, ORM (Object Relational Mapping), First Hibernate Example,
Annotations - @Entity ; @Table; @Id, CRUD operations, Hibernate Query Language (HQL),
Native SQL, Web Application with Hibernate.
Module V: Spring Boot (24Hours)
Spring Boot: Introduction; Hello Boot example, Basic REST Annotations for RESTful service in
Spring REST Binding URI to Resource using @RequestMapping; @GetMapping;
@PostMapping; Extracting parameters using @RequestParam; @PathVariable;
@ModelAttribute; @RequestBody and @ResponseBody; @CookieValue, @RequestHeader
and @ResponseHeader,
Module VI: AngularJS (24 Hours)
AngularJS: What is AngularJS? Architecture & Features, Single Page Application (SPA),
Download AngularJS, Expressions, Modules and Dependency Injection, Controllers, Directives,
Scope and RootScope, Data Binding
Module VII: Services (24 Hours)
Services: build-in; Factory; Service; Provider, $http, validation, Filters, Routing
P a g e | 14
Text Books:
1. Balaji Varanasi, Sudha Belida, “Spring REST”,in Apress, 2015.
2. CRAIG WALLS, “Spring in Action” 5th edition, in Manning, 2017.
3. Agus Kurniawan, “AngularJS Programming by Example”, in Kindle , 2017.
Online Source (active on 25th June 2019):
1. javatpoint.com
2. spring.io
3. https://docs.angularjs.org/api
P a g e | 15
