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.
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
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
PreviewLecture 1 : Creating Stored Procedures With No Input And No Output Params (4:30)
PreviewLecture 2 : Creating Stored Procedures With Input And No Output Params (3:52)
PreviewLecture 3 : Creating Stored Procedures With Input And Output Params (5:04)
PreviewLecture 4 : Creating User Defined Functions (7:39)