Tech Coach

Merge Statement in Oracle | Merge Statement in SQL

Vlookup Hlookup Index Match Xlookup Practice Questions Excel | Lookup Practice Exercise

Conditional Formatting with Formulas in excel

Conditional Formatting Basics in Excel | Conditional Formatting Highlight Cell Rules

Analytical Functions in oracle explained with real examples

Absolute relative and mixed referencing | Relative Reference Excel | Mixed Reference Excel

ORACLE 11 g Installation on Windows 7/8/Windows 10 in 2020|Oracle 11g installation easy on laptop

Excel Dataset as Table | Excel Range as Table | Excel Dataset Range as Table

Difference Between Procedure and Functions in Oracle|Oracle Interview Questions|SQL INTERVIEW

Generate Millions Rows of Data in 2 mins |Test Data Generation|Random Data Generator Excel

Excel Versions |Microsoft Excel 365 | Microsoft Excel 2019|Microsoft Excel 2010|Microsoft Excel 2013

SQL Oracle Full Course 2020|Real Project SQL Course|SQL Introduction|SQL tutorial for beginners

Window Analytic Function in SQL | Analytical Function in Oracle | Analytical Function practice

Materialized views in oracle - Part 1

Index Organized Table in Oracle|IOT Oracle|Tech Coach

Textjoin Function in Excel | Textjoin with Filter Function Excel | Text join real scenario

SQL DDL Practice Excercise| SQL Practice Questions|SQL Questions

Filter Function in Excel | Filter Dynamic Array Function Excel

Merge Statement in Oracle | Merge Statement in SQL

Dynamic Array and Sequence Function in Excel | Dynamic Arrays Excel| Sequence Function in Excel

Automated data recon| Data reconciliation |Data Reconciliation In SQL | Data Reconciliation OLAP

Large Small Function in Excel | Large Function Excel | Small Function Excel

Average IF Function in Excel |SumIFS function Excel |CountIFS Function Excel|CountIF function excel

Functional Indexes in Oracle

Foreign key in sql with real project Examples | Referential Integrity | Why use Foreign keys

Materialized View In Oracle - Part 3

Text Function Questions in Excel | Text functions Practice Exercise Excel

Unix Interview Question for ETL Informatica and data analyst roles

Excel Conditional Formatting Question | Excel Real project Scenario

Run SQL Query online|SQL query practice online|How to execute SQL query online|Oracle Query online

SQL query Practice | Oracle Query Practice

Unique Function in Excel | Unique Dynamic Array Function

Offset Function in Excel | Make your range Dynamic | OFFSET Function with CountA Function

Sum Product Function in Excel | Sumproduct Function Excel

Microsoft PowerBI Interview | Power BI Interview Questions | Power BI Mock Interview

Correlated and Non Correlated Sub query in SQL |Subquery|Nested Subquery|Correlated Subquery in sql

Indexing in Oracle :B-Tree,Bitmap Indexing

SQL Practice Query | Oracle SQL Practice

Ribbon Data Tab| Data Tab in Excel | Excel Data tab| Excel Data Ribbon

Window Analytical Function Solution | Analytical function in Oracle | Analytical function Oracle

Dynamic Lookup Transformation in Informatica

Splitting and Spawning in B- Tree Index : How Blocks are stored

SQL Query Practice exercise with Solution| SQL Interview Scenario | SQL Interview Query

Indexes in Oracle :Index Scan Methods :Part 2

Microsoft Power BI Learning Path|Learn Power BI | Learn Microsoft Power BI

SQL TABLE CREATION BASICS|SQL ROWS AND COLUMNS|ENTITY TUPLE RECORD ATTRIBUTES|SQL COURSE BEGINNERS

Dynamic Array basics concepts| Dynamic Array in Excel | Dynamic arrays and spill

Execute Immediate in PL/SQL Explained with example.

Joins in Oracle (SQL) Explained in detail with practical examples

BITMAP and BITMAP JOIN INDEX IN ORACLE explained

Second Normal Form in DBMS|Second Normalization Form|Second Normal form in sql|DB Normalization 2020