Azure Secret Computing

Shivani Mishra -  Easy Azure for Everyone SQL Database Basics SQL database is a relational database service that allows you to manage and query structured data. It is the latest version of Microsoft SQL Server database engine in the cloud. Relational databases in Azure What is a Relational Database? A relational database is a collection of tables that are related to each other through defined relationships. It allows you to store data in a structured manner and define constraints to ensure data quality. ·          You can define tables with columns to store data. ·          You can define constraints to ensure data quality. ·          You can use multiple tables and define relationships between them. ·          You can run SQL queries to combine data from multiple tables. Why Use Relational Da...

Shivani Mishra -  Easy Azure for Everyone Our data factory is a fantastic tool for moving data, but until recently, it was not great at transforming data. However, this has changed with the introduction of mapping data flows for Azure Data Factory. Mapping data flow allows us to create data transformations without writing code. It is a visual designer that allows us to create data transformation flows by simply dragging and dropping actions. Build ETL visual way When building a flow, it typically looks like the following: ·          One or more data sources ·          At least one data set ·          Multiple actions and data syncs This is very similar to how SQL Server Integration Services (SSIS) works, so if you are familiar with SSIS, this will feel familiar to you. In data flows, there are multiple types of actions: ·   ...