Learn MS SQL Server From Scratch
4.1 (223 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
9,723 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn MS SQL Server From Scratch to your Wishlist.

Add to Wishlist

Learn MS SQL Server From Scratch

SQL is a standard language for accessing any database
4.1 (223 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
9,723 students enrolled
Last updated 1/2015
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
By the end of this course you will be in a position to do the following :-
Creating, Altering And Dropping DataBase Creating Tables
Primary Keys, Identity Columns and Unique Keys DataBase Diagram and Creating Relationships between tables
DataTypes In SQL Server
Insert Statement, Update Statement and Delete Statement
Select Statement with Top(), Order by, Where, in, not in, between, not between and Like Clauses, Aggregate Functions like Sum(), Avg(), Min(), Max(), Count() etc.,
DateTime Functions Like getDate(), Day(), Month(), Year(), DateDiff(), DateAdd(), etc.,
Group By and Having Clause with 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.
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 and Creating Functions
View Curriculum
Requirements
  • Need MS Sql Server express of any version higher than 2005 installed on your system.
Description

Few Proofs:

Rekha

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.

Julio Mendez

i learned a lot. very helpful

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!

Chris Motunmori

Great Stuff for On-The-Fly Review!

Simply concise instructions! No blabbing stories!! :)

Amalia Artopoulou

Congrats!!

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

Awesome

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.

Who is the target audience?
  • Fresh Graduates
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 32 Lectures Collapse All 32 Lectures 03:52:58
+
Basic MS Sql Server Data Definition Language
3 Lectures 27:02
+
Data Manipulation Language - Insert,Update And Delete
2 Lectures 07:04

Adds a new row to a table or a view using Insert statement

Preview 03:55

Updating and deleting an existing row to a table using Update and delete statement

Preview 03:09
+
Data Manipulation Language - Select
2 Lectures 15:29

Retriving existing rows from a table using select statement.

Select Statement
04:10

Top(), Order by, Where, in, not in, between, not between and Like Clauses

Aggregate Functions like Sum(), Avg(), Min(), Max(), Count() etc.,

Various Clauses
11:19
+
Data Manipulation Language - Built In Functions
2 Lectures 21:05

string Functions Like Lower(), Upper(), Reverse(), SubString(), etc.,

Built In Functions
12:24

DateTime Functions
08:41
+
Data Manipulation Language - Advance clauses and Joins
4 Lectures 32:27

Group By and Having Clause

Group By and Having Clause
11:50

Joins Like Inner Join, Left Outer Join, Right Outer Join, Full Outer Join

Understanding Joins
06:30

Implementing Joins Like Inner Join, Left Outer Join, Right Outer Join, Full Outer Join.

Implementing Joins
08:35

Self Join
05:32
+
Data Manipulation Language - Stored Procedures And Functions
4 Lectures 21:18

Creating Stored Procedures With No Input And Output Params

Creating Stored Procedures With No Input And Output Params
04:33

Creating Stored Procedures With Input And No Output Params

Creating Stored Procedures With Input And No Output Params
03:56

Creating Stored Procedures With Input And Output Params

Creating Stored Procedures With Input And Output Params
05:07

Creating User Defined Functions

Creating User Defined Functions
07:42
+
Subqueries
4 Lectures 30:47
Scalar SubQueries
05:56

Multivalued Subqueries
08:03

EXISTS and not EXISTS
03:25

Correlated Queries
13:23
+
Advanced Data Manuplation And Control Structures
5 Lectures 33:45
Delete Vs Truncate
07:45

OUTPUT clause
03:12

IIF()
01:41

Case When
09:14

IF...ELSE
11:53
+
Advanced Operations
6 Lectures 34:01
Views
07:58

Slowly Changing Dimensions
06:10

Scope Identity Function
07:48

Transactions
05:57

Triggers
06:08

Download Queries
10 pages
About the Instructor
Mohammed Manzoor Ahmed
4.3 Average rating
1,849 Reviews
40,774 Students
11 Courses
Microsoft Certified 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