SQL Troubles: 📦Resources

Where to Start?

Microsoft 365

Microsoft 365 Developer Program - free, renewable 90-days (+30 days indefinite extension) Microsoft 365 E5 developer subscription pre-provisioned with Microsoft 365 app (includes Teams, Power BI, Visio Online)
Microsoft Azure - start with an Azure free trial (incl. SQL Server Azure)
Microsoft Ideas

Microsoft Learning

Databases

Apache Cassandra
MariaDB
MySQL
Neo4j - graph-based DBMS
PostgreSQL
SQL Server 2022 Developer or Express
SQL Server Management Studio - IDE for any SQL infrastructure, from SQL Server to Azure SQL Database

Diagramming

Azure Architectures - a collection of Azure architecture diagrams
Azure Diagrams Architecture Advisor - collaborative diagram designed for the Azure infrastructure
Cmap - construct, navigate, share and criticize knowledge models represented as concept maps
Microsoft Visio Online (see Microsoft 365 Developer Program)
Fabric icons (see icons.zip)

Dynamics D365 and Power Platform

IDEs

Visual Studio Community - fully-featured, extensible, free IDE for creating modern applications for Android, iOS, Windows, as well as web applications and cloud services
Visual Studio Code free IDE for Windows, Linux & Mac with support for many languages incl, Python, R, PowerShell, etc.

SQL Server

Libraries (membership-based, trial available)

LinkedIn - paid access to courses
O'Reilly (formerly Safari Books Online) - paid access to books & courses
Packt Publishing - paid access to books & courses
Skillsoft - paid access to books, courses, skill and course assessments, coding labs, etc.

MOOCs (Massive Open Online Courses)

Coursera - includes courses created by Microsoft, IBM, Google and various universities
edX - includes courses from AWS, IBM, Google, and various universities
MOOC.org - list of courses
MOOC-list - list of courses
Udemy - has several courses on Dynamics 365

Open Data Sources

AWS's registry of public data
CERN
DataHub.io: mainly economic & financial data
Data Portals - list of open data portals
DE cities: Berlin, Bonn, Cologne, Dortmund, Frankfurt, München
European Central Bank exchange rates (monthly, yearly) - just replace USD in the link with other currencies and export the data as .csv
European Union datasets
Google public data explorer
FiveThirtyEight - small repository of datasets and the code used for visualizations
Health Data
Kaggle datasets
NASA
Open Science Data Cloud
Statista
UNICEF
UK cities: London
UK Data Service
UN Data - statistics from countries that are part of the United Nations
US Census
US Government
US cities: Ontario
US universities: UC Irvine ML repository,
World Bank
World Health Organization (WHO)

Power BI Tools

Virtual Conferences & Webcast providers

Books

Adrià A Santacreu (2024) "Extending Dynamics 365 Finance and Operations Apps with Power Platform", Packt
Juan B Vargas, Mariano M Melo (2023) "Becoming a Dynamics 365 Supply Chain Management Functional Consultant Associate", Packt
Brent Dawson (2023) "Becoming a Dynamics 365 Finance and Supply Chain Solution Architect", Packt
Robert Houdeshell (2021) "Microsoft Dynamics 365 Project Operations", Packt
Mahender Pal (2020) Implementing Microsoft Dynamics 365 Customer Engagement, Packt
JJ Yadav et al, (2020) "Implementing Microsoft Dynamics 365 for Finance and Operations Apps", Packt
Andreas Luszczak (2019) "Using Microsoft Dynamics 365 for Finance and Operations"
Deepesh Somani (2019) "Mastering Microsoft Dynamics 365 Customer Engagement" 2nd Ed., Packt
Mohamed Aamer (2018) "Microsoft Dynamics 365 Enterprise Edition: Financial Management" 3rd Ed. Packt
Deepak Agarwal & Abhimanyu Singh (2017) "Dynamics 365 for Finance and Operations Development Cookbook" 4th Ed., Packt

SQL Troubles