The Complete Mysql Server From Scratch: Bootcamp 1 Section45 Lessons1 QuizLifetime Access
Curriculum
- 1 Section
- 45 Lessons
- Lifetime Access
Expand all sectionsCollapse all sections
- The Complete Mysql Server From Scratch: Bootcamp46 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) (Copy)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 (The Complete Mysql Server From Scratch: Bootcamp)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
Certificate Validator
Quickly and easily check the validity of your
Royal Open College course certificates with Royal Open College’s Course Certificate Validator tool.
Payment methods possible
Copyright © 2026 Royal Open College. All Right Reserved.






