POWER BI FULL STACK TRAINING IN HYDERABAD | BEST FULL STACK POWER BI TRAINING IN KPHB KUKATPALLY 

 

 

 

 

MICROSOFT SQL SERVER (SQL+T-SQL)

 

 

 

Overview:

      • Microsoft SQL Server is one the most popular Relational Database Management System(RDBMS)used in Microsoft universe.It can be used for data storage as well as for data reading for applications which can be either on desktop or API/Browse.

Course Objectives:Learn about SQL–Structured Query Language

      • Build database using Data Definition Language  Statements Perform basic CRUD operations using Data Manipulation Language statements like Insert, Update and Delete Write and call Stored Procedures, Functions, Triggers, Cursors and Optimizations techniques in a database.

Pre-requisite/Target Audience:

      • This sqlserver course can be taken by any beginner who wants to build career in Information Technology.The subscriber needs to have working knowledge of Windows Operating System.

Module1:- Introduction to Basic Database Concepts

      • Overview of Data,Field,Record,Files,File Groups and database
      • Limitations of File Management System.
      • Exploring Relational DBMS VS RDBMS
      • Understanding Client And Server Architecture

Module2:- Normalization

      • First Normal Form, Second Normal Form, Third Normal and EF.Cod rules Form Practically Normalizing Tables 

Module3:- Introduction to SQL Server

      • SQL Server Version history and different editions
      • OverviewofComponents,ToolsandSoftwareInstallations Starting and Stopping SQL Server Instances / Services
      • Introduction to Management Studio
      • Types of System Databases in SQL (Master, Model, MSDB, TempDB) 

Module4: Introduction to SQL

      • SQL Commands (DDL,DML,DQL,TCL,DCL)
      • Datatypes,OperatorstypesofOperators
      • Exploring Commands with Examples

Module5: Working with Constraints & Data Integrity

      • Primary Key, Unique, NULL, NOT NULL,CHECK, Default, Composite Key, Candidate Key and Foreign key
      • Real time scenarios to create database and Objects

Module6: Working with Queries (DQL)

      • Understanding Select Statement \ Query Processing steps
      • Clauses(TOP,WHERE,GROUPBY,HAVING,Order By with Offset and fetch)with Operators
      • CASE and IIF Statement

Module7: Aggregate Functions/StringFunctions/Date & Time Functions

      • Using String functions in Queries
      • Count,Sum,Min,Max,Avg,Groupby andHavingClauses
      • Date time Functions
      • Windows Functions/Analytical Functions
      • with Grouping sets, Rollup and Cube
      • RANK Functions

Module8: Set Operators

      • Introduction of Set Operators and Types
      • UNION, UNIONALL, INTERSECT, EXCEPT

Module9: SubQuery’s

      • Introduction of Sub query’s
      • Sub query’s, Co-Related Sub Query’s

 

Module10: Joins

      • Introduction to Joins and types
      • Inner Join / Left Outer Join / Right Outer Join / Full Outer Join /Self-Join /Cross Join

 

Module11: Table Expressions/Temporary tables

      • Derived Tables,Table variables,CTE (CommonTableExpressions),Temporary Tables (Local,Global)
      • PIVOT / UNPIVOT, Temporal tables

Module12: Working with Indexes

      • Heapstructurevs.B-TreeStructureFormat
      • Types Of indexes
      • Clustered Index,Non-Clustered Index,Filter Index,Covering Index,Column Store index,IndexScan,Index Seek, Index Re-Organize and Index -Rebuild
    •  

Module13: Implementing Views & partitions

      • Introduction & Advantages of Views
      • Types of Views(Simple/Complex/Materialized)
      • Creating, Altering, Dropping Views
      • SQL Server Catalogue Views (System Defined Views)

 

Module14: Transactions

      • ACID Properties, ISOLATION Levels, Locks.

 

Module15: BasicsofT-SQL Programming

      • Variables Introduction & Types of Variables and Usage
      • IF – Else, While structure programs.
      • System functions

 

Module16: Working with Stored Procedures (SP/Procs)

      • Introduction to stored procedures
      • Syntax of Creating,Executing,Altering,Dropping of Procedures
      • Input–Output and Optional Parameters
      • Procedure Optimization techniques
      • Error Handling in Stored Procedures
      • Stored procedures vs. User defined functions

 

Module17: Working with Functions (UDF)

      • User Defined Functions and types Of UDF
      • Creating,Altering and Dropping Functions
      • Scalar Functions, Inline Table Valued Functions, Multi Statement Table Valued Functions

Module18: Implementing Triggers

      • Introductiontotriggers
      • Constraints vs Triggers
      • Creating,Altering,Droppingtriggers
      • Magic Tables
      • Instead of Triggers

 

Module19: Working with Cursors

      • Introduction of cursors , Advantages of cursors, Creating Cursors, Types of cursors, Locks on cursors 

Module20: Backup and Restore

      • Generating & executing SQL Script
      • Taking database Backup and Restoring database using backup

 

Module21: Query Performance Techniques & XML Data Types

      • Query Optimization Techniques and SQL Profiler Overview.

 

Module22: SQL Server Agent (JobSchedules)

      • Introduction of SQL Server Agent
      • Create a Job and Schedule a time to Process data automatically

 

Power BI

Power BI Complete Introduction

      • Power BI Introduction,Brief History of Power BI,Data,DataVisualization,Reporting, Business Intelligence(BI), Traditional BI,Self-Serviced BI,Cloud Based BI,On Premise BI.
      • Power BI Report Server,Power BI Service,Power BI Mobile,Paginated Reports
      • Flow of Work in Power BI/Power BI Architecture
      •   Power BI Desktop Installation and Hands on practice

 

PBI Desktop& Power View Overview

 

      • Power BI Desktop Components (Power Query,Power Pivot, Power View,Power Map,Q&A,Data Gateway)
      •  Building Blocks of Power BI (Fields,Filters,Visualizations,Reports,Data,Model Dashboards andTiles)
      •   Data Connectivity Modes (Import,Direct,Live&Composite Models)
      •   Get Data Connecting Multiple source and represent the data
      •   Overview of default and Custom visualizations
      •   Power BI Desktop User Interface.
      •  Fields Pane,Visualizations pane,Ribbon,Views,PagesTab,Canvas,Visual Edit Interactions,Sync Slicer, Selection Pane, Buttons, Book Marks, Conditional formatting.

 

Power View

      • Report View User Interface Fields Pane,Visualizations pane,Ribbon,Views,Pages Tab,Canvas, Visual Interactions, Interaction Type (Filter,Highlight, None) Visual Interactions Default Behaviour, Changing the Interaction.
      •   Filter Types,Visual Level Filters,Page Level Filters,Report Level Filters,Drill Through Filters,
      •   Filter Sub Types,Basic Filtering,Advanced Filtering,Top N,Relative Date Filtering
      •   Numeric field filters,Text field filters,Date andTime field Filters

 

Hierarchies and Drill-Down Reports

      •     Hierarchy Introduction,Default Date Hierarchy,Creating Hierarchy,Creating Custom Date Hierarchy,Change Hierarchy Levels,Drill-Up and Drill-Down Reports,Data Actions,Drill Down, Drill Up,Show Next Level,Expand Next Level, Drilling filters other visuals option 

Power BI Visualizations

      •   Visualizing Data,,Visualization types,Field Values,Visuals for Filtering,Visualizing, Categorical Data,Visualizing Trend Data,Visualizing KPI Data, Visualizing Tabular Data,Visualizing Geographical Data, Leveraging Power BI Custom Visuals 

Visuals for Filtering

      • Slicer/Sync Slicer Visualization, When to use a Slicer,Create and format Slicer Visualization,Hierarchy Slicer (CustomVisualization),When to use a Hierarchy Slicer,Create and format Hierarchy Slicer, Advantages of Hierarchy Slicer

 

Visualizing Categorical Data

      • Create and Format Barand Column Charts,Create and Format Stacked Bar Chart Stacked Column Chart,Create and Format Clustered Bar Chart, Clustered Column Chart,Create and Format 100% Stacked Bar Chart, 100% Stacked Column Chart, Create and Format Pie and Donut Charts,Create and Format the Tree Map Visual, Create and Format Scatter Charts

 

Visualizing Trend Data

      • Line Chart ,Area Charts ,Create and Format Line Chart ,Area Chart ,Stacked Area Chart Combo Charts ,Create and Format Line and Stacked Column Chart ,Line and Clustered Column Chart, Create and Format Ribbon Chart, Water fall Chart, Funnel Chart

 

Visualizing KPI Data

      • Create and Format Gauge Visual ,KPI Visual ,Create and Format Card Visualization ,Multi RowCard
      •   Visualizing Tabular Data,Geographica lData & R Script Visual
      • Create and Format Table Visual ,Matrix Visualization ,Create and Format Map Visual ,Filled Map Visual, Arc GIS Maps Visual, Create and Format R Script Visual
      •   Interview Questions Discussion and Practical Scenario based Tasks

 

Power Query Editor\Transform Editor

 

      •   Introduction to Power Query–Extract,Transform and Load(ETL)
      • The Queries Pane,The Data View/Results Pane,The Query Settings Pane,Formula Bar,Advanced Editor – Complete ETL Code.
      •   Overview of Power Query /Transform Editor
      •   Data types,Changing the Data type of a Column
      •   Filters in Power Query,Auto Filter/Basic Filtering,Filter a Column using Text Filters
      •   Filter a Columns using Number,Date and Text

 

Inbuilt Column Transformations

      •   Remove Columns /Remove Other Columns,Name /Rename aColumn,Reorder Columns or Sort Columns,Add Column/Custom Column,Split Columns,Merge Columns,PIVOT, UNPIVOT Columns, Transpose Columns, Invoke functions

In built Row Transformations

      •   Header Row or Use First Rowas Headers,Keep Top Rows,Keep Bottom Rows,Keep Range of Rows,Keep Duplicates,Keep Errors,Remove Top Rows,Remove Bottom Rows,Remove Alternative Rows, Remove Duplicates, Remove Blank Rows, Remove Errors, Group Rows / Group By

 

Combine Queries (Append Queries & Merge Queries)

 

      •   Append Queries,Append Queries as New,Append 2 or more files individually with differentqueries, Appending multiple files of same type from a folder using single query,Query Options,Copy Query,Paste Query,Delete Query,Rename Query,Enable Load,Includein report Refresh,Duplicate Query, Reference Query, Move to Group, Move Up, Move Down

 

Merge Queries/Join Queries

 

      • Merge Queries,Merge Queriesas New,Default Types of  Joins/Join Kinds/Merge Type,Left Outer(all from first, matching from second), Right Outer (all from second, matching from first), Full Outer (all rows from both), Inner (only matching rows), Left Anti (rows only in first),Right Anti (rows only in second).

 

Grouping,Binning & Sorting

      • Grouping and Binning Introduction, Using grouping, Creating Groups on Text Columns,Using binning,Creating Binson Number Column and Date Columns,Sorting Datain Visuals,Changing the Sort Column,Sort Order,Sort using column that is not used in the Visualization,Sort using the Sortby Column button

Power Pivot (DAX)

Power BI DataModeling–Relationship View

 

      •   Data Modeling Introduction
      •   Relationship,Need of Relationship
      •   Relationship Types/Cardinality in General
      •   One-to-One,One-to-Many(orMany-to-One),Many-to-Many
      • AutoDetect the relationship,Create a new relationship,Edit existingrelationship·
      • Make Relationship Active or Inactive
      • Delete a relationship
      • Cross filter direction (Single,Both),Assume Referential Integrity

Enhancing the Data Model–DAX

 

      • Introduction of DAX,Calculated Columns,Measures,Example of Creating Calculated Columns, Creating Measures and Calculated Tables, Implicit Vs Explicit Measures, Row Filtervs.Context filters,DAX Operators,Types of Operators,Arithmetic Operators,Comparison Operators,Text Concatenation Operator, Logical Operators.

 

DAX Functions Categories

 

      •     Date and Time Functions
      •     Text Functions
      •     Logical Functions
      •     Aggregate Functions
      •     Filter Functions
      •     Information Functions
      •     Relationship Functions
      •     Time Intelligence Functions
      •     Table Manipulation Functions

 

Date & Time Functions

      • YEAR, MONTH, DAY, WEEKDAY, WEEKNUM,FORMAT (Text Function) a Month Name,Weekday Name
      •   DATE,TODAY, NOW, HOUR, MINUTE, SECOND, TIME, DATEDIFF, CALENDAR, Calendar Auto,Creating Date Dimension Table

 

Text Functions

      • COMBINEVALUES, CONCATENATE, CONCATENATEX, EXACT,FIND, FORMAT, LEFT, LEN, LOWER, REPLACE, RIGHT, SEARCH, SUBSTITUTE, TRIM, UPPER, VALUE
      •   Logical Functions
      •   IF, TRUE, FALSE, NOT, OR, IN, AND, IFERROR, SWITCH

 

Aggregate Functions

      • AVERAGE, AVERAGEA, AVERAGEX, COUNT, COUNTA,C OUNTAX, COUNTBLANK, COUNTROWS,  COUNTX, DISTINCTCOUNT, DISTINCTCOUNTNOBLANK, MAX ,MAXA, MAXX, MIN, MINA, MINX, SUM, SUMX. 

Filter Functions

      • ALL, ALLCROSSFILTERED, ALLEXCEPT, ALLSELECTED, CALCULATE, CALCULATETABLE, EARLIER, EAR LIEST, FILTER, KEEPFILTERS, LOOKUPVALUE, SELECTEDVALUE

 

Information Functions

      • CONTAINS, HASONEFILTER, HASONEVALUE, ISBLANK, ISCROSSFILTERED, ISEMPTY, ISERROR, ISFIL TERED, SELECTEDMEASURE, USERNAME, USEROBJECTID, USERPRINCIPALNAME.

 

Relationship Functions

      •       CROSSFILTER, RELATED, RELATEDTABLE, USERELATIONSHIP

 

Time Intelligence Functions

      • CLOSINGBALANCEMONTH, CLOSINGBALANCEQUARTER, CLOSINGBALANCEYEAR, DATEADD, DATESBETWEEN, DATESINPERIOD, DATESMTD, DATESQTD, DATESYTD, ENDOFMONTH, ENDOFQUARTER, ENDOFYEAR, FIRS TDATE, FIRSTNONBLANK, LASTDATE, LASTNONBLANK, NEXTDAY, NEXTMONTH, NEXTQUARTER, NEXTYEAR, OPENINGBALANCEMONTH,OPENINGBALANCEQUARTER, OPENINGBALANCEYEAR, PARALLELPERIOD, PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSQUARTER, PREVIOUSYEAR, SAMEPERIODLASTYEAR, STARTOFMONTH, STARTOFQUARTER, STARTOFYEAR, TOTALMTD, TOTALQTD, TOTALYTD

 

Table Manipulation Functions

      • ADDCOLUMNS,CROSSJOIN,DISTINCTcolumn,DISTINCTtable,EXCEPT,FILTERS,GENERATESERIES, GROUPBY, INTERSECT, NATURALINNERJOIN, NATURALLEFTOUTERJOIN, ROLLUP, ROLLUPGROUP, SELECTCOLUMNS, SU MMARIZE, SUMMARIZECOLUMNS, TOPN,UNION, VALUES

 

PowerBI Service (Admin Activities)

Power BI Service Introduction

 

      •   Power BI Service Introduction, Power BI Cloud Architecture, Creating Power BI Service Account, SIGN IN to Power BI Service Account, Publishing Reports to the Power BI service, Import / Getting theReporttoPBIService,My Workspace /AppWorkspacesTabs,DATASETS,WORKBOOKS,REPORTS,DASHBOARDS,WorkingwithDatasets,CreatingReports in Cloud using Published Datasets, PowerBIDatasetsLiveConnectionusingDesktop, WorkingwithWorkbooks,workingwithReports, Sharing Reports

 

Dashboards Development

      • Creating Dashboards,PinVisuals and Pin LIVE Report Pages to Dashboard,Advantages of Dashboards, Interacting with Dashboards, Adding Tiles to Dashboards, Web Content, Image, Text Box, Video, Formatting Dashboard, Sharing Dashboard

 

DataGateways

      •  Introduction to Data Gateways,Download Data Gateway,Installinga Data Gateway,Typesof Gateways,On-premises Data Gateway(StandardGateway),On-premises Data Gateway(personal mode\Private),Data Gateways work Connect to an on premise Data Source by using a Data Gateway, Manage Data Gateway, Add and Remove Administrators, Add DataSource, Add or Remove Users to a Data Source, Refresh On Premise Data, Configuring Automatic Refreshusing Schedules

 

Collaboration in Power BI using App Workspace

      • Introduction to App Workspaces, Create an App Workspace, Add Members to App Workspace to Collaborate,App Workspace Roles Access, Admin, Member, Contributor,Assign Workspace to Deployment Pipelines.

 

Sharing Power BI Content using Appsand Content Packs

 

      • Introduction to App,Publish an App,Update a Published App,Organization,Specific individuals or group, Un publishing an App, Content Pack Introduction, Create Content Pack, Sharing Content Packs,Specific Groups, My Entire Organization 

Row Level Security in Power BI(RLS)

      • Introduction to Row Level Security, Row Level Security (RLS) with DAX Dynamic & Static, Manage Roles, Creating Roles, Testing Roles, Adding Members to Roles in Power BI Service,Dynamic Row Level Security,Creating Users Table and Adding to the Model,Capturing users using Username ()or User Principal Name () Functions.

 

Data Flows

      • Over view of Datasets & DataFlows.

 

Report Server,Report Builder

 

      • Need for Report Server in PROD,Install,Configure Report Server,Report Serve rDB,TempDatabase, Web service URL, Web portal URL, Power BI DesktopRS, Uploading InteractiveReorts,Report Builder, Report Builder For Power BI Cloud, Designing Paginated Reports
      • (RDL),Deploy to Power BI Report Server,Data Source Connections,Report,Power BI ReportServer to Cloud, Tenant IDs, Mobile Report Publisher.

 

MicrosoftBusinessIntelligence(MSBI)

Introduction to Business Intelligence SQL Server 2008R2/2012/2015/2017/2019 Business Intelligence

Course Agenda:

 

      •     SQLServer2008R2/2012/2015/2017IntegrationServices(SSIS)–(ETL)
      •     SSISPackageArchitectureOverview
      •     Installationsofsoftware’sandOverviewofUtilizationDevelopmentandManagementTools
      •     TheImportandExportWizardSSISPackageComponents

 

Introduction to DataFlow

 

      • DataFlowOverview,DataSources,DataDestinations,DataFlowTransformations,DataViewers 

Data Sources

      •       ExcelSource,FlatFileSource,OLEDBSource,XMLSourceandOtherSources.

 

DataFlow Transformations

      • AggregateTransformation,AuditTransformation,CharacterMapTransformation, Conditional Split Transformation, Copy Column Transformation, Derived Column Transformation,Data Conversion Transformation, Multicast Transformation, OLE DBCommand Transformation, PercentageSamplingTransformation,RowCount Transformation,SortTransformation,Union All Transformation

Advanced DataFlow Transformation

      • LookupTransformation,MergeTransformation,MergeJoinTransformation,SlowlyChanging DimensionTransformation, PivotTransformation, Export Transformation,Import Transformation, Unpivot Transformation.

 

DataFlow Destinations

      • ExcelDestination,FlatFileDestination,OLEDBDestination,SQLServerDatabaseDestination

Introduction to Control Flow

      • ControlFlowOverview,PrecedenceConstraints,ExecuteSQLTask,BulkInsertTask,FileSystem Task,FTPTask,Send MailTask, Bulk Insert Task, Data FlowTask,Execute PackageTask Execute Process Task, Web Service Task, XML Task 

Advanced Control Flow(containers)

      • ForLoopContainer,ForEachLoopContainer,SequenceContainer

Variables and Configurations(Local&Global)

      • VariablesOverview,Variablescope,SSISsystemvariables,usingvariablesincontrolflow,using variables in data flow, using variables to pass information between packages.

Debugging,Error Handling and Logging

      • SSISdebuggingoverview,BreakpointsinSSIS,EventHandlers,ConfiguringPackageLogging

Extending SSIS through Custom Code–Scripting

      • IntroductiontoSSISscripting,SSISscripteditor(C#)

SSIS Package Deployment-SSISDB CatLog/FileSystem

      • Configurationsanddeploymentutilities,Deploymentoptions(Package/project).

SSIS Package Management

      • The SSIS Service, Managing packages with SQL Server Management Studio, Scheduling packages with SQL Server Agent.

SSIS Real Time Project–(Retail/Banking)

      • SSIS ETL&DWH withSTARSchema, SSIS ETL& DWH withSNOWFLAKE Schema, DimensionTableDesign&BusinessKeys,FactTableDesign,DataIntegrity,IncrementalDataLoadswithContainers,KeyLookupandBusinessKeyIdentification,StagingTables,Master -ChildPackages,SSISPackage Deployment [Catalog Deployments].

SSIS Training:

      • Project Specifications, Project Explanation and Solution, Project FAQsandResume Support,ChapterWise FAQs and Answers, Concept Wise Tasks and Solutions, SSIS DWH Databaseswith Reports, Technical Resume Points in SSIS, End to End Implementation [MSBI].

 

 

SQLServer2008R2/2012/2014/2016 ReportingServices

SQL Server Reporting Services (SSRS) Architecture 

      •       Report Server Configuration
      •       Report Server Architecture
      •       Report types and formats
      •       SSRS Web Services
      •       Report Server
      •       Report Builder
      •       Model Designer

 

Datasources: 

      • SQL Server,Oracle,OLEDB,XML

Authoring Reports Creating basic reports

      •       Tabular
      •       List
      •       Matrix
      •       Chart
      •       Constructing data sources and Datasets
      •       Inserting a data region,fields and images

 

Leveraging expressions & Types

      •       Built in Expressions
      •       Calculating fields
      •       Integrating expressions in properties
      •       Applying conditional formatting
      •       Adding images

 

Grouping and sorting data

      •     Grouping to multiple levels
      •     Sorting the results
      •     Employing aggregate functions Implementing Parameters and Filters Building parameters into reports
      •     Returning subsets of data with query parameters
      •     Mapping report parameters to query parameters
      •     Building cascading report parameters
      •     Passing parameters to stored procedures
      •     Exploiting multivalve parameters

 

Restricting report data with filters

      •     Enhancing performance with filters
      •     Filters vs.query parameters
      •  Localizing tables and queries Leveraging Advanced Reporting Features Combining data regions in one report
      •     Utilizing sequential and nested regions
      •     Producing master/detail reports
      •     Linking sub reports

 

Presenting data with appropriate detail 

      •   Revealing report detail with drill down
      •   Displaying related data with drill through
      • Navigating with document maps Deploying and Delivering Reports Deploying reports to the server
      •   Preparing reports for publishing
      •   Configuring project properties
      •   Units of deployment:Individual reports, projects,solutions,data sources
      •   Checking results with Report Manager

 

Securing Reporting Services Securing the RS environment

      •     Assigning users to roles
      •     Setting permissions on report items
      •     Granting and revoking system-level permissions

 

Creating reports with Report Builder

      •       Deploying Report Builder to users
      •       Dragging and dropping entities onto charts and tabular reports
      •       Navigating data with infinite drill through Creating Reports with RESTAPI/XML

 

ADDON:

      • Interview questions and Discussions
      • Real time Project Explanation
      • Resume preparation

 

AzureDataFactory(ADF)

Introduction to Microsoft Azure

 

      • what is Cloud computing
      • what are services offering Microsoft azure
      • Advantages of cloud computing
      • Types of cloud deployments
      • Types of cloud Services
      • Microsoft Azurevs.AWS
      • How to Create Azure Account
      • Understand Azure Management Portal
      • Azure Architecture & Services
      • How to Create Resources and Resource Groups in Microsoft Azure
      • Azure Resource Manager vs.classic deployment
      • How to create Virtual Machine

Storage Account in Azure

      • Create a Storage Account
      • Blob,File,Queues,Tables,Security in Storage Account,Access keys,Share Access Signatures
      • Create Containers and Blobs
      •   Install & Explore Azure Storage Explorer
      • Create SAS tokens and understand the benefits of SAS tokens
      • Copy Files from on pre Blob, File, Queues, Tables,Security in Storage Account, Access keys,Share Access Signatures
      • Create File Shares and sync the files
      • Create Tables using Storage Explorer

 

Azure SQL Database

      • What is Azure SQL
      • Azure SQL Managed Instance,SQL in Virtual Machine
      • How to Create Database in Azure SQL Server
      • What is Elastic Poolin Azure SQL Database
      • How to Query Azure SQL Server from On-premises SSMS and Cloud
      • What is Polybase in Azure SQL
      • What is an External table
      • How to Load Data from On-premises to Cloud SQL using data factory
      • Migration of Existing Data from on premises to SQLA zure

 

Azure Data Factory

      • Azure Data Factory vs SSIS
      • Linked Services,Data Sets,Pipelines
      • Parameters vs Variables
      • Copy Data,Monitor Manage,
      • Different kinds of integration runtimes
      • How to create pipelines from template
      • How to configure different Integration Runtimes
      • Azure Integration runtime,
      • Azure Self Hosted Integration Runtime,
      • SSIS Integration runtime.
      • Move & transform,Copy Data,Append Variable,Execute Pipeline,Execute SSIS Package
      • Get Metadata,Lookup,Stored procedure,Set Variable,Delete,Wait,Until,
      • Iteration & Conditionals,Filter,For Each,If Condition,Until
      • Incremental Loading in Azure Data factory using Blob Storage to SQL Implementing Slowly changing Dimension Data Flow
      • Source,Lookup,Derived Column,Alter Row,Conditional Split,Sink

 

Azure–DeploymentasCodeusingARMTemplates

      • What are ARM Templates using for Deployment
      • How to Deploy Data Factory Pipelines DEV,Test,Prod environment
      • Version Control and Code Repository in Git Hub
      • Debugging and Monitoring Pipelines
      • Error handling and Logging error records
      • Lift and Shift SSIS packages into Azure Data Factory.

 

Azure Data Lake

      • Blob Storage vs Data Lake
      • What is Data Lake & Date Lake Gen1VsGen2
      • How to store Data into data lake
      • How to Query data from Data Lake to SQL Server.
      • Introduction to Azure Data Lake U-SQL Batch Job
      •   How to Schedule Data Lake Analytics Jobs using Data Factory
      • Azure Blob to Data Lake Gen 2 using Data Factory

 

 

 

KOSMIKTECHNOLOGIES CLASS IS ONE OF THE BEST POWER BI FULLSTACK  OFFLINE & ONLINE TRAINING INSTITUTES IN HYDERABAD, KUKATPALLY/KPHB

power bi fullstack training institutes Hyderabad, Kukatpally at kosmik Training Institute covers topics from beginner level to advanced level. Finally, by the end of Power bi fullstack Course in Hyderabad you can be confident with Power bi fullstack Training in hyderabad.

Power bi fullstack training in Kukatpally,KPHB consists of assignments and completely real-time practical Power bi fullstack job oriented training in Hyderabad . He explains the difficult topics for beginners with ease, provides best Power bi fullstack examples and makes the student comfortable with the Power bi fullstack cloud computing training in hyderabad .

 Kosmik is the best Power bi fullstack training institute Hyderabad,KPHB. We are providing Power bi fullstck Training in hyderabad & lab facilities with complete real-time Power bi fullstack trainingPower bi fullstack Training in Kukatpally is based on complete advance concepts. So that you can get easily "hands-on experience". We will give 100% job assistance.Power bi fullstack Training in kphb, Power bi fullstack Training in Kukatpally,Power bi fullstack Training in Telangana, Power bi fullstack training institutes in hyderabad, Power bi fullstack course in hyderabad.