3.01 Office 365
3.02 Azure Portal
3.03 Microsoft SQL
- 3.3.1 Install Guide for Microsoft SQL Server
- 3.3.2 SQL Server Database Engine
- Bulk Import Image File Data into SQL Server Table
- Calendar Reference Table
- Database Administration Scripts / Tools
- Database Audit Scripts / Tools
- Determine Data Types from Query
- Import Blob Storage CSV File to Azure SQL Server Table
- Optimised Queries for Microsoft SQL Server for BI Dashboards
- Scheduled Stored Procedures and Log Setup
- SQL Server Analysis Services Linked Server
- Stored Procedure Error Handling
- Stored Procedures and Functions for Web Based APIs
- 3.3.3 SQL Server Analysis Services (SSAS)
- 3.3.4 SQL Server Reporting Services (SSRS)
- 3.3.5 SQL Server Integration Services (SSIS)
3.04 MySQL
3.05 Oracle
3.06 Microsoft Windows
- 3.6.1 Setting up a batch file or powershell on task scheduler
- 3.6.2 Command Line (cmd) Batch File Scripts
- 3.6.3 Powershell