Amazon AWS Certified SysOps Administrator Associate – Databases for SysOps Part 6

11. RDS Performance Insights So let’s talk about RDS Performance Insights, and that’s the last one around monitoring for RDS, but I think you need to know it and it is quite a cool tool overall. So Performance Insights allows you to visualize your database performance and you can analyze why there are issues that… Read More »

Amazon AWS Certified SysOps Administrator Associate – Databases for SysOps Part 5

9. RDS Events and Logs Okay, so now let’s talk about RDS events and event subscriptions. So RDS will keep a record of events related to multiple events related to the database instances, to your snapshots, to changes made to your parameter groups or your security groups, etc. So what is an event? Well, an… Read More »

Amazon AWS Certified SysOps Administrator Associate – Databases for SysOps Part 4

7. RDS Parameter Groups A very short lecture on parameter groups, so I talked about them. But basically you can configure your entire DB engine as we’ll see using parameter groups. And if it’s a dynamic parameter, it can be applied immediately. But if it’s a static parameter, then it will only be applied after… Read More »

Amazon AWS Certified SysOps Administrator Associate – Databases for SysOps Part 3

5. [SAA/DVA] RDS Encryption + Security So now let’s talk about RDS security. And the first topic I want to talk about is encryption. So we have at Rest encryption, which is the data that’s not in movement. And there is a possibility to encrypt the master database and the read replicas using AWS Kms,… Read More »

Amazon AWS Certified SysOps Administrator Associate – Databases for SysOps Part 2

3. [SAA/DVA] RDS Hands On Play with RDS. So I’m going to go to the RDS service and we are going to create our first database in RDS. So we’ll go to the Databases tab and we’ll click on Create Database. Now we are getting into this new interface and we need to create a… Read More »

Amazon AWS Certified SysOps Administrator Associate – Databases for SysOps

1. [SAA/DVA] RDS Overview So let’s get started with an overview of AWS RDS. RDS stands for relational database service. And what it means is that it’s a managed database service for database that use SQL as a query language. So SQL is a structured language to query a database. It’s very well adapted and… Read More »

Amazon AWS Certified SysOps Administrator Associate – CloudFront Part 2

4. CloudFront Caching – Deep Dive So here is a deep dive lecture on CloudFront caching. And on CloudFront you can cache based on multiple things and we’ll do a deep dive on all those. So headers, session cookies, query string parameters, and based on the combinations of what you set for these parameters, the… Read More »

Amazon AWS Certified SysOps Administrator Associate – CloudFront

1. [SAA/DVA] CloudFront Overview Now we’re getting into content delivery and we’ll start by CloudFront. So CloudFront is a content delivery network or CDN, and what it does is it improves read performance because the content is going to be distributed and cached at the edge locations. And edge locations are all around the world… Read More »

PL-300 – Section 38: Part 4 Section 7 – Other Power BI Service Topics

281. Create a PivotTable from a Power BI Dataset in Excel Now, suppose you didn’t actually want to export the data, you just wanted to do an analysis in Excel, namely a pivot chart. So that’s equivalent of a matrix in Power BI. Well, you can do this in Excel fairly easily. But you might… Read More »

PL-300 – Section 37: Part 4 Section 6 – Create and Manage Workspaces Part 2

278. Promote or Certify Power BI Report or App Now, that we’ve created an app, how can we say how good an app this is? You’ll remember that a few videos ago, we were able to promote or certify or endorse datasets. Well, as of around October 2020, Power BI now allows you to endorse… Read More »