Learn MS SQL Server 2017 With Db Design Techniques

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

   Watch Promo

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 (Will Arrive Soon)
  • 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)

Your Instructor

Manzoor The Trainer
Manzoor The 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

Frequently Asked Questions

When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Get started now!