Learn MS SQL Server Advanced Concepts

Lectures : 13 | Video : 1.9 hours | Includes : Lifetime access

Hi, if you are done with Learn MS SQL Server From Scratch Free Course then this is the right course for you. In this course we will start from understand how to write different kinds of stored procedures and user defined function. Then we will go for writing sub queries which includes scalar, multi valued and correlated sub queries.

Moving ahead we see the programming logic in query writing using T-SQL and understand how to write conditional statements in your large complex stored procedures. And finally we will try to understand the advanced concepts like views, scope identity function, transactions and triggers.

So, I ensure you that you will enjoy each and every minute of the videos by learning something new.

See what our students are saying about this course...

This is a really good class, and was a natural segue after taking a really introductory course.

Manzoor goes into great detail, and since he shows exactly what he's doing on video, it's easy to follow along and not get lost as sometimes happens in live instructor-led courses.

I think I know enough now to be well positioned for a job with more emphasis on SQL Server than Excel or Access. I've worked with SQL for 10+ years, but not with SQL Server that much.

- Louis Hemmi

Hands down THE BEST COURSE I have taken. Manzoor rocks this topic, with solid examples and hands-on learning experiences. The tools provided will allow students to build live databases, not toys. This is a great course!!

- John Omohundro

I am working on SQL Server, coming from a DB2 Environment. This helped me to come up to speed with SQL Server and understand the concepts.
Course was clear and well presented.

- Carl Pohl

Such an awesome Course.I searched various resourses,subscribed the training in may other sites but never came across such an awesome,precise,to the point explanation.Very good trainer.Very good course and am very happy I could reach the trainer whenever i was getting errors.My problem was solved within 12 hours always.Waiting for the upcoming video.One request to do a video o triggers.
Keep up the good work.All the Best Manzoor.

- Rekha

Very Thorough and Well Organized! I am astonished at how much I have learned from this course even with a strong background in databases and programming. Highly recommend this course if you are looking to refresh your knowledge of SQL Server or learn from the start.

- Farhan Ishraq

Your Instructor

Manzoor The Trainer
Manzoor The Trainer

Manzoor is a Microsoft Certified Trainer who has been working on MS .Net technologies for more than a decade. Apart from development he is also passionate about delivering training on various MS .Net technologies and he has 10+ years of experience as a software development teacher. He writes articles for code-project as well. His YouTube channel has 1 million hits. He is the founder of ManzoorTheTrainer portal.

"I focus on simplifying, complex concepts..." - ManzoorTheTrainer

Frequently Asked Questions

When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Get started now!