Microsoft SQL Data Models Development Exam 70-768 & SQL Data Warehouse Implementation Exam 70-767 Video Training Course Download
 
 
Overall  Duration : 11 Hours
 
Size: 2.95 GB
 
 
Microsoft SQL Data Models Development 70-768
 
1- Microsoft SQL_ Data Modeling
 
1 - Welcome to 70-768 Developing SQL Data Models.mp4
2 - Introducing SSAS and Data Modeling.mp4
3 - Getting SSAS (SSDT).mp4
4 - Dimensions and Measures.mp4
5 - Multidimensional Data Sources and Views.mp4
6 - Designing Dimensions for Multidimensional Models.mp4
7 - Building a Cube.mp4
8 - Using Your Cube in Power BI.mp4
9 - Fact Dimensions.mp4
 
10 - Parent-Child Dimensions.mp4
11 - Referenced Dimensions.mp4
12 - Slowly Changing Dimensions.mp4
13 - Introducing Hierarchies (Attribute Relationships).mp4
14 - Implementing Attribute Relationships.mp4
15 - Multidimensional Dimension Types.mp4
16 - Multidimensional Measures and Measure Groups.mp4
17 - Multidimensional Calculations and Aggregations.mp4
18 - Introducing Tabular Modeling.mp4
19 - Introducing Tabular Measures and DAX.mp4
 
20 - Tabular Relationships.mp4
21 - Hierarchies.mp4
22 - Tabular Partitions.mp4
23 - Implementing Tabular Partitions.mp4
24 - Perspectives.mp4
25 - Calculated Columns.mp4
26 - Tabular DirectQuery vs. In-Memory.mp4
27 - Automating Scheduled Refreshes.mp4
28 - Managing Users and Permissions.mp4
29 - Row Level Security.mp4
 
 
2 - Microsoft SQL_ MDX and DAX
 
1 - Introducing Multidimensional Expressions (MDX).mp4
2 - MDX Rows, Columns, Members, and Sets.mp4
3 - Understanding Tuples.mp4
4 - Tuple Sets.mp4
5 - Introducing MDX Functions with MEMBER.mp4
6 - ORDER and HEAD Functions.mp4
7 - Handling Nulls in MDX.mp4
8 - MDX FILTER Function.mp4
9 - Navigation with DESCENDANTS.mp4
 
10 - Time Functions.mp4
11 - WITH Clause.mp4
12 - MDX AGGREGATE Function.mp4
13 - Logical Functions in MDX.mp4
14 - Introducing Data Analysis Expressions (DAX).mp4
15 - DAX Studio and EVALUATE.mp4
16 - Formatting Results with ORDER and FILTER.mp4
17 - Grouping Aggregations with SUMMARIZECOLUMNS.mp4
18 - Basic DAX Calculations.mp4
19 - Custom Measures, Variables, and Tables Using DEFINE.mp4
20 - Introducing Iterator (X) Calculations.mp4
21 - Implementing Iterator (X) Functions.mp4
22 - Basic Logical Functions in DAX.mp4
23 - SWITCH Logical Function.mp4
24 - Variables (VAR).mp4
25 - CALCULATE Function.mp4
26 - Date and Time Functions.mp4
27 - Ranking Data with RANKX.mp4
 
 
 
3 - Microsoft SQL_ SSAS Tuning
 
1 - File and Disk Layouts.mp4
2 - Multidimensional Memory Limits.mp4
3 - Configuring Multidimensional Memory Limits.mp4
4 - Tabular Memory Limits.mp4
5 - Understanding NUMA.mp4
6 - Configuring Affinity.mp4
7 - Understanding SSAS Clustering.mp4
8 - Multidimensional Query Plans.mp4
9 - Tracing a Multidimensional Query.mp4
 
10 - Tabular Query Plans.mp4
11 - Tracing a Tabular Query.mp4
12 - Performance Monitoring.mp4
13 - KPIs.mp4
 
 
 
Microsoft SQL Data Warehouse Implementation -70-767
 
1 - Microsoft SQL_ Designing a Data Warehouse
 
1 - Introducing Data Warehousing.mp4
2 - Selecting a Storage Subsystem.mp4
3 - Redundant Array of Independent Disks (RAID) Levels.mp4
4 - Installing and Configuring SQL Server with SSIS.mp4
5 - Fact and Dimension Tables.mp4
6 - Star and Snowflake Schemas.mp4
7 - Designing Dimension Tables.mp4
8 - Dimension Table Details.mp4
9 - Slowly Changing Dimensions (SCD).mp4
 
10 - Designing Fact Tables.mp4
11 - Introducing SQL Indexes.mp4
12 - Clustered vs Non-Clustered Indexes.mp4
13 - Rowstore vs. Columnstore Indexes.mp4
14 - Introducing Data Partitioning.mp4
15 - Partition Ranges.mp4
16 - Implementing Partition Functions and Schemes.mp4
17 - Implementing a Sliding Partition Window.mp4
18 - Scale Out Solutions.mp4
 
 
2 - Microsoft SQL_ SSIS
 
1 - Introducing SSIS.mp4
2 - Introducing Flows.mp4
3 - Connection Manager.mp4
4 - Precedence and Expression Constraints.mp4
5 - SSIS in Action.mp4
6 - File Tasks.mp4
7 - Web Service Tasks.mp4
8 - Variables.mp4
9 - Transactions.mp4
 
10 - Checkpoints.mp4
11 - Profiling the Source Data.mp4
12 - Parallelism.mp4
13 - Basic Transformations.mp4
14 - Pivot.mp4
15 - Aggregations.mp4
16 - Fuzzy Data Transformations.mp4
17 - Slowly Changing Dimension (SCD) Data Flows.mp4
18 - SSIS Merge and Lookups.mp4
19 - Incremental Loading with T-SQL MERGE.mp4
 
20 - Enabling Change Data Capture (CDC).mp4
21 - Implementing CDC.mp4
22 - Debugging and Troubleshooting.mp4
23 - Securing SSIS Packages.mp4
24 - Deploying a Package to SSIS.mp4
 
 
 
3 - Microsoft SQL_ Data Quality
 
1 - Installing Data Quality Services (DQS).mp4
2 - Data Quality Knowledge Base (DQKB), Domains, and Attributes.mp4
3 - DQS Data cleaning.mp4
4 - DQS Data Flow Tasks in SSIS.mp4
5 - Handling Duplicates in DQS.mp4
6 - Installing Master Data Services (MDS).mp4
7 - Managing Master Data.mp4
8 - System Administration, MDS Hierarchies, and Business Rules.mp4
9 - Importing and Exposing Data in MDS.mp4
10 - Preparing for the 70-767 Exam.mp4
 
 
 
Exam Ref 70-767 Implementing a SQL Data Warehouse .pdf
 
Exam Ref 70-768 Developing SQL Data Models.pdf