logo

Azure Data Engineering

This program is well structured to provide you or your team with a broad understanding of cloud computing on Microsoft Azure Platform. Students can learn various data platform technologies that are available on Azure, and how they can take advantage of this technology to an organization’s benefit. The Training program also includes and is not limited to modules with which students can dive deep and understand Azure technologies that analyze text and images and relational, nonrelational, or streaming data.

  • English
  • 9000
  • 18000
 Add To Cart
  • Course Includes
  • Live Classes
  • Continuous Assessment
  • Downloadable Course Materials
  • Real Time feedback

Requirements

  • Open to all

Description

Students who complete this training program successfully will become project-ready to create Azure services such as building pipelines with Azure Data Factory, running jobs on Azure Databricks, U-SQL with Azure SQL Database, etc. This training program will also describe the features of Azure AD and several methods of integrating it into an organization.

Students will as well learn at a high level how to identify and meet the data requirements to design data solutions that use Azure data services, design tasks that include designing Azure data storage solutions that use relational and non-relational data stores, batch and real-time data processing solutions, and data security and compliance solutions.

Course Content

DATABASE CONCEPTS

Basics

DML Vs DDL Operations

SQL Vs PL SQL

RDBMS Vs NoSQL

 Basic database objects
 mb
SQL

Select Statements

Restricting and Sorting data

Single row functions

Aggregating Using Group functions

Manipulating Data

Creating and Managing Tables

Joins

Including Constraints

Using SET Operators

Datetime Functions

Subqueries

 mb
PLSQL

Declaring Variables

Writing executable statements

Writing control structures

Composite data types

Cursors

Creating Procedures

Creating Functions

Managing Subprograms

Creating Packages

Creating Triggers

 mb
DBA FUNDAMENTALS

Managing Tables

Managing Indexes

Managing Data Integrity

Managing Privileges

Managing Users

Managing Roles

 mb
DATABASE OBJECTS

Schema Objects Vs Non Schema Objects

 mb
SCHEMA OBJECTS

Clusters

Constraints

Database links

Index-organized tables

Indexes

Materialized views

Sequences

Stored functions, stored procedures

Synonyms

Tables

Views

 

 mb
NON SCHEMA OBJECTS

Roles

Rollback segments

Tablespaces

Users

 

 mb
OTHER IMPORTANT TOPICS

Database Structures

Relationships

Data Integrity rules

Data Normalization and Denormalization

ER diagram

Introduction to NoSQL and Unstructured Data

 mb
DATA WAREHOUSING CONCEPTS

What is a Data Warehouse?

Data warehouse Vs OLTP System

Data warehouse Vs OLTP System

Bottom up approach

EDW Vs Data Marts

Typical Data Warehouse Architecture

Logical Vs Physical Design

Star Schema

Snowflake Schema

Staging area

Data Marts

Cardinality and Relationships

Facts

Dimensions

Date Dimension

Conformed Dimensions

Shared Dimension

The need for Materialized Views

DWH Performance Tuning

 mb
ETL OVERVIEW

Extraction

Transformation

Loading and Refreshing

Load time and Throughput

Load scheduling

Data Load Administration and Monitoring

Lookups and Other important transformations

Time Series analysis & Slowly Changing Dimension(SCD)

ETL Tool Walkthrough (Informatica or Talend)

 

 mb
OLAP

Symantec Layer

Data Visualization

Pivoting

Functions

Aggregations

Cubes

Multi-dimensional analysis

Reports

Data Rendering

Performance tuning

Slicing and Dicing

Temporary tables

Report automation and scheduling

OLAP Tool walkthrough (Tableau or PowerBI)

 mb
TEST MANAGEMENT

Test Plan

Test cases & scenarios

Testing cycle

UTC

Integration Testing System testing

UAT

 mb
TOOLS

HP ALM - High level –Theory

Jira - High level demo

 mb
AGILE

Agile overview

Agile types

Agile methodologies

Agile methodology in testing

 mb
UNIX

Unix Basics

UNIX commands for various operations

UNIX file I/O operations and file permissions

 mb
PROJECT WORK

Project involving creation of database objects, ER diagrams, Dimensional Modeling, ETL transformations, Mappings, and OLAP reports

 mb

Recent Courses

blog
Expert-Level Shell-Scripting Traini...
  • 5000
  • 10000
blog
Advanced Level Perl Training Progra...
  • 15000
  • 30000

About the Instructor

instructor
Rohit
About the Instructor

Report