This repository showcases the diverse range of courses I have completed, highlighting my educational accomplishments and areas of expertise.
- Basic programming concepts, including data types, variables, functions, and control structures, emphasise object-oriented programming (OOP). Acquired skills in defining classes, creating objects, and using inheritance and polymorphism in Python.
freeCodeCamp: Algorithms and Data Structures
- Studied fundamental data structures and algorithms such as arrays, linked lists, sorting, searching, and an understanding of time complexity analysis.
- SQL joins, subqueries, and aggregate functions.
Designing and Implementing SQL Server Tables and Views
- Designing and implementing efficient SQL Server tables and views for optimal data organization and retrieval.
Designing and Implementing SQL Server Database Indexes
- Learned the best practices and techniques for designing and implementing effective database indexes in SQL Server to improve query performance and optimize data retrieval.
Programming SQL Server Database Stored Procedures
- Programming SQL Server stored procedures to efficiently manage and manipulate database data, improve performance and/or security, and automate complex database operations.
Programming SQL Server Database Triggers and Functions
- Benefits of using, when to use triggers and functions, and how to code them.
Managing SQL Server Database Performance
- Tools for performance monitoring, server health check, resource setting configurations.
Analyzing SQL Server Query Plans
- How to interpret, debug and improve performance with Query Plans.
Microsoft Learn: DP-300 Exam - Administering Microsoft Azure SQL Solutions Learning Path
- Learning Path for DP-300: Azure Database Administrator Associate certification. Migration, backup, log shipping, automation of database tasks and resource deployment to cloud, performance monitoring and configuring HA/DR environments.
Pluralsight: Building Your First SSIS 2016 Package
- Gained knowledge in navigating SQL Server Data Tools to design, manage and deploy SSIS packages. Developed skills in extracting, transforming and loading (ETL) data using data flow components, automating data movement, processing tasks and executing package deployment step-by-step.
Microsoft Learn: Power BI Data Analyst Associate Learning Path
- Learning path for PL-300: Microsoft Power BI Data Analyst certification. Acquired skills in transforming, cleaning, and shaping data from various sources, DAX formula creation, and report building. DataCamp: Data Analysis in Excel
- Data organisation, cleaning, pivot tables, conditional formatting, and advanced formula techniques.
Microsoft Learn: Data Engineer Associate Learning Path
- Learning Path for DP-203: Azure Data Engineer Associate certification. Data lake concepts, usage of Synapse Analytics, Databricks, configuration of spark pools and usage of Apache Spark, Azure Data Factory and data governance.