Microsoft Power Apps Training From SQL School Training Institute

Complete Real-time and Practical Power Apps Training with Real-time Project. POur Microsoft Power Apps Training courses are designed to equip learners with the knowledge to build high-productivity business solutions, automate and integrate business processes, gain data insights, and create intelligent chatbots using Power Apps offerings. Attending our Microsoft Power Apps courses will surely help learners to understand the proper use of Power Apps in their current job and enhance their career growth.. Our Power Apps course include Basic to Advanced.

Power Apps Training

	PLAN A	PLAN B	PLAN C
Course includes	Power Apps	T-SQL, Power Apps	T-SQL, Power BI, Power Apps
Total Duration	4 Weeks	7 Weeks	11 Weeks
Power Platform	✔	✔	✔
Power Apps	✔	✔	✔
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	❌	❌	✔

Trainer: Mr.Sai Phanindra (17+ Yrs of Exper)

All Session Are Completely Practical & Real Time

Please register for Power BI Training Videos

TRAINING HIGHLIGHTS

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

Power Apps Training Course Contents:

Brochure:

Register Today

Module 1 : SQL Server & T-SQL Queries [Applicable for Power BI Plans B, C]

Ch 1: DATABASE INTRODUCTION

Data, Databases and RDBMS Software
Database Types : OLTP, DWH, OLAP
Microsoft SQL Server Advantages, Use
Versions and Editions of SQL Server
SQL : Purpose, Real-time Usage Options
SQL Versus Microsoft T-SQL [MSSQL]
Microsoft SQL Server - Career Options

SQL Server Components and Usage
Database Engine Component and OLTP
BI Components, Data Science Components
ETL, MSBI and Power BI Components
Course Plan, Concepts, Resume, Project
24 x 7 Online Lab for Remote DB Access
Software Installation Pre-Requisites

Ch 5: SQL Basics - 3, T-SQL INTRO

Database Objects : Tables and Schemas
Schemas : Group Tables in Database
Schemas : Security Management Object
Creating Schemas & Batch Concept
Using Schemas for Table Creation
Data Storage in Tables with Schemas
Data Retreival and Usage with Schemas

Table Migrations across Schemas
Import and Export Wizard in SSMS
Data Imports with Excel File Data
Performing Bulk Operations in SSMS
Temporary Tables : Real-time Use
Local and Global Temporary Tables
# and ## Prefix, Scope of Usage

Ch 9: Triggers & Transactions

Triggers - Purpose, Real-world Usage
FOR/AFTER Triggers - Real time Use
INSTEAD OF Triggers - Real time Use
INSERTED, DELETED Memory Tables
Using Triggers for Data Replication
Enable Triggers and Disable Triggers
Database Level, Server Level Triggers

Transactions : Types, ACID Properties
Transaction Types and AutoCommit
EXPLICIT & IMPLICIT Transactions
COMMIT and ROLLBACK Statements
Open Transaction Scenarios & Cause
Query Blocking Scenarios @ Real-time
NOLOCK and READPAST Lock Hints

Ch 2: SQL SERVER INSTALLATIONS

System Configuration Checker Tool
Versions and Editions of SQL Server
SQL Server and SSMS Installation Plan
SQL Server Pre-requisites : S/W, H/W
SQL Server 2022 / 2019 Installation
SQL Server 2017 Installation
Instance Name and Server Features

Instances : Types and Properties
Default Instance, Named Instances
Port Numbers, Instance Differences
Service and Service Account Use
Authentication Modes and Logins
Windows Logins and SQL Logins
FileStream and Collation Properties

Ch 6 : CONSTRAINTS, INDEXES

Constraints and Keys - Data Integrity
NULL, NOT NULL Property on Tables
UNIQUE KEY Constraints: Importance
PRIMARY KEY Constraint: Importance
FOREIGN KEY Constraint: Importance
REFERENCES, CHECK and DEFAULT
Candidate Keys and Identity Property

Database Diagrams and ER Models
Relationships Verification and Links
Indexes : Basic Types and Creation
Index Sorting and Search Advantages
Clustered and NonClustered Indexes
Primary Key and Unique Key Indexes
Need for Indexes - working with Keys

Ch 10: DB Architecture & Group By

Database Architecture: Data Files
Database Architecture: Log Files
Primary and Secondary Data Files
Log Files Creation and Realtime Use
Creating and Using Filegroups
Linking Tables with Filegroups
Scripting Database and Objects

GROUP BY: Importance, Realtime Use
GROUP BY Queries and Aggregations
Group By Queries with Having Clause
Group By Queries with Where Clause
Using WHERE and HAVING in T-SQL
Using Group By in Data Audits
Using Group By with Joins, Audits

Ch 3: SSMS Tool, SQL BASICS - 1

SQL Server Management Studio
Local and Remote Connections
System Databases: Master and Model
MSDB, TempDB, Resource Databases
Creating Databases : Files [MDF, LDF]
Creating Tables in User Interface
Data Insertion & Storage. Limitations

SQL : Purpose and Real-time Usage
SQL Versus T-SQL : Basic Differences
DDL, DML, SELECT, DCL and TCL
Creating Tables using SQL Scripts
Data Storage, Inserts - Basic Level
Table Data Verifications with Select
SELECT Statement for Table Retrieval

Ch 7: JOINS & LINKED SERVERS

JOINS - Table Comparisons Queries
INNER JOINS For Matching Data
OUTER JOINS For (non) Match Data
Left Outer Joins with Example Queries
Right Outer Joins with Example Queries
FULL Outer Joins - Realtime Scenarios
Join Queries with "ON" Conditions

CROSS JOIN and CROSS APPLY
One-way, Two way Data Comparisons
Linked Servers Configurations
Linked Servers: RPC Settings & Tests
Linked Servers, Remote Joins in TSQL
Multi Server Connections, DB Access
2 Part, 3 Part, 4 Part Name Conventions

Ch 11: TSQL Queries: Group By, Joins

Joins with Group By Queries in TSQL
Joining 3 Tables with Group By
Joining 4 Tables with Group By
Multi Table Joins with Table Aliases
Table & Column Aliases with Joins
Joins with HAVING Conditions
Joins with WHERE & Aggregations

Joins with Sub Queries, Formatting
Joins with IIF() Function, Conditions
Joins with CASE Statement Conditions
UNION and UNION ALL Operator
Storing Queries in Database Views
Office Data Connections, Excel Reports
Manual Data Refresh & Reports

Ch 4: SQL BASICS - 2

Creating Databases & Tables in SSMS
Single Row Inserts, Multi Row Inserts
Rules for Data Insertion Statements
SELECT Statement @ Data Retrieval
SELECT with WHERE Conditions
Batch Concept and Go Statement
AND and OR Operators Usage

IN Operator and NOT IN Operator
Between, Not Between Operators
LIKE and NOT LIKE Operators
UPDATE Statement & Conditions
DELETE & TRUNCATE Statements
Logged and Non-Logged Operations
ADD, ALTER and DROP Columns

Ch 8: VIEW, SPs, FUNCTIONS BASICS

Database Objects: Overview & Usage
Views: Types, Usage in Real-time
System Predefined Views and Audits
Listing Databases, Tables, Schemas
Functions: Types, Usage in Real-time
System Predefined Functions, Audits
DBId, DBName, ObjectID, ObjectName

Using Parameters in SQL Server
Dynamic Joins for Database Audits
Procedures: Types, Usage in Real-time
User & System Predefined Procedures
Parameters and Dynamic SQL Queries
Sp_help, Sp_helpdb and sp_helptext
sp_pkeys, sp_rename and sp_help

Ch 12 : ER MODELS, NORMAL FORMS

First Normal Form and Atomicity
Second Normal Form, Candidate Keys
3rd Normal Form Multi Value Dependency
Boycee-Codd Normal Form : BNCF
Fourth Normal Form Realtime Advantages
Self Reference Keys and 4 NF Usage
1:1, 1:M, M:1, M:M Relationship Types

MERGE Statement - Comparing Tables
WHEN MATCHED and NOT MATCHED
Incremental Load with MERGE Statement
UPSERT Operations with MERGE
Stored Procedures for Merge Statement
DML Operations with ON Keyword
Tuning / Optmizing Merge Statement

Case Study 1 -
For Database, Table Design (Constraints, Keys)

Case Study 2 -
For Query Writing + Window Functions
(Rank, RowNumber)

Module 2 : Power Apps [Applicable for Power Apps Plan B, C]

Module 3 : Power BI [Applicable for Power BI Plans A, B, C]

EVERY SESSION IS COMPLETELY PRACTICAL. REAL-TIME. TASKS, MATERIAL, LAB WORK for EVERY SESSION. Register Today

Trainer Profile

Reviews

Course Curriculum

Mode of Training

Free Demo

Register Today

Job-Oriented Real-time Training @ SQL School Training Institute - Trainer : Mr.Sai Phanindra (17+ Yrs of Exper)

SQL Server & T-SQL

SQL Server Course

SQL Server Course

SQL Server Course

SQL Server DBA

SQL DBA Course

SQL DBA Course

SQl DBA Course

MSBI (SSIS, SSAS, SSRS)

MSBI Online Training Course

MSBI Classroom Training

MSBI Video Course

SSIS (with ETL, DWH)

SSIS Online Training

SSIS Classroom Training

SSIS Video Training

SSAS (with MDX, DAX)

SSAS Online Training

SSAS Classroom Training

SSAS Video Training

SSRS & Power View

SSRS Online Training

SSRS Classroom Training

SSRS Video Training

SQL Performance Tuning

SQL Performance Tuning

SQL Performance Tuning

SQL Performance Tuning

Power BI Training

PowerBI Online Course

PowerBI Classroom Course

PowerBI Video Course

PL-SQL Training

PL-SQL-Courses

PL-SQL-Courses

PL-SQL-Courses

Register Today