#dataanalytics

Articles tagged with #dataanalytics

Joins in SQL: Bridging the Gap Between Data Tables
Joins is a clause in SQL used to combine rows from two or more tables based on a related column. Tables that share information have a primary key that identifies the entity uniquely across the database. JOIN combines row data across separate tables u...
Sep 7, 20237 min read14
Understanding the SELECT Statement in SQL
THE SELECT STATEMENT
Aug 17, 20232 min read18
Mastering Date Extraction in Excel.
Working in Excel it is very unlikely that you'll lack a date column. This article explores techniques for extracting and manipulating dates in Excel. Dates are stored as serial numbers while time is stored as decimals. Date is stored as continuous da...
Aug 10, 20232 min read59