Jonathan Shinray FangLet’s know more about Excel LookupA brief explanation that uncovers the secrets behind the marvelous Excel Lookup Functions.6d ago6d ago
Jonathan Shinray FangLet’s know more about Excel Pivot TableAll you need to know about Excel Pivot Table in order to help you in your daily basisJul 19Jul 19
Jonathan Shinray FangLet’s know more about SQL Window FunctionsA comprehensive explanation of SQL Window Functions, we’ll thoroughly discussing this from what it is to how to utilize it in our query.Jul 8Jul 8
Jonathan Shinray FangLet’s know more about JOIN ClauseA comprehensive explanation of what and how much important is JOIN clause in Structured Query LanguageJun 26Jun 26
Jonathan Shinray FangLet’s know more about Advance SQL TechniquesIntroduction to Advance SQL Techniques that mostly used in everyday work, like subquery, windows function, and aggregate functionsJun 19Jun 19
Jonathan Shinray FangLet’s know more about Basic SQL ConceptA simplified guide version of what is Structured Query Language (SQL) with exampleJun 16Jun 16
Jonathan Shinray FangLet’s know more about Distance MeasuresA small comparison between Euclidean Distance, Cosine Similarity, Manhattan Distance, and Mahalanobis DistanceJun 10Jun 10
Jonathan Shinray FangLet’s know more about AI PromptingAI Prompt used for easier ‘chat’ with AI, when interacting with AI it makes AI more understand your needsMay 30May 30
Jonathan Shinray FangLet’s know more about CTECommon Table Expressions or CTE is commonly used in SQL to make the query cleaner, makes it easier to readMay 27May 27