Freelance Guruji journal

Tag: Technical Documentation

SQL data types: a practical guide with review steps, an example, common questions and clear limits for client work.

October 10, 20262 min read

Correlated and non-correlated SQL subqueries: a practical guide with review steps, an example, common questions and clear limits for client work.

October 10, 20262 min read

SQL IN statement: a practical guide with review steps, an example, common questions and clear limits for client work.

October 10, 20262 min read

SQL JOIN queries: a practical guide with review steps, an example, common questions and clear limits for client work.

October 10, 20262 min read

SQL window functions vs CTEs: a practical guide with review steps, an example, common questions and clear limits for client work.

October 10, 20262 min read

SQL HAVING vs WHERE: a practical guide with review steps, an example, common questions and clear limits for client work.

October 10, 20262 min read

Excel AVERAGE function: a practical guide with review steps, an example, common questions and clear limits for client work.

October 10, 20262 min read

Excel FIND vs SEARCH: a practical guide with review steps, an example, common questions and clear limits for client work.

October 10, 20262 min read

Excel date functions: a practical guide with review steps, an example, common questions and clear limits for client work.

October 10, 20262 min read

TEXT function in Excel: a practical guide with review steps, an example, common questions and clear limits for client work.

October 10, 20262 min read