8368722963 info@nxaeon.com Admin Login

Data Analytics

Data analytics is the process of examining data sets in order to draw conclusions about the information they contain. It enable organizations to make more-informed business decisions keeping all the aspects of analytics in mind. There is a step by step process in Data Analytics which assists the business to know their existing strategies’ loopholes and lapses. Data Analytics can act as a tool for the Data Analysts rather than a trouble. The depths of Data Analytics can amaze you to the extent of starting your own business with Data Analytics as your partner. To realize and accept the true nature and power of DA we have dwell into it.

Data analytics is primarily conducted in business-to-consumer (B2C) applications. Global organizations collect and analyze data associated with customers, business processes, market economics or practical experience. Data is categorized, stored and analyzed to study purchasing trends and patterns.

Evolving data facilitates thorough decision-making. For example, a social networking website collects data related to user preferences, community interests and segment according to specified criteria such as demographics, age or gender. Proper analysis reveals key user and customer trends and facilitates the social network’s alignment of content, layout and overall strategy.

Syllabus of Data Analytics

Data Analytics

  • Warming up
  • Setting up machine
  • The basics of Python language
  • Regular Expressions in Python
  • Scientific libraries in Python – NumPy, SciPy, Matplotlib and Pandas
  • Effective Data Visualization
  • Scikit-learn and Machine Learning
  • Practice and deep learning

Python

Python is a general-purpose interpreted, interactive, object-oriented and high-level programming language. Currently Python is the most popular Language in IT. Python adopted as a language of choice for almost all the domain in IT including Web Development, Cloud Computing (AWS, OpenStack, VMware, Google Cloud, etc), Infrastructure Automations , Software Testing, Mobile Testing, Big Data and Hadoop, Data Science, etc. This course to set you on a journey in python by playing with data, creating your own application, and also testing the same.

Syllabus of Python

An Introduction to Python

  • Brief History
  • Why Python
  • Where to use

Beginning Python Basics

  • The print statement
  • Comments
  • Python Data Structures & Data Types
  • String Operations in Python
  • Simple Input & Output
  • Simple Output Formatting

Python Program Flow

  • Indentation
  • The If statement and its’ related statement
  • An example with if and it’s related statement
  • The while loop
  • The for loop
  • The range statement
  • Break & Continue
  • Assert
  • Examples for looping

Functions & Modules

  • Create your own functions
  • Functions Parameters
  • Variable Arguments
  • Scope of a Function
  • Function Documentation/ Docstrings
  • Lambda Functions & map
  • An Exercise with functions
  • Create a Module
  • Standard Modules

Exceptions

  • Errors
  • Exception Handling with try
  • Handling Multiple Exceptions
  • Writing your own Exceptions

File Handling

  • File Handling Modes
  • Reading Files
  • Writing & Appending to Files
  • Handling File Exceptions
  • The with statement

Classes in Python

  • New Style Classes
  • Variable Type
  • Static Variable in class
  • Creating Classes
  • Instance Methods
  • Inheritance
  • Polymorphism
  • Encapsulation
  • Scope and Visibility of Variables
  • Exception Classes & Custom Exceptions

Regular Expressions

  • Simple Character Matches
  • Special Characters
  • Character Classes
  • Quantifiers
  • The Dot Character
  • Greedy Matches
  • Grouping
  • Matching at Beginning or End
  • Match Objects
  • Substituting
  • Splitting a String
  • Compiling Regular Expressions
  • Flags

Data Structures

  • List Comprehensions
  • Nested List Comprehensions
  • Dictionary Comprehensions
  • Functions
  • Default Parameters
  • Variable Arguments
  • Specialized Sorts
  • Iterators
  • Generators
  • The Functions any and all
  • The with Statement
  • Data Compression
  • Closer
  • Decorator

Thread in Python

  • Thread life Cycle
  • Thread Definition
  • Thread Implementation

Network Programming Introduction

  • A Daytime Server
  • Clients and Servers
  • The Client Program
  • The Server Program
  • Recap
  • An Evaluation Client and Server
  • The Server Portion
  • A Threaded Server

Python MySQL Database Access Introduction

  • Installation
  • DB Connection
  • Creating DB Table
  • INSERT, READ,UPDATE, DELETE operations
  • COMMIT & ROLLBACK operation
  • Handling Errors

Project Work

Advanced Excel

Advanced Excel is the tool that maximizes the data of companies that will be able to store, compare and analyze information effectively. Excel gives you the ease of using graphics and empower you to use of formulas, tables that are used in reports presentations, sales and others. Among the tools Excel includes ways to identify trends by means and averages that will be useful when seeking explanations of the behavior of certain figures. Advance Excel is especially for students and working professional who wants to gain necessary to use pivot tables, audit worksheet data, vlookup, utilize data tools. Create, Edit and Format all applications will be easily used in excel application. If you want to learn Advanced Excel Training then you can come to nx-aeon at Mayur Vihar Phase-III, New Delhi.

Introduction and Basic MS Excel

  • Customizing common options in Excel
  • Absolute and relative cells
  • Protecting and unprotecting worksheets and cells

Working with Functions

  • Writing conditional expressions (using IF)
  • Using logical functions (AND, OR, NOT)
  • Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
  • VlookUP with Exact Match, Approximate Match
  • Nested VlookUP with Exact Match
  • VlookUP with Tables, Dynamic Ranges
  • Nested VlookUP with Exact Match
  • Using VLookUP to consolidate Data from Multiple Sheets

Data Validations

  • Specifying a valid range of values for a cell
  • Specifying a list of valid values for a cell
  • Specifying custom validations based on formula for a cell

Working with Templates

  • Designing the structure of a template
  • Using templates for standardization of worksheets

Sorting &  Filtering Data

  • Sorting tables
  • Using multiple-level sorting
  • Using custom sorting
  • Filtering data for selected view (AutoFilter)
  • Using advanced filter options

Working with Reports

  • Creating subtotals
  • Multiple-level subtotals
  • Creating Pivot tables
  • Formatting and customizing Pivot tables
  • Using advanced options of Pivot tables
  • Pivot charts
  • Consolidating data from multiple sheets and files using Pivot tables
  • Using external data sources
  • Using data consolidation feature to consolidate data
  • Show Value As (% of Row, % of Column, Running Total, Compare with Specific Field)
  • Viewing Subtotal under Pivot

Advanced Excel More Functions

  • Date and time functions
  • Text functions
  • Database functions
  • Power Functions (CountIf, CountIFS, SumIF, SumIfS)

Formatting 

  • Using auto formatting option for worksheets
  • Using conditional formatting option for rows, columns and cells

whatIf Analysis

  • Goal Seek
  • Data Tables
  • Scenario Manager

Advanced Excel More Functions

  • Date and time functions
  • Text functions
  • Database functions
  • Power Functions (CountIf, CountIFS, SumIF, SumIfS)

Charts

  • Using Charts
  • Formatting Charts
  • Using 3D Graphs
  • Using Bar and Line Chart together
  • Using Secondary Axis in Graphs
  • Sharing Charts with PowerPoint / MS Word, Dynamically

New Features of Excel

  • Sparklines, Inline Charts, data Charts
  • Overview of all the new features

 

Creating Macro

  • Type of VBA Macro.
  • Display of Developers Tab and VB Editor.
  • Macro Security.
  • How to record a VBA Macro
  • Execution of recorded Macro.
  • Editing the recorded Macro
  • Various Keyboard Shortcuts related to VBA Macros.
  • Working on Various Examples of Macro recorder
  • Introduction to the writing of basic VBA codes
  • Saving Off Your Macro.
  • Introduction to the Personal Macros

Programming Writing Concepts

  • Defining Variables to Macro.
  • Discussion on different Types of Variables.
  • Use of Local Window.
  • Working on Programming, Understanding on VBA Language.
  • Introduction of Message Box in Macro.
  • Introduction of Input Box In Macro.
  • Use of decision making statements in Macro by using: If and Else conditions, And /OR conditions.

Working with Loops and Worksheet Ranges

  • Introduction of the loops in Macro
  • Use of Different type of loops like, For & Next LOOP, For & Each Loop, Do & Until LOOP While and While and Wend Loop
  • Working with ranges like selecting, copying and pasting the ranges and extract the data on same Worksheet level
  • Selecting, copying and pasting the ranges and extract the data on different Worksheet level in the same Workbook
  • Selecting, copying and Pasting the Ranges and extract the data on different Workbook Level.

Writing of Formulae in VBA an Error handling

  • Introduction of programming concepts for writing the Excel Formulas
  • Difference between the A1 and R1C1 style of writing formula in VBA
  • Look at the style A1 and R1C1 and decide which is better
  • Find out the better solution to write the formulas in VBA
  • Writing of the basic formulas in to VBA
  • Writing of the complex formulas in to the VBA
  • Writing of Logical formulas and Lookup formulas in VBA
  • Freezing of the formula in VBA
  • Other useful formulas to be write in Class
  • Error handling

Advanced VBA Functions

  • What is User Defined Function
  • Use of User Defined Function
  • How to create any Function OR Formula which is not available in Excel
  • What is ADD-IN
  • Use of ADD-IN and How to create ADD-IN.
  • What are Events
  • How and when to use the VBA Events.
  • VBA User Forms
  • What are User Forms,
  • Why to create User Forms and How to create User Forms

Project

 

Java

It is the most widely used programming language with a wide range of application. Java was released in the year 1995 by Sun Microsystems. It is used for the development of the Internet of Things, APIs, e-commerce websites, financial trading platforms, scientific applications and a lot more. It is Java that powers Android. Java is present in every aspect of the digital environment.  Java developers earn good money. Some of the career options for Java programmers are Software Developer, Big Data Developer, Web Developer, Application Developer,  EJB Programmer, Back-End Developer,  Android Developer, Web Programmer, Embedded Devices Developer and a lot more. From mobile phones to supercomputers, there are vast options for usage and application of Java.

Our trainers are industry professional have many  years of practical experience. It doesn’t matter if you are a beginner or want to improve your existing knowledge of Java; our trainers will mentor you to become the best in your field. Nx-aeon is leading training institute in IT training program. Our ability to provide practical training to our students has made us the best Java training institute in Mayur Vihar Phase-III.

Syllabus of Core Java

 

Fundamentals of Java Programming

  • Naming convention of Java language
  • Comments
  • Statements
  • Blocks (Static, Non-static/instance)
  • Identifiers
  • Keywords
  • Literals
  • Primitive Data Types, Range
  • Reference(User defined) Data type
  • Variables (Primitive, Reference)
  • Type Casting, Default Value
  • Operators

Introduction to Java Programming

  • Environment
  • How to Install & set Path
  • A Simple Java Program
  • Compiling & executing Java Program
  • Phases of Java Program
  • Analysis of a Java Program
  • Understanding Syntax and Semantic Error,
  • Runtime Exception
  • Name of a Java Source File
  • Platform Independency
  • Java Technology( JDK, JRE, JVM, JIT)
  • Features of Java
  • Text Editors
  • Consoles

Control Structure

  • Working with Control Structures
  • Types of Control Structures
  • Decision Control Structure (if, if-else, if else
  • if, switch –case
  • Repetition Control Structure (do –while,
  • while, for

Keyboard Input in JAVA

  • Java program inputs from Keyboard
  • Methods of Keyboard inputs
  • Scanner, Buffered Reader
  • J Option Pane

JAVA Array

  • What is Array
  • Array Declaration in java vs C and C++.
  • Instantiation of an Array
  • String vs character array. Accessing Array
  • Elements, Default Value,
  • for-each loop, varargs.
  • Length of an Array (What is
  • Array Index Out Of Bounds Exception).
  • Increasing, Decreasing the Size
  • and Copy of an Array
  • Multi-Dimensional Arrays

Command-Line Arguments

  • What is a Command-Line Argument?
  • Java Application with Command-Line
  • Arguments
  • Conversion of Command-Line Arguments
  • Passing Command-Line Arguments
  • Using methods (Static , Non Static)

Integrated Development Environment

  • Using various Editors
  • Program Compilation, Execution in Editor
  • Using Eclipse IDE
  • Project Set Up
  • Source File Generation
  • Application Compilation and Run
  • Difference between C and C++ with Java

Object Oriented Programming

  • Procedural Vs Object Oriented Program
  • Different type of Program Procedural Vs
  • Object Oriented.
  • Top Down Vs Bottom Up Approach.
  • Introduction to Object Oriented
  • Programming
  • Abstraction, Encapsulation, Inheritance,
  • Polymorphism.
  • Introduction to Classes and Objects
  • Custom Class Definition
  • Instance and Static Variables
  • Different ways to create Object Instance

Types of Class

  • Instance Variable and it’s role in a Class
  • Constructors, types of Constructor,
  • Constructor Rule, Constructor
  • Overloading.
  • Static Variable and it’s use.
  • Methods and their behavior.
  • Constructor vs Methods
  • Constructors
  • “this” Keyword.
  • Java Access Modifiers ( and Specifiers)
  • Explanation of psvm() , sopl()

Inner Class

  • First View of Inner Class
  • Outer Class Access
  • Types of Inner Class

Inheritance

  • A Little knowledge on Inheritance
  • Sub-Classes
  • Object Classes
  • Constructor Calling Chain
  • The use of “super” Keyword
  • The use of “private” keyword inheritance.
  • Reference Casting

Abstract Classes and Inheritance

  • Introduction to Abstract Methods,
  • Abstract Classes and Interface
  • Interface as a Type
  • Interface v/s Abstract Class
  • Interface Definition
  • Interface Implementation
  • Multiple Interfaces’ Implementation
  • Interfaces’ Inheritance
  • How to create object of Interface

Polymorphism

  • Introduction to Polymorphism
  • Types of Polymorphism
  • Overloading Methods
  • Overriding Methods
  • Hiding Methods
  • Final Class and Method
  • Polymorphic Behaviour in Java
  • Benefits of Polymorphism
  • “Is-A” vs “Has-A”
  • Association Vs Aggregation

Package

  • First look into Packages
  • Benefits of Packages
  • Package Creation and Use
  • First look into Classpath
  • Classpath Setting
  • Class Import, Package Import
  • Role of public, protected, default
  • and private w.r.t package
  • Namespace Management
  • Package vs. Header File
  • Creating and Using the Sub Package
  • Sources and Class Files Management
  • Using Predefined Lang Package & other
  • Java.lang Hierarchy
  • Object class and using toString(), equals(),
  • hashCode(), clone(), finalize() etc
  • Using Runtime Class, Process Class to play
  • music, video from Java Program
  • Primitives and Wrapper Class
  • Math Class, String, StringBuffer, StringBuilder Class
  • String Constant Pool, Various usage and methods of String,
  • StringBuffer, StringBuilder, Wrapper Classes
  • System Class using gc(), exit(), etc.
  • Atuo boxing and Auto unboxing
  • Static import, Instanceof operator
  • Enum and its use in Java
  • Working with jar

Garbage Collection

  • Garbage Collection Introduction
  • Advantages of Garbage Collection
  • Garbage Collection Procedure
  • Java API

Exception Handling

  • Introduction to Exceptions
  • Effects of Exceptions
  • Exception Handling Mechanism
  • Try,catch,finally blocks
  • Rules of Exception Handling
  • Exception class Hierarchy, Checked &
  • Unchecked Exception
  • Throw & throws keyword
  • Custom Exception Class
  • Chained Exception
  • Resource handling & multiple exception classes.

Multithreading

  • Introduction
  • Advantages of threading
  • Creating a Thread by inheriting
  • Thread class, Run() and start() method.
  • Constructor of Thread Class
  • Various Method of Thread Class
  • Runnable Interface Implementation
  • Thread Group, Thread States and Priorities
  • Synchronization method, block
  • Class & Object Level Lock
  • Deadlock & its Prevention
  • Inter thread Synchronization
  • Life Cycle of Thread
  • Deprecated methods : stop(), suspend(), resume(), etc

GUI (Graphical User Interface)

  • Applet, AWT, Event Handling
  • Introduction & Advantage of Applet
  • How to create and run an Applet in browser and Life cycle of Applet
  •  Using Graphics, Color, Font and other
  • classes in Applet to draw Shapes, String, and Images
  • Creating Banner in Applet and AppletContext interface
  • Using AudioClip interfaces to play music 
  • AWT Hierarchy
  • Component classes like Button,TextArea, TextField, Checkbox, Label etc
  • Using Container classes line Applet,
  • Panel, Frame, Window, Dialog(Open & Save Dialog)
  • Using Layout Manager to organize component on a container
  • Using Borderss, Menus, Toolbars, Dialogs
  •  Event Listeners
  • Using Event in Applet & Event Handling
  • Adaptor Classes

Input Output Streams

  • I/O Stream – Introduction
  • Java I/O Stream
  • Types of Streams and Standard I/O Streams
  • Stream Class Hierarchy
  • Using File Class
  • Copy and Paste the content of a file.
  • Byte Streams vs Character Streams
  • Text File vs Binary File
  • Character Reading from Keyboard by
  • InputStreamReader
  • Reading a Line/String from Keyboard by
  • BufferedReader
  • Using Data Streams to read/write
  • PrintStream vs PrintWriter
  • Using StreamTokenizer and
  • RandomAccessFile.

Networking

  •  Networking Basics
  • What is IP Address, Protocol and Ports
  • What is Client/Server Architecture
  • What is Sockets
  • INetAddress class, ServerSocket, MultiCastSocket class and Socket Class
  • DatagramSocket and DatagramPacket
  • URL & URLConnection class
  • Creating chat application

JDBC (JAVA Database Connection)

  • Introduction to JDBC
  • Databases and Drivers
  • Types of Driver
  • Loading a driver class file
  • Establishing the Connection to different
  • Database with different Driver.
  • Executing SQL queries by ResultSet,
  • Statements , Prepared Statement interface.
  • Using CallableStatement.
  • Transaction Management & BatchUpdate.

Syllabus of Advanced Java

 

Introduction to Advanced Java

 

  • Java Editions and Overview
  • Need of Advanced Java
  • Website and Webpage
  • Web Terminologies
  • Web Application Architecture
  • Prerequisite of Core Java

Introduction to HTML

HTML

  • Introduction to HTML
  • Tags and Attributes
  • Adding Image, Hyperlink, Table, Form and List
  • Scrolling Text and Image
  • Playing Audio and Video
  • Tooltip, datalist

CSS

  • Introduction to CSS
  • Advantages and Disadvantages of CSS
  • Types of CSS, Inline CSS, Internal CSS, External CSS
  • Different Types of Selector
  • Element Selector, Class Selector and Id Selector
  • Creating Template using CSS

JavaScript

  • Introduction to JavaScript
  • Advantages of JavaScript
  • Types of JavaScript
  • Internal JavaScript

SQL

  • Introduction to SQL
  • SQL Sublanguages (DDL, DML, DRL, TCL and DCL)
  • Constraints, Join and Sub Query
  • Indexes, Views, Sequences and Synonyms
  • Cursors, Stored Procedures and Functions
  • Triggers

JDBC (Java Database Connection)

  • Introduction to JDBC
  • Types of Drivers
  • Steps required to develop and Execute JDBC Application
  • JDBC Statement Object Statement
  • Prepared Statement and Callable Statement
  • Result Set, Read Only Result Set
  • Updatable Result Set and Forward Only Result Set
  • Scrollable Result Set
  • Database Metadata and Result Set Metadata
  • Batch Updation
  • Transaction Management
  • Adding and Retrieving BLOB and CLOB Objects

Servlet

  • Introduction to Servlet
  • Different ways to develop servlet program
  • Develop and Access First Servlet Application in Tomcat Web Server
  • Servlet Life Cycle
  • Reading HTML Form Data in Servlet
  • External JavaScript
  • Working with User defined and Built-in Function
  • Reading HTML Element in JavaScript
  • Form Validation
  • File Uploading and File Downloading
  • Servlet Config. and Servlet Context
  • Servlet Chaining, Forward Model and Include Model
  • Cross Context and Cross Server Communication
  • Session Tracking Mechanisms and  URL-Rewriting
  • Hidden Form Fields, Cookies, Http Session, Filters
  • Listeners
  • Annotation

JSP

  • Introduction to JSP
  • Advantages of JSP over Servlet
  • JSP Life Cycle
  • JSP Implicit Objects and Explicit Objects
  • JSP Directives, page, include and taglib
  • JSP Scripting Elements
  •  JSP Chaining
  • Java Bean and JSP Communication
  • Develop Java Code less JSP using Action
  • tag, EL, JSTL and Custom tag

Web Application Security

  • Cross Site Scripting
  • Session Fixation
  • Cross Site Request Forgery
  • Security Misconfiguration
  • Insecure Cryptographic Storage
  • SQL Injection
  • Failure to restrict URL Access
  • Salt Hashing

Report Generation

  • PDF File
  • Excel File
  • CSV File

Collections Framework

  • Introduction to Collections
  • Difference between Array and Collection List, Set and Map
  • Reading Elements From Collection using Cursor

MVC

  • Introduction to MVC
  • Different Types of Logic in Java based Web Application
  • Advantages and Disadvantages of MVC Architecture
  • MVC pattern Layer: Model, View and Controller
  • Create Login and Registration Module in MVC

Basics of Spring

  • Introduction to Spring
  • Spring Modules
  • Inversion of Control
  • Dependency Injection
  • Develop and Execute Spring Application in Eclipse IDE

Basics of Hibernate

  • Introduction to Hibernate
  • Understanding First Hibernate Application
  • Develop and Execute Hibernate Application in Eclipse IDE

Basics of Web Services

  • Introduction to Web Service
  • Types of Web Service
  • SOAP Web Service
  • RESTful Web Service
  • Develop and Execute SOAP and RESTful Web Service based Application

 

C/C++

C language is a universal procedural programming language on which certain other programming languages like Perl, PHP, Python and objective C have been borrowed. C is the general-purpose language with ability to draw the expressions, data flow, and data structures. This language is available on a wide range of platforms from embedded microcontrollers to supercomputers. It also has the feature in which more than one assignment can be performed in a single statement. Almost all the OS programs such as Windows, UNIX, and Linux are written by C language.  C++ is a general-purpose object-oriented programming (OOP) language. It is considered to be an intermediate-level language, as it encapsulates both high- and low-level language features. C++ is one of the most popular languages primarily utilized with system/application software, drivers, client-server applications and embedded firmware.It is true! The language is important to every branch of students whether it may be engineering, master’s degree or any other course. Apart from the colleges, there are many training institutes, which offer this course. Nxeone is one among those. Nxeone is providing the platform of every class of students to master the C and C++ language.

Syllabus of C

 

Feature of C

  • Interactivity
  • Flexibility
  • Modularity
  • Efficiency and Effectiveness
  • Portability
  • Reliability

Introduction to Programming

  • Program and Programming
  • Programming Languages
  • Types of software’s
  • Operating Systems
  • Compiler, Interpreter, Loader and Linker

Fundamentals in C

  • History of ‘C’
  • A Simple C Program
  • Program execution phases
  • Backslash character constants
  • Character set, Constants and Format specifiers
  • Identifiers, Keywords and Variables
  • Declaration of Variable
  • Assigning Values to Variables
  • Initialization and Comments
  • Basic Structure of a ‘C’ program

Data Types

  • Dealing with each data types
  • Memory representation of each type
  •  Modifiers and Format specifiers

Operators and Expressions

  • Arithmetic operators
  • Increment and decrement operators
  • Relational operators
  • Logical operators
  • The assignment operators
  • The conditional operator
  • The size of operator
  • The comma operator
  • Type casting operator

Input and Output Operation

  • Reading / writing character
  • Input/Output Library Functions
  • Unformatted I/O Functions
  • Single Character Input/Output
  • String Input/Output
  • Formatted I/O Functions
  • printf() and scanf() Width Specifier

Decision Making and Looping

  • The if – else statements
  • The for Statements
  • Nesting of if –else statements
  • The switch statements
  • The while and do while statements

Function

  • What is function?
  • Why function?
  • Advantages of using functions
  • Function Prototype
  • Defining a function
  • Calling a function
  • Return statement
  • Types of functions
  • Nested functions
  • Recursion
  • Library Function
  • Local and global variables

Array

  • One dimensional arrays
  • Declaration of one dimensional arrays
  • Initialization of one dimensional arrays
  • Accessing element of one dimensional arrays
  • Reading and displaying elements
  • Two dimensional arrays
  • Declaration of two dimensional arrays
  • Initialization of two dimensional arrays
  • Accessing element of two dimensional arrays
  • Reading and displaying elements

Strings

  • strings versus character arrays
  • Initializing strings
  • Reading string
  • Displaying string
  • The %s format specifier
  • The gets() and puts() functions
  • string handling functions
  • Two-dimensional character arrays or array of string

Pointer

  • Understanding Pointers
  • Declaration of Pointer Variables
  • Pointer Expressions
  • Pointer and Arrays
  • String Pointer
  • Pointers and character String
  • Pointers to Functions
  • Pointers and Structures
  • Advance pointer Concept

Storage Class

  • Types of storage class
  • Scoping rules
  • Dealing with all storage classes

Structure and Union

  • Defining a Structure
  • Declaration of Structure Variables
  • Reading and Displaying Structure Variable
  • Benefit of Structure
  • Storage of Structures in Memory
  • Size of Structure
  • Arrays of Structures
  • Structures and Functions
  • Defining Unions ,Enumeration and typedef

Dynamic Memory Allocation

  • Introduction to Dynamic Memory Allocation
  • Malloc , calloc , Realloc free
  • Concepts of Linked Lists
  • Creating a Linked Lists
  • Inserting /Deleting an item
  • Application of Linked Lists

The Preprocessor

  • What is preprocessing?
  • Macro Substitution
  • Conditional compilation
  • File Inclusion
  • Compiler Control Directives

File Management in C

  • Introduction to File Management
  • File management I/O functions
  • Opening /Closing a File
  • Input /Output Operations on Files
  • Random Access Files
  • Error Handling During I/O Operations

Data Structure with C

  • Introduction of link List & Array
  • Stack with Array and liked list
  • Queue with Array and liked list
  • Sorting like Bubble , Insertion ,Quicksort , Mergesort etc
  • Searching

 

Syllabus of C++

 

Feature of C++

  • Interactivity
  • Flexibility
  • Modularity
  • Efficiency and Effectiveness
  • Portability
  • Reliability

Introduction to C++

  • History of ‘C++’
  • Understanding Requirement : why c ++
  • C vs C++
  • Advantage of OOP
  • Software and Hardware for c++
  • Compling and Linking

An Overview of C++

  • Basic Structure of a ‘C++’ program
  • Keywords and Constants
  • Data Types , Variables And Arrays
  • Operators

Operators and Expressions

  • Arithmetic operators
  • Increment and decrement operators
  • Relational operators and Logical operators
  • The assignment operators and conditional operator
  • The size of operator and comma operator
  • Type casting operator

Input and Output Operation

  • Reading / writing character
  • Input/Output Library Functions
  • Formatted I/O Functions and Unformatted I/O Functions
  • String Input/Output

Decision Making and Looping

  • The if – else statements
  • Nesting of if –else statements
  • The switch statements
  • The for Statements
  • The while and do while statements
  • Conditional Control Statements
  • Break, continue, goto , exit and return

Function

  • What is function?
  • Advantages of using functions
  • Functions Prototyping
  • Actual and Formal Arguments
  • Call /Return By Reference
  • Return by pointer mechanism
  • Inline Functions and Function overloading
  • Friend and Virtual Functions

Introduction to OOPs

  • C structure vs C++ structure
  • C++ class vs C++ structure
  • Class and Object
  • Encapsulation and Abstraction
  • Polymorphism and Inheritance
  • Message Passing

Classes and Objects

  • Declaring / defining classes
  • Data members and member functions
  • Access specifiers : public and private and protected
  • Creating objects of a class
  • Defining Member Functions
  • Arrays within a Class
  • Memory allocations for Objects
  • Pointers to Members and Pointers to object
  • Implicit this pointer
  • Static data members and static objects
  • Static member functions
  • Passing objects to a member function
  • Returning objects from a member function
  • Nested classes and Local classes
  • The const member functions

Constructors and Destructors

  • Defining Constructor
  • Default Constructor
  • Parameterized /copy/Dynamic Constructors
  • Multiple Constructors in a Class
  • Dynamic initialization of objects
  • Constructing Two –dimensional Arrays
  • Destructors and Defining Destructor
  • Comparing Constructor Member Function
  • Constructor Overloading
  • Local vs Global object

Operator Overloading

  • Need of Overloading
  • Defining Operator
  • Operator Overloading Rules
  • Overloading Binary Operators
  • Overloading Binary Operators using Friend Function
  • Overloading Other Operators
  • Overloading Unary /Binary operators
  • Overloading Unary Operators using Friend Function
  • Manipulations of String Using Operators
  • Type Conversions

Inheritance: Extending Classes

  • What is inheritance?
  • Single Level, Multilevel, Multiple, Hierarchical and Hybrid  Inheritances
  • Name ambiguities under multiple inheritance
  • Multipath Inheritance
  • Virtual Base Classes
  • Constructor and Destructor in Inheritance
  • Common constructor
  • Delegation
  • What is composition?
  • Defining Derived Classes and Abstract Classes
  • Member Classes : Nesting of Classes

Polymorphism, Virtual Functions and Pointers

  • About polymorphism
  • Compile time and runtime polymorphism
  • Virtual functions and Virtual destructor
  • Pure virtual function and abstract base class
  • What is RTTI (Run-time Type Information)?
  • VPTR and VTABLE
  • Difference between member Function Overloading and Overriding
  • Object slicing
  • Constructor and virtual function
  • Destructor with virtual function
  • Pointers to Objects
  • This pointer and Pointer to Derived Classes

Exception Handling

  • What is an exception?
  • Exception handling
  • Throwing an exception
  • Catching an exception
  • Trying for an exception
  • Order of catch blocks
  • Catching all exceptions
  • Nested try blocks
  • Rethrowing an exception
  • Exception specifications
  • What is stack unwinding?
  • Exceptions in ctors and dtors
  • The unexpected() and terminate() function
  • The standard exceptions
  • Creating our own exception classes

Input and Output in C++

  • Streams –Hierarchy of I/O Streams
  • Fundamental stream classes and objects
  • Standard input and output functions
  • Unformatted /Formatted I/O Operations

File Management in C++

  • Introductions to File Managements
  • Hierarchy of File Streams
  • Using constructor method
  • Object as file stream reader and writer
  • Opening /Closing a File
  • Input/Output Operations on Files
  • Error Handling During I/O Operations
  • Command Line Arguments
  • Both sequential and random file accessing mechanism.
  • Different error handling mechanism in files

Working with String in C++

  • Different C string handling library
  • string handling using relational operator
  • Different string handling function

Template

  • What is generic programming?
  • Introduction to Template
  • What are function templates?
  • Class Template
  • Overloading of Template Function
  • Argument deduction and template parameters
  • What are class templates?
  • Specializations of class templates

Data Structures

  • Introduction
  • Single, Doubly and Circular Linked List
  • Stacks and Queues

Database Operation in C++

  • What is database?
  • SQL for relational database.
  • About API connect to database.
  • Database connectivity MySQL.
  • Database manipulation using C++

Basic Computer Courses

It is the most widely used programming language with a wide range of application. Java was released in the year 1995 by Sun Microsystems. It is used for the development of the Internet of Things, APIs, e-commerce websites, financial trading platforms, scientific applications and a lot more. It is Java that powers Android. Java is present in every aspect of the digital environment. Learning Java makes it easy to learn other languages if you want to broaden your horizons.

 

Allocation of total hours for each chapter

 

S.No Chapter Theory Tutorial Practical
Hours Hours Hours
1 Knowing computer 1 1 1
2 Operating Computer using GUI Based Operating System 1.5 0 4
3 Understanding Word Processing 1.5 1 5
4 Using Spreadsheet 1 1 4
5 Introduction to Internet, WWW and web browsers 2 0 4
6 Communications and Collaboration 1 0 2
7 Making small presentation 1 1 1
8 Financial Literacy for banking Scheme and Applications 1 0 1
Total Hours 10 4 22

 

Syllabus of Basic Computer

 

Knowing Computer

  • What is Computer?
  • Basic Applications of Computer
  • Components of Computer System
  • What is Central Processing Unit (CPU)?
  • What is VDU, Keyboard and Mouse?
  • What are input/output devices?
  • What is Computer Memory?
  • Concepts of Hardware and Software
  • Concept of Computing,
  • Data and Information
  • Applications of IECT
  • Connecting keyboard, mouse, monitor and printer to CPU and checking power supply.

Operating Computer using GUI Based OS

  • What is an Operating System?
  • Basics of Popular Operating Systems
  • The User Interface, Using Mouse
  • Using right Button of the Mouse and Moving Icons on the screen
  • Using Menu and Menu-selection
  • Use of Common Icons, Status Bar
  • Running an Application
  • Viewing of File
  • Folders and Directories
  • Creating and Renaming of files and folders
  • Opening and closing of different Windows
  • Using help
  • Creating Shortcuts
  • Basics of OS Setup
  • Common utilities

Understanding Word Processing

  • Word Processing Basics
  • Opening and Closing of documents
  • Text creation and Manipulation
  • Formatting of text; Table handling
  • Spell check, language setting and thesaurus
  • Printing of word document

Using Spreadsheet

  • Basics of Spreadsheet
  • Manipulation of cells
  • Formulas and Functions
  • Editing of Spreadsheet
  • printing of Spreadsheet

Introduction to Internet, www and Web Browser

  • Basic of Computer networks
  • LAN, WAN; Concept of Internet
  • Applications of Internet
  • connecting to internet
  • What is ISP
  • Knowing the Internet
  • Basics of internet connectivity related troubleshooting
  • World Wide Web
  • Web Browsing software
  • Search Engines
  • Understanding URL
  • Domain name
  • IP Address
  • Using e-governance website

Communications & Collaboration

  • Basics of electronic mail
  • Getting an email account;
  • Sending and receiving emails;
  • Accessing sent emails;
  • Using Emails;
  • Document collaboration;
  • Instant Messaging;
  • Netiquettes

Making Small Presentation

  • Basics of presentation software
  • Creating Presentation
  • Preparation and Presentation of slides
  • Slide Show; Taking printouts of presentation / handouts.

Introduction to Internet, www and Web Browser

  • Basic of Computer networks
  • LAN, WAN; Concept of Internet
  • Applications of Internet
  • connecting to internet
  • What is ISP
  • Knowing the Internet
  • Basics of internet connectivity related troubleshooting
  • World Wide Web
  • Web Browsing software
  • Search Engines
  • Understanding URL
  • Domain name
  • IP Address
  • Using e-governance website

Communications & Collaboration

  • Basics of electronic mail
  • Getting an email account;
  • Sending and receiving emails;
  • Accessing sent emails;
  • Using Emails;
  • Document collaboration;
  • Instant Messaging;
  • Netiquettes

Making Small Presentation

  • Basics of presentation software
  • Creating Presentation
  • Preparation and Presentation of slides
  • Slide Show; Taking printouts of presentation / handouts.