Learn Databases from Developer Perspective (7 hours) Training - Urdu/Hindi

In this training, you will learn databases concepts (primarily with SQL server but almost same concepts apply to other RDBMS too) with practical examples. Practice is must. After this training, you may consider yourself as (at least) 2 years experienced Database Developer. ----------- [00:00:00] Introduction to Databases [00:08:58] Data Anomalies [00:16:43] Candidate Keys + Relationships [00:30:56] Normalization [00:42:50] SQL Server Installation [00:54:50] SQL Server Introduction [01:04:10] Tables Creation in Management Studio [01:11:12] Data Types in SQL Server [01:23:31] Introduction to SELECT Statement [01:36:37] DDL, DML Syntax [01:44:48] DDL, DML Examples [01:53:50] Group Functions [02:09:50] Introduction to Joins [02:18:06] Joins Examples [02:33:11] Introduction to T-SQL [02:42:33] Stored Procedures [02:49:57] Functions [03:00:05] Intro to Temp Tables [03:18:29] Intro to Views [03:33:03] Intro to Database Constraints [03:44:32] Intro to Triggers [03:55:28] Clustered Index vs. Non-Clustered Index [04:07:35] Sub Query vs. Derived Table vs. CTE [04:19:53] Row Number, Rank, Dense Rank, Partition By [04:29:12] Miscellaneous Concepts -- Exists -- Dynamic Query -- TOP, DISTINCT -- UNION -- UNION ALL -- INTERSECT -- EXCEPT -- Introduction to full text search [04:37:40] Practical Example: Workflow System [05:15:35] Practical Example: Schedule Management System [05:42:04] Practical Example: Playing with Election 2013 data [06:15:27] Transactions ACID properties Isolation Levels [06:25:08] Transaction ISOLATION Levels in SQL Server [06:56:47] Tips Regarding Management Studio + DB Design (Performance) ----- Helping Scripts are available at https://github.com/bilalshahzad139/databases-learn-in-urdu For More Free Videos http://learninginurdu.pk/ https://www.youtube.com/c/LearnInUrdu139 Facebook Page https://www.facebook.com/LearningInUrduCentre/