UrbanPro
Login Ask & Answer Success Stories Paid Courses Free Classes Tuition & Classes Fees Write a Review All Categories Help Center
Post your Learning Need Signup as a Tutor
✕

Popular Cities

Bangalore

Hyderabad

Delhi

Mumbai

Chennai

Pune

Kolkata

Gurgaon

Ahmedabad

Jaipur

Noida

✕
true

Sumit Shaw

Senior Business Analyst

Sector 15, Noida, India - 201301

1 review

Verified 2 Students

Contact
Referral Discount: Get ₹ 250 off when you make a payment to start classes. Get started by Booking a Demo.

Details verified of Sumit Shaw✕

Identity

Education

Know how UrbanPro verifies Tutor details

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

Teaches

Microsoft Excel Training classes
1 review

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Microsoft Excel Training classes

2

Teaches following Excel features

Advanced Excel, Excel Macro Training, Basic Excel

C Language Classes

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in C Language Classes

2

Tableau Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Tableau Training

2

SAS Advanced

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in SAS Advanced

2

SQL Programming Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in SQL Programming Training

2

BTech Tuition

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in BTech Tuition

2

BTech Computer Science subjects

Data Structures and Algorithms, Java Programming

BTech Branch

BTech 1st Year Engineering, BTech Computer Science Engineering

Type of class

Crash Course, Regular Classes

Class strength catered to

One on one/ Private Tutions, Group Classes

Taught in School or College

Yes

BTech 1st Year subjects

Computer science, Engineering Mathematics (M1)

Class 11 Tuition

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Class 11 Tuition

2

Board

CBSE, ISC/ICSE, State

ISC/ICSE Subjects taught

Mathematics, Computer Science

CBSE Subjects taught

Computer Science, Mathematics

Taught in School or College

Yes

State Syllabus Subjects taught

Computer Science, Mathematics

Class 12 Tuition

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Class 12 Tuition

2

Board

CBSE, ISC/ICSE, State

ISC/ICSE Subjects taught

Mathematics, Computer Science

CBSE Subjects taught

Computer Science, Mathematics

Taught in School or College

Yes

State Syllabus Subjects taught

Computer Science, Mathematics

Class 9 Tuition

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Class 9 Tuition

2

Board

CBSE, ICSE, State

CBSE Subjects taught

Computer Practices, Science, Mathematics

ICSE Subjects taught

Chemistry, Computer Application, Mathematics, Physics

Taught in School or College

Yes

State Syllabus Subjects taught

Mathematics, Science

Class 10 Tuition

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Class 10 Tuition

2

Board

CBSE, ICSE, State

CBSE Subjects taught

Computer Practices, Science, Mathematics

ICSE Subjects taught

Chemistry, Computer Application, Mathematics, Physics

Taught in School or College

Yes

State Syllabus Subjects taught

Mathematics, Science

Class 6 Tuition

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Class 6 Tuition

2

Board

CBSE, ICSE, State

CBSE Subjects taught

Mathematics, Computers, English, Bengali, Science

ICSE Subjects taught

Computer Science, Physics, Biology, Mathematics, Chemistry

Taught in School or College

Yes

State Syllabus Subjects taught

Mathematics, English, Science

Class 7 Tuition

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Class 7 Tuition

2

Board

CBSE, ICSE, State

CBSE Subjects taught

Mathematics, Computers, English, Bengali, Science

ICSE Subjects taught

Computer Science, Physics, Biology, Mathematics, Chemistry

Taught in School or College

Yes

State Syllabus Subjects taught

Mathematics, English, Science

Class 8 Tuition

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Class 8 Tuition

2

Board

CBSE, ICSE, State

CBSE Subjects taught

Mathematics, Computers, English, Bengali, Science

ICSE Subjects taught

Computer Science, Physics, Biology, Mathematics, Chemistry

Taught in School or College

Yes

State Syllabus Subjects taught

Mathematics, English, Science

Class I-V Tuition

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Class I-V Tuition

2

Board

State, CBSE, ICSE

CBSE Subjects taught

Mathematics, Computers, Bengali, Science

ICSE Subjects taught

Mathematics, Science, Bengali

Taught in School or College

Yes

State Syllabus Subjects taught

Computer Science, Mathematics, Science

5 out of 5 1 review

Sumit Shaw https://p.urbanpro.com/tv-prod/member/photo/3820734-small.jpg Sector 15
5.0051
Sumit Shaw
J

Microsoft Excel Training

"I learnt few lessons in MS-Excel and VBA from Sumit. He is having excellent knowledge in this software and he is simply awesome the way he teach. "

Have you attended any class with Sumit?

Answers by Sumit Shaw (2)

Answered on 02/09/2017 Learn IT Courses/SQL Programming

How do I connect to a MS SQL database with C++?

#include "stdafx.h" #include "iostream" #include "windows.h" #include "sqltypes.h" #include "sql.h" #include "sqlext.h" using namespace std; int main() { #define SQL_RESULT_LEN 240 #define SQL_RETURN_CODE_LEN 1000 //define handles and variables SQLHANDLE sqlConnHandle; ... ...more
#include "stdafx.h" #include "iostream" #include "windows.h" #include "sqltypes.h" #include "sql.h" #include "sqlext.h" using namespace std; int main() { #define SQL_RESULT_LEN 240 #define SQL_RETURN_CODE_LEN 1000 //define handles and variables SQLHANDLE sqlConnHandle; SQLHANDLE sqlStmtHandle; SQLHANDLE sqlEnvHandle; SQLWCHAR retconstring[SQL_RETURN_CODE_LEN]; //initializations sqlConnHandle = NULL; sqlStmtHandle = NULL; //allocations if (SQL_SUCCESS != SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &sqlEnvHandle)) goto COMPLETED; if (SQL_SUCCESS != SQLSetEnvAttr(sqlEnvHandle, SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, 0)) goto COMPLETED; if (SQL_SUCCESS != SQLAllocHandle(SQL_HANDLE_DBC, sqlEnvHandle, &sqlConnHandle)) goto COMPLETED; //output cout << "Attempting connection to SQL Server..."; cout << "\n"; //connect to SQL Server //I am using a trusted connection and port 14808 //it does not matter if you are using default or named instance //just make sure you define the server name and the port //You have the option to use a username/password instead of a trusted connection //but is more secure to use a trusted connection switch (SQLDriverConnectW(sqlConnHandle, NULL, (SQLWCHAR*)L"DRIVER={SQL Server};SERVER=ServerAddress, 1433;DATABASE=DataBaseName;UID=DataBaseUserName;PWD=PassWord;", //(SQLWCHAR*)L"DRIVER={SQL Server};SERVER=localhost, 1433;DATABASE=master;Trusted=true;", SQL_NTS, retconstring, 1024, NULL, SQL_DRIVER_NOPROMPT)) { case SQL_SUCCESS: cout << "Successfully connected to SQL Server"; cout << "\n"; break; case SQL_SUCCESS_WITH_INFO: cout << "Successfully connected to SQL Server"; cout << "\n"; break; case SQL_INVALID_HANDLE: cout << "Could not connect to SQL Server"; cout << "\n"; goto COMPLETED; case SQL_ERROR: cout << "Could not connect to SQL Server"; cout << "\n"; goto COMPLETED; default: break; } //if there is a problem connecting then exit application if (SQL_SUCCESS != SQLAllocHandle(SQL_HANDLE_STMT, sqlConnHandle, &sqlStmtHandle)) goto COMPLETED; //output cout << "\n"; cout << "Executing T-SQL query..."; cout << "\n"; //if there is a problem executing the query then exit application //else display query result if (SQL_SUCCESS != SQLExecDirectW(sqlStmtHandle, (SQLWCHAR*)L"SELECT @@VERSION", SQL_NTS)) { cout << "Error querying SQL Server"; cout << "\n"; goto COMPLETED; } else { //declare output variable and pointer SQLCHAR sqlVersion[SQL_RESULT_LEN]; SQLINTEGER ptrSqlVersion; while (SQLFetch(sqlStmtHandle) == SQL_SUCCESS) { SQLGetData(sqlStmtHandle, 1, SQL_CHAR, sqlVersion, SQL_RESULT_LEN, &ptrSqlVersion); //display query result cout << "\nQuery Result:\n\n"; cout << sqlVersion << endl; } } //close connection and free resources COMPLETED: SQLFreeHandle(SQL_HANDLE_STMT, sqlStmtHandle); SQLDisconnect(sqlConnHandle); SQLFreeHandle(SQL_HANDLE_DBC, sqlConnHandle); SQLFreeHandle(SQL_HANDLE_ENV, sqlEnvHandle); //pause the console window - exit when key is pressed cout << "\nPress any key to exit..."; getchar(); }
Answers 1 Comments
Dislike Bookmark

Answered on 02/09/2017 Learn IT Courses/SQL Programming

How do I connect SQL with c++?

int main() { #define SQL_RESULT_LEN 240 #define SQL_RETURN_CODE_LEN 1000 //define handles and variables SQLHANDLE sqlConnHandle; SQLHANDLE sqlStmtHandle; SQLHANDLE sqlEnvHandle; SQLWCHAR retconstring; //initializations sqlConnHandle = NULL; sqlStmtHandle... ...more
int main() { #define SQL_RESULT_LEN 240 #define SQL_RETURN_CODE_LEN 1000 //define handles and variables SQLHANDLE sqlConnHandle; SQLHANDLE sqlStmtHandle; SQLHANDLE sqlEnvHandle; SQLWCHAR retconstring[SQL_RETURN_CODE_LEN]; //initializations sqlConnHandle = NULL; sqlStmtHandle = NULL; //allocations if (SQL_SUCCESS != SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &sqlEnvHandle)) goto COMPLETED; if (SQL_SUCCESS != SQLSetEnvAttr(sqlEnvHandle, SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, 0)) goto COMPLETED; if (SQL_SUCCESS != SQLAllocHandle(SQL_HANDLE_DBC, sqlEnvHandle, &sqlConnHandle)) goto COMPLETED; //output cout << "Attempting connection to SQL Server..."; cout << "\n"; //connect to SQL Server //I am using a trusted connection and port 14808 //it does not matter if you are using default or named instance //just make sure you define the server name and the port //You have the option to use a username/password instead of a trusted connection //but is more secure to use a trusted connection switch (SQLDriverConnectW(sqlConnHandle, NULL, (SQLWCHAR*)L"DRIVER={SQL Server};SERVER=ServerAddress, 1433;DATABASE=DataBaseName;UID=DataBaseUserName;PWD=PassWord;", //(SQLWCHAR*)L"DRIVER={SQL Server};SERVER=localhost, 1433;DATABASE=master;Trusted=true;", SQL_NTS, retconstring, 1024, NULL, SQL_DRIVER_NOPROMPT)) { case SQL_SUCCESS: cout << "Successfully connected to SQL Server"; cout << "\n"; break; case SQL_SUCCESS_WITH_INFO: cout << "Successfully connected to SQL Server"; cout << "\n"; break; case SQL_INVALID_HANDLE: cout << "Could not connect to SQL Server"; cout << "\n"; goto COMPLETED; case SQL_ERROR: cout << "Could not connect to SQL Server"; cout << "\n"; goto COMPLETED; default: break; } //if there is a problem connecting then exit application if (SQL_SUCCESS != SQLAllocHandle(SQL_HANDLE_STMT, sqlConnHandle, &sqlStmtHandle)) goto COMPLETED; //output cout << "\n"; cout << "Executing T-SQL query..."; cout << "\n"; //if there is a problem executing the query then exit application //else display query result if (SQL_SUCCESS != SQLExecDirectW(sqlStmtHandle, (SQLWCHAR*)L"SELECT @@VERSION", SQL_NTS)) { cout << "Error querying SQL Server"; cout << "\n"; goto COMPLETED; } else { //declare output variable and pointer SQLCHAR sqlVersion[SQL_RESULT_LEN]; SQLINTEGER ptrSqlVersion; while (SQLFetch(sqlStmtHandle) == SQL_SUCCESS) { SQLGetData(sqlStmtHandle, 1, SQL_CHAR, sqlVersion, SQL_RESULT_LEN, &ptrSqlVersion); //display query result cout << "\nQuery Result:\n\n"; cout << sqlVersion << endl; } } //close connection and free resources COMPLETED: SQLFreeHandle(SQL_HANDLE_STMT, sqlStmtHandle); SQLDisconnect(sqlConnHandle); SQLFreeHandle(SQL_HANDLE_DBC, sqlConnHandle); SQLFreeHandle(SQL_HANDLE_ENV, sqlEnvHandle); //pause the console window - exit when key is pressed cout << "\nPress any key to exit..."; getchar(); }
Answers 1 Comments
Dislike Bookmark

Contact

Sumit Shaw describes himself as Senior Business Analyst. He conducts classes in BTech Tuition, C Language and Class 10 Tuition. Sumit is located in Sector 15, Noida. Sumit takes at students Home, Regular Classes- at his Home and Online Classes- via online medium. He has 2 years of teaching experience . Sumit has completed Bachelor of Engineering (B.E.) from Indian Institute of Engineering Science & Technology in 2015. He is well versed in English, Bengali and Hindi. Sumit has got 1 reviews till now with 100% positive feedback.

X

Share this Profile

Recommended Profiles

Arun kumar

Arun kumar photo Vengal Rao Nagar, Hyderabad

Sangeetha

Sangeetha photo Perungudi, Chennai

Manish Ranjan Thakur photo

Manish Ranjan Thakur

Manish Ranjan Thakur photo Airoli Sector 2, Mumbai

Rohit sharma

Rohit sharma photo Mira Road East, Mumbai

Pratik Mokashi

Pratik Mokashi photo Ghatkopar West, Mumbai

Janitha Arun photo

Janitha Arun

Janitha Arun photo MDR598 Perumanttunallur, Kattankulathur

Also have a look at

Learn More

What is Microsoft Excel Microsoft Excel Introduction Microsoft Excel Features Microsoft Excel Advantages Microsoft Excel Versions NCERT Solutions for Class 9 CBSE Class 10 Syllabus NCERT Class 10 Solutions NCERT Solutions For Class 11 NCERT Class 12 Solutions

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.

✕

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

✕

Different batches available for this Course

Book a Free Demo

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 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 7.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

ThinkVidya Learning Pvt Ltd © 2010-2025All Rights Reserved