sql server for beginners

Description

It has 20 labs which covers the below syllabus.

Lab 1:- Basic Fundamentals Database, Tables, rows and columns.

Lab 2:- Primary key, foreign key, referential integrity and constraints.

Lab 3 :- Database Normalization (1st, 2nd and 3rd normal forms).

Lab 4: – SQL basics(Select, Insert, Update and Delete)

Lab 5 :- DDL (Data definition language) Queries.

Lab 6: – ISNULL and Coalesce functions.

Lab 7: – Row_Number, Partition, Rank and DenseRank

Lab 8: – Triggers, inserted and deleted tables

Lab 9: – Instead of and after triggers.

Lab 10: – Denormalization, OLTP and OLAP

Lab 11: – Understanding Star schema and Snow flake design.

Lab 12: – SQL Server 8 kb pages.

Lab 13 :- Index and performances

Lab 14 :- Page Split and indexes

Lab 15 :- Clustered vs non-clustered

Lab 16: – Stored procedures and their importance.

Lab 17: – Change Data Capture.

Lab 18: – Explain Columnstore Indexes?

Lab 19: – SQL Server agent

Lab 20: – How can we implement Pivot & Unpivot in SQL Server?

Who this course is for:

  • Developers who want to become SQL Server developers

Requirements

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

Last updated 12/2018

Download

Direct Download

sql server for beginners.zip | Mirror [Size: 2.5 GB]

Download Torrent (Please seed after downloading)

Download Torrent | Mirror

Source: https://www.udemy.com/sql-server-sql/

Leave a Reply

Your email address will not be published. Required fields are marked *