Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.


MS SQL Server With Real World Db Design Techniques

via Udemy


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

What you'll 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

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 ofstored proceduresanduser defined function. Then we will go for writingsub querieswhich includes scalar, multi valued andcorrelated sub queries.

Moving ahead we see the programming logic in query writing usingT-SQLand understand how to writeconditional statementsin your large complex stored procedures. And finally we will try to understand the advanced concepts likeviews,scope identity function,transactionsandtriggers.

So, I ensure you thatyou will enjoy each and every minute of the videosby 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)

Taught by

Manzoor Ahmed


4.3 rating at Udemy based on 443 ratings

Start your review of MS SQL Server With Real World Db Design Techniques

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.