School Management System Real Time Java Project

School Management System is a Java based Windows Application developed for different Schools and colleges.

Modules included in this project are below:

  1. Admissions Module
  2. Attendance Module
  3. Examinations Module
  4. Staff Management Module
  5. Library Module
  6. Fee Management Module
  7. Accounts Module
  8. Reports Module

Output Screens of this project are below:

Login Page:

Admin and School Management can login through this login Page by entering user name and password

School Management System Login Page

Home Page View

After logged into the system, admin can have able to see and manage all menu options like admissions, attendence, examinations, staff, library, fee, accounts and reports.

Basic page where admin can add student information, Parent Guardian and Academic details

Home Page View
Admissions Page View

Adminssions page has several fields like Admission number, Date, First Name, Last Name, Father Name, Mothers Name, Date of Birth,  Gender, Class, Section, Contact Number, Identification Marks, Fee Perticulars, Date of Payment, Remarks, etc..

Adminissions Page View
Attendance Page View

Attendance Page View
Examinations Page View

Examinations Page View
Staff Management Page View

Staff Management Page View
Library Page View

Here we can manage Library book information with the help of availability of book and issues books.
Book list contains book name, Author, Total number of books, number of books issued, number of books available

Library Page View
Fee Management Page View

Here we can manage all fee details of the students, Can manage & update all students fee details using the below fields:
1) Fathers Name
2) Mother Name
3) Class
4) Section
5) Contact Number
6) Total Fee
7) Paid Term Wise
8) Mode of Payment
9) Payment Due

Fee Management Page View
Accounts Page View

Welcome to the Accounts Page Section:
In this accounts section we can able to manage money related info for books, accesories, salaries and other miscellaneous details

Accounts Page View
Reports Page View

Welcome to the reports Page Section:
Here reports can be generated by using the search option for selecting the class, Name, Roll Number/Lecturer ID, Admission Number or using the search box for internal search.
Once the Search operation is done, we can find the reports to view, upload and print purpose.

Reports Page View

SAP XI/PI Training & Real Time Projects

 SAP XI/PI Training CATALOG 

In this course you will explore the architecture of SAP PI, understand different components of PI. 

At the end of this training you would be able to 

  • Understand Key Integration Concepts
  • What is SAP PI
  • How SAP PI Helps in Integration
  • Understand SAP PI Features and Functions
  • Understand SAP PI Monitoring Features
  • How Messages are processed in SAP PI
  • Develop Interface using SAP PI (Message Mapping)
  • Configure different Adapters

Overview:

  • Introduction to SAP Process Integration
  • Overview of SAP NetWeaver Architecture and Features 

The System Landscape Directory (SLD) concepts:

Landscape:

  • Technical Systems
  • Landscapes
  • Business Systems

Software Catalog:

  • Products
  • Software Components

Development:

  • Name Reservation

Manage Name Reservations for NetWeaver Development

  • CIM Instances/CIM Classes

View and Maintain data on CIM level 

Enterprise Services Repository:

  • Namespace Definition 

Interface Objects

  • Data Type
  • Message Type
  • Service Interface (Message Interface)
  • External Definition
  • Context Object
  • Data Type Enhancement
  • Fault Message Type 

Mapping Objects

  • Message Mapping
  • Operation Mapping (Interface Mapping)
  • Mapping Template
  • Imported Archive
  • Function Library 

Adapter Objects

  • Adapter Metadata
  • Communication Channel Template 

Version Creation

  • Change List 

Work Areas

  • Software Component Version
  • Namespace 

Process Integration Scenario Objects

  • Process Integration Scenario
  • Action
  • Integration Process
  • Monitoring Process
  • Step Group
  • Alert Category 

Design Menu – TOOLS options

  • Import External Definitions
  • Import Design Objects
  • Export Design Objects
  • Transfer Design Objects
  • Find Transports
  • Java Proxy Generation 

Design Menu – Environment options

  • Integration Builder (Configuration)
  • Cache Notifications
  • Clear SLD Data Cache

Integration Builder – Integration Directory 

ICO: Integrated Configuration Object

Collaboration Profile:

  • Party

Communication Component

  • Business System
  • Business Component (Business Service)
  • Integration Process
  • Communication Channel
  • Process Component

Collaboration Agreement:

  • Sender Agreement
  • Receiver Agreement
  • Direct Connection
  • Integrated Configuration 

Configuration Objects:

  • Receiver Determination
  • Receiver Rule
  • Interface Determination
  • Value Mapping Group 

Administration:

  • Configuration Scenario
  • Folder
  • Change List 

Configuration and Monitoring

Runtime Workbench

  • Component Monitoring
  • Message Monitoring
  • End-to-End Monitoring
  • Performance Monitoring
  • Index Administration
  • Configuration
  • Alert Configuration
  • Alert Inbox
  • Cache Monitoring 

Adapters:

  • File
  • JDBC
  • JMS
  • MAIL
  • RFC
  • SOAP
  • IDOC
  • HTTP
  • BC
  • CIDX
  • RNIF
  • RNIF11
  • WS
  • Marketplace 

Descriptive Information of PI message processing: 

Messaging:

  • SAP PI Pipeline Example for an Asynchronous Scenario.
  • Introducing the scenario
  • PI messages: structure and transfer to the pipeline
  • Logical Routing
  • Mapping and technical Routing
  • Message mapping

Monitoring:

  • Runtime Workbench
  • Runtime Workbench Overview

BPM:

  • Business Process Management
  • BPM Overview
  • ccBPM: Designing and Configuring Integration Processes
  • BPM Runtime

DEMOs On:

Scenarios:

  • File to File (XML),
  • File to File (FCC),
  • File to IDoc/RFC,
  • RFC/IDoc to File,
  • JDBC to File
  • JDBC to RFC
  • File to RFC
  • SOAP to PROXY
  • PROXY to SOAP
  • HTTP to PROXY
  • BPM Scenario

SAP BW Real Time Projects and Scenarios

BW101 – SAP BW Starter Kit

Online Course Details

What should you expect to learn?

Introduction to DATA

  • Understanding data from an IT perspective
  • BIG DATA – a small discussion

Data storage and retrieval basics in IT systems

  • Data Storage: Files to Tables
  • Tables > Fields & Tuples > Datatypes
  • Building Relationships with data(table joins)
  • The ER model

OLTP and OLAP

  • OLTP system basics
  • OLAP system basics
  • OLTP Vs OLAP (differences and complications)

Introduction to Data-Warehousing

  • Datawarehousing techniques and methodologies (a discussion)
  • Datawarehousing Concepts

The STAR Schema
Snowflake Schema
The Extended STAR schema

Introduction to SAP Business Warehouse

  • Landscape & Architecture
  • Dismantling the Warehouse – Top down approach

Building the SAP Business Warehouse

  • Building Blocks of SAP BW

InfoAreas / InfoObjects / DataSources / PSA / DSOs / InfoCubes / Transformations

  • Defining your Business Warehouse

Business definition / Identification of Business Data / Defining Business Reports

  • Start Building – Discuss Why / Where / When / How for each of the items below

Create InfoArea

Create InfoObectCatalogs

Create InfoObjects

Create Datasources(flat file)

Create DSO(s)

Create Cube(s)

Transformations to the InfoProviders

Load Master and Transaction Data from Flat files

New: Surrogate IDs and Dimension IDs – A discussion

New:Attribute Change Run

                                New: Implement Delta mechanism (flat-file to DSO to Cube)

New: Create a simple Bex report based on the InfoProviders created so far

Explore and Experiment, then Discuss the Building Blocks

  • Explore types, options, settingsand usage scenarios

InfoObjects

InfoProviders

InfoCubes

DataStoreObjects

Multiproviders

RemoteCube

Transformations

DTPs

SAP Modules and their interaction

  • Source Systems
  • Datasources in the context of source systems
  • SAP ECC and ERP an important discussion
  • Understanding SAP FI and SD from a BW reporting perspective
  •  Familiarize yourself with FI & SD tables and Datasources

SAP Business Content

  • Identify Business Content Objects for FI & SD
  • Identify Datasources delivered by SAP for FI & SD
  • Discuss the Business Content objects discovered
  • Install Standard objects and activate them

Filling your Data Warehouse with SAP Business Data

  • Extract FI data using Standard Extraction

Master Data Extraction

Transaction Data extraction

  •  Extract SD data using LOS Extraction

                                Understanding LOS extraction benefits and necessities

LO Cockpit Overview

Data Extraction Full Load and Delta mechanisms

  • A note and an exercise on Generic Extraction

Maintaining your SAP Business Warehouse

  • Administering the InfoCubes
  • Administering the DSOs
  • PSA Maintenance
  • Automation: Creating and Monitoring the Process Chains

Explore SAP BW Data

  • BEx Query Designer
  • Query Design Elements (RKFs, CKFs, Variables, Conditions, Exceptions etc)
  • RRI

Web Application Designer

  •                 BEx Analyzer
  •                 Query Monitor (RSRT)
  •                 Build a Complex Report with ageing, variables, RKFs and CKFs etc

Performance Optimization

  • Understanding Performance Top-Down and Bottom-Up
  • Investigating Performance – The Approach
  • Load Performance Optimization

Building it right
Re-building it if required

  • Query Performance Optimization

BW Aggregates
Partitioning
BW Indexes
Your Eyes and Ears – BI Statistics
BI Accelerator (meet its Big brother SAP HANA)

  • Advanced Data Warehousing(Discussion and Debate on usage and pros and cons)

                Study of Internal Structures and their workings

                                Cubes and Dimensions (SIDs, DIMIDs)

                                DSO mechanics (Delta Management with Active, Change-log tables)

                                InfoSets& Virtual Providers

                                Time Dependent Master Data Management

                                Extracting Hierarchies for ECC Sets (GS01, GS02, GS03 etc)

QlikView Real Time Projects and Scenarios

Qlik Training Module

1)    Qlikview  Server

  1. Qlikview Server components
  • QMC
  1. a)Technical brief about Qlikview Architecture
  • Webserver
  • QVS
  • Qlikview Desktop
  1. Services installed on Qlikview Server
  • Qlikview Directory Service Connector
  • Qlikview Distribution Service
  • Qlikview Management Service
  • Qlikview Server
  • Qlikview Webserver
  1. Qlikview Management Console
  • Mount a folder for deploying Qlikview files (User Document)
  • Connection to Active directory, LPAD
  • Document Reload
  • Licenses in Qlikview
  • Providing licenses to User
  • To add or remove user from document security tab
  • Availability of document to users
  1. a)Access Point
  2. b)Mobile / Tablet
  • Timeout settings for Qlikview document
  • Email alerts to send to users if reload fails
  • Check Qlikview Active Users
  • Authentication for Qlikview Users
  • Reload Tasks view
  1. Qlikview Logs
  • Qlikview Server log
  • Webserver log
  • Directory connector log
  • QMC log
  1. Qlikview Webserver
  • Access point
  • Single Sign On
  1. Ports to run Qlikview services

2)    Data Modelling

  • Dimensions
  • Facts
  • Schemas
  • Best Practices
  • Link table vs concatenate
  • Normalization

 

3)    Qlikview Introduction

  • Qlikview features
  • Value creation
  • Story telling
  • How to think while designing apps?
  • Concepts of BI
  • Tools (Tableau vs Qlik), power BI

 

4)    QlikviewImplementing Architecture

1)      Database Connectivity

  • SQL Queries
  • SQL Tables
  • ODBC/JDBC
  • DSN Creation

2)       Qlikview Memory Management

3)      QVD Layer

  • Database connection in Qlikview
  • Fetching Data from Qlikview
  • Generations of QVD
  • Fetch data from other data sources in Qlik

4)      Transformation Layer

  • Identifying Facts and dimensions
  • Creation of Data Model
  • Scripting techniques
  • Optimization in scripting
  • Applying Business logic
  • Creating Calendar
  • Types of Load

5)      Visualization

  • Identifying KPIS for the business
  • Layouts and colours
  • Bookmark
  • Extensions

6)      Deployment Process

 

5)    Set Analysis and Functions

1)      Point in Time Reporting

  • Current Year
  • Previous Year
  • YTD
  • MTD

 

2)      Chart Function

  • Range
  • Aggr
  • Class
  • Pick
  • Above
  • Below

 

3)      Scripting Functions

  • Control Statement
  1. a)If else
  2. b)For loop
  3. c)Switch Case
  • Other Functions
  1. a)Apply Map
  2. b)Match
  3. c)Look up
  4. d)Wild match
  5. e)Interval match
  6. f)FirstsortedValue
  7. g)FieldValue
  8. h)Exists
  9. i)Isnull
  10. j)Date functions
  11. k)Time functions
  12. l)Aggregated functions
  13. m)Peek
  14. n)Previous
  15. o)Rec no
  16. p)Row no

 

  • Techniques
  1. a)Joins
  2. b)Group By
  3. c)Order By
  4. d)Keep
  5. e)Concatenation
  6. f)Variables
  7. g)Let
  8. h)Set
  • Pnl Template Explanation

 

6)    Qlik Project Management Process

1)      Business Understanding – Ground work to be done before project

  • Domain/Sector Understanding
  • Understanding the specific processes which generate the required data (for e.g. Billing Process in a hospital)
  • Understanding the technology (ERP sector) which capture data from a business stand point
  • Clearly understanding the KPIs and the business terminology

2)      Requirement Gathering

  • Reports
  • KPIs
  • Presentations
  • Email
  • Daily/Monthly/YTD views
  • Dashboards
  • User Role Specific
  • Document Template

3)      Technical Architecture

  • Server configuration
  • Ports
  • Authentication

4)      Development Governance

  • Status Reports – Weekly (formats attached)
  • Tracking the project plan
  • Timesheet

5)      Testing

  • Unit Testing – at the time of development
  • Test Cases formats

6)      UAT

7)      User Presentation/Demos

8)      KT and Adoption Techniques and Support related

  • Detailing of each charts – Dashboard
  • CBT

 

7)    Qlik Visualization

1)      Qlik Visualization Concepts

  • Variables
  • Example Chart with all properties used including benchmarking
  • Qlik Properties
  • Sample Application
  • Extensions (deployment etc.) in Qliksense
  • Document properties & Sheet properties
  • Sample Application for Both Qlikview/Qliksense

2)      Things to check

  • Spell check
  • Font Consistency
  • Colour
  • Layout Consistency
  • Chart Text

 

 

8)    Optimization and Best Practices

  • Scripting End
  • Visualization End
  • Server Performance Side
  • Performance Turning
  • Qlikview Analyser
  • QlikView Governance Dashboard

 

 

 

9)    Qlik Support and Bug Finding

Qlik community:

  1. What is Qlik community?
  2. How it is useful?
  3. How to register?

 

Branch.Qlik.com:

  1. What is Branch Qlik.com?
  2. How to use it and for what?

Support Track

Debugging Issues

 

Download Qlik Training Module

Data warehouse Concepts:

  •  Basics of Data Warehousing.
  • What is ETL. (DaraMerging, DataAggrygation, Datascrubbing, Data cleansing)
  • Data warehouse Architecture
  • Data mart

Dimensional Modeling Concepts:

  •  Introduction to Dimensional Modeling.
  • Conceptual Data Modeling, Logical Data Modeling, Physical Data Modeling
  • Dimensional table
  • Fact table
  • Star Schema
  • Snowflake Schema
  • Star schema Vs. Snowflake Schema
  • Fact Vs. Dimension table
  • Fact Vs. Aggregate Table
  • Types of Facts
  • Types of Fact tables
  • Types of Dimensions
  • Level of Granularity
  • Slowly Changing Dimensions( SCD )
  • Normalization De Normalization

QlikView Introduction:

  • What is QlikView?
  • Why QlikView is most effective than other BI Tools.
  • QlikView Architecture.
  • QlikView Components.
  • Qlikview Desktop Developer.
  • How data flows in QlikView.

Scripting:

  • Creating Etractor
  • Concatenate.
  • NoConcatenate
  • Auto Concatenate
  • Joins Vs Keep
  • About Synthetic keys.
  • About Circular references
  • About Set & Let
  • Mapping Load
  • Look up
  • Link Table
  • Binary Load
  • Exist  & Not Exist
  • Set Analysis
  • Incremental load
  • Partial load
  • Inline Load
  • Security
  • Section access
  • Interval match
  • Master Calendar
  • About qualify and unqualified
  • Basic Aggregation Functions.
  • String Function.
  • Counter Functions.
  • Advanced Aggregation.

Modeling:

  • Table Viewer.
  • Modeling Techniques and Best Practices.
  • Creating Star Schema
  • Creating SnowFlake Schema.

QVD File:

  • How to create a QVD File.
  • Reading data from QVD Files.
  • Storing QVD By Variable.

Incremental Load:

  • Insert.
  • Insert and Updates.
  • Incremental Load through a QVD File.
  • Preceding Load.

Hierarchies:

  • Drill Down group.
  • Cyclic Group WithExpressions.

QlikView -Set Analysis and Alternate State:

Transformations in QlikView:

  • User Preferences.
  • Document Properties.
  • Sheet Properties.
  • Sheet Objects:
  1. List Box.
  2. Statistic Box.
  3. Multi Box.
  4. Table Box.
  5. Charts.
  6. Input Box.
  7. Current Selections Box.
  8. Buttons.
  9. Text Object.
  10. Bookmark Object.

Other Features we provide:

  • Real Time Scenarios
  • Resume Preparation
  • Provide Sample Resumes
  • Interview FAQ’S
  • Conduction Mock Interviews
  • Class notes which is useful for who is trying for job.

Tableau Real Time Projects and Scenarios

Tableau Desktop Course Curriculum

1) Connecting to Database

  1. Connecting to Single Database, Defining Joins Filters.
  2. Connecting to Multiple Databases, Defining Joins, Filters.
  3. Connecting Database from Server

2) Extracting Data from Database

  1. Extracting Data from Single Database
  2. Extracting Data from Multiple Databases
  3. Updating Extracts
  4. Blending data from multiple Data Sources
  5. Publishing Extracts to Server.

3) Creating Reports

  1. Simple Report
  2. Charts
  3. Maps

4) Creating Calculations

  1. Simple Calculations
  2. Date Calculations
  3. Table Calculations
  4. String Calculations
  5. Parameters

5) Report Formatting

  1. Simple Formatting
  2. Conditional Formatting
  3. Conditional Tool-tip
  4. Conditional Shapes

6) Creating Dashboards

  1. Adding Sheets
  2. Defining Global Filters
  3. Layout Design
  4. Defining Drill Through
  5. Sheet Selection

7) Publishing, Scheduling & Securities

8) Advanced Reports Building – Real time Scenarios

9) Basics of Tableau Server