Skills Overview: Difference between revisions
Tags: Manual revert Visual edit: Switched |
|||
| Line 24: | Line 24: | ||
SSIS with parameters. | SSIS with parameters. | ||
<div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;"> | <div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;"> | ||
<div > | <div>BIML (SSIS Visual Studio extension)</div> | ||
<div class="mw-collapsible-content"> | <div class="mw-collapsible-content"> | ||
Link to MUFG | |||
<br> Link to other | |||
</div> | </div> | ||
</div> | </div> | ||
== SQL Server DBA - Database Administration == | == SQL Server DBA - Database Administration == | ||
Revision as of 10:05, 30 September 2024
Over the course of my IT career, I have gained considerable experience with a broad range of IT skills. This page lists an overview of these, with links to other pages where individual skills are described in greater details, along with the roles where I have used these.
SQL Server TSQL coding
Window functions
Group by/aggregation
WHERE clause / Having
Use of SQL Server CTEs (Common Table Expressions).
Sort by
Subqueries
Views
Joins
SQL Server development
Database design
Medallion architecture
SSIS with parameters.
Link to MUFG
Link to other
SQL Server DBA - Database Administration
SQL Server performance tuning/indexing/statistics
Security/user accounts
Logging
backups and restores
SQL Server version upgrades & downgrades
Out of hours support
Spark SQL
Spark sql
Databricks
data migration
Python
Other technical
Powershell
Apache Subversion - MUFG
Non-technical
Documentation
User training
Teamwork/Mentoring