Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
MS SQL Server From Scratch
Such an awesome Course.I searched various resources,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.
i work as DBA assistant and this course help me a lot to improve my knowledge.
Uzoma Umekwe Charles II
Worth every single second of my time
I just like to say that I have been following almost all of Mazoor's courses on Udemy and that is only because I consider him a good teacher. In this course I like how he takes time to explain and also demonstrates his knowledge for the subject. I would recommend him anytime anyday!
Great Stuff for On-The-Fly Review!
Simply concise instructions! No blabbing stories!! :)
Very good and very helpful for the first steps of SQL. Gives an idea what the whole thing is about and goes a little bit further!!
IT Professional Trainer Bongani Skosana
Thanks Manzoor. This is such a wonderful training. I have learned so much, well explained and demonstrated. Keep up the good work.
Q. What is MS SQL Server?
A. Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for different workloads (ranging from small applications that store and retrieve data on the same computer, to millions of users and computers that access huge amounts of data from the Internet at the same time). Its primary query languages are T-SQL and ANSI SQL.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Basic MS Sql Server Data Definition Language|
Getting Started With Sql Server Management StudioPreview
Create A DatabasePreview
Creates a new table in SQL Server and managing it.
|Section 2: Data Manipulation Language - Insert,Update And Delete|
Adds a new row to a table or a view using Insert statement
Updating and deleting an existing row to a table using Update and delete statement
|Section 3: Data Manipulation Language - Select|
Retriving existing rows from a table using select statement.
Top(), Order by, Where, in, not in, between, not between and Like Clauses
Aggregate Functions like Sum(), Avg(), Min(), Max(), Count() etc.,
|Section 4: Data Manipulation Language - Built In Functions|
string Functions Like Lower(), Upper(), Reverse(), SubString(), etc.,
|Section 5: Data Manipulation Language - Advance clauses and Joins|
Group By and Having Clause
Joins Like Inner Join, Left Outer Join, Right Outer Join, Full Outer Join
Implementing Joins Like Inner Join, Left Outer Join, Right Outer Join, Full Outer Join.
|Section 6: Data Manipulation Language - Stored Procedures And Functions|
Creating Stored Procedures With No Input And Output Params
Creating Stored Procedures With Input And No Output Params
Creating Stored Procedures With Input And Output Params
Creating User Defined Functions
|Section 7: Subqueries|
EXISTS and not EXISTS
|Section 8: Advanced Data Manuplation And Control Structures|
Delete Vs Truncate
|Section 9: Advanced Operations|
Slowly Changing Dimensions
Scope Identity Function
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