Bellevue WA educated with Microsoft Technologies: Please Don't use my material to cheat! This is only for those who want to know and understand the concepts of what I have been through to help student's and other's to grow in life.
Stored Procedures|CTE's|Functions|Concepts|Cube-MDX|Tabular-DAX|Data Modeling (T-SQL/Kusto KQL) Triggers/Stored Procedures
Performance
Using Sub-Queries
Functions-Procedures
SQL Performance Useful-SQL (IF EXISTS)
Creating-Views
Using Partition
Constraints/Indexing
CTE's Aggregation Insert-Joins-Unions
DDL-Indexes-FK
Using-Variables
Calc-Running Total
Dimensional Model Research Data Modeling
OLTP-OLAP
Periodic Snap-Shot
JunkDims-RolePlaying
Factless-Fact & Outrigger Derived-Vs-Calculated
Advanced-Q&A
Data Modeling Techniques
DAX-Scripts
Using Pivot RANK & ROW_NUMBER
GROUP BY & HAVING
Employee-Manager
ROLLUP & CUBE
Date Table (Fiscal) Basic-Querying
Filtering
T-SQL-Examples
Cast/Convert/Concatenation
Using Sub-queries Sub-queries2
Sub-queries3
Find Bike Buyers (1)
Find Bike Buyers (2)
vTarget Mail Method (3) GROUP BY (Grouping)
Aggregates
Outer Joins
Inner Joins
Inner Joins (Using Like) MDX-Scripts
Interview Questions
Delete Duplicate Rows
AVG Orders on Seasons of Years
'CustomerCityVisitsDB Power M-Query (Folding)
DWAdventureWorks Flush-Fill (ETL)
PrimaryKeyVsUniqueKey
Resume
Resume Kusto (KQL)
ItemQTY&SalesByPrevMonth
DateTime Analytics (T-SQL-Kusto)
Snowflake
Resume
Objects|Classes|Methods|Interfaces|Delegates (Advanced C#) Coke Machine Code
Coke Machine Layout
Temp Conversion
Fruit Inheritance Code
Fruit Inheritance Layout Poker Code
Poker Layout
Delegates-Sorting (LayOut)
Delegates-Sorting(Code)
Inheritance Project Lists-Polymorphism (Code)
IComparable<T>Interface
For Loop Array
Resume
Boxing and Un-Boxing Book Store Project
RegEx Date Validation
Random Guessing
Resume
TempConversion-Layout Creating Loops
2D Array
RegEx (HTML-C#-JS-PS)
Coke Machine (Constructors)
CountConsecutiveCharGroups Rand-Generator 2D Array
Random Roll Dice
Squared / Cubed
Resume
Basic Array Sort Advanced Poker Project
Bubble Sort (Delegates)
Polymorphic Behavior (Objects)
Resume
Resume File System Objects (FSO)
DupCharFinder (Code)
DupCharFinder (Download)
Resume
Resume CharCountInString (Code)
CharCountInString (Download)
Resume
Resume
CountConsecCharGrps (Download)
Extract|Transform|Load (SSIS/Azure Data Factory/Azure Database Migration) ETL-LayOut
VConnSettings (ETL)
EmailValidation (ETL)
Adding Today's Date to Time (ETL)
OLTP-OLAP (ETL) FlatFile-SQLDB (ETL)
DWAdventureWorks_Basics(ETL)
DWAdventureWorks_Level01(ETL)
Deploy
Resume ValidateEmail(Script)
CreateFiles/Folders
Foreach Loop (ETL)
Validate Email
Advanced Multi/Tabular Project OLTP-OLAP Project
ForEach Loop Project
SCD StoredProc Project
EmailValidate Py-PS-CSharp
Resume Create/Delete VM's(Azure)
AzureDataStudioToLensExplorer
ForEachLoop (Download)
Resume
Resume
Objects|Methods|Classes|Class Library-Integration (ASP.NET/MVC) More coming soon! PC-Super Store
Log-In Library
ASP Objects-Structure
Log-In (DAL-Library)
Multi-Table Insert Session Transfer
WebConfig
Transfer-SQL-DB
Mask | Validate Phone#
Mask | Validate (JQuery) Login (Webforms)
Login (.NET CORE)
Login (.NET Framework)
Login (LDAP)
Resume Resume
AutoEmail (OfficeClient)
AutoEmail (OfficeServer)
AutoEmail (SendGrid)
AutoEmail (GMail) RazorSyntax (MVC 5)
WebGrids (MVC 5)
J-Query/Ajax
Lin-Q 7 Data Access
Add/Delete Rows DeepDataView (Webforms)
DeepDataView (MVC)
DeepDataView (.NET CORE)
DeepDataView (.NET 7)
Resume DeepDataView (.NET Website)
Resume
Resume
Resume
Resume
HTML|CSS|JavaScript (Web Development) BlackJack(21)
BlackJack(21)Code
Guessing Game
Blog Format
RockPaperScissors Temperature
Page Transitions
Schedule (Table)
Sneaker Contest
Table Schedule Resume
DeepDataView (WebSite)
Resume
Resume
Resume
Analysis|Data Mining|Statistics|Cube Modeling (SSAS) Tabular Modeling
Prospective Buyers
Movie Goer Prediction
Products Sold Together
Predict Temperature Periodicity Hint (Stocks)
Decision Tree
Derived Vs Calculated
Basic MDX Syntax
Tabular DAX Scripts MDX Cube Design
Excel Sales Report (Tabular)
Excel Pivot (Multi-Source)
MDX-Scripts
Power BI Intro-Inference
Probability
Standard Normal Distribution
Confidence-Interval
Probability Formulas Z-Score Graph
Linear Regression
Z-Score Chart
Excel Analytics (DAX)
1-Stems-Histograms 2-Box-StemPlots
4-Response-ScatterPlots
7-Probability
9-Proportions
10-NormDistr 10-Z-ScoreDistr
13-RandomProp
15-ConfInterval
19-DOF-T-Interval
Excel_BIAnalytics(DAX).xlsx BI Analytics Excel (DAX) PDF
Delete Duplicate Rows
Employee-Manager
Power BI (CustomerVisitsDB)
Resume Advanced Multi/Tabular Project
Lense Explorer
Resume
Resume
Resume Resume
Resume
Resume
Resume
Resume
SQL Reporting Services|Tableau Desktop|Power BI Desktop|Excel (SSRS) Tableau (DebtCntry)
Tableau (Supplies)
Tableau (ShipCost)
Tableau07B (Titanic)
Tableau (PssgSaved) Tableau (SalesProfit)
Tableau (Population)
Dashboard (IntSales)
Dashboard (RslerSales)
Excel Finding Data
SSRS (IntSales)
SSRS (ResalerSales)
Tableau (Demographics)
Tableau (sales) Power BI (Sales)
Power BI (CustomerCityVisitsDB)
AdvDWPowerBI
Resume
Resume Power M-Query (Folding)
Kusto (KQL)
PBI Direct-Vs-Cached
Resume
Resume
