Microsoft Power Apps is a low-code cloud application platform that allows us to build custom apps, automate processes, and achieve excellent efficiency for any businesses for their end to end implementations. Power Apps is a consistent leader in low cods application platforms.
In our Power Apps Training course, we start from the very basics of App Design. Learn how to use PowerApps Studio, App Designer, Create Apps, Solutions, Dataverse, Tasks, Subscriptions and implement end to end framework, tasks, subsriptions and dataverse with Microsoft Excel, OnDrive, SQL Databases, Sharepoint, Power Automate, MS Flow, Power Pages, Power Virtual Agent and more.. !
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
Course includes | Power Apps | T-SQL, Power Apps |
T-SQL, Power BI, Power Apps |
No of Videos | 15 Videos | 27 Videos | 45 Videos |
Power Apps Design | ✔ | ✔ | ✔ |
Power Apps Solutions | ✔ | ✔ | ✔ |
Microsoft Dataverse | ✔ | ✔ | ✔ |
Sharepoint Integration | ✔ | ✔ | ✔ |
Power Virtual Agent | ✔ | ✔ | ✔ |
Power Automate | ✔ | ✔ | ✔ |
SQL Database, T-SQL Queries | ❌ | ✔ | ✔ |
Normal Forms, Joins, Query Tuning | ❌ | ✔ | ✔ |
Sub Queries, Stored Procedures | ❌ | ✔ | ✔ |
Excel Pivot Tables, Pivot Charts | ❌ | ✔ | ✔ |
Power BI Report Design | ❌ | ❌ | ✔ |
Power BI Desktop, Custom Visuals | ❌ | ❌ | ✔ |
Data Modelling with Power Query | ❌ | ❌ | ✔ |
Data Modelling with DAX | ❌ | ❌ | ✔ |
Power BI Cloud, Excel Analysis | ❌ | ❌ | ✔ |
Power BI Mobile, R, REST API | ❌ | ❌ | ✔ |
PL 300 Exam Guidance | ❌ | ❌ | ✔ |
Real-Time Project in Power BI | ❌ | ❌ | ✔ |
Total Course Fee* | INR 12000 USD 150 |
INR 17000 USD 200 |
INR 29000 USD 375 |
Trainer: Mr.Sai Phanindra (17+ Yrs of Exper)
All Session Are Completely Practical & Real Time
Register Now for Power Apps Videos
Custom Visuals | Power BI Mobile |
Big Data Sources | R, Python, JSON |
Excel Analysis | Excel Online |
Google Big Query | Report Server |
Gateways, Rest API | Power BI Admin |
✔ Tabular Mode | ✔ Data Models |
✔ Tabular Mode OLAP | ✔ Tabular Mode DAX |
✔ Cube Design | ✔ Excel Analytics |
Ch 1: DATABASE INTRODUCTION
|
Ch 5: SQL Basics - 3, T-SQL INTRO
|
Ch 9: Triggers & Transactions
|
Ch 2: SQL SERVER INSTALLATIONS
|
Ch 6 : CONSTRAINTS, INDEXES
|
Ch 10: DB Architecture & Group By
|
Ch 3: SSMS Tool, SQL BASICS - 1
|
Ch 7: JOINS & LINKED SERVERS
|
Ch 11: TSQL Queries: Group By, Joins
|
Ch 4: SQL BASICS - 2
|
Ch 8: VIEW, SPs, FUNCTIONS BASICS
|
Ch 12 : ER MODELS, NORMAL FORMS
|
Case Study 1 - For Database, Table Design (Constraints, Keys) |
Case Study 2 - For Query Writing + Window Functions (Rank, RowNumber) |
Ch 1: Power Apps - IntroductionWhat is Power Platform? What is Power Apps? Power Apps Eco System? Power Apps Components? What is Share Point ? How Share Point different from Power Apps? Power Apps Power Apps building blocks; Relation between Office 365 and Power Apps; |
Ch 2: Power Apps ImplementationPower Apps Implementation Options; Configuring Power Apps Trial Account; Canvas App : Usage Options, Navigations and Shortcuts; Understanding the End to End Workflow; Data Source Types and App Types; Software Licensing Requirements; Power Apps for Mobile Devices; Power Apps Desktop Editor |
Ch 3: Beginning with Power AppsCreate an app from template Canvas App Layouts; Create a Blank Canvas App Types of Screens in Canvas App; Canvas App Screen Properties; Renaming & Reorder Screen Navigations; Form Size and Layout Options; Data Cards; Form Types; Custom Form Tools & Screens; |
Ch 4: Canvas Controls & App DesignIntroduction to different type of controls; Adding & Selecting a control; Renaming the unique name of control; Deleting a control; Reorder, Move & Resize a Controls; Changing label text; Button Configurations; Toolbar Configurations; Understanding Tab Configurations; Controls - Properties; Canvas : Adding Controls; Configuring Controls; Search & Sort Options; |
Ch 5: App Design with ExcelPower Apps Connectors; Using Excel Data Sources; Working with Excel Sheets (One, Many), Excel Tables in Power Apps; Creating Structured Tables & Apps; Data Validation Techniques, Formatting Options; Data Tables & Gallery; Power Apps Search Function - Parameters; Implementation of Search Function; Using Snap to Columns; Data Card Value Properties; Adding Images and Icons; Save and Publishing your Forms; |
Ch 6: App Design with SQL DatabaseUsing SQL Server Data Sources for Power Apps; Creating Stored Procedures & Parameters; Using Parameterized Joins with Power Apps; Data Validations; Table Union, Table Merge Implementation; Working with Date and Time formats in Power Apps; Working with String Functions and Data Classifications in Power Apps; |
Ch 7: App Design with Cloud SourcesUsing Azure SQL Data Sources for Power Apps; Creating Azure SQL Tables for Power Apps; Remote Joins with Power Apps; Data Validations; Microsoft One Drive with Power Apps; Google Sheets with Power Apps; App Validations and Testing Strategies; |
Ch 8: Power Apps SolutionsDataverse Database : Architecture & Creation; Dataverse Tables; Common Data Models; Power www.sqlschool.com For Free Demo: Reach us on +91 9666 44 0801 or +1 956.825.0401(24x7) Apps Solutions - Creation, Management (Edits), Security, Sharing; Dataverse Implementation in Power Apps; Flows - Creation & Use; App Navigation Functions and Parameters; Dataverse Views and Real-time Use; Dataverse Charts & Dashboards; Setting Form Visibility; App Logic and Rules; |
Ch 9: Share Point with Power AppsUsing Share Point with Power Apps; Apps Creation Process; Share Point with Power Apps; Create Share Point Site Create Share Point List; What is Gallery, Data table & Form Different Between Gallery & Data table; Different Type of Galleries in canvas; Customizing the forms and gallery controls; List Publish & Revert Options; Custom Power App from Share Point ; Using Blank Template with Share Point Online; Save and Publish Power App; |
Ch 10: Power Apps - Advanced Design - 1Power Apps Variables; If – Else Condition & Its Implementation Nested If – Else Conditions; Switch Conditions; Modifications to data depending on user input Hide; Show Controls with Parameters; Dynamic Data Apps Design; Power Apps Scope of Power Apps Variables; Power Apps Forms - Creation; Creating Custom Form; Patch Function; Dynamic Data Submissions; |
Ch 11: Power Apps - Advanced Design - 2Dynamic Data Submissions; Power Apps Parameters; Filter, Lookup, Search Cascade and Update If functions; Power Apps Collections - Creation & Use; Collect & Clear Collect; Real time Use of Collections; Customized Theme and Branding; Screens and Transitions; |
Ch 12: Power Apps Components & VersionsCreating Power Apps Components; Version Control Strategies; Standard Alerts & Custom Alerts with Power Apps; Version Restore; Configuring Search within a Power App; Power App Controls; Pen Inputs; |
Ch 13: Sharing Power AppsPower Apps : Sharing, Security Management. End User Integrations & Access; Model Driven Apps & Business Role; Create Dashboard in model driven app; Integrating Power BI with Power Apps; Share Point and Excel Analytics with Power BI; Sharing your Apps; Assigning App Owners; App Details & App Settings; |
Ch 14: Power Automate - IntroductionPower Automate - Purpose; Types of Power Automate flows; Power Automate Connectors; Triggers, Actions and Email Notifications; Power Automate Approval process in Power Automate; |
|
Ch 15: Power Apps Certification Samples (PL 900) |
Part 1: Power BI Report Design |
Part 2: ETL, Data Modeling, DAX |
Part 3: Power BI Cloud, Admin |
Ch 1 : POWER BI BASICS
|
Ch 7 : POWER QUERY LEVEL 1
|
Ch 13 : POWER BI CLOUD - 1
|
Ch 2: BASIC REPORT DESIGN
|
Ch 8 : POWER QUERY LEVEL 2
|
Ch 14 : POWER BI CLOUD - 2
|
Ch 3 : Visual Sync, Grouping
|
Ch 9 : POWER QUERY LEVEL 3
|
Ch 15 : EXCEL & RLS
|
Ch 4 : Hierarchies, Filters
|
Ch 10 : DAX Functions - Level 1
|
Ch 16 : Report Server, RDL
|
Ch 5 : Bookmarks, Azure, Modeling
|
Ch 11 : DAX Functions - Level 2
|
Ch 17: MSBI Integrations
|
Ch 6 : Visualization Properties
|
Ch 12 : DAX FUNCTIONS Level 3
|
Ch 18 : REAL-TIME PROJECT
|