Power Platform Developer

Our training program on Mocrosoft’s Power Platform developer equips you with the knowledge and skillset to build custom applications and automate workflows.  You will master Power Automate for process automation, build elegant data-driven apps with Power Apps, and gain actionable insights with Power BI, all without needing to write a code. This training empowers you to become a developer, bridging the gap between IT and business needs to drive digital transformation.

Courses required to become a fullfledged Power Platform Developer

Database Design and Development

Database Fundamentals:

  • Database Concepts: Defining databases, types (relational, hierarchical, network), advantages, and applications
  • Database Management Systems (DBMS): Roles, types, components, and functions
  • Data Modeling: Conceptual, logical, and physical model creation using ER diagrams
  • Entity Relationship Modeling (ERD): Diagramming entities, attributes, relationships, and keys
  • Normalization: Understanding normal forms (1NF, 2NF, 3NF, BCNF) and their benefits
  • Table Design: Creating tables, defining data types, constraints, primary keys, foreign keys

SQL Server Basics:

  • SQL Server Overview: History, features, editions, and architecture
  • SQL Language: Syntax, data types, operators, and expressions

Database Development:

  • Creating Databases: Using SQL Server Management Studio (SSMS) or Transact-SQL (T-SQL)
  • Creating Tables: Defining structures and relationships
  • Populating Tables: Inserting data, using bulk operations
  • Writing Queries: Retrieving, filtering, sorting, grouping, and aggregating data
  • Joining Tables: Inner, outer, self joins, and their applications
  • Views: Creating, using, and managing views
  • Stored Procedures: Creating, using, and managing stored procedures for reusable code
  • Functions: Defining user-defined functions (UDFs) for custom logic
  • Triggers: Handling events and automating actions

Additional Topics:

  • Transactions: Handling data integrity and consistency
  • Security: Implementing user permissions, roles, and access control
  • Backup and Recovery: Ensuring data availability and disaster recovery
  • Performance Tuning: Optimizing queries and database performance
  • Indexing: Understanding types (clustered, non-clustered) and usage strategies
Basics of Azure Cloud and Azure Databases

Azure Fundamentals:

  • Introduction to Cloud Computing: Concepts, benefits, deployment models (public, private, hybrid)
  • Overview of Microsoft Azure: Services, features, pricing model, subscription management
  • Azure Portal: Navigation, resource creation, configuration, monitoring
  • Azure Resource Manager (ARM): Understanding templates, deployments, resource groups

Azure Database Options:

  • Relational Databases: Azure SQL Database, Azure SQL Managed Instance, Azure Database for MySQL, Azure Database for PostgreSQL
  • NoSQL Databases: Azure Cosmos DB, Azure Table Storage, Azure Blob Storage
  • Choosing the Right Database: Considerations for data model, scalability, performance, cost

Database Deployment in Azure:

  • Creating Databases: Using the Azure portal, PowerShell, Azure CLI
  • Connecting to Databases: Using SQL Server Management Studio (SSMS), Azure Data Studio, application connection strings
Power App Development

Power App Fundamentals:

  • Introduction to Power Apps: Overview of the platform, capabilities, and use cases.
  • User Interface Design: Building screens, layouts, and controls for your app.
  • Data Sources and Connections: Connecting to various data sources like SharePoint, SQL Server, and cloud platforms.
  • Formulas and Expressions: Utilizing built-in formulas for logic, calculations, and data manipulation.
  • Canvas App Development: Building basic canvas apps with galleries, forms, and navigation.

Advanced Power App Development:

  • Gallery Features: Mastering advanced data display and manipulation within galleries.
  • Canvas App Performance Optimization: Techniques to improve responsiveness and efficiency.
  • Model-driven app development: Creating apps based on existing data models and leveraging advanced functionality.
  • Custom connectors and data integration: Building your own connectors for unique data sources.
  • Security and Governance: Managing app permissions, sharing, and user access controls.
Power Automate

Power Automate Essentials:

  • Introduction to Power Automate: Understanding the platform’s capabilities, use cases, and benefits.
  • Building basic flows: Creating automated workflows with triggers, actions, and conditions.
  • Connecting to data sources: Integrating with popular services like SharePoint, SQL Server, and cloud platforms.
  • Data manipulation and logic: Utilizing expressions, variables, and loops for advanced automation.
  • Error handling and debugging: Techniques for troubleshooting and perfecting your flows.

Advanced Power Automate Techniques:

  • Conditionals and branching logic: Building sophisticated workflows with complex decision-making.
  • Scheduling and recurring flows: Automating tasks at specific times or intervals.
  • Custom connectors and API integration: Connecting to unique data sources and services.
  • Error recovery and retry mechanisms: Ensuring your workflows handle unexpected situations gracefully.
  • User interaction and input forms: Capturing user data and triggering actions based on their input.
  • Security and governance: Implementing user permissions, flow sharing, and data security measures.
SharePoint Basics

Module 1: SharePoint Foundations

  • What is SharePoint?: Understanding its purpose, components, and benefits for collaboration and content management.
  • Key Concepts: Sites, libraries, lists, pages, permissions, versions, workflows, and search.
  • Navigating the SharePoint interface: Exploring the SharePoint home page, site contents, and ribbon.
  • Creating and managing sites: Types of sites, site templates, site settings, and customization options.

Module 2: Working with Content in SharePoint

  • Uploading and organizing documents: Using libraries, folders, metadata, and views.
  • Creating and editing pages: Using the SharePoint page editor, adding text, images, web parts, and formatting.
  • Sharing and collaborating: Managing permissions, co-authoring documents, and using version history.
  • Using lists and libraries for data management: Creating custom lists, adding columns, and using views to filter and sort data.

Module 3: Essential SharePoint Features

  • Searching for content: Using search bars, filters, and refiners to find information efficiently.
  • Managing workflows: Understanding basic workflow concepts and creating simple approval workflows.
  • Integrating with other Microsoft tools: Using SharePoint with Teams, OneDrive, and Outlook.
  • Customizing SharePoint: Using themes, branding, and web parts to personalize the experience.
Power BI

Module 1: Introduction to Power BI and Data Analytics

  • What is Power BI and its role in data analytics?
  • The Data Analytics Lifecycle: Exploring data acquisition, cleansing, analysis, and visualization.
  • Benefits and use cases of Power BI.
  • Interface overview and navigation.

Module 2: Connecting to Data Sources

  • Connecting to various data sources: Files, databases, cloud platforms, etc.
  • Understanding data connection types and their applications.
  • Importing and transforming data in Power Query Editor: Filtering, cleaning, and shaping data.

Module 3: Building the Data Model

  • Understanding the importance of a well-structured data model.
  • Creating relationships between tables and defining hierarchies.
  • Measures and calculations: Creating custom fields for analysis.

Module 4: Designing Visualizations

  • Fundamentals of data visualization: Choosing the right chart type for your data.
  • Creating basic visual elements: charts, graphs, maps, and custom visuals.
  • Formatting and customizing visuals for effective communication.

Module 5: Building Reports and Dashboards

  • Designing insightful reports with multiple visuals and layouts.
  • Creating interactive dashboards with filters, slicers, and drill-downs.
  • Sharing and collaborating on reports and dashboards.

More Questions?

Do you have more questions? Please feel free to call, email or drop us a comment on our social media channels.