Unique @CSE

The Department always uphold a research culture, in parallel with the overall teaching-learning process. The outcome is the papers published by the students and faculty in National and International conferences and journals. Some of the research areas of focus are:

Big Data – Hadoop

Overview:

BIG DATA - HADOOP helps to apply practical skills and analytical knowledge to real time issues.Big Data refers to a huge volume of data, which is a collection of large datasets that cannot be processed using traditional computing techniques.Hadoop is an open-source framework that allows to store and process big data in a distributed environment across clusters of computers using simple programming models. It is designed to scale up from single servers to thousands of machines, each offering local computation and storage.

This course aims to train the students in Big Data – Hadoop. The goal is to accelerate the technology Big Data – Hadoop is growing across the world and this strong growth pattern translates into great opportunity for all the IT Professionals.This course builds you to become passionate about building successful career in Big Data- Hadoop.Objectives:The course should enable the students to:

Develop in various Big data technologies like Hadoop and its ecosystems.

  • Master the concepts of HDFS and Map Reduce framework.
  • Understand Hadoop 0.x, 1.x and 2.x Architectures.
  • Setup Hadoop Cluster and write Complex Map Reduce programs.
  • Perform data analytics using Pig, Hive and YARN.
  • Implement H base and Map Reduce integration.
  • Learn data loading techniques using Sqoop and Flume.
  • Implement Advanced Usage and Indexing.
  • Implement best practices for Hadoop development.

Course Contents:

Week / Date Content

Week1

Day1 Introduction to Big Data & Hadoop
Day2 Hadoop and its file system - HDFS
Day3 Hadoop Distributed File System
Day4 Hadoop Components/Architecture
Day5 Anatomy of a File Read
Day6 Anatomy of a File Write

Week2

Day7 Understanding Hadoop Cluster
Day8 Lab Activity:
Walkthrough of CDH VM setup
Day9 Hadoop Cluster modes, Hadoop Configuration files
Day10 Three Modes of Cluster configurations
Day11 Lab Activity:
About the linux operating system, Linux commands, About VMWare.
Day12 Lab Activity:
Big Data – Hadoop 0.xx Version,Software installation.

Week3

Day13 Lab Activity:
Words PerLine Program, Compression Program, Chaning Program, Dynamic wordcount Program
Day14 Pig Latin Language
Day15 Pig UDF & executing a Pig UDF, Pig Use cases
Day16 Lab Activity:
Pig Latin Language commands and exercises
Day17 Introduction to Hive
Day18 Lab Activity:
Hive Data types, Data Storage,Managed & External Tables

Outcomes:

At the end of the course the students will be able to:

Know the evolution of latest Hadoop technology through VMWare.

  • Work on real-time projects (in all tools like – Pig, Hive, Map reduce & H Base).
  • Hand-on and outs will be given which would serve as a knowledge-check.
  • Exclusive Access to a variety of latest interview questions and answers.

Training Duration: Twice in semester:3 weeks duration; From 4 PM to 6 PM.Contact:

Ms. G. Sulakshana
Assistant Professor of Computer Science and Engineering
Phone: 7799880086
e-MailID: g.sulakshana@iare.ac.in

CISCO Academy

Overview:

As Enterprises migrate toward controller based architectures, the role and skills required of a core network engineer are evolving and more vital than ever. To prepare for this network transition, the CCNA Routing and Switching certification will not only prepare you with the knowledge of foundational technologies, but ensure you stay relevant with skill sets needed for the adoption of next generation technologies.

The role and skills required of a core network engineer are evolving significantly as enterprise networks encounter increased business demands and technology advancements. To meet these challenges, skilled IT professionals are needed with up-to-date, networking skills. For individuals looking to build and validate CISCO networking fundamentals, the CISCO CCNA Routing and Switching program focuses on foundational IP networking skills required to deploy, operate and troubleshoot network layers 1-3. It introduces awareness of programmable networks (SDN), VPN technologies, adoption of IPv6, virtualized and cloud services, along with knowledge of QoS concepts and the ability to ensure critical traffic is being properly prioritized.

Objectives:

The course should enable the students to:

  • Learn adequate knowledge on networking.
  • Understand the network issues and able to find solutions
  • Install local area network and IP routers
  • Install new protocols.
  • Understand wide-area network technologies.

Course Contents:

Week / Date Content

Week-1

Day1

Operation of IP Data Networks:
Operation of IP Data Networks Recognize the purpose and functions of various network devices such as Routers, Switches, Bridges and Hubs.

Day2

Select the components required to meet a given network specification. Identify common applications and their impact on the network Describe the purpose and basic operation of the protocols in the OSI and TCP/IP models.

Day3

Predict the data flow between two hosts across a network. Identify the appropriate media, cables, ports, and connectors to connect Cisco network devices to other network devices and hosts in a LAN

Day4

LAN Switching Technologies:
Determine the technology and media access control method for Ethernet networks Identify basic switching concepts and the operation of Cisco switches.

Day5

Configure and verify initial switch configuration including remote access management. Verify network status and switch operation using basic utilities such as ping, telnet and ssh. Identify enhanced switching technologies Describe how VLANs create logically separate networks and the need for routing between them.

Day6

Configure and verify VLANs Configure and verify trunking on Cisco switches Configure and verify PVSTP operation

Week-2

Day7

IP addressing (IPv4 / IPv6): Describe the operation and necessity of using private and public IP addresses for IPv4 addressing Identify the appropriate IPv6 addressing scheme to satisfy addressing requirements in a LAN/ WAN environment.

Day8

Identify the appropriate IPv4 addressing scheme using VLSM and summarization to satisfy addressing requirements in a LAN/WAN environment.

Day9

Describe the technological requirements for running IPv6 in conjunction with IPv4 such as dual stack Describe IPv6 addresses.

Day10

IP Routing Technologies: Describe basic routing concepts Describe the boot process of Cisco IOS routers Configure and verify utilizing the CLI to set basic Router configuration Configure and verify operation status of a device interface, both serial and Ethernet.

Day11

Verify router configuration and network connectivity Configure and verify routing configuration for a static or default route given specific routing requirements Manage Cisco IOS Files Differentiate methods of routing and routing protocols

Day12

Configure and verify OSPF (single area) Configure and verify EIGRP (single AS)

Week-3

Day13

Configure and verify interVLAN routing (Router on a stick) Configure SVI interfaces

Day14

IP Services: Configure and verify DHCP (IOS Router) Describe the types, features, and applications of ACLs

Day15

Configure and verify ACLs in a network environment Identify the basic operation of NAT

Day16

Configure and verify NAT for given network requirements Configure and verify NTP as a client

Day17

Recognize High availability (FHRP) Configure and verify Syslog Describe SNMP v2 & v3

Day 18

Network Device Security: Configure and verify network device security features

Week-4

Day 19

Configure and verify Switch Port Security features

Day 20

Configure and verify ACLs to filter network traffic Configure and verify an ACLs to limit telnet and SSH access to the router.

Day 21

WAN Technologies: Identify different WAN Technologies.

Day 22

Configure and verify a basic WAN serial connection.

Day 23

Configure and verify a PPP connection between Cisco routers

Day 24

Configure and verify Frame Relay on Cisco routers Implement and troubleshoot PPPoE.

Outcomes:

At the end of the course the student will be able to:

  • Identify all the network components and purposes.
  • Install, operate, configure, and verify a basic IPv4 and IPv6 network.
  • Configure a LAN switch and IP router.
  • Identify basic security threats and troubleshooting common network issues.
  • Configure EIGRP and OSPF in both IPv4 and IPv6.
  • Identify and install WAN technologies.
  • Understanding wide-area network technologies, and getting familiar with device management and Cisco licensing.

Training Duration: Twice in semester ; 4 weeks duration; From 4 PM to 6 PM.

Contact:

Dr G Ramu
Professor of Computer Science and Engineering
Phone: 9703962233
e-Mail ID: g.ramu@iare.ac.in

Data Analytics Using R Programming

Overview:

R is statistical programming used for data analytics and data visualization. With over 2 million users worldwide R is rapidly becoming the leading programming language in statistics and data science. Every year, the number of R users grows by 40% and an increasing number of organizations are using it in their daytoday activities.

The knowledge on this course accelerates to use R programming to explore variety of data from a variety of sources by building data models and generating charts, graphs, and other data representations. As data intensive applications are emerging more, there is good demand for people having R language skills in the industries. With the knowledge gained in this course, student will be ready to undertake his first own data analysis.

Objectives:

The course should enable the student to:

  • Understand the basics of programming with R language.
  • Explore on data extraction techniques from variety of sources like web, social network and No SQL databases.
  • Perform data analysis with R.
  • Manipulate, process, transform, merge and reshape large volumes of data.
  • Understand basic statistics and create visualization to solve data analysis problems in web analytics, social sciences, finance, and economics.

Course Contents:

Week / Date Content

Week-1

Day 1

R Introduction, R software installation, R Studio setup, creating R script.Simple Arithmetic with R, R objects,checking type of object. Lab Activity:Use R like a calculator: arithmetic operations with objects and without objects, built-in mathematical functions.

Day 2

Working with different data types and data structures: data cleaning and data transformation techniques.

Lab Activity: Working with data types: Reading and writing data, data formats, vectors, lists, arrays, matrices, tables and data frames functions.

Day 3

Working with data types

Day 4

Data Descriptive Statistics: Summary statistics on different objects.

Day 5

Lab Activity:Data summaries, aggregations, subset, with functions on R objects.

Day 6

Lab Activity:apply, lapply, summary statistics, advanced summary functions on various objects.

Week-2

Day 7

Data distribution, functions and control statements.

Day 8

Lab Activity:Random data generation, data distribution functions: binomial, continuous etc.

Day 9

Handling variety of data in R.

Day 10

Lab Activity:R with text, csv, web datasets.
Case Study 1: Data exploration on IRIS dataset, cars, MS admission process.

Day 11

R with Excel, R Markdown creation.

Day 12

Lab Activity:Package installation in R with Excel sheet, creating R Markdown and publish in RPUBS cloud.

Week-3

Day 13

No SQL databases with R

Day 14

Handling semi structured (XML) data in R.
Lab activity:Restaurant Menu data process

Day 15

SQL on data objects.Lab Activity:
SQLDF package installation and SQL queries on data objects in R.

Day 16

Visualization in R.

Lab Activity: Plots: Scatterplot, biplot, corrplot, histogram, boxplot, barplot, lineplot, wordcloud plots, par, legand.
Case Study 2 : Visualization on MTCARS and IRIS data sets

Day 17

Missing data and outlier detection, finding hidden relationships among attributes in a data set, correlation and covariation analysis.

Day 18

Data model using linear and logistics regression, residual analysis and model evaluation.
Lab Activity:Hidden relation among heart weight and body weight, predictive model on heart weight

Day 19

Case study 3: One predictive Model application

Outcomes:

At the end of the course the students will be able to:

  • Get good insight into R Language.
  • Explore on importing, cleaning and exporting variety of data.
  • Perform data analysis and exploration techniques.
  • Apply basic statistics and visualization techniques on data.
  • Develop a predictive data model and evaluation on model.

Training Duration:Twice in semester; 3 weeks duration;From 4 PM to 6 PM.

Contact:

Dr M. Madhu Bala
Professor of Computer Science and Engineering
Phone: 9885543778
e-Mail ID: m.madhubala@iare.ac.in

Informatica

Overview:

Informatica helps to apply practical skills and analytical knowledge to real time issues. The term ETL which stands for extract, transform, and load is a three-stage process in database usage and data warehousing. It enables integration and analysis of the data stored in different databases and heterogeneous formats. After it is collected from multiple sources (extraction), the data is reformatted and cleansed for operational needs (transformation). Finally, it is loaded into a target database, data warehouse or a data mart to be analyzed.

In most of the Data Integration or Data Warehousing projects, the amount of time spent in enforcing business data domain rules and/or business data integrity rules could be as high as 80 percent of the total time. And enforcement of such rules normally happens through Data Transformations.

Objectives:

The course should enable the students to:

  • Increase skills in database queries.
  • Use ETL and Informatica applications to extract data.
  • Manage Master Data and Metadata.
  • Learn knowledge of Data profiling and Data quality concepts and techniques.
  • Experience in Gathering process information, business model and requirements.
  • Know designing database models and converting different database into uniform format.
  • Learn the usage of Informatica Power Center for designing, developing, maintaining, and monitoring ETL processes.
  • Learn to create documents for design and mapping.
  • Learn how to migrate database from existing server using ETL methodology.
  • Understand how to manage and updating database as per the business requirements.

Course Contents:

Week / Date Content

Week1

Day1

Introduction to data ware housing

Day2

Types of systems-OLTP/OLAP

Day3

ETL plan

Day4

Data extraction, data transformation, data loading

Day5

Data warehousing /database design

Day6

Slowly changing dimensions

Week2

Day7

Informatica architecture

Day8

Lab Activity:
Practical on database queries

Day9

Lab Activity:
Introduction of informatica tool

Day10

Lab Activity:
Importing source and targets/column profiling

Day11

Lab Activity
Practical with real-time datasets

Day12

Lab Activity:
Extraction of data from social media sites

Week3

Day13

Introduction to mapping

Day14

Introduction to transformations

Day15

Lab Activity:
Mapping without transformations

Day16

Lab Activity:
Mapping with transformations/loading

Day17

Lab Activity:
Introduction practical on workflow

Day18

Lab Activity:
Introduction & practical on monitoring workflow

Outcomes:

At the end of the course the students will be able to:

  • Design a database schema for given problem.
  • Identify the entities, attributes, relationships, keys for given database.
  • Formulate queries using SQL DML, DDL commands.
  • Apply the normalization techniques for development of application software to realistic problems.
  • Learn to build a data warehouse and query it using informatics tool
  • Learn to execute data mining tasks using a data mining toolkit (such as INFORMATICA) and visualize the results.
  • Demonstrate the working of algorithms for data mining tasks such association rule mining, classification, clustering and regression.

Training Duration: Twice in semester ; 3 weeks duration; From 4 PM to 6 PM.

Contact:

Ms. N.M.Deepika
Assistant Professor of Computer Science and Engineering
Phone: 9618937154
e-Mail ID: deepika.n@iare.ac.in

Internet of Things (IoT) with Arduino

Overview:

IoT is simply the network of interconnected things/devices which are embedded with sensors, software, network connectivity and necessary electronics that enables them to collect and exchange data making them responsive. More than a concept Internet of Things is essentially an architectural framework which allows integration and data exchange between the physical world and computer systems over existing network infrastructure. It gives you the power to change the world and the way we understand it. Arduino senses the environment by receiving inputs from add-on devices such as sensors, and can control the world around it by adjusting lights, motors, and other actuators.

In this course you will learn how and when to use the different types of sensors and how to connect them to the Arduino. Since the external world uses continuous or analog signals and the hardware is digital you will learn how these signals are converted back-and-forth and how this must be considered as you program your device. You'll also learn about the use of Arduino-specific shields and the shields software libraries to interface with the real world. You’ll discover fundamental concepts of cloud computing, sensor reading and connecting the Arduino to the Internet, using both wired and wireless interfaces and Android phones. You’ll also learn to use the most popular open platforms for managing sensor data from the Arduino, how to trigger actuators remotely, and how to reprogram Arduino using cloud services.

Objectives:

The course should enable the student to:

  • Demonstrate basic IOT devices and applications using sensors.
  • Design and implement Bluetooth based applications for home automation using smart phones.
  • Illustrate Ethernet based applications for remote monitoring and controlling devices.
  • Develop Wi-Fi based applications for controlling web server enabled things.
  • Build and deployapplicationswith acloud based IOTplatform.

Course Contents:

Week / Date Content

Week - 1

Day 1

Introduction to Internet of Things, IoT architecture, Innovations and initiatives in IoT.

Day 2

Hardware and software platforms, Cloud platforms, IoT security.

Day 3

Introduction to Arduino development, working on Arduino development platform.

Day 4

Introduction to modular sensors, Integration of sensor with Arduino board.
Lab Activity:
Sensor based experiments:

Outdoor temperature and humidity monitoring.

Day 5

Lab Activity:

Intruder detection using PIR sensor.

Level / distance measurement using ultrasonic Sensors.

Week - 2

Day 6

Introduction to Wired Communication Technologies (UART, SPI, I2C, Ethernet), Introduction to Ethernet Shield and Configuring as a client and server.

Day 7

Introduction to open source cloud, HTML methods (GET, POST), Interfacing Ethernet shield with Arduino Board, Arduino as a Webserver for remote controlling of equipment.
Lab Activity:

Servomotor position control from mobile application using Bluetooth.

Day 8

Arduino as client for sending data to the cloud, generating email & notifications, Parameter Monitoring & Control through mobile application.
Lab Activity:

Voice controlled mini home automation using android Smartphone.

Day 9

Introduction to wireless communications (Bluetooth, WiFi, GPRS, Xbee, NFC), Introduction to communication protocols designed for IoT (MQTT)
Lab Activity:

Development of web-server and remote monitoring and control of equipment.

Send environmental parameters to remote cloud.

Day 10

Demonstration of NodeMCU development board, Interfacing Bluetooth module with Arduino and monitoring & controlling of parameters, WIFI based webserver & client, WiFi based smart home system with NodeMCU development board and android application.
Lab Activity:

Receive automatic call notification on mobile phone for burglar alarm using IoT.

Automatically tweet sensor data on Twitter.

Week - 3

Day 11

Introduction to Raspberry pi, Introduction to Python programming.

Day 12

Image processing on Raspberry pi, Interfacing of sensors and output devices with raspberry pi, Hosting apache web server of Raspberry pi.
Lab Activity:

Creating program for local host web server for controlling devices.

Day 13

Remote control of GPIO’s through webpage, Raspberry pi based home security system.
Lab Activity:

Uploading parameters to the remote cloud server using Wi-Fi.

Day 14

Working on product building using Arduino Platform, Arduino platform current advancements.
Lab Activity:

Event based notification server using IFTTT.

Day 15

Working on product building using Raspberry pi platform, Raspberry pi platform current advancements.

Outcomes:

At the end of the course the students will be able to:

  • Learn the importance of IoT in society, the current components of typical IoT devices and trends for the future.
  • Understand the IoT design considerations, constraints and interfacing between the physical world and your device.
  • Learn the integration of sensors with Arduino board.
  • Understand the IoT architecture, innovations and initiatives in IoT.
  • Understand various wired communication technologies (UART, SPI, I2C, Ethernet).
  • Learn how to use Arduino as a webserver for remote controlling of equipments.
  • Understand various communication protocols designed for IoT (MQTT).
  • Explore Python-based IDE (integrated development environments) for the Raspberry Pi and tracing and debugging Python code on the device.

Training Duration: Twice in semester; 3 weeks duration; From 4 PM to 6 PM.

Contact:

Ms. B Padmaja
Associate Professor of Computer Science and Engineering
Phone: 9618150625
e-mail: b.padmaja@iare.ac.in

SAP-ABAP

Overview:

ABAP (Advanced Business Application Programming), is a fourth-generation programming language, used for development and customization purposes in the SAP software. Currently positioned along with Java, as the main language for SAP application server programming, most of the programs are executed under the control of the run-time system.

ABAP is the programming language used to develop applications in SAP. It is a programming language developed by SAP which is a German company that develops ERP (Enterprise Resource Planning) systems. These systems are used by companies to track all information related to the business integrating finance, sales, materials data etc. ABAP/4 is the programming language used for the development of thousands of tiny embedded programs called transactions that make up the application.SAP is very flexible; it can be used for specific business functions rather than the whole enterprise and can be modified for the company's specific needs. Every SAP installation has its own specific configuration and set of functions. SAP is an industry specific software and comes with a lot of predefined applications and configurations. SAP also provides lots of customizing options, if any of the applications provided by SAP does not meet your company specific requirements.

Objectives:

The course should enable the students to:

  • Understand key business processes in an organization and identify the main integration points.
  • Effectively use SAP ERP to configure, test and execute standard business processes.
  • Designing database tables as per the requirements of the organization.
  • Work with Report Programming and Data migration Techniques.
  • Make the customizations as per the needs.

Course Contents:

Week / Date Content

Week1

Day1

Introduction to data SAP-ABAP

Day2

Architecture of R/3 System

Day3

Transaction code & usage

Day4

ABAP Programming

Day5

ABAP Development work Bench

Day6

Package Creation , Debugging

Week2

Day7

Components of ABAP Dictionary

Day8

ABAP Database Objects

Day9

Modularization Techniques

Day10

Report Programming

Day11

Classical Reports , Interactive Reports

Day12

ALV Reports

Week3

Day13

Dialog Programming

Day14

Data Migration Techniques

Day15

Smart Forms

Day16

Object Oriented ABAP (OOABAP)

Day17

Cross Applications

Day18

Web Services

Outcomes:

At the end of the course the students will be able to:

  • Understand the basic concepts of ERP.
  • Learn to execute the programs with ABAP editor
  • Work with database tables, search helps, views
  • Work with Report Programming.
  • Understand the basic concepts of Smart Forms and Cross Applications.

Training Duration: Twice in semester; 3 weeks duration; From 4 PM to 6 PM.

Contact:

Ms. G.Nishwitha
Assistant professor of Computer Science and Engineering
Phone: 9642623426
e-MailID: g.nishwitha@iare.ac.in