stego.ro - /helpme/_C_U_R_S_U_R_I_/Udemy-70-461.761.Querying.Microsoft.SQL.Server.with.Transact-SQL/
[To Parent Directory]
Friday, November 24, 2023 2:59 PM <dir> 1. Session 1 - Let's begin, and let's download SQL Server
Friday, November 24, 2023 3:00 PM <dir> 10. Session 2 - Summarising and ordering data
Friday, November 24, 2023 3:01 PM <dir> 11. Session 2 - Adding a second table
Friday, November 24, 2023 3:01 PM <dir> 12. Session 2 - Find missing data, and delete and update data
Friday, November 24, 2023 3:01 PM <dir> 13. End of Session 2
Friday, November 24, 2023 3:02 PM <dir> 14. Session 3 - Introduction
Friday, November 24, 2023 3:03 PM <dir> 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)
Friday, November 24, 2023 3:04 PM <dir> 16. Session 3 - Objectives 2 and 3 Views
Friday, November 24, 2023 3:05 PM <dir> 17. Session 3 - Objective 5 Create and alter DML triggers
Friday, November 24, 2023 3:05 PM <dir> 18. Session 3 - Conclusion
Friday, November 24, 2023 3:05 PM <dir> 19. Session 4 - Introduction
Friday, November 24, 2023 3:05 PM <dir> 2. Session 1 - Starting SQL Server
Friday, November 24, 2023 3:07 PM <dir> 20. Session 4 - Objective 13 Combine datasets
Friday, November 24, 2023 3:07 PM <dir> 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements
Friday, November 24, 2023 3:08 PM <dir> 22. Session 4 - Objective 18a - Implement trycatchthrow
Friday, November 24, 2023 3:08 PM <dir> 23. End of Session 4!
Friday, November 24, 2023 3:08 PM <dir> 24. Session 5 - Introduction
Friday, November 24, 2023 3:09 PM <dir> 25. Session 5 - Objective 9 Implement aggregate queries
Friday, November 24, 2023 3:09 PM <dir> 26. Session 5 - Objective 9d Ranking functions
Friday, November 24, 2023 3:10 PM <dir> 27. Session 5 - Objective 9a New analytic functions
Friday, November 24, 2023 3:10 PM <dir> 28. Section 5 - Objective 9b Grouping sets
Friday, November 24, 2023 3:11 PM <dir> 29. Session 5 - Objective 9c Spatial aggregates
Friday, November 24, 2023 3:11 PM <dir> 3. Session 1 - Creating tables - First pass
Friday, November 24, 2023 3:11 PM <dir> 30. End of Session 5
Friday, November 24, 2023 3:12 PM <dir> 31. Session 6 - Introduction
Friday, November 24, 2023 3:12 PM <dir> 32. Session 6 - Objective 7 Sub-queries
Friday, November 24, 2023 3:13 PM <dir> 33. Session 6 - Objective 7e WITH statement
Friday, November 24, 2023 3:13 PM <dir> 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing
Friday, November 24, 2023 3:13 PM <dir> 35. Session 6 - Objective 7d CTE statement
Friday, November 24, 2023 3:14 PM <dir> 36. Session 6 - Objective 14 Functions
Friday, November 24, 2023 3:14 PM <dir> 37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics
Friday, November 24, 2023 3:15 PM <dir> 38. Session 6 - Objectives 8c GUIDs; and Sequences
Friday, November 24, 2023 3:15 PM <dir> 39. Session 6 - Objective 10 Query and manage XML data - converting tables to XML
Friday, November 24, 2023 3:16 PM <dir> 4. Session 1 - Number types and functions
Friday, November 24, 2023 3:17 PM <dir> 40. Session 6 - Objective 10 Shredding XML data
Friday, November 24, 2023 3:17 PM <dir> 41. Session 6 - Objective 10 Other XML considerations
Friday, November 24, 2023 3:18 PM <dir> 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)
Friday, November 24, 2023 3:18 PM <dir> 43. Session 6 - Temporal Tables
Friday, November 24, 2023 3:18 PM <dir> 44. Session 6 - Conclusion
Friday, November 24, 2023 3:18 PM <dir> 45. Session 7 - Introduction
Friday, November 24, 2023 3:19 PM <dir> 46. Session 7 - Manage transactions
Friday, November 24, 2023 3:20 PM <dir> 47. Session 7 - Indexes
Friday, November 24, 2023 3:21 PM <dir> 48. Session 7 - Optimise queries
Friday, November 24, 2023 3:21 PM <dir> 49. Session 7 - Dynamic Management Views and Functions
Friday, November 24, 2023 3:22 PM <dir> 5. Session 1 - String data types and functions
Friday, November 24, 2023 3:22 PM <dir> 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations
Friday, November 24, 2023 3:22 PM <dir> 51. Congratulations
Friday, November 24, 2023 3:23 PM <dir> 52. Bonus - Installing SQL Server 2016 Developer Edition
Friday, November 24, 2023 3:23 PM <dir> 53. Bonus - Installing SQL Server 2014 Developer Edition (for Windows 7 and Vista)
Friday, November 24, 2023 3:23 PM <dir> 6. Session 1 - Date data types and functions
Friday, November 24, 2023 3:23 PM <dir> 7. Session 1 - Conclusion
Friday, November 24, 2023 3:24 PM <dir> 8. Welcome to Session 2
Friday, November 24, 2023 3:24 PM <dir> 9. Session 2 - Creating and querying part of a table