Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

SQL in Depth ( 4 Hours / Day ) Weekdays / Weekend Batches

65 Reviews

BTM Layout 2nd Stage, Bangalore

Course ID: 43716

BTM Layout 2nd Stage, Bangalore

Students Interested 0 (Seats Left 0)

65 Reviews

About the Course

Students or Working professional Who would like to become expert in SQL.

Trainees will learn SQL concept practically with realtime examples step by step.

Trainees should bring their own laptop.


 


ANSI SQL Concepts



  • Writing SQL from scratch

  • Writing queries for realtime data

  • Writing query to create, rename, delete table and fields

  • Column and Table Alias

  • UNION

  • UNION ALL

  • SQL Joins

  • Inner Join

  • Left Outer Join

  • Right Outer Join

  • Constraints

  • Primary Key

  • Unique Key

  • Foreign Key

  • Difference between Primary Key vs Unique Key

  • Difference between Primary Key vs Foreign Key

  • Default Constraint

  • Check Constraint

  • Distinct

  • Date & Time functions

  • Text Functions

  • Math Functions

  • Sub Queries (Step by step to create sub queries)

  • Normalization

  • Entity relationship

  • One to One relationship

  • One to Many relationship

  • Many to many relationship


What is special in this course compare to other trainers?



  • 22+ Years real-time experienced trainer.

  • Teaching from the basic to advanced topic in methodological way.

  • SQL queries will be practically explained with different RDBMS à MySQL, MSSQL, Oracle servers

  • All concept are explained with realtime data

  • Assignment for each concepts

  • Online objective type test to check you knowledge

  • Each query concept will be explained in step by step in depth.

  • Interview tips



  • Provide support after training

Date and Time

Not decided yet.

About the Trainer

Umasankar Natarajan picture

5 Avg Rating

205 Reviews

197 Students

14 Courses

Umasankar Natarajan

B.E., M.B.A., PMP

20 Years of Experience

I have 22 Years experience - 20+ years of software design & development experience and 2 years of Non IT experience.

I have practically worked C, C++ , PHP, MySQL for 18+ years in different software companies like Tata Elxsi, Mphasis, Aricent, Mindtree.

I worked 8+ years as Project Manager, where I worked many excel vba project to create dashboard and automate project reports.

I completed 25+ realtime project in Software Industries. Out of which I have done 21+ C & C++ Real time projects. 15+ Excel Projects for Automation, Dashboard and report generation.

6+ PHP MySQL Real time Projects.

I can teach you Excel VBA Macro Programming in depth with practical examples.

I can teach you C and C++ Programming in depth with practical examples. Also I will teach C & C++ with memory level debugging.

I can teach you PHP - MySQL programming in depth with practical examples.

Student Feedback

5.0

Average Rating

100%
0%
0%
0%
0%

Reviews

H

Hazrat Ali

Class was Very Good. All commands are explained properly with syntax and the exercise are helpful. Covered Topics very clear and well organized, and has a lot of exercises that really help learning and putting into practice the concepts taught. Thank you Sir.

K

Khushboo Sharma

I like the way you provide training, it's very clear and concise. Even a layman who doesn't know anything about SQL would be able to write queries from the day one. I would recommend anyone who doesn't know anything about SQL to learn from you. The way you interact within students to clarify their doubts is really appreciable. Thank you very much, Sir.

K

Kamal K

SQL class you have taken was good and useful to me. Queries you have practically done it is good way of teaching than theoretically explaining. I have got confidence to write a SQL query. Expecting your support on any time.

A

Ankit Ramesh

I have attended the SQL & Advanced Excel session taken by Mr.Umasankar in ATI. Concept was clearly explained with practical examples. Though I had little knowledge on SQL. I was able to understand the concept and syntax very clearly. The presentation was simple and easy to follow covering all the important concepts with examples. Each concept was demonstrated practically by coding then and there itself. All the doubts were clarified and codes/presentation was shared via email on the same day. Important tips are also being shared even after the sessions are completed. I would highly recommend anyone who is interested in learning SQL to attend his classes to start or grow their career in SQL domain.Advanced Excel class was also interactive and case studies were performed based on real time data and scenarios and it was easy to grasp things.

V

Vikash Kumar

I like your training sections, it is very clear and easy to understand. I like the way you make it simple and explain very well. I was very confused about joins concepts in SQL but you made it very simple and explained clearly with good examples. I recommend my friends also to attend your classes. Thank you so much sir. "The SQL class you have taken was really nice. In addition to that, writing SQL queries you have practically done it. We get confidence to write a SQL query at any point of time. Hereafter, we will be able to write SQL query after attending your class.

B

Bhavana

Attended SQL training in ATI by Umasankar. SQL class he has taken are really good and from basics he provided good hands on exercises.

A

Aishwarya

Sir is a great teacher and hard to find in a modern city like Bangalore. He urges you to shun the book and dive into coding. Takes out fear of coding and makes you think logically. He is very punctual and committed. Clears your doubts with patience. Explains multiple alternatives approach to solve a single question. Sir is well experienced in real time applications of the language. If you wanna take up a project of your know he is willing to help you if you are stuck somewhere.

K

Kush Joshi

The SQL class of Mr. Umasankar was really helpful for me. That help me to clear all my confusion regarding join,sub query, union, primary key and help to make my concepts right. He was so good in explaining in each topic and didn't miss a any topic to teach because of him SQL look easy to me. Thank you sir.

S

Sujay

"Very professional personality" I like the way you interact with us and spending time with us to solve our problem, if it's a silly problem then also you won't get upset. Keep going in like this sir. You doing great job we have respect for that. Thank you.

R

Rudramuni Swamy

I attended SQL class at ATI conducted by Mr.Umashankar. Before attending this class I didn't know about SQL. But after completion I got good knowledge regarding SQL. It was good learning by him. Thank you very much.

S

Sujatha Gopal

Attend classes to learn SQL at ATI and find that Mr. Umashankar, the trainer, is very well prepared for each class and is very methodical. Has a good sense of timing that allows him to cover the subject broadly as well.

M

Mathews Joseph

I've zero knowledge about SQL before the class. Now I am happy to say that the class by our tutor Mr. Umasankar Natarajan is quite lively and knowledgeful. He simply defines the concept with practical examples and helps us to any extent for our development. He have a real gift in this area and again I am happy to say that this class values my time.

S

Sumalatha

The coaching is extremely great. We can understand much more about the usage of upcoming applications in real time applicable both for a fresher and experienced candidate. I would sincerely acknowledge Mr. Umasankar for the constant support in the approach and knowledge provided in a very short duration of time. I would get back to you for further courses as well. Kindly direct me as per the requirement. If your base is strong you can jump into any platform with ease. If you want to explore more into the subject and to develop your core knowledge he is the right educationalist to enhance your skills.

S

Sridhar K

The training was very clear and to the point. Examples and datasets given for every concept was sufficient and helped me get clarity on each concept. The case studies provided was also a good practice in case I've had doubts of my own.

R

Reshma Madhu

Sir, I felt you are very good in your subject. The way you put things is so good and make it very simple and clear for us to understand with good examples. I basically liked the way you teach wherein first you explain and make us understand the concept and also give us time to practice where most of the trainers won't do. I will definitely recommend others to attend your class sir.

A

Anand Saini

1. Before attending your class my concepts was not clear. But now it seems pretty much easy. 2. I like the way you teach. You are full of energy and eager to give / provide knowledge. Moreover, demonstrating each and every concepts for clearing our doubts.

A

Aditya A

I have attended SQL weekday batch at ATI which was taught by Mr. UmaSankar sir. I liked his teaching style, simple and focused on subject. First he asked us to listen to his teaching, understand the concept, clarify if there are any doubts and then execute the concept which I felt was more suitable to my style of understanding the subject. He repeats the concept multiple times to make it very clear. His teaching flow is very nice. Highly knowledgeable person. I feel confident after attending his SQL class. I got study material and case studies which are more of real time datasets. Thanks a lot sir.

A

Anusha Choudary

I like the way you are responding to solving problems.your teaching way is very nice and understandable, and a hatsoff to your patience sir,given case studies has helped me better usage of commands, In the course we have covered all the topics which are relevant to today's market.

A

Arvind T

Sir I would first like to start by saying that I understand almost all queries in SQL, as now its been crystal clear thanks to your critical brainstorming coaching session. Sir you have made SQL easy by making your students to practically work on each and every query raised and have made us practice on case studies which was really helpful to make concepts really clear and understandable. I would surely recommend a beginner coder or an advanced coder to take up your classes to make SQL understandable to its core, as your coaching session concentrates on all groups of students, from beginner to professional. I would really like to thank you to make SQL easy and understandable, and I wholeheartedly feel is because of your unique and best way of teaching.

S

Sunil Kumar

I have attended SQL training taken by Mr.Umashankar - it's was very clear and simple to understand. As a non technical student It was very easy to understand. The training did hand to hand practice and he is very helpful to solve your query. Once we have written query, he will explains the how it formulated and how it will affect your data structure. And Sir is always open for doubts about SQL not Only in class, he is ok in over the phone also. Finally it is a highly worth of your time at Umashankar SQL class and easy to learn. Thanks.

P

Pushkar Deshpande

The SQL classes taken by Mr.Umasankar in ATI were really impressive. All the concepts were covered with proper explanations. Now I am confident with writing SQL queries undoubtedly. The teaching has helped me grow my knowledge in SQL to the greatest.

H

Hunain Altaf

I would like to take this opportunity to thank ATI for my wonderful learning experience. You guys delivered what you had promised and my special thanks to the Institute's SQL / Excel trainer Mr. Umasankar. I literally started with zero knowledge of the subject and I can proudly and confidently post these skills in my resume now. He is a professional trainer par excellence who knows his job pretty well.

A

Atul Rao

I have undertaken the SQL (using MySQL) class under Umasankar sir recently and can say for sure that he trains out of passion and not only as a profession. He takes great pain and pays individual attention and makes sure everyone understands the concepts inside out. You can get tired and let go but he will never let go until you understand and that's what makes him stand out from the rest. In all it was really a wonderful learning experience and his classes are 100% recommended by me.

R

Roshan C

I have attended the training by Mr Umasankar in ATI, Koramangala. He has a complete package of SQL understanding. He delivers a Parallel understanding of let say MySQL, Access, MS SQL etc. It happen to attend few interviews and I must say 90% of the questions were among what he taught in class. He never refuses to any questions, moreover he explains it while executing the same and showing the difference between the queries. I really liked his teaching way and recommended my friends to attend his class to have a complete understanding of what is SQL and how it's used by the industries. To start with SQL this is the best place and he's the right person.

V

Vikash Tiwari

I have attended your SQL session in ATI. It was very nice. All the topics were explained by you in a excellent way. Being from non coding background Now it has become easy to me to understand the SQL. Thanks for the support.

J

Jayasimha A

I attended SQL home training. Extraordinary training classes. All the concepts were explained in simple and understandable form. Very patient. Waits till students complete typing queries. I have asked same doubts at least 3-4 times. Never hesitated to explain again. Shared extra notes including advance excel. A very good trainer overall. I would rate 10 out of 10 for the training classes conducted. Thank you so much sir.

A

Amaresh

I love the way you are responding to solving problems. Your teaching way is very nice and understandable. and a hats-off to your patience sir, given case studies has helped me better usage of commands. In the course you have covered all the topics which are relevant to today's market.

N

Natarajan

Umasankar is a sincere, dedicated, committed instructor. Whether it was in installation of MySQL, or in understanding the semantics of the platform, or in understanding use cases of DBMS and RDBMS, he was always there to enlighten, guide and suggest. What I found most remarkable about him was his commitment to time. He was not only present before time, he never wasted a single minute within class, and often had to be reminded by students that class time was up. I wish him all the best in his endeavors.

J

Jagannadha Raju

I have attended Uma shankar sir SQL class in ATI, Basically I am not from programming background but he explained everything explicitly and vigorous practise in the class led me to better understanding, I strongly recommend those who are starting like me can listen his classes and Flourish with good knowledge on SQL.

S

Sajan

From my experience, Umasankar's SQL training was superb. No doubt of it. Also it covers all the topics in that time span. It's really helpful to upgrade my knowledge in SQL and also I humbly recommend others to go through the training section even if you are new in this field you can easily grab the ideas. Thank you sir. All the wishes.

D

Dr. Huma

I am very new to SQL, but class of Mr. Umashankar made it much easier for me. Very well taught, well explained with practice and examples. Here after attending his class I am confident to write SQL queries. Thanks Sir!

V

Vivek

The SQL class taken by Umasankar was very helpful along with case studies. The presentation was easy to understand and were conceptual. We also learned about interview question and answer.

R

Raghavendra G

The SQL class taken by Umashankar sir was very good, we all learnt the topics thoroughly from not knowing anything to mastering it, thanks for the great teaching.

A

Abhiroop Bhattasali

The classes were very good. Everything was explained properly. Real life examples like shopping websites were used which made the classes interesting. The classes also gave an idea of what's important from interview point of view.

C

Charan Teja

He has a very simple, structured and systematic method of teaching and he is very patient with responding to all my queries. He shared all the notes and codes after the class, this is a great relief as I am not under pressure to take notes while he is teaching and focus on understanding the concepts rather than taking notes. Needless to say his 22 years of experience reflects the in depth knowledge of SQL. Above all, I thank him for being very considerate by being available and giving one on one time after the class. This gives me a great sense of hope and belief to crack mastering SQL when I know that I can reach out to anytime after the class as well to clarify my doubts and he goes beyond his means by giving that extra support and personal attention after the class as well. I look forward to have further interactions with him in the future and seek to learn other courses that serve my interest apart from SQL that he thought. Thank You Umasankar Sir.

S

Salman

Umashankar Sir's knowledge of the subject and it's delivery is exceptional. From the core concepts of databases to the actual hand's on experience, Sir has gone the extra mile to have all corners covered.

R

Raja

Mr. Umasankar Natarajan is a patience, vastly knowledge person, and conveys his knowledge of the complex material in a manner easily understandable. I can't thank him enough for all the help that he gives me, with his help I was able to take my career to a next level. His view of coding is pretty understandable for one who has zero knowledge of coding. The way he taught and explained the program in a step by step (debug mode) with the real time examples was easily understandable. I strongly recommend Umasankar as tutor for those who would like to become Advanced Excel and Excel VBA experts. Note: If you utilize your time by doing the projects given by him after completing each concept, trust me you will get the confidence in the programming knowledge.

D

Dipaanita Mohanty

I attended SQL training in ATI by Umasankar. His training was a brain storming session. Learnt a lot in few hours. There was good interaction between students and faculty.

P

Pavitha RM

I have attended SQL training. I liked your way of teaching technique. You explained all the concepts with good examples. I recommend my friends also to attend your sessions. Thank you sir.

K

Kundan Kumar Singh

I like your training sections, it is very clear and easy to understand. I like the way you make it simple and explain very well. I was very confused about joins concepts in SQL but you made it very simple and explained clearly with good examples. I recommend my friends also to attend your classes. Thank you so much sir.

S

Santhosh Kumar

The SQL class which I had attended on 22nd & 29th of April and the trainer Mr. Umasankar sir session for SQL was explained clearly and made it all step by step by explaining the methods first and latter on given some 15 questions to solve, by solving it was very interesting and more understandable, which was very nice moreover Mr . Umasankar made us clear if we had any doubts or queries without hesitation. I will recommend anyone can join .Thank you

P

Praveen Sagar

I have attended the SQL session taken by Mr.Umasankar in ATI. Concept was clearly explained with practical examples. It was amazing to be part of your classes.

P

Parag

I have attended SQL class by Umashankar Sir. Prior to that, I had never tried SQL. It was completely new topic for me. But Sir taught it really well. He started from basics and built it up gradually with proper examples. He helped us understand the concepts and write our own codes. He is a very dedicated person when it comes to teaching and follows a methodical approach. He even took time after the class to answer my queries. He got a lot of industrial experience which helps in answering your queries. You need to be very focused during the class otherwise you will miss his words in between, because he is very fast at typing. If you practice after every lecture (on that day itself) then it becomes very easy to understand the topic. Now i am able to write my own SQL code and I am a happy student of Sir.

D

Deepti Nair

"MySQL" classes were good & simple. Easy to follow. Explanation before writing the query, then writing the query made the things easier. Then followed by examples was good & great. Every doubts were made clear by you then & there. Thank you for the SQL classes. It was all together a good & simple class.

E

Emil Joshua

The SQL session that were taken by Mr Umasankar was very helpful as the SQL queries and the syntax's were made simple so that they are easy to understand. Most of the important concepts that are related to the current professional environment were thought which made SQL a bit easy.

A

Abhishek Sinha

I attended SQL training in Analytics Training Institute by Umasankar. Training was very informative, had great learning experience. Now I am having a clear idea about SQL. Looking forward for other training sessions which will be provided by you (Umasankar Sir).

V

Vince

Really good SQL training. Helpful in getting a grasp of sql concepts. Resolved my doubts quickly and provided clarifications. I recommend UmaSankar's SQL classes.

V

Veena Giriyal

Attended SQL class by Umasankar at ATI Bangalore.The SQL class you have taken was really nice. In addition to that, writing SQL queries you have practically done it . We get confidence to write a SQL query at any point of time. Hereafter, we will be able to write SQL query after attending your class.

D

Dayamay Tiwari

I attended SQL class at ATI. Sir, thanks a lot for SQL classes. I liked the way you teach. You made it very simple to understand. You also explained all my queries. I recommend my friends also to attend your classes. Thank you so much sir.

S

Shawn Mathai

The SQL classes were easy to understand, even for someone like me with hardly any coding experience. My instructor Mr. Umasankar was very helpful and clarified all our doubts on the spot. I'm looking forward to learning more about SQL and its applications.

G

Gaayathri GK

I have attended SQL training conducted by Umasankar at ATI. His class was good. Practicing by the same time of learning was very much helpful.

M

Mustafa Hussaini Syed

First of all I would like to thank Umasankar for training on SQL concepts. The training was well structured(step by step).The way he explained concepts with examples are very clear, easily understandable. He trained on different methods to get the same result which was very helpful. The other very good thing was he gave questions(case studies) to solve in class room itself after each concept, which helped us in understanding things more clearly, got confidence and practical experience in writing queries.He trained us on all the concepts. Overall training was very good. Those who are looking for SQL I will definitely suggest to learn from him. Most of the trainers don't follow structure and don't cover all the concepts and they will be looking for excuses to waste time and finish classes as soon as possible without covering all topics. He did justice to your trainees by utilizing all the allocated hours infact he took extra time also to cover more concepts. I enjoyed learning SQL and for the first time I felt this is the way training has to be. Knowledgeable faculty.

A

Anchana Selvarajan

I attended SQL training taken by Umasankar at ATI .I liked his SQL training class. He made us to work with queries at the right moment which was very clear and precise and he was dedicated in clearing the doubts too.

S

Sathiah Kumar

I took a SQL class under Mr. Umashankar at ATI. It's clear that he knows his stuff inside and out and always up to the point. He was very humble and patient in clearing the doubts. The exercises given in the class were interesting. I would recommend his class to anyone who wants to learn SQL.

P

Prashanna Hegde

Actually I am from Non-IT background and had no previous knowledge about IT related codes and programmes. I was very much worried and confused whether I would be able to catch the pase with other people in the class. But after attending Umashankar class, my confidence has really boosted, he is very nice person who is very humble in nature and he does not get irritated in spite of asking him to repeat multiple times about queries. He is very punctual to his work and has good patience while teaching and also. He teaches the codes step by step and makes sure that everyone has understood the concept. He does even point out the interview questions which is useful for the first timers.

K

Kaustav Ghosh

I attended SQL training in ATI. Excellent class by Mr. Umashankar. Good content delivery on his part and displayed great pupil engagement skills.

S

Shaik Hazrat

I like your training sections, it is very clear and easy to understand. I like the way you make it simple and explain very well. I was very confused about joins concepts in SQL but you made it very simple and explained clearly with good examples. I recommend my friends also to attend your classes. Thank you so much sir.

V

Vandana Parashar

Very impressive training with good insight of SQL basics and applications. Presentations and course material are very informative and easily understandable. He has vast knowledge and able to clarify all doubts with simpler examples. Patient and friendly tutor. Thank you Sir.

K

Krishna Chaitanya

I have attended the SQL session taken by Mr.Umasankar in ATI. Concept was clearly explained with practical examples. Though I had zero knowledge on SQL, I was able to understand the concept and syntax very clearly.The presentation was simple and easy to follow covering all the important concepts with examples. Each concept was demonstrated practically by coding then and there itself. All the doubts were clarified and codes/presentation was shared via email on the same day. Important tips are also being shared even after the sessions are completed.I would highly recommend anyone who is interested in learning SQL to attend his classes to start or grow their career in SQL domain.

S

Senthilnathan R

The SQL class you have taken was really nice. In addition to that, writing SQL queries you have practically done it . We get confidence to write a SQL query at any point of time. Hereafter, we will be able to write SQL query after attending your class.

A

Abhilash Velaan

I attended his SQL class in ATI. He makes you thorough with the basics of SQL, while providing with good examples. His support lasts beyond the class, provides with excellent guidance.

P

Poovesh Kumar

Attended SQL training in ATI. I liked the hands on experience of the class. Right from basics, all the necessary details were covered.

H

Hemang R Parghi

Training for SQL was good, knowledge of the tutor is really helpful. He guides personally as well. Overall good experience.

A

Amrita Dutta

Attended SQL training by Mr. Umashankar in ATI. Sessions was fruitful, he covered a lot of syntax n commands with examples, which was helpful in increasing knowledge of practical application of the commands. It will be more useful if the topics are followed by at least one practice sessions. And including a few case studies during the sessions will make the training more effective.

K

Karan A

Attended SQL training at ATI. One of the best person in terms of knowledge in depth in SQL. Very simple style of teaching but can understand really well with nice presentation.

Discussions

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for SQL Programming Training Post your requirement now

Enquire

Submit your enquiry for SQL in Depth ( 4 Hours / Day ) Weekdays / Weekend Batches

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Umasankar

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

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