UrbanPro
true

Learn SQL

LIVE
1 review
30 Hours

Just Pay ₹1,500 to Register

- OR -

Course offered by Marineni Chinmaya Srikanth

4 reviews

This course is designed for people who aspires to become a Data Analyst/Data Scientist/Data Engineer/Software Developer or anyone who wish to learn SQL.All the concepts will be taught in an easier way with examples and practice questions wherever necessary.By the end of this course learners will be able to manipulate data and write complex queries in a best possible way.We will be using MICROSOFT SSMS for this tutorial.This course is divided into three parts as below.

BASIC

  1. SQL Overview and Basics
  2. Types of SQL Statements
  3. Working with Databases and Tables
  4. Alter, Drop and Truncate statements
  5. Various constraints
  6. Select and where
  7. Update,Insert and Delete Statements
  8. Case statement,Like, in,not in, intersect and except operator
  9. Identity column
  10. Handling NULLS
  11. Distinct, Orderby
  12. Group By and Having
  13. Where vs Having
  14. Union and union all
  15. union vs join
  16. Joins and Comparison
  17. Schemas

INTERMEDIATE

  1. Coalesce function
  2. String functions
  3. Date Functions
  4. Casting and mathematical functions
  5. User Defined functions
  6. Sequence
  7. Indexes
  8. Views
  9. Materialized Views and comparison
  10. Stored procedures
  11. Debugging procedures
  12. Exception Handling
  13. Stored Procedures vs Functions
  14. Temporary Tables
  15. Triggers
  16. Audit tables and other triggers
  17. Subqueries
  18. Subquery vs join
  19. CTE
  20. CTE vs Temporary Tables
  21. Partition and OVER 
  22. Row number, Rank and Dense Rank
  23. Transactions
  24. Normalisation

ADVANCED

  1. Cursors
  2. Why should we avoid cursors
  3. Merge 
  4. Concurrent Transactions
  5. Deadlocks
  6. Table valued and other functions
  7. Optional parameters in SQL
  8. Grouping function
  9. Pivot and Unpivot
  10. Miscellaneous Functions
  11. Offset fetch and GUID
  12. Dynamic SQL
  13. Caching Sql query
  14. Exec vs execute sql
  15. ACID properties
  16. Miscellaneous topics

ADD ONS

  1. Performance tuning
  2. Interview questions

About the Trainer

Marineni Chinmaya Srikanth picture

5 Avg Rating

4 Reviews

5 Students

2 Courses

Marineni Chinmaya Srikanth

Bachelor of Technology (B.Tech.) from V R SIDDHARTHA ENGINEERING COLLEGE in 2015

I am working as a dotnet full stack developer with a total of 8 years experience in IT industry. I am an AZURE certified professional. I am enthusiastic in learning new programming skills. I have taken some mentorship roles as well in my career. I came from a non programming background hence I have had enough challenges in the beginning of my career in understanding the programming concepts. Hence I decided to help the students with my experience and skills. My goal is to teach the subjects(C#, LINQ, ADO.NET and SQL) at basic level so that it would help learners in becoming better programmers. Having said that, I wish to cover all the concepts at deeper level.
My teaching style would be like explaining the basic concepts first with enough practice questions and then teaching advanced concepts in a simpler way. Along with the concepts, I will also help with the interview guidance and good programming practices. I would love to help the students in building a strong career path. I prefer to teach online and mostly during the weekends.

Students also enrolled in these courses

LIVE
26 reviews
10 Hours
3,000 Group Class (max 5)
6,500 1-on-1 Class

Course offered by Rupesh Vaingankar

14 reviews
LIVE
20 reviews
20 Hours
6,000 Group Class (max 10)
10,000 1-on-1 Class

Course offered by Juned Ahmad Hashmi

27 reviews
LIVE
1 review
10 Hours
10,000 1-on-1 Class

Course offered by Vinod

59 reviews
LIVE
10 Hours
20,000 Group Class (max 2)
25,000 1-on-1 Class

Course offered by Vicky

0 review

Reviews (1)

5 out of 5 1 review

Marineni Chinmaya Srikanth https://p.urbanpro.com/tv-prod/member/photo/11710938-small.jpg Miyapur
5.0051
Marineni Chinmaya Srikanth
R

Learn SQL

"Excellence teaching through all concepts in SQL from beginning and I loved the way of teaching with much patience and good guidance. "

View All
Have you attended any class with Vicky?

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

5 out of 5 1 review

Marineni Chinmaya Srikanth https://p.urbanpro.com/tv-prod/member/photo/11710938-small.jpg Miyapur
5.0051
Marineni Chinmaya Srikanth
R

Learn SQL

"Excellence teaching through all concepts in SQL from beginning and I loved the way of teaching with much patience and good guidance. "

Have you attended any class with Vicky?

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

tickYou have successfully registered

Learn SQL by Marineni Chinmaya Srikanth

Marineni Chinmaya Srikanth picture
LIVE
(1 reviews)

Class
starts in

00

Days

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Learn SQL by Marineni Chinmaya Srikanth

Marineni Chinmaya Srikanth picture
LIVE
(1 reviews)

Class
starts in

00

Days

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

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