DP-900: Understanding Relational Data Concepts | Azure Data Fundamentals - video Dailymotion

SkillTech Club

In this DP-900 session, we explore the fundamental concepts of relational data, essential for working with structured databases in Microsoft Azure. Whether you're preparing for the DP-900 certification or looking to understand relational database management systems (RDBMS), this lecture provides a step-by-step guide to relational data models, SQL databases, and Azure database services.  🔍 What You’ll Learn in This Session: ✅ Introduction to Relational Databases & RDBMS ✅ Understanding Tables, Rows, Columns, and Schema ✅ ACID Properties & Data Integrity in Relational Databases ✅ SQL Basics – Queries, Joins, and Normalization ✅ Exploring Azure SQL Database & Managed Instances ✅ Best Practices for Database Performance & Security  🛠️ Who Should Watch This? Beginners & IT professionals new to relational databases Students & data enthusiasts preparing for the DP-900 exam Database administrators & developers working with SQL in Azure Business analysts & cloud professionals exploring Azure database services 📌 Key Highlights: ✅ Simple, easy-to-understand explanations of relational data concepts ✅ Real-world examples & practical use cases in Azure SQL ✅ Exam-focused insights for DP-900 certification prep ✅ Live demos on using relational data in Azure  💡 Master relational data concepts & take your first step into the world of databases!  Explore Our Other Courses and Additional Resources on: https://skilltech.club/

Transcript

00:00in this video we are going to explore roles and responsibilities in the world

00:12of data obviously when you're dealing with data what kind of role you have

00:16according to that you're going to work on the data we will focus that if you

00:21are a data engineer or data scientist or just a database administrator according

00:26to that role what kind of jobs you have to do and then what kind of tools you're

00:31going to use in this now first let's focus on roles in data obviously depends

00:39upon the size of the organization there are chances that whatever roles I'm

00:42going to show you here will may be performed by a single user or maybe one

00:48or two users or you have to combine more than one roles in your job but yes on a

00:53standard basis in an organization we will have three kind of roles database

00:57administrator data engineer and data analyst the database management part

01:03implementing the security associated with the data taking care of the backups

01:08and the user access and also monitoring the focus of the security as well as the

01:12performance will be a work of database administrator which formerly known as DBA

01:17data engineers are going to focus on the data pipelines and the processes most of

01:23the time these are ETL or ELT kind of pipelines like you know extract transform

01:28load or extract load transform a data ingestion and storage is also going to

01:33be taken care by data engineers and same way they mostly focus on preparing data

01:37writing some analytical processing on that and then loading the data at the end

01:42of the process then we have a third which are actually data analyst now this

01:47role of data analyst is going to provide the insights into the data whether it's

01:52data is stored in the raw format or any semi-structured format when you want to

01:56take some business decision you have to do analysis on that and this kind of

02:00visual reporting modeling and analysis for the data is a work of data analyst now

02:07obviously based on the role of the user they are going to use different tools

02:11for database administration data engineering and data analyzing let's see

02:16those tools also some common tools for database administrators are a sure data

02:21studio sequel server management studio which formerly we call SSMS and if you

02:27are dealing with the cloud data then you can also use a sure portal or the

02:31command-line interface of a sure which is provided on the portal itself in the

02:36sure data studio the graphical user interface is going to be there which

02:40will allow you to manage your on-premise and the cloud-based data services it

02:44mostly runs on all the operating systems like Windows Mac OS and Linux SSMS is

02:51only going to run on Windows but this is one of the most popular tools for

02:55SQL server database management you can take care of the database backup security

03:00everything at one place and it can be also useful for managing your on-premise

03:05and cloud-based data services and the third one which is a sure portal is

03:11actually only available on the ensure or cloud-based databases so this is

03:14going to be available within the cloud this is providing the tools for

03:18management and provisioning of ensure data services manual and automation of

03:23the scripts are also available in Azure CLI where you can just write the script

03:26once and then you can rerun the script again again just to do the same kind of

03:31job repeatedly then if we move forward to the tools for data engineering then we

03:36have three kind of tools in that SSMS and Azure portal is equally available here

03:41also but we have a new tool which is known as Azure Synapse studio the Synapse studio

03:47is actually providing end-to-end data storage data transformation and data

03:53ingestion kind of services which are available with a very high performance

03:58and a very low latency we have a sure portal integrated in the Azure Synapse

04:04studio which is actually allowing us to do data ingestion which is going to be

04:09mostly done by Azure data factory or Azure Synapse pipelines or we also have some

04:15kind of a compute associated SQL dedicated pools or Apache spark pools

04:20available in Azure Synapse we are going to see this tools in depth when we are

04:24going to go through the demo sessions of this course but yes these are the three

04:28tools which are going to be used by data engineers then third and the important

04:35one is data analyst and data analysts are going to use tools like power bi now

04:41there are various versions of power bi which are available you can use power bi

04:45desktop which you need to install in your computer and it will allow you to do data

04:49visualization and model creation and then it can also allow you to integrate with

04:55the existing tools like Azure Synapse you can also use power bi portal or the

05:00services which are available which can be integrated with some third-party

05:03applications and services and then you can also use power bi report builder which

05:08can allow you to model and visualize your paginated reports when mostly you

05:13have millions and thousands of records available then you can use this kind of

05:18report builders to generate a proper reports so these are the tools which are

05:22going to be used by these three different roles and obviously which role you

05:27belongs to that you only knows that thing and which tool you are going to use

05:31that is something which is based on your organization so in this video we have

05:36seen that what kind of roles and responsibilities are there in the world

05:39of data and we have also seen that which kind of tools are going to be used by

05:43each and every role which is associated using these tools we can understand that

05:49different database administrators data engineers and data analysts can get the

05:55maximum advantage of the data which is getting stored or which is getting

05:59processed

DP-900: Understanding Relational Data Concepts | Azure Data Fundamentals

Category

Transcript

Recommended