Learn MS SQL Server 2017 With Db Design Techniques (Udemy.com)

With real time data base designing techniques, SQL, Joins, SPs, Functions, Views, Transactions, Triggers and lot more...

( 48 Reviews )

Created by: Manzoor Ahmed

Produced in 2018

What you will 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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 86 / 100

Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a sql course? Or looking for more detail on Manzoor Ahmed's Learn MS SQL Server 2017 With Db Design Techniques? Feel free to chat below.

Join CourseDuck's Online Learning Discord Community

Course Description

Q: Is it possible for me to learn query writing against MS SQL Server database, even if I don't have any basics of DBMS?
A: Yes! you can learn and this course is perfect for those who are absolute beginners in MS SQL Server technology. In this course we are going to learn every thing from scratch i.e., right from installing MS SQL Server management Studio, creating database, tables, understanding relationships, performing basic insert, update, delete and select operations, using basic builtin functions till all types of joins.
We will also understand how to write different kinds of stored procedures and user defined function. Then we will go for writing sub querieswhich 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
Topics Covered are :

Introduction-Database-Table-Keys (36:14)
DataTypes-ForeignKey-DBDesign-Techniques (37:26)
Insert-Update-Delete-Select Start (37:42)
OrderBy-Where-String-Aggrigate (48:11)
DateTimeFunctions-GroupBy-IntroToJoins (40:46)
Implementing 2 And 3 Tables Joins (24:16)
SelfJoin-Union-Simple-Correlates-SubQueries (34:26)
Views And Common Table Expression (CTE) (31:25)
StoredProcedures-Functions (33:00)
Table Variables - Transactions - Slowly Changing Dimensions - ScopeIdentity (36:26)
Triggers - Admin Tasks - Assigment (34:00)

Who this course is for:

Fresh Graduates

Time: 10.5h

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

Instructor Details

Manzoor Ahmed

4.3 Rating
48 Reviews

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

SQL in Motion (2017)

0.0 (0 Reviews)

Provider: Manning Publications
Time: 4h

$59.99

Introduction to SQL (2015)

0.0 (0 Reviews)

Provider: SQLBolt

Free

Intro to SQL: Querying and managing data (2015)

0.0 (0 Reviews)

Provider: Khan Academy
Time: 1h

Free

More Courses

Reviews

4.3

48 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Armin Hirsch on

Audio if first part very bad, makes it nearly impossible to listen to.

By Kumaran S on

I am new to SQL and came here to learn the best and get a change in my career. Hope my expectation would be met

By Rafael Diaz on

I LIKE THE DETAILS FROM ZERO TO KNOW AS MUCH AS I NEED TO, AND HE IS DOING IT, THANKS

By TrevorHowardMartin Martin on

Very well done. I was able to follow along with a database of my own! Looking forward to utilizing these tools to build some very valuable reports and add meaningful impact to my professional skillset. Additionally, I will say that Manzoor is very attentive toward his students. Anytime I had a question he was quick to answer within a day or so.

By Bipin Bihari Pradhan on

Course content is good, but video quality is very bad. If possible update the Video

By Feraud Hamid on

Outstanding teaching style.

By Louis Hemmi on

This is a really good class, and was a natural segue after taking a really introductory course on Udemy.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.

By Raghavendra Sunku on

He is explaining very briefly with examples. he covered all the topics. very nice

By Raffaelepagani on

Si sembra proprio adatto a meyes i'm thinking that this course is what i need

By Guruprasad Madivali on

This course' certificate could be improved and stated in a better way.It mentions total time of videos of this course on it and undermines the additional time and effort put in by students (surely greater than 4 hours of videos). It exclusively shows/tags that the student has done ONLY 4 hours of course or effort to earn this course/knowledge.Somehow this course' certificate leaves you feeling less important compared to other similar courses and this makes this course less attractive/valuable.It states: "This is to certify that (XXX-name) completed 4 hours of Learn MS SQL from scratch online course on DD-MM-YYYY".Rather all other completion certificates I have received on Udemy would state / have stated: "This is to certify that (XXX-name) completed (COURSE NAME) online course on DD-MM-YYYY".

By Justin Craig Richter on

I've just started and the content is easy to follow. I'd like to see the videos updated to current versions of SQL though.

By John Omohundro on

Hands down THE BEST COURSE I have taken at Udemy. 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!!