UrbanPro

Location Set your Location

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
Devanand Shukla SQL Programming trainer in Ghaziabad

Featured

Devanand Shukla

Data Engineering| Snowflake Architect | | MSBI with 12 Years experience

Raj Nagar Extension, Ghaziabad, India - 201001.

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

Details verified of Devanand Shukla✕

Identity

Education

Know how UrbanPro verifies Tutor details

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

Overview

Currently working in HCL technologies as a Technical Architect/Data Engineer.
SQL developer - 11 Years
SSIS - 11 Years
Snowflake - 4 Years
Matillion ELT - 4 Years
SSRS - 11 Years

Languages Spoken

Hindi Mother Tongue (Native)

English Proficient

Education

UPTU Lucknow 2012

Bachelor of Technology (B.Tech.)

Address

Raj Nagar Extension, Ghaziabad, India - 201001

Verified Info

ID Verified

Phone Verified

Email Verified

Report this Profile

✕
x

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

Teaches

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

7

Snowflake Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Snowflake Training

4

Teaching Experience in detail in Snowflake Training

4 years Working experience along with teaching experience in Snowflake project.

MS SQL Integration Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MS SQL Integration Training

6

MS SQL Reporting Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MS SQL Reporting Training

7

SSRS Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in SSRS Training

6

MS SQL General Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MS SQL General Training

6

MS SQL Development Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MS SQL Development Training

6

SQL Server Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in SQL Server Training

7

Database Training classes

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Database Training classes

6

Reviews

No Reviews yet!

FAQs

1. Which classes do you teach?

I teach Database Training, MS SQL Development, MS SQL General, MS SQL Integration, MS SQL Reporting, SQL Programming, SQL Server, SSRS and Snowflake Training Classes.

2. Do you provide a demo class?

Yes, I provide a free demo class.

3. How many years of experience do you have?

I have been teaching for 7 years.

Contact

Lessons (1)

Why Snowflake is best Data Warehouse solution rather than Azure Synapse and AWD Redshift

Snowflake is the Cloud Data warehousing solution which provides the best storage and compute functionality seperately. It means you can increase Compute power (to transform th data) and storage (to store...

16 Mar
0 0
0

Contact

Answers by Devanand Shukla (5)

Answered on 15 Mar Learn IT Courses/MS SQL/MS SQL Integration

What are the primary data integrity constraints in SQL?

Primary key constraint is must for each tables so that SQL can create Clustered Index behind the scene to perform DML(Insert/Update/Delete) and select operations quickly. Without clustered index, nonclilustered index will not work and that's the reason we always create primary key constraint.
Answers 2 Comments
Dislike Bookmark

Answered on 15 Mar Learn IT Courses/MS SQL/MS SQL Integration

How do I integrate SQL queries in a single query?

1. You can write a store procedure and wrap-up all the queries inside procedure. And then you can execute using single statement EXEC SPName 2. You can create a view and wrap-up all the SQL statements inside view and then using select statement you can see the result of all the queries ...more

1. You can write a store procedure and wrap-up all the queries inside procedure.

And then you can execute using single statement

EXEC SPName 

2. You can create a view and wrap-up all the SQL statements inside view and then using select statement you can see the result of all the queries 

Answers 2 Comments
Dislike Bookmark

Answered on 15 Mar Learn IT Courses/MS SQL/MS SQL Integration

What are SQL Server Integration Services (SSIS) deployment strategies?

You can use below method to deploy your packages 1. Use file system - copy updated ssis package from solution and paste into your network path (file system) 2. Create SSISDB database in MSSQL and deploy packages using project deployment model
Answers 2 Comments
Dislike Bookmark

Answered on 15 Mar Learn IT Courses/MS SQL/MS SQL Integration

What do you typically use to enforce referential integrity in an SQL server?

Create Foreign Keys on transactional table and reference with Primary key table which you are taking reference. Ex. Tblemployee - empId, empname, deptid Tbldepartment - deptid, deptname Create FK on tblemployee table on deptid column and make reference to the tbldepartment table with deptid column... ...more

Create Foreign Keys on transactional table and reference with Primary key table which you are taking reference.

Ex. 

Tblemployee - empId, empname, deptid

Tbldepartment - deptid, deptname

Create FK on tblemployee table on deptid column and make reference to the tbldepartment table with deptid column to maintain the integrity 

Answers 2 Comments
Dislike Bookmark

Answered on 15 Mar Learn IT Courses/MS SQL/MS SQL Integration

What are the command line tools to execute SQL Server Integration Services packages?

Dtexec
Answers 2 Comments
Dislike Bookmark

Contact

View All

Teaches

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

7

Snowflake Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Snowflake Training

4

Teaching Experience in detail in Snowflake Training

4 years Working experience along with teaching experience in Snowflake project.

MS SQL Integration Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MS SQL Integration Training

6

MS SQL Reporting Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MS SQL Reporting Training

7

SSRS Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in SSRS Training

6

MS SQL General Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MS SQL General Training

6

MS SQL Development Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MS SQL Development Training

6

SQL Server Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in SQL Server Training

7

Database Training classes

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Database Training classes

6

No Reviews yet!

Answers by Devanand Shukla (5)

Answered on 15 Mar Learn IT Courses/MS SQL/MS SQL Integration

What are the primary data integrity constraints in SQL?

Primary key constraint is must for each tables so that SQL can create Clustered Index behind the scene to perform DML(Insert/Update/Delete) and select operations quickly. Without clustered index, nonclilustered index will not work and that's the reason we always create primary key constraint.
Answers 2 Comments
Dislike Bookmark

Answered on 15 Mar Learn IT Courses/MS SQL/MS SQL Integration

How do I integrate SQL queries in a single query?

1. You can write a store procedure and wrap-up all the queries inside procedure. And then you can execute using single statement EXEC SPName 2. You can create a view and wrap-up all the SQL statements inside view and then using select statement you can see the result of all the queries ...more

1. You can write a store procedure and wrap-up all the queries inside procedure.

And then you can execute using single statement

EXEC SPName 

2. You can create a view and wrap-up all the SQL statements inside view and then using select statement you can see the result of all the queries 

Answers 2 Comments
Dislike Bookmark

Answered on 15 Mar Learn IT Courses/MS SQL/MS SQL Integration

What are SQL Server Integration Services (SSIS) deployment strategies?

You can use below method to deploy your packages 1. Use file system - copy updated ssis package from solution and paste into your network path (file system) 2. Create SSISDB database in MSSQL and deploy packages using project deployment model
Answers 2 Comments
Dislike Bookmark

Answered on 15 Mar Learn IT Courses/MS SQL/MS SQL Integration

What do you typically use to enforce referential integrity in an SQL server?

Create Foreign Keys on transactional table and reference with Primary key table which you are taking reference. Ex. Tblemployee - empId, empname, deptid Tbldepartment - deptid, deptname Create FK on tblemployee table on deptid column and make reference to the tbldepartment table with deptid column... ...more

Create Foreign Keys on transactional table and reference with Primary key table which you are taking reference.

Ex. 

Tblemployee - empId, empname, deptid

Tbldepartment - deptid, deptname

Create FK on tblemployee table on deptid column and make reference to the tbldepartment table with deptid column to maintain the integrity 

Answers 2 Comments
Dislike Bookmark

Answered on 15 Mar Learn IT Courses/MS SQL/MS SQL Integration

What are the command line tools to execute SQL Server Integration Services packages?

Dtexec
Answers 2 Comments
Dislike Bookmark

Contact

Lessons (1)

Why Snowflake is best Data Warehouse solution rather than Azure Synapse and AWD Redshift

Snowflake is the Cloud Data warehousing solution which provides the best storage and compute functionality seperately. It means you can increase Compute power (to transform th data) and storage (to store...

16 Mar
0 0
0

Contact

Devanand Shukla describes himself as Data Engineering| Snowflake Architect | | MSBI with 12 Years experience. He conducts classes in Database Training, MS SQL Development and MS SQL General. Devanand is located in Raj Nagar Extension, Ghaziabad. Devanand takes at students Home and Regular Classes- at his Home. He has 7 years of teaching experience . Devanand has completed Bachelor of Technology (B.Tech.) from UPTU Lucknow in 2012. He is well versed in English and Hindi.

X

Share this Profile

Recommended Profiles

Bhavani P

Bhavani P photo Kondapur, Hyderabad

Mohit Tyagi

Mohit Tyagi photo Vasundhra, Ghaziabad

Somanjineyulu Pedda Kadapa

Somanjineyulu Pedda Kadapa photo Singasandra, Bangalore

Pradeep Thakur

Pradeep Thakur photo Murgeshpalya, Bangalore

Rakhi R.

Rakhi R. photo Yousufguda, Hyderabad

Srinivasa Rao Gorrepati

Srinivasa Rao Gorrepati photo Ameerpet, Hyderabad

Also have a look at

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-2024All Rights Reserved