Posts

Covid 19 Data Factory Udemy Course

Permalink Last updated on -  Enrolled on 1st july Course link   git link ECDC Website for Covid-19 Data -  https://www.ecdc.europa.eu/en/covid-19/data Euro Stat Website for Population Data -  https://ec.europa.eu/eurostat/estat-navtree-portlet-prod/BulkDownloadListing?file=data/tps00010.tsv.gz

Udemy Courses enrolled for ADF/SSIS/Azure SQL Server VMs & more

Updated on -> 1st July 9 PM. The following was tried out on 20th June and then till 25th/26th  june.  Then documentation below was updated on 26th/27th june. Since, then most time away for health. Today, 1st July, was all about trying to get blog post Updated time to show .. no luch, so to be done manually only  Permalink 1. Good ADF starter and free  -    - Good quick starter. Moving json from blob storage to data lake storage with ADF (20th June)   1. Create ResourceGroup (naming conventions explained)        1. Create a dashboard with appropriate naming convention and pin the resource group above to the dashboard   2. Create storage account , for source data - this is done in a new resource group in the udemy class.        1. in this account, create a container instance      2. Upload json file (sales.json provided by tutor) in this container   3. Create another storage account to hos...

Azure SQL Server for Beginners - 1

  Permalink   Enrolled in the course with the same name as the title of this blog post in udemy, primarily to learn creating, managing sql server vms in Azure.

Relational data course - Azure SQL and Azure SQL Warehouse

Image
  Permalink

Udemy Course - Implementing an Azure Data Solution

  Permalink 1. Azure Portal - tips to use it for free chapter in the course 2. An example of free Azure resource availability even after free azure portal run out of free budget  3. Resources available via Visual Studio based subscription  (gurao@hotmail.com) 4.  IaaS and PaaS table in this context  5. Same link as above -> NoSQL Offerings of MS Azure     a. Az storage, Data Lake, cosmos DB..     b. standard storage vs premium storage    c. Programmatic access to az storage - rest api, sdks, powershell, az cli, az storage explorer, az copy     d. az storage v2 vs az storage v1 vs blob storage  6. Many of these course content options not available in az data storage now..  7. Storage account networking    private network access, select  public network access, open to all public.

19thMay

Permalink here  1. azure account trial one expired 2. so, upgraded to free tier (pay as you go). (tried with vramana2021@hotmail.com, did not work, probably due to same c card used) 3. Resuming where left off on 10th april.. 4. In the meanwhile, need to focus on Azure BI/BDA/Analytics topics mentioned by Sanjay:  a.) databricks b.) adf c.) Synapse or az dwh d.) ssis e.) az db sql server f.) LogicApps for flow control   b.) Good article - https://www.mssqltips.com/sqlservertip/6438/azure-data-factory-vs-ssis-vs-azure-databricks/ c.) Logic Apps article - https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-overview#how-does-logic-apps-differ-from-functions-webjobs-and-power-automate d.) ADF Copy article - https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-performance-features

10-11-12Apr2021-CreatedAccount

Permalink for this site   ICICI CC and hotmail id used Key Links  work done on the 11th lost, since Update of the Blog Post not done.  1, Udemy course recommended useful link   2. Azure Cli installed from this site 3.  Azure learning github link 4. Azure github ARM deployment  link 5. Link explaining how to download ARM templates -  6. The ARM templates themselves here ..