DP-300 Microsoft Azure Database – Implement compliance controls for sensitive data

1. 34. apply a data classification strategy Now is some of your data sensitive, but people might still need to be able to see it. So sensitive data includes data privacy, regulatory and national requirements. So we’ve talked extensively about GDPR and the California version. And maybe there are security scenarios including controlling access. So… Read More »

DP-300 Microsoft Azure Database – Implement security for data at rest and in transit Part 2

4. Always Encrypted versus Transparent Data Encryption In this video, we’re going to compare and contrast. Always encrypted and transpound data encryption, or TDE. What’s the difference between them? Well, TDE is an older technology, so you can see it was first around in SQL Server 2008, whereas Always Encrypted started in 2016. Now, you… Read More »

DP-300 Microsoft Azure Database – Implement security for data at rest and in transit

1. 28. implement Transparent Data Encryption (TDE) Hello. And in this section we’re going to look at how we can implement security for data at rest and in transit. In other words, on the move. So we’re going to start with transparent Data encryption or TDE, TDE encrypts and then Denry data at the page… Read More »

DP-300 Microsoft Azure Database – Plan and Implement Data Platform Resources Part 2

4. 6, 8. evaluate scalability and security aspects In this video, we’re going to start by looking at the scalability of the various database offerings. So first of all, as your SQL Database, it really depends on what version you go for. So it starts off at around the 1 TB level. So we’ve got… Read More »

DP-300 Microsoft Azure Database – Plan and Implement Data Platform Resources

1. 1. deploy database offerings on selected platforms Hello. And in this section we’re going to have a look at planning and implementing data platform resources. And we’re going to start with using manual methods. So we’ve already got our first SQL Database. So what happened? I went to Azure SQL and I can go… Read More »

DP-300 Microsoft Azure Database – Optimize Query Performance Part 3

5. 58. determine the appropriate type of execution plan Now in this video we’re going to go a bit behind the scenes and have a look at execution plans. So what I’ve got here is a crossjoin. So I’m joining this table to itself. So if this table is giving me 450 rows then joining… Read More »

DP-300 Microsoft Azure Database – Optimize Query Performance Part 2

3. 67. identify normal form of database tables – Normal Forms 1 to 3 In the previous video we had a not optimal table structure and we’re going to use the first normal form to get it into better shape. But what is the first normal form? Well, the first normal form was proposed by… Read More »

DP-300 Microsoft Azure Database – Optimize Query Performance

1. 69. validate data types defined for columns Hello. Now we’ve got that review of the select statement out of the way. We’re going to look in this section about how to optimize query performance. So part of that is about normalizing tables. We’ll have a look at that in the next three videos and… Read More »

DP-300 Microsoft Azure Database – Review prerequisites Part 2

3. Installing SSMS, connecting to Azure SQL Database, and quick look around SSMS In this video we’re going to connect to our SQL database that we installed in the previous video. So we can do this in the Portal, the Azure Portal, by going to the SQL database and going to Query Editor. So it’s… Read More »

DP-300 Microsoft Azure Database – Review prerequisites

1. Getting a free trial of Microsoft Azure So now let’s get our free account. And you can see an ad at the top, azure Microsoft. com account, free. You could just google Azure Free credit and see what you get as well. So let’s click on that and you can see we have a… Read More »