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/
🔍 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/
Category
🤖
TechTranscript
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