Watch trailer
Course at a glance
Included in these subscriptions:
- Dev & IT Pro Video
- Dev & IT Pro Power Pack
| Release date | 3/25/2021 | |
| Level | Advanced | |
| Runtime | 1h 21m | |
| Closed captioning | Included | |
| Transcript | Included | |
| eBooks / courseware | N/A | |
| Hands-on labs | N/A | |
| Sample code | Included | |
| Exams | Included |
Course description
This course discusses Row-Level Security
Data Analysts are responsible for designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations. The PL-300 Exam validates this expertise.
Prerequisites
Experience with Microsoft Excel, pivot tables and power pivot modelling is helpful.
Meet the expert
Nikolai is a mathematician and works as a data scientist in a large German company. He is focused mainly on gaining insights from data and creating a positive impact with this knowledge.
Course outline
Row-Level Security
Row-Level Security (24:09)
- Introduction (00:13)
- Row Level Security (03:20)
- Creating RLS (04:51)
- RLS in the Cloud (03:31)
- RLS Data Model (04:38)
- Dynamic RLS (07:28)
- Summary (00:08)
Dynamic and Many-to-Many RLS (17:15)
- Introduction (00:08)
- Dynamic Many-to-Many (04:04)
- Hierarchical RLS (04:03)
- Implement Hierarchical RLS (03:07)
- Manage Roles (05:44)
- Summary (00:08)
Advanced M Language
M Basics (21:59)
- Introduction (00:08)
- DA-100 Update (01:06)
- M Language Basics (06:40)
- Values, Lists, and Tables (13:56)
- Summary (00:08)
M Language Functions (18:31)
- Introduction (00:08)
- M Language Functions (13:13)
- More Functions and Steps (05:02)
- Summary (00:08)