{"title":"Learn SQL Server Step By Step","description":null,"products":[{"product_id":"learn-sql-server-step-by-step","title":"Learn SQL server step by step","description":"\u003ch4 class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eWhat will students learn in your course?\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eSQL Server installation, creating entities like database , tables , rows and columns. Covers fundamentals like primary key,foreign key , referential integrity , constraints , normalization ( first , second and third normal forms), Denormalization,OLTP , OLAP, StarSchema and SnowFlake design.\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eWriting DML and DDL query like inner join,left join,right join, outer join, union , co-related queries, union all, alias,case statements,cartesian,ISNULL, aggregate( sum\/count),wild card , top, order by, create , insert, bulk insert , update , backup , restore,ISNULL,Coalesce,Row_Number, Partition, Rank ,DenseRank   , Pivot and Unpivot.\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eUnderstanding importance of indexes , how it makes our search faster , non-clustered indexes vs clustered indexes , page splits in indexes and column store indexes.\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eTriggers,Insteadof , After trigger ,Inserted , deleted tables ,Stored Procedures,CDC,8 KB page and SQL Server agent.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch4 class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eWhat are the requirements or prerequisites for taking your course?\u003c\/h4\u003e\n\u003cdiv class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003e\n\u003cul\u003e\n\u003cli\u003eNo experienced required , should have the will to learn :-)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch4 class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eWho is this course for?\u003c\/h4\u003e\n\u003cdiv class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003e\n\u003cul\u003e\n\u003cli\u003eDevelopers who want to become SQL Server developers\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp data-pm-slice=\"1 1 []\"\u003e\u003cstrong\u003eIt has 21 labs which covers the below syllabus.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp data-pm-slice=\"1 1 []\"\u003eLab 1:- Basic Fundamentals Database, Tables, rows and columns.\u003cbr\u003eLab 2:- Primary key, foreign key, referential integrity and constraints.\u003cbr\u003eLab 3 :- Database Normalization (1st, 2nd and 3rd normal forms).\u003cbr\u003eLab 4: - SQL basics(Select, Insert, Update and Delete)\u003cbr\u003eLab 5 :- DDL (Data definition language) Queries.\u003cbr\u003eLab 6: - Transactions, Locks and Isolation level in SQL Server.\u003cbr\u003eLab 7: - ISNULL and Coalesce functions.\u003cbr\u003eLab 8: - Row_Number, Partition, Rank and DenseRank\u003cbr\u003eLab 9: - Triggers, inserted and deleted tables\u003cbr\u003eLab 10: - Instead of and after triggers.\u003cbr\u003eLab 11: - Denormalization, OLTP and OLAP.\u003cbr\u003eLab 12: - Understanding Star schema and Snow flake design.\u003cbr\u003eLab 13: - SQL Server 8 kb pages.\u003cbr\u003eLab 14 :- Index and performances\u003cbr\u003eLab 15 :- Page Split and indexes\u003cbr\u003eLab 16 :- Clustered vs non-clustered\u003cbr\u003eLab 17: - Stored procedures and their importance.\u003cbr\u003eLab 18: - Change Data Capture.\u003cbr\u003eLab 19: - Explain Columnstore Indexes?\u003cbr\u003eLab 20: - SQL Server agent\u003cbr\u003eLab 21: - How can we implement Pivot \u0026amp; Unpivot in SQL Server?\u003c\/p\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e","brand":"Questpond","offers":[{"title":"Default Title","offer_id":42865920770254,"sku":"","price":999.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0644\/2359\/2142\/files\/Learnsqlserver-100.jpg?v=1731752313"}],"url":"https:\/\/questpondshop.myshopify.com\/collections\/learn-sql-server-step-by-step.oembed","provider":"Questpond Videos","version":"1.0","type":"link"}