Amitava Majumder

Birati, Kolkata, India - 700051

Amitava Majumder photo

Featured

Amitava Majumder

IT Trainer

Birati, Kolkata, India - 700051.

38 Students taught

5.0

UrbanPro Rating

Details verified of Amitava Majumder

Identity

Education

Know how UrbanPro verifies Tutor details

Identity is verified based on matching the details uploaded by the Tutor with government databases.

Overview

I am an experienced Trainer and IT professional with over 10 years of experience in IT Sector and more than 5 years experience in tutoring students in various software technologies like Oracle (PL/SQL), C, C++, Java, Web Technologies, Computer Science/IT across School level students, college level students and working professionals who want to groom their career in IT and want to learn Software Technologies. So far, I have worked as a Senior Software Engineer for the Jubilant Retail, Keane (NTT-Data), TCS, System Solution and Total.

Languages Spoken

Hindi

Bengali

English

Education

Sathyabama Institute of Science and Technology (Deemed University), Chennai 2006

Bachelor of Engineering (B.E.)

Address

Birati, Kolkata, India - 700051

Verified Info

ID Verified

Education Verified

Phone Verified

Email Verified

Facebook Verified

Demo Class

No

Report this Profile

Is this listing inaccurate or duplicate? Any other problem?

Please tell us about the problem and we will fix it.

Please describe the problem that you see in this page.

Type the letters as shown below *

Please enter the letters as show below

C Language Classes Overview

C Language Classes

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in C Language Classes

8

Gallery (4)

Class 12 batch-1

CLASS XI-BATCH-1

CLASS-XII-BATCH-2

C++ Class

Reviews (23)

this is test message this is test message this is test message this is test message this is test message this is test message this is test message

5.0 out of 5.0 23 reviews

5.0/523
R
01 Jun, 2019

Ranit Bhowmick attended Class 12 Tuition

"Amitava is very attentive, very approachable and knowledgeable in the material that he taught. Amitava really helped my brother grow and glow in confidence, and for that we are thankful. "

P
24 Mar, 2019

Piyali Sengupta attended C Language

"Good support with us & good behavior. I would recommend to all.One of the most learned and experienced professors I ever came across, with great depth of knowledge in the subject and has a beautiful way to convey that knowledge to his students. "

S
30 Oct, 2017

Sandip Dutta attended Java Training

""I learned about JAVA programming from Amitava Sir. He taught us very sensitively. He always solved our doubts according to the course. He helped us in our course as a good friend, philosopher." "

M
13 Aug, 2017

Master Ritabrato Chatterjee . attended Java Training

""Today I stand upon the shoulder of a giant and am able to witness a far away light shining upon something which is still yet to brought under man's captivity, for the one who raised me to such an eccentricity is no one but the ones who stood by me in times of trouble, turmoil and hardships, the one who held my hand firmly, letting me rise to such a height and the one who rekindled the flame of my knowledge, so that one day I too might become a person like the one I referred and accepted as a key figure in my life". "

Have you attended any class with Amitava? Write a Review

Lessons (9)

What Is WorkTable In SQL Server?

What is WorkTable in SQL Server? USE AdventureWorks2014 GO SET STATISTICS IO ON GO SELECT * FROM Production.Product p CROSS JOIN Production.Product p1 GO If you run above query,...

19/12/2017
0 0
0
Rename The Logical Name Of SQL Server Database Files Using T-SQL

Rename the logical name of SQL Server database files using T-SQL: 1. Problem: SQL Server database files have two names: one is the logical file name and the other is the physical file name. The logical...

31/07/2017
0 0
0
SQL SERVER: How To Pass Parameters To The Stored Procedure?

SQL SERVER: How To Pass Parameters To The Stored Procedure? After so many years of existence of the stored procedures, I still see developers struggling to execute the stored procedure. The most common...

18/07/2017
0 0
0

Answers by Amitava (32)

Answered on 10 May IT Courses/Programming Languages/C Language

Following is the basic structure of a C program. Documentation Consists of comments, some description of the program, programmer name and any other useful points that can be referenced later.Link Provides instruction to the compiler to link function from the library function.Definition Consists of symbolic... ...more

Following is the basic structure of a C program.

Documentation Consists of comments, some description of the program, programmer name and any other useful points that can be referenced later.
Link Provides instruction to the compiler to link function from the library function.
Definition Consists of symbolic constants.
Global declaration Consists of function declaration and global variables.
main( )
{

} Every C program must have a main() function which is the starting point of the program execution.
Subprograms User defined functions.
Lets explore the sections with an example.

Write a program to print area of a circle.
In the following example we will find the area of a circle for a given radius 10cm.

Formula
The formula to compute the area of a circle is πr2 where π is PI = 3.1416 (approx.) and r is the radius of the circle.

Lets write the C code to compute the area of the circle.

 

#include <stdio.h>

#define PI 3.1416

float area(float r);

int main(void)
{
float r = 10;
printf("Area: %.2f", area(r));
return 0;
}

float area(float r) {
return PI * r * r;
}
The above code will give the following output.

Area: 314.16
Different sections of the above code
Documentation
This section contains a multi line comment describing the code.

In C, we can create single line comment using two forward slash // and we can create multi line comment using /* */.

Comments are ignored by the compiler and is used to write notes and document code.

Link
This section includes header file.

#include <stdio.h>
We are including the stdio.h input/output header file from the C library.

Definition
This section contains constant.

#define PI 3.1416
In the above code we have created a constant PI and assigned 3.1416 to it.

The #define is a preprocessor compiler directive which is used to create constants. We generally use uppercase letters to create constants.

The #define is not a statement and must not end with a ; semicolon.

Global declaration
This section contains function declaration.

float area(float r);
We have declared an area function which takes a floating number (i.e., number with decimal parts) as argument and returns floating number.

main( ) function
This section contains the main() function.

int main(void)
{
float r = 10;
printf("Area: %.2f", area(r));
return 0;
}
This is the main() function of the code. Inside this function we have created a floating variable r and assigned 10 to it.

Then we have called the printf() function. The first argument contains "Area: %.2f" which means we will print floating number having only 2 decimal place. In the second argument we are calling the area() function and passing the value of r to it.

Subprograms
This section contains a subprogram, an area() function that is called from the main() function.

float area(float r) {
return PI * r * r;
}
This is the definition of the area() function. It receives the value of radius in variable r and then returns the area of the circle using the following formula PI * r * r.


The math.h header defines various mathematical functions and one macro. All the functions available in this library take double as an argument and return double as the result. 

string.h is the header in the C standard library for the C programming language which contains macro definitions, constants and declarations of functions and types used not only for string handling but also various memory handling functions; 

Answers 41 Comments
Dislike Bookmark

Answered on 19/08/2017 IT Courses/SQL Programming

Can you explain the functionality of SQL Server Integration Services in Management Studio?

SQL Server Integration Services. SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. It features a data warehousing tool used for data extraction, transformation, and loading (ETL).
Answers 1 Comments
Dislike Bookmark

Answered on 31/07/2017 IT Courses/SQL Programming

How can I connect my HTML page to the SQL server using JavaScript and without C# or vb.net? I want to... ...more
How can I connect my HTML page to the SQL server using JavaScript and without C# or vb.net? I want to upload a text area value to my database table.

You still need to have a c#, visual basic or even php file in order to communicate with the server. You can use javascript to send the data with ajax to the file, and then the file will write it to the database.
Answers 2 Comments
Dislike Bookmark

Answered on 31/07/2017 IT Courses/SQL Programming

How can I copy one month data from one database server to another in SQL Server 2017?

Using Linked Servers and distributed query ETL - extract one month worth of data, transfer to the different server, load the data Replication
Answers 1 Comments
Dislike Bookmark

Answered on 31/07/2017 IT Courses/SQL Programming

How can I publish reports using SSRS in Power BI?

You can create the reporting solution using PowerBI connectivity to your SQL server instead of the report created with SSRS.
Answers 1 Comments
Dislike Bookmark

AmitavaDirections

x
C Language Classes 5.0

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in C Language Classes

8

C++ Language Classes 5.0

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in C++ Language Classes

8

Proficiency level taught

Advanced C++, Basic C++

Java Training Classes 5.0

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Java Training Classes

4

Teaches

JSP (Java Server Pages), Core Java, Servlet

SQL Server Training 5.0

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in SQL Server Training

8

Teaching Experience in detail in SQL Server Training

SQL SERVER 2008/2012/2014

Courses in SQL Server Training

PL/SQL Classes 5.0

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in PL/SQL Classes

8

Database Training classes 5.0

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Database Training classes

8

Class 11 Tuition 5.0

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Class 11 Tuition

7

Board

IGCSE, State, ISC/ICSE, CBSE

ISC/ICSE Subjects taught

Computer Science

CBSE Subjects taught

Computer Science

Taught in School or College

No

State Syllabus Subjects taught

Computer Science

Class 12 Tuition 5.0

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Class 12 Tuition

7

Board

IGCSE, State, ISC/ICSE, CBSE

ISC/ICSE Subjects taught

Computer Science

CBSE Subjects taught

Computer Science

Taught in School or College

No

State Syllabus Subjects taught

Computer Science

BCA Tuition 5.0

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in BCA Tuition

5

BCA Subject

Java Programming, Database Management Systems , Programming in C++ , Object Oriented Technologies, C Language Programming, Computer Basics and PC Software , IT

Type of class

Regular Classes

Class strength catered to

One on one/ Private Tutions, Group Classes

Taught in School or College

No

BTech Tuition 5.0

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in BTech Tuition

9

BTech Computer Science subjects

Object Oriented Programming & Systems, Types of Database Systems, Database Management Systems, Data Structures and Algorithms, Internet Technology and Applications, Java Programming, Object Technology

BTech Branch

BTech Information Science Engineering, BTech Computer Science Engineering

BTech Information Science subjects

Digital Systems, Operations and Systems Management, Operating Systems, Database Systems, Object Oriented Programming, Business Intelligence, Design and Development of Web Applications, Data Structures and Algorithms

BTech Instrumentation subjects

Object Oriented Programming

Type of class

Regular Classes, Crash Course

Class strength catered to

One on one/ Private Tutions

Taught in School or College

No

Class 10 Tuition 5.0

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Class 10 Tuition

3

Board

CBSE, ICSE, IGCSE, International Baccalaureate

IB Subjects taught

Computers

CBSE Subjects taught

Computer Practices, Information and Comunication Technology

ICSE Subjects taught

Computer Application

IGCSE Subjects taught

Information Technology

Taught in School or College

No

Answers by Amitava (32)

Answered on 10 May IT Courses/Programming Languages/C Language

Following is the basic structure of a C program. Documentation Consists of comments, some description of the program, programmer name and any other useful points that can be referenced later.Link Provides instruction to the compiler to link function from the library function.Definition Consists of symbolic... ...more

Following is the basic structure of a C program.

Documentation Consists of comments, some description of the program, programmer name and any other useful points that can be referenced later.
Link Provides instruction to the compiler to link function from the library function.
Definition Consists of symbolic constants.
Global declaration Consists of function declaration and global variables.
main( )
{

} Every C program must have a main() function which is the starting point of the program execution.
Subprograms User defined functions.
Lets explore the sections with an example.

Write a program to print area of a circle.
In the following example we will find the area of a circle for a given radius 10cm.

Formula
The formula to compute the area of a circle is πr2 where π is PI = 3.1416 (approx.) and r is the radius of the circle.

Lets write the C code to compute the area of the circle.

 

#include <stdio.h>

#define PI 3.1416

float area(float r);

int main(void)
{
float r = 10;
printf("Area: %.2f", area(r));
return 0;
}

float area(float r) {
return PI * r * r;
}
The above code will give the following output.

Area: 314.16
Different sections of the above code
Documentation
This section contains a multi line comment describing the code.

In C, we can create single line comment using two forward slash // and we can create multi line comment using /* */.

Comments are ignored by the compiler and is used to write notes and document code.

Link
This section includes header file.

#include <stdio.h>
We are including the stdio.h input/output header file from the C library.

Definition
This section contains constant.

#define PI 3.1416
In the above code we have created a constant PI and assigned 3.1416 to it.

The #define is a preprocessor compiler directive which is used to create constants. We generally use uppercase letters to create constants.

The #define is not a statement and must not end with a ; semicolon.

Global declaration
This section contains function declaration.

float area(float r);
We have declared an area function which takes a floating number (i.e., number with decimal parts) as argument and returns floating number.

main( ) function
This section contains the main() function.

int main(void)
{
float r = 10;
printf("Area: %.2f", area(r));
return 0;
}
This is the main() function of the code. Inside this function we have created a floating variable r and assigned 10 to it.

Then we have called the printf() function. The first argument contains "Area: %.2f" which means we will print floating number having only 2 decimal place. In the second argument we are calling the area() function and passing the value of r to it.

Subprograms
This section contains a subprogram, an area() function that is called from the main() function.

float area(float r) {
return PI * r * r;
}
This is the definition of the area() function. It receives the value of radius in variable r and then returns the area of the circle using the following formula PI * r * r.


The math.h header defines various mathematical functions and one macro. All the functions available in this library take double as an argument and return double as the result. 

string.h is the header in the C standard library for the C programming language which contains macro definitions, constants and declarations of functions and types used not only for string handling but also various memory handling functions; 

Answers 41 Comments
Dislike Bookmark

Answered on 19/08/2017 IT Courses/SQL Programming

Can you explain the functionality of SQL Server Integration Services in Management Studio?

SQL Server Integration Services. SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. It features a data warehousing tool used for data extraction, transformation, and loading (ETL).
Answers 1 Comments
Dislike Bookmark

Answered on 31/07/2017 IT Courses/SQL Programming

How can I connect my HTML page to the SQL server using JavaScript and without C# or vb.net? I want to... ...more
How can I connect my HTML page to the SQL server using JavaScript and without C# or vb.net? I want to upload a text area value to my database table.

You still need to have a c#, visual basic or even php file in order to communicate with the server. You can use javascript to send the data with ajax to the file, and then the file will write it to the database.
Answers 2 Comments
Dislike Bookmark

Answered on 31/07/2017 IT Courses/SQL Programming

How can I copy one month data from one database server to another in SQL Server 2017?

Using Linked Servers and distributed query ETL - extract one month worth of data, transfer to the different server, load the data Replication
Answers 1 Comments
Dislike Bookmark

Answered on 31/07/2017 IT Courses/SQL Programming

How can I publish reports using SSRS in Power BI?

You can create the reporting solution using PowerBI connectivity to your SQL server instead of the report created with SSRS.
Answers 1 Comments
Dislike Bookmark

Enquire

Load More

Lessons (9)

What Is WorkTable In SQL Server?

What is WorkTable in SQL Server? USE AdventureWorks2014 GO SET STATISTICS IO ON GO SELECT * FROM Production.Product p CROSS JOIN Production.Product p1 GO If you run above query,...

19/12/2017
0 0
0
Rename The Logical Name Of SQL Server Database Files Using T-SQL

Rename the logical name of SQL Server database files using T-SQL: 1. Problem: SQL Server database files have two names: one is the logical file name and the other is the physical file name. The logical...

31/07/2017
0 0
0
SQL SERVER: How To Pass Parameters To The Stored Procedure?

SQL SERVER: How To Pass Parameters To The Stored Procedure? After so many years of existence of the stored procedures, I still see developers struggling to execute the stored procedure. The most common...

18/07/2017
0 0
0

Enquire

Load More

Amitava Majumder describes himself as IT Trainer. He conducts classes in BCA Tuition, BTech Tuition and C Language. Amitava is located in Birati, Kolkata. Amitava takes at students Home and Regular Classes- at his Home. He has 9 years of teaching experience . Amitava has completed Bachelor of Engineering (B.E.) from Sathyabama Institute of Science and Technology (Deemed University), Chennai in 2006. HeĀ is well versed in Hindi, Bengali and English. Amitava has got 23 reviews till now with 100% positive feedback.

X

Post your Learning Need

Let us shortlist and give the best tutors and institutes.

or

Send Enquiry to Amitava

Let Amitava know you are interested in their class

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more