Microsoft Power Apps Training

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.. !

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 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 (18+ Yrs of Experience)

S No	Time (IST, Mon - Fri)	Start Date
SQL Server & T-SQL Schedules
1	6 AM - 7 AM	Oct 24th	Register
2	8 AM - 9 AM	Oct 18th	Register
3	6 PM - 7 PM	Sep 27th	Register
4	8 PM - 9 PM	Nov 6th	Register
5	9 PM - 10 PM	Oct 4th	Register

If above schedules does not work for you, please register for Power Apps Training Videos

Power Apps Training Highlights

PowerApp Design	Azure SQL DB
PowerApp Solutions	Sharepoint
MS Flow, Tasks	DataVerse
Canvas Controls	VersionControl
Laypout Design	Subscriptions
Apps with Excel	Power Automate

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

Databases Introduction & Purpose
Database Types : OLTP, DWH, OLAP
Microsoft SQL Server Advantages, Use
SQL Server Components and Usage
Microsoft SQL Server - Career Options
Developer, DBA, Data Engineer
Data Analyst, Data Scientist Careers

SQL : Purpose, Real-time Usage Options
SQL Versus Microsoft T-SQL [MSSQL]
Course Plan, Real-time Project, Resume
24 x 7 Online Lab for Remote DB Access
Versions and Editions of SQL Server
SQL Server Pre-requisites : S/W, H/W
System Configuration Checker Tool

Ch 5: SQL Basics - 3, TSQL 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 Retrieval & 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: Functions, Procedures Basics

Functions with SQL Server, TSQL
Scalar, Inline, Table Functions
Variables: Declare, Real-time Use
Creating, Executing Functions
Functions for Computations
Functions for Parameterized Joins
Procedures: Usage in Real-time

Using Parameters in SQL Server
Parameterized Joins in TSQL
Compilation with Stored Procedures
sp_help, sp_helptext, sp_helpindex
sp_helpdb, sp_rename, sp_recompile
System Views For Metadata Audits
DBID, DBName, ObjectID, ObjectName

Ch 2: SQL SERVER INSTALLATION

SQL Server & SSMS Installation Plan
SQL Server Pre-requisites : S/W, H/W
SQL Server 2022 & 2019 Installation
Database Engine Feature, OLTP
Instances : Types and Properties
Default Instance, Named Instances
Service and Service Account Use

Authentication Modes and Logins
Windows Logins and SQL Logins
SQL Server Management Studio
Server Connections with SSMS Tool
Local and Remote Connections
System Databases: Master and Model
MSDB, TempDB, Resource Databases

Ch 6: Constraints, Index Basics

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 & 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: 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
Batch Concept and Go Statement
Open Transactions in Real-time
Using Conditional Commits, Rollbacks

Ch 3: SSMS Tool, SQL BASICS - 1

Creating Databases: Files [MDF, LDF]
Creating Tables in User Interface
Data Insertion & Report in User Interface
SQL : Purpose and Real-time Usage
SQL Versus T-SQL : Basic Differences
DDL, DML, SELECT, DCL and TCL
Creating SSMS Sessions : SPID

Create, Connect Databases using SQL
Creating Tables with INT, CHAR
Data Storage, Inserts - Basic Level
Table Data Verifications with Select
SELECT Statement for Table Retrieval
Identify Databases and Tables
Identify Sessions and Session ID

Ch 7: Joins Basics, TSQL Queries

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

CROSS JOIN and CROSS APPLY
One-way, Two way Data Comparisons
Using Table Aliases & Column Aliases
Optimizing Join Queries with Indexes
Choosing Correct Comparison Columns
Joining Unrelated Tables in TSQL
Self References, Self Joins in TSQL

Ch 11: Normal Forms, Cursors

First Normal Form and Atomicity
Third Normal Form and MVD Property
Boycee-Codd Normal Form : BNCF
Fourth Normal Form : Advantages
Self Reference Keys and 4 NF Usage
1:1, 1:M, M:1, M:M Relationship Types
Linked Servers Configurations, RPC

Linked Servers, Remote Joins in TSQL
2 Part, 3 Part, 4 Part Naming Styles
Remote Joins Queries and Aliases
Cursors - Basics, Data Operations
Cursors - Life Cycle & Declaration
Cursors Types, FETCH Operations
Cursors - Deallocate, Real-world Use

Ch 4: SQL BASICS - 2

Creating Tables: VARCHAR, FLOAT
Single Row Inserts, Multi Row Inserts
Rules for Data Insertion Statements
SELECT with WHERE Conditions
AND and OR Operators Usage
IN Operator and NOT IN Operator
Between, Not Between Operators

LIKE and NOT LIKE Operators
ORDER BY, TOP & OFFSET
Basic Sub Queries with SELECT
UPDATE Statement & Conditions
DELETE & TRUNCATE Statements
ALTER, ADD COLUMN Statements
DROP Statements: Table, Database

Ch 8: Group By in TSQL, Views Basics

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
Group By with Joins in TSQL
Query Execution Order & Aliases

Joins with Sub Queries, Formatting
Database Objects: Overview & Usage
Views: Types, Usage in Real-time
Creating, Executing & Verifying Views
Storing Queries in Database Views
Excel Analytics - Joins & Views
Excel Office Data Connection Reports

Ch 12: TSQL Queries, SQL Analytics

IIF() Function with SELECT Query
WHEN..THEN..ELSE
WHEN MATCHED, NOT MATCHED
Incremental Loads, Upsert Statement
Stored Procedures: Merge Statement
UNION and UNION ALL Operator
Window Functions: Rank, Dense Rank

Row_Number, PartitionBy in TSQL
Duplicate Row Identification, Deletion
Grouping, Cube, Rollup, Lag, Lead
Data Types: Numerical, Date, Time
Data Types: Characters, Real, Float
Date & Time Functions, DateAdd
String Functions, Concat, SubString

Case Study 1: Database Design with Tables,
Constraints, Keys & Relations

Case Study 2: Joins with Group By,
Sub Queries, Views, Excel Analytics

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

Ch 1: Power Apps - Introduction

What 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 Implementation

Power 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 Apps

Create 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 Design

Introduction 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 Excel

Power 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 Database

Using 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 Sources

Using 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 Solutions

Dataverse 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 Apps

Using 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 - 1

Power 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 - 2

Dynamic 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 & Versions

Creating 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 Apps

Power 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 - Introduction

Power 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)

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

Part 1: Power BI Report Design	Part 2: Power Query, Cloud (Service)	Part 3: DAX & Report Server
Ch 1: POWER BI INTRODUCTION Power BI : Introduction to Analytics Power BI Tools Suite, Advantages Power BI : Career Options, Plan Power BI Developer Job Role Microsoft Data Analyst Job Role Big Data Analyst Job Role Power BI Data Analyst (PL 300) Data Engineer, Power BI (DP 500 ) Artificial Intelligence (AI) Visuals AI Enabled Power BI Features Course - Lab Plan with Design Tools Need for Power Query & DAX Power BI Licensing Types Power BI Cloud - Advantages Power BI Report Server Advantages	Ch 7: POWER QUERY LEVEL 1 Power Query M Language Purpose Power Query Architecture and ETL Data Types, Literals and Values Power Query Transformation Types Table & Column Transformations Text & Number Transformations Date, Time and Structured Data let, source, in statements @ M Lang Get Data, Table Creations and Edit ETL Operations with Power Query Merge Transformations in Power BI Join Kinds: Inner, Outer & Apply Union All Transformation & Appends Power Query Editor, Step Edits Close & Apply Options. Report Design	Ch 13: DAX Functions - Level 1 DAX : Importance in Real-time DAX Data Types, Syntax Rules DAX Measures and Columns ROW Context and Filter Context Operators, Special Characters DAX Functions, Vertipaq Engine DAX Cheat Sheet : Expressions Data Analytics with DAX DAX Measures : Expressions ISBLANK, IF, IN, SUM SUMX, AVG, AVERAGEX Data Models: Fact, Dimensions Detecting Relations for DAX Star & Snowflake Schemas Data Modeling Options in DAX
Ch 2: Basic Report Design Power BI Eco System: Architecture Data Sources & Types in Real-world Report Types: Interactive, Paginated Analytical Reports & Mobile Reports Data Sources : File, Database, Web Visualizations : Report Shapes Power BI Design Tools, Requirements Power BI Desktop Tool : Installation Desktop Interface: Overview, Canvas Get Data, Data View, Report View In-Memory Xvelocity Database Basic Visuals: Table, Tree Map Data Labels, Legend, Category Local Store: PBIX & PBIT Files Data Points and Tooltips	Ch 8: POWER QUERY LEVEL 2 Query Duplicate, Query Reference Group By and Advanced Options Aggregations with Power Query Transpose, Header Promotion Reverse Rows and Row Count Data Type Changes & Detection Replace Columns: Text, NonText Advanced Query Edit Options Replace Nulls: Fill Up, Fill Down Pivot, Unpivot Transformations Move Column and Split Column Date & Time Transformations Derive Year, Quarter, Month, Day Add Column : Query Expressions Query Step Inserts and Step Edits	Ch 14: DAX Functions - Level 2 Quick Measures in Power BI Average and Filtered Average Running Totals, EARLIER( ) RELATED, COUNTROWS CALCULATE Function Conditions ALL Members Scope & IN Account and Time Calculations Star Rating, DAX Expressions Data Modeling Options in DAX 1:1, 1:M and M:1 Relations Working with Facts & Measures Modeling : Missing Relations Relationships & Importance Modeling : Relation Management Modeling with Multiple Keys
Ch 3: Visual Interaction, Visual Sync Visual Interaction with Data Points Disabling / Enabling Interactions Edit Interactions: Format Options Spotlight and Focus Mode Report Export to CSV, PDF Tooltip Options and Usage Working with Pages in PBI Rename, Duplicate, Hide Pages Slicer Visual : Real-time Usage Orientation, Selection Properties Slicer Settings : Tiles & Slider Single & Multi Select, Header Number, Text, Show Summary Date Slicer and Value Selections Slicer List, Dropdowns & Clear	Ch 9: POWER QUERY LEVEL 3 Big Data Loads : Parameter Queries Creating Parameters in Power Query Parameter Data Types, Default Lists Static & Dynamic Lists: List Queries Convert Tables to Lists, Use Cases Linking Parameters to Queries Testing Parameters with Canvas Multi-Valued Parameter Lists Creating Lists in Power Query Converting Lists to Table Data Invoke Function, Type Conversions Function Query & Parameter List Columns From Examples, Indexes Conditional Columns, Expressions Disable / Enable Data Loads	Ch 15: DAX Functions - Level 3 DAX : Variables and Expressions Dynamic Expressions, RETURN Current Value, Previous Value SELECTED VALUE, Joins FORMAT Function with DAX RELATED, Joins in DAX DAX Expressions with SQL DB Time Intelligence Functions Date Dimension : Generation CALENDAR(), DATESYTD() TOTALYTD, TOTALQTD TODAY, DATE, DAY with DAX SELECTEDVALUE, FORMAT Date, Time and Text Functions
Ch 4: Grouping & Hierarchies Grouping : Visuals with Pdf Sources List Grouping and Binning Options Grouping Static / Fixed Data Values Grouping Dynamic / Changing Data Bin Size and Bin Limits (Max, Min) Bin Count and Grouping Options Group with Bins & Clustering Group, Layer with Selection Pane Creating Hierarchies in Power BI Independent, Dependant Drill-Down Drill-Down with Interactive Reports Conditional Drilldowns, Data Points Drill Up Buttons and Operations Expand & Show Next Level Dynamic Data Drills Limitations	Ch 10: POWER BI CLOUD - 1 Power BI Cloud Components App Workspaces, Report Publish Reports & Related Datasets Cloud Creating New Reports in Cloud Report Publish, Report Uploads Report Edits and New Reports Report Actions: Downloads Dataset Usage Options in Cloud Dashboards Creation and Usage Pining Visuals and Report Pages Visual Pin Actions in Dashboards Dashboard & LIVE Interactions Media Tiles: Images, Custom Links Q & A Option with Dashboards Pin with Q & A; Standard Visuals	Ch 16: DAX Functions - Level 4 RLS: Row Level Security Data Models in Power BI Desktop DAX Roles Creation and Testing DAX Expressions & Operators PBIX Uploads: Power BI Cloud Dataset Security with DAX Roles Entity Sets and Slicing in DAX Dataflows with Power BI Analytical Reports - DAX Usage Creating Data Models with DAX Datasets in Excel and Dashboards Using Excel Analyzer in Power BI Power BI Data Source in Excel Connection Strings and Refresh Analytical Reports - Limitations
Ch 5: Filters & Bookmarks Filters : Types and Usage in Real-time Visual Filter, Page Filter, Report Filter Basic, Advanced and TOP N Filters Category and Summary Level Filters Data / Drill Options, DrillThru Filters Keep All Filters" Options in DrillThru CrossReport Filters, Include, Exclude Drill-thru Filters, Page Navigations Bookmarks : Report Navigations Buttons, Images with Actions Selection Pane, Actions, Text URLs Show Data and See Records Custom Tooltips, Table Visual Table Vs Matrix : Drill-downs Styles, Cell Properties, Databars Conditional Formatting, Divergent	Ch 11: POWER BI CLOUD - 2 Report Actions : Share, Subscribe Report Actions : Lineage, Embed Report Actions : Export Options Report Actions : Public User Access Dashboard Actions : Share, Subscribe Dashboard Actions : Themes, Lineage Dashboard Actions : Share, Subscribe Favorite, Insights, Embed Code Gateways Configuration, PBI Service Gateway Types, Cloud Connections Gateway Cluster, Add Data Sources Data Refresh : Manual, Scheduled Power Query Parameters, Gateways DataFlows, Power Query in Cloud Lineage, Share, Subscribe, Insights Performance Inspector& Gateways	Ch 17: Power BI Report Server Power BI Report Server Config SQL Server Instance Verifications Report Server DB, Temp Database WebService & WebPortal URL Uploading Interactive Reports End User Report Share (pdf) Power BI Desktop RS Tool Interactive Reports: Report Server Mobile Reports : Design Options Mobile Reports : Grids, Elements Mobile Reports : Uploads, Edits Paginated Reports : Deployments Paginated Vs Interactive Reports Paginated Vs Analytical Reports Paginated Vs Mobile Reports Power BI Report Server Vs Cloud
Ch 6: Big Data Access, Visuals OLTP Databases, Big Data Sources Azure Database Access, Reports Import, Direct Query & Dual Mode Data Modeling: Do Not Summarize Data Modeling: Currency, Relations Power BI Archtiecture, Eco System Power BI Interface for Reports Stacked Chart, Clustered Chart Line Chart, Area Chart, Bar Chart 100% Stacked Bar & Column Chart Map Visuals: Tree, Filled, Bubble Small Multiples, Legends, Axis Cards, Funnel, Table, Matrix Scatter Chart : Play Axis, Labels Waterfall Chart, Multi Row Cards	Ch 12: POWER BI CLOUD - 3 Workbooks : Excel Online & Pins Power BI Apps: Creation & Usage Power BI Segments, Content Navigation Screens, Audience App Publish, Verification & Edits Export, Share & Subscribe List View & Lineage View Options Power BI Scorecards: Realtime Use Paginated Reports - Design & Usage Power BI Report Builder Tool Microsoft Report Builder Tool Report Builder : Datasets, Charts Report Builder : Bar Charts, Fields Report Builder : Creating RDL Files Paginated Reports : Deployments	Ch 18: Power BI Admin & AI Power BI Cloud Management Power BI Admin : Alerts Workspace Management, Users Security: Report, Dataset Levels Security: Dataset, App Levels Security: Workspace Options PBI Performance Inspector Power BI & Artificial Intelligence Power BI & CoPilot Add-Ins AI Visuals & Big Data Analytics Smart Narrative and Q & A Infographics, Icons and Labels Key Influencer Visual in Power BI Metrics Visual, Performance Paginated Reports Visual
Power BI : Realtime Project (Sales - Retail)
Phase 1 : Basic Report Design Project Requirement Analysis Requirement Gathering, FSA Report Design with Excel Basic Data Modelling Infographics, Histograms Analytics and Formating	Phase 2 : SME Level Report Design with SQL DB SQL Database : Joins, Views Dual Storage Mode, SQL Queries Data Modeling, Power Query Dynamic Connections, Azure DB Parameters and M Lang Scripts	Phase 3: Deployments (Cloud, Server) DAX Requriements, Analysis Cloud and Report Server Custom Visualizations 3party Visuals & REST API * Project FAQs and Solutions One - One Resume, Mock Interview