Developed proficiency in creating and managing SQL views for streamlined data management and abstraction. Gained expertise in manipulating views, including creating, updating, and deleting them. Mastered advanced SQL views incorporating joins, indexed views, and functions for optimized performance. Applied window functions for complex data analysis, utilizing various windowing techniques. Combined window functions with Common Table Expressions (CTEs) to perform comprehensive and efficient data analysis.