Tutorialspoint
Subscription Includes
$ 23   11

Learn SQL Server step by step

Created by SHIVPRASAD KOIRALA, Last Updated 26-Feb-2020, Language:English

Learn SQL Server step by step

Step by Step Videos tutorial guide for learning SQL Server practically

Created by SHIVPRASAD KOIRALA, Last Updated 26-Feb-2020, Language:English

What Will I Get ?

  • Creating Tables, Rows and Columns in Database.
  • Using basic operations - Select, Insert, Update and Delete operations in SQL Server.
  • Understanding Transactions, Locks and Isolation level, Triggers, Understanding Normalization Forms in SQL Server.
  • ISNULL & Coalesce Functions, Row_Number, Partition, Rank and DenseRank.
  • Star Schema Design, Snow Flake Design, SQL Server 8 KB Pages, Index, performances, Page Split.
  • CDC(Change Data Capture) in SQL, SQL Server agent.
  • Implementing Pivot & Unpivot in SQL Server.

Requirements

  • No experienced required, should have the will to learn.

Description

This training will be covering below topics-

  • Basic Fundamentals Database, Tables, rows and columns.
  • Primary key, foreign key, referential integrity and constraints.
  • Database Normalization (1st, 2nd and 3rd normal forms).
  • SQL basics(Select, Insert, Update and Delete)
  • DDL (Data definition language) Queries.
  • Transactions, Locks and Isolation level in SQL Server.
  • ISNULL and Coalesce functions.
  • Row_Number, Partition, Rank and DenseRank
  • Triggers, inserted and deleted tables
  • Instead of and after triggers.
  • Denormalization, OLTP and OLAP.
  • Understanding Star schema and Snow flake design.
  • SQL Server 8 kb pages.
  • Index and performances
  • Page Split and indexes
  • Clustered vs non-clustered
  • Stored procedures and their importance.
  • Change Data Capture.
  • Explain Columnstore Indexes?
  • SQL Server agent
  • How can we implement Pivot & Unpivot in SQL Server?

Course Content

SHIVPRASAD KOIRALA

I love recording Step by Step tutorials

My name is Shivprasad Koirala ( thats my young time photo) , I love teaching and learning , I started QuestPond website 15 years back with the one single goal creating quality step by step IT programming related lessons.

I saw many lessons online , either they are done too fast or too slow or are too complicated.

The main goal of Questpond is to create Step by Step lessons on C#, ASP.NET , Design  patterns , SQL and so on. As years moved on i added other step by step lessons like Angular , Sharepoint , MSBI, Azure and so on.