Skip to main content

#DP-700

DP – 700 is the certification for Fabric Data Engineer. Fabric Data Engineer is the latest trending job role that deals with End to End Data Warehouse design (DWH) using ETL (Extract, Transform, Load) techniques. This prominent job role also involves Big Data Analytics and Business Intelligence implementation using Spark, PySpark, Cloud Computing, TSQL and more..

In this course, we also aim at optimized One Lake Structures (Warehouse, LakeHouse, Stream House, etc..) and big data analytics using KQL, Activator and more..!

 

Training Schedules

S NoTime (IST, Mon - Fri)Start Date
16 AM - 7 AMAug 5th
29 AM - 10 AMJuly 28th
36 PM - 7 PMAug 11th
48 PM - 9 PMAug 18th
DP-700 Training Highlights

DP 700 Training
Course Contents:

Module 1 : Microsoft SQL (TSQL)

Ch 1: SQL SERVER INTRODUCTION

  • Database Introduction
  •  Types of Databases
  •  Need for & ETL, DWH
  •  BI Implementations
  •  SQL Server Advantages
  •  Version, Editions of MSSQL
  •  Data Analyst Job Roles

Ch 2: SQL SERVER INSTALLATIONS

  • SQL Server 2019, 2017
  • SSMS Tools Installation
  • Database Engine (OLTP)
  • SCM, Configuration Tools
  • Instance Types, Uses
  • Authentication Modes
  • Collation, File Stream

Ch 3: SQL BASICS – 1

  • Need for Databases, Tables
  • Need for SQL Commands
  • DDL, DML & DQL Statements
  • Database Creation @ GUI
  • Data Operations @ GUI
  • Session ID, SQL Context
  • DB, Tables, Data @ SQL

Ch 4: SQL BASICS – 2

  • DDL Variants in MSSQL
  • DML Variants in MSSQL
  • INSERT & INSERT INTO
  • SELECT & SELECT INTO
  • Basic Operators in SQL
  • Special Operators in MSSQL
  • ALTER, ADD, TRUNCATE, DROP

Ch 5: Data Imports, Schemas

  • Data Imports with Excel
  •  ORDER BY & UNION
  • UNION ALL For Sorting Data
  •  Creating, Using Schemas
  •  Real-world Banking Database
  •  Table Migrations @ Schemas
  •  2 Part, 3 Part & 4 Part Naming

Ch 6 : Constraints, Index Basics

  • Need for Constraints, Keys
  •  NULL, NOT NULL, UNIQUE
  •  Primary Key & Foreign Key
  •  RDBMS and ER Models
  •  Identity Property, Default
  •  Clustered Index, Primary Key
  •  Non Clustered Index, Unique

Ch 7: Joins & Views Basics

  • JOINS: Purpose. Inner Joins
  • Left / Right / Full Outer Joins
  • Cross Joins, Query Tuning
  • Creating & Using Views
  • DML, SELECT with Views
  • RLS : WITH CHECK OPTION
  • System Views & Metadata

Ch 8: Functions(UDF), Data Types

  • Using Functions in MSSQL
  •  Scalar Value Functions
  • Inline & Multiline Functions
  • Date & Time Functions
  • String, Aggregate Functions
  • Data Types : Integer, Char, Bit
  • SQL Variant, Timestamp, Date

Ch 9: Stored Procedures,Models

  • Stored Procedures & Usage
  • Creating, Testing Procedures
  • Encryption, Deferred Names
  • SPs for Validations, Analysis
  • System SPs, Recompilation
  • Normal Forms & Types
  • Data Models, Self-References

Ch 10: Triggers, Temp Tables

  • Need for Triggers
  • DDL & DML Triggers
  • Using Memory Tables
  • Data Replication, Automation
  • Local & Global Temp Tables
  • Testing & Using Temp Tables
  • SELECT .. INTO & Bulk Loads

Ch 11: DB Architecture, Locks

  • Planning VLDBs : Files, Sizing
  • Filegroups, Extents & Types
  • Log Files : VLF, Mini LSN
  •  Table Location, Performance
  • Schemas, Transfer, Synonyms
  • Transactions Types, Lock Hint
  •  Query Blocking Scenarios

Ch 12 : Cursors & CTEs, Links

  • Cursors : Realtime Use
  • Fetch & Access Cursor Rows
  • CTEs for SELECT, DML
  • CTEs: Scenarios & Tuning
  • Linked Servers, Remote Joins
  • Linked Servers: MSDTC, RPC
  • Tuning Remote Queries

Ch 13: Merge, Upsert & Rank

  • Need for Merge in ETL
  • Incremental Loads with SQL
  • MERGE and RANK Functions
  • Window Functions, Partition
  • Identify, Remove Duplicates

Ch 14: Grouping & Cube

  • Group By & HAVING
  • Cube, Rollup & Grouping
  • Joins with Group By
  • 3 Table, 4 Table Joins
  • Query Execution Order

Ch 15: Self Joins, Excel Analysis

  • Self Joins & Self References
  •  UNION, UNION ALL
  •  Sub Queries with Joins
  •  IIF, CASE, EXISTS Statements
  •  Excel Analytics, Pivot Reports

Module 2: Fabric Data Engineer

Ch 1: Fabric Introduction

  • Need for Fabric, Big Data
  • Fabric Data Engineering Model
  • Fabric Components (Items)
  • Microsoft Fabric: Advantages
  • Cloud Warehouse Uses
  • Benefits of Fabric Over Azure
  • Azure Versus Fabric DWH

Ch 2: Fabric Account, Workspace

  • Need for Fabric Workspace
  • Workspace Creation Process
  • Pins and New Items
  • Item Categorization
  • ETL, Storage, Analytical
  • Streaming, Monitoring
  • Compute & Separation

Ch 3: Fabric Architecture

  • Intelligent Data Foundation
  • Polaris Distributed Engine
  • Stateless & Stateful
  • Cache, Metadata, Xact & Data
  • Fabric Tasks, Inputs & DAG
  • State Machine & Statistics
  • Hot Spot Recovery

Ch 4: Fabric Warehouse

  • Fabric Warehouse Creation
  • Fabric Warehouse Features
  • Fabric Warehouse Properties
  • Fabric Warehouse Limitations
  • DWH Internal Operations
  • Default Schemas & Objects

Ch 5: Fabric Data Types

  •  Realtime use of Fabric Houses
  • Exact, Approximate Numbers
  • Date and Time Data Types
  • Fixed & Variable Length
  • Binary & String Data Types
  • Fabric Type Limitations

Ch 6: SSMS Connections

  •  Warehouse SQL Connection
  • Database Engine Server
  • Multi Factor Authentication
  • Warehouse Artifacts
  • Executing .SQL Scripts
  • Testing Fabric Artifacts

Ch 7: Fabric Caching

  • Fabric Caching Process
  • In-memory Cache, Disk Cache
  • Cache Types: LRU /MRU
  • Cold Cache / Cold Run
  • Realtime use of Caching
  • Performance Advantages
  • Warehouse Optimizations

Ch 8: Fabric Statistics

  • Query Engine Options
  • Statistics Types
  • Leverage Statistics
  • Auto, Manual Statistics
  • Update Statistics
  • Statistics Consistency
  • Statistics Lists & Reports

Ch 9: Time Travel

  • Continuous Data Protection
  • Data Storage, Retention
  • FOR TIMESTAMP AS OF
  • Time Travel Scenarios
  • Time Travel Implementation
  • Time Travel on Queries
  • Time Travel Limitations

Ch 10: Aggregated Data Store

  • Options for Data Aggregations
  • Save As table, Save As View
  • Single Table Aggregations
  • Multi Table Aggregations
  • Dynamic Conditions
  • Parameterized Aggregations

Ch 11: Zero Copy Cloning

  •  User Layer, Storage Layer
  • Cloning & Parquet Files
  • Synapse Data Warehouse
  • Data History Retention
  • Point In Time , Schema Level
  • Zero Copy Cloning Limitations

Ch 12: Fabric Security

  • Workspace Security
  • Warehouse Security
  • Item Security & Roles
  • Adding AD Users
  • Item Security Limitations
  • MFA & Client Security

Ch 13: Fabric Data Factory

  • ETL Implementation Options
  • Need for Fabric Data Factory
  • ETL Operations in FDF
  • Data Sources, Transformations
  • Data Destinations (Sinks)
  • Creating Pipelines

Ch 14: Fabric Pipelines

  • Activities and Connections
  • Gateways & OnPrem Access
  • Data Sets & Activity Sets
  • Data Activator & Alerts
  • Run ID & Monitoring
  • Pipeline Creation, Verification
  • Activity Check, Schedule

Ch 15: Fabric Pipelines Design

  • Creation Options for Pipelines
  • Azure SQL DB Data Loads
  • Creating Data Sets
  • RRR Transformations
  • Copy Command Usage
  • Internal Staging (Workspace)
  • Data Loads to FDWH

Ch 16: Fabric Aggr Data Loads

  • Aggregation Scenarios
  • Creating Views in TSQL
  • Using Views in FDF Pipelines
  • Using Pipeline Editor
  • Data Loads to Warehouse
  • Pipeline Verifications

Ch 17: ETL Staging

  •  Staging : Advantages
  • Caching & Storing Concept
  • Staging Types in Fabric
  • Workspace & External
  • External Stages in Pipelines
  • Compressions & Advantages
  • Pipeline Trigger, Monitor

Ch 18: OnPrem Gateways

  • Need for On_Premi Gateway
  • Installing & Configuring
  • Authentication, Usage
  • OnPremises Connections
  • Pipelines for Data Loads
  • Warehouse Data Storage
  • Data Refresh with Gateways

Ch 19: Fabric Lakehouse

  • Need for Fabric Lakehouse
  • Files and Tables Storage
  • Data Sources: Parquet Files
  • Transformation Options
  • Direct Lake Concepts
  • Lakehouse Consumption
  • Lakehouse Real time Use

Ch 20: Lakehouse File Loads

  •  Creating Lakehouse
  • Copy Data Wizard
  •  Azure SQL Database Source
  •  File Data Loads in Lakehouse
  •  Concurrency & Batch Count
  •  Pipeline Execution Tests
  •  Pipeline Monitor Check

Ch 21: Lakehouse Aggr Loads

  • Aggregated Data Store
  • Plan & Design Aggregations
  • Testing Aggregations
  • Pipelines for Data Compute
  • Data Copy Options
  • Pipeline Optimizations
  • Data Loads and Verification
  • Pipeline Execution Tests
  • Pipeline Monitor Check

Ch 22: MultiTable Loads in LH

  • Table Loads Connections
  • Data Load in Lakehouse
  • Using Copy Data Wizard
  • Data Store in Lakehouse
  • View Run History, Executions
  • SQL End Points & Access
  • Lakehouse Schemas

Ch 23: Lakehouse Visual Queries

  • Visual Query Interface
  • Visual Editor & Tables / Views
  • Merge, Remove, Sort Tfns
  • Data Preview, Save As Table
  • Save As View : Advantages
  • Using Schemas, Identifiers
  • TDS Packets & Transfer Units

Ch 24: File Explorer

  • Installing One Lake Explorer
  • Autocreation of Folders
  • Workspace Directories
  • Warehouse Directories, Logs
  • Lakehouse Folders, Files
  • Lakehouse Uploads
  • Explorer Tool Limitations

Ch 25: Power Query Level 1

  • Power Query Concept
  • Need for Power Query
  • Data Flow Gen 1
  • Data Flow Gen 2
  • Power Query Items
  • Differences with Copy Activity
  • ETL, ELT Process

Ch 26: Power Query Level 2

  • Data Flow Gen2 Operations
  • PQ Online Editor
  • Working with Binary Content
  • Detailed Data Options
  • Data Cleansing Options
  • Step Names, Aggregations
  • Warehouse Data Loads

Ch 27: Power Query Level 3

  • Binding Power Query Steps
  • Edit / Delete Steps
  • Optimizing Power Query
  • ETL & ELT with Power Query
  • Advanced Editor
  • M Language Expressions
  • Duplicate / Reference Queries

Ch 28: Fabric Notebooks

  • Need for Notebooks
  • Fabric Notebook Types
  • Get / Prep / Analyze
  • Sessions, Markdown Folding
  • Standard, High Concurrency
  • Magic Command
  • Freeze Cells

Ch 29: Spark SQL Notebooks

  • Creating Environment
  • Creating Spark Clusters
  • Spark Cluster Compute
  • SQL Analytics in Notebooks
  • Visual Query Vs SQL
  • Cell Execution Options
  • Magic Command Usage

Ch30: PySpark Notebooks

  •  Creating / Using Environment
  • PySpark Notebook Sessions
  • Reading Source Data
  • Data Prep & Aggregations
  • Data Loads, Analytics
  • Cell Execution Options
  • Markdown Cells

Ch 31: StreamHouse, KQL

  • Need for Stream House
  • Auto creation of KQL
  • Manual KQL Databases
  • Verification & Usage
  • Differences with Warehouse
  • Differences with Lakehouse

Ch 32: KQL Query Sets

  • KQL Database ExtractionFile Imports – on Premises
  • Metadata Edit Options
  • Query Analytics
  • Exports, Visualizations
  • Query Sets Versus Notebooks

Ch 33: Fabric Data Activator

  • Need for Alerts, Notifications
  • Fabric Data Activator Options
  • Alert Conditions, Thresholds
  • Email Notifications
  • Events & Notifications
  • Edit / Enable / Disable

Ch 34: Model Layouts

  • Need for Layouts
  • Creating Model Layouts
  • Adding Refences, Keys
  • Power BI Semantic Models
  • Creating Report Items
  • Using Power BI Desktop

Ch 35: Azure Synapse Migrations

  • Azure Synapse DWH
  • Azure Synapse Connections
  • Migrating to Fabric
  • Compatibility Checks
  • Synapse Vs Fabric Warehouse
  • Fabric DWH Advantages

Ch 36: DP 700 Exam Guidance
End to End Realtime Project: Ecommerce Domain

SQL SCHOOL

24x7 LIVE Online Server (Lab) with Real-time Databases.
Course includes ONE Real-time Project.

DP-700 Training FAQ's

What is DP-700 Job Role?

A DP-700 certified professional is an Azure Data Analyst Associate who is responsible for designing and implementing data solutions using Azure Synapse Analytics, Azure SQL, Data Lake, and Power BI. The role involves building and optimizing data models, ingesting and transforming data, implementing security, and creating enterprise-level reports and dashboards. DP-700 professionals help organizations turn raw data into actionable business insights on Azure.

What are the Job Roles of a DP-700 Azure Data Analyst?

💼 Top Job Roles:

1️⃣ Design and build modern analytics solutions using Azure services
2️⃣ Create and optimize data models for analytics and reporting
3️⃣ Develop ETL/ELT pipelines using Synapse and Data Factory
4️⃣ Visualize data and create dashboards using Power BI
5️⃣ Implement data governance, security, and compliance
6️⃣ Collaborate with data engineers, architects, and business users and more..!

What does our DP-700 Training course contains?

The course is carefully curated with below module:
👉🏻Module 1: MSSQL & TSQL Queries
👉🏻Module 2: Fabric Data Engineer

Who can join this course?

  • Freshers targeting careers in cloud data analytics

  • SQL and BI professionals moving to Azure data analytics

  • ETL developers expanding to cloud data solutions

  • Data analysts aiming for DP-700 certification

  • Anyone interested in building end-to-end data solutions on Azure

No prior coding experience is required. All concepts are taught from scratch

What training modes are available?

Option 1:        LIVE Online Training  (100% Interactive, step by step, assignments)

Option 2:        Self Paced Videos (100% practical, step by step with concept wise assignments)

You may choose any one of these options, same curriculum!

I (Trainer) shall be available for doubts and clarifications, assignment check and review.

Why should I choose SQL School for DP-700 training?

👉🏻 Every session is Practical, Step by Step with Concept wise FAQs !!

👉🏻 100% results with on-time practice.  Daily Tasks for every session.

👉🏻 Concept wise tasks be submitted before next class for Job Waiters / Starters.

👉🏻 Concept wise tasks due for submission by Weekends for Working Professionals.

Why Choose SQL School

  • 100% Real-Time and Practical
  • ISO 9001:2008 Certified
  • Concept wise FAQs
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews
  • 24/7 LIVE Server Access
  • Realtime Project FAQs
  • Course Completion Certificate
  • Placement Assistance
  • Job Support
  • Realtime Project Solution
  • MS Certification Guidance