UdemySQLPaid courseBeginner levelCertificate

Master MS SQL Server and Database Design Techniques (Udemy.com)

Unlock the full potential of your database management skills with our comprehensive course on MS SQL Server

4.4

451 reviews

Created by: Manzoor Ahmed

Last updated June 2024

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.

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 88 / 100

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

Beginner Level

Time: 23.8h

Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

Instructor Details

Manzoor Ahmed

4.4 Rating
451 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