Microsoft Sql Server Development For Everyone 1 Section45 Lessons1 QuizLifetime Access
Curriculum
- 1 Section
- 45 Lessons
- Lifetime Access
Expand all sectionsCollapse all sections
- Microsoft Sql Server Development For Everyone46 Items
- 1.1Module 01. Introduction2 Minutes
- 1.2Module 02. SQL Server 2019 Express8 Minutes
- 1.3Module 03. Installing SQL Server Management Studio4 Minutes
- 1.4Module 04. Downloading the AdventureWorks Sample Database8 Minutes
- 1.5Module 05. Course Environment Walkthrough10 Minutes
- 1.6Module 06. Window Function with OVER10 Minutes
- 1.7Module 07. PARTITION_BY6 Minutes
- 1.8Module 08. ROW_NUMBER11 Minutes
- 1.9Module 09. RANK and DENSE_RANK8 Minutes
- 1.10Module 10 (Part 1). Introducing Subqueries8 Minutes
- 1.11Module 10 (Part 2). Scalar Subqueries8 Minutes
- 1.12Module 11. Correlated Subqueries11 Minutes
- 1.13Module 12. EXISTS14 Minutes
- 1.14Module 13. FOR XML PATH with STUFF15 Minutes
- 1.15Module 14. PIVOT (Part 1)11 Minutes
- 1.16Module 15. PIVOT (Part 2)9 Minutes
- 1.17Module 16. Common Table Expressions (Part 1)11 Minutes
- 1.18Module 16. Common Table Expressions (Part 2)
- 1.19Module 17. Recursive CTEs14 Minutes
- 1.20Module 18. TEMP Tables (Part 1)11 Minutes
- 1.21Module 19. TEMP Tables (Part 2)
- 1.22Module 20. CREATE and INSERTvvvvvvvv14 Minutes
- 1.23Module 21. TRUNCATE (Part 1)10 Minutes
- 1.24Module 22. TRUNCATE (Part 2)9 Minutes
- 1.25Module 23. Modifying Tables Using UPDATE (Part 1)9 Minutes
- 1.26Module 24. Modifying Tables Using UPDATE (Part 2)9 Minutes
- 1.27Module 25. DELETE5 Minutes
- 1.28Module 26. Optimizing with UPDATE (Part 1)8 Minutes
- 1.29Module 27. Optimizing with UPDATE (Part 2)9 Minutes
- 1.30Module 28. Improved EXISTS with UPDATE12 Minutes
- 1.31Module 29. Introduction to Indexes10 Minutes
- 1.32Module 30. Index Example12 Minutes
- 1.33Module 31. LOOKUP Tables (Part 1)14 Minutes
- 1.34Module 32. LOOKUP Tables (Part 2)8 Minutes
- 1.35Module 33. The Use of Variables (Part 1)10 Minutes
- 1.36Module 34. The Use of Variables (Part 2)9 Minutes
- 1.37Module 35. User Defined Functions8 Minutes
- 1.38Module 36. Making Functions Reusable12 Minutes
- 1.39Module 37. Stored Procdeures12 Minutes
- 1.40Module 38. Control Flow With IF Statement12 Minutes
- 1.41Module 39. Using Multiple IF Statements8 Minutes
- 1.42Module 40. Dynamic SQL (Part 1)10 Minutes
- 1.43Module 41. Dynamic SQL (Part 2)15 Minutes
- 1.44Mock Exam (Microsoft Sql Server Development For Everyone)50 Minutes40 Questions
- 1.45Final Exam
- 1.46Order Your Certificate
Royal Open College provides high-quality online courses covering a variety of topics along with certificates issued by top organisations.
Explore
Important Links
Payment methods possible
Company Registration No : 14422633
Copyright © 2026 Royal Open College. All Right Reserved.