Day 4 still on subqueries but intermediate subqueries, will try again tomorrow and also master level subqueries
The more I practice the more I learn and understand SQL in general
The main thing about subqueries to me is understanding how to analyse the question
Day 2 of MySQL 30-Day Challenge
Today I learned about data types and got hands on with learning the basics of creating & managing a database using the following functions :
CREATE SCHEMA, USE, CREATE TABLE, SELECT, SHOW TABLES, RENAME, DROP.
The best analysts arenāt the smartest.
Theyāre the ones who take action.
-They publish dashboards, even if they arenāt perfect.
-They post case studies, even when they feel like imposters.
-They apply for jobs before they "feel ready"
Stop overthinking.
YouTube >>>>>>>>>>
You can learn so much there for free. See, some people don't even have the resources (DATA) to keep up, but YOU𫵠do.
All you need now is to INVEST your TIME, and you will come out equipped with real skills.
Take advantage of that privilege TODAY .
#Day3#100daysofDA#datacleaning#DataAnalytics
Today, I learned how to:
-Extract the day from a date using the DAY function.
-Find the day of the week using the WEEKDAY function.
-Get the month from a date using the MONTH function.
-Extract the year using the YEAR function
540 Followers 527 FollowingData & BI Analyst || Excel ⢠SQL ⢠Power BI ⢠Looker Studio || Turning Complex Data into Smart Business Decisions || https://t.co/COKCjV3hEi
221 Followers 672 FollowingData Analyst | Financial Analyst | Making numbers and data tell the story behind smarter business decisions | Portfolio: https://t.co/RrwWIh8yJ4
2K Followers 2K FollowingHtml+Css+Js BTECH:IMT | SQL|Power Bi |Python|Data Analyst|Data Scientist | Tracking Analyst. Let Love Lead (LLL)| Egalitarian .
819 Followers 3K FollowingRealist, lover of nature albeit a creation beyond nature, great traveler of time, mixed heritage and always winning. I follow back if I find you genuine.
66 Followers 106 FollowingPassionate about Data, Digital Solutions & Football šā½
Excel | Power BI | SQL | Learning in public
Lifelong Learner š || Man United š“
540 Followers 527 FollowingData & BI Analyst || Excel ⢠SQL ⢠Power BI ⢠Looker Studio || Turning Complex Data into Smart Business Decisions || https://t.co/COKCjV3hEi
221 Followers 672 FollowingData Analyst | Financial Analyst | Making numbers and data tell the story behind smarter business decisions | Portfolio: https://t.co/RrwWIh8yJ4
5 Followers 17 FollowingTurning raw numbers into clear insights š | Data Analyst | SQL ⢠Excel ⢠Power BI ⢠Python | Helping businesses make smarter decisions
225 Followers 412 FollowingHealth Data Analyst || Bioinformatics|| Machine Learning and Artificial intelligence || Teen and Youth Empowerment|| https://t.co/1Q1mgSXBN8
2K Followers 2K FollowingHtml+Css+Js BTECH:IMT | SQL|Power Bi |Python|Data Analyst|Data Scientist | Tracking Analyst. Let Love Lead (LLL)| Egalitarian .
661 Followers 60 FollowingData Analyst|| Business Analyst||Plumber|| Geologist|| Manchester United FCā¤ļø|| my goal is to leverage my expertise to provide invaluable insight in dataš»
172 Followers 461 FollowingData Analyst | Helping health orgs, Businesses & researchers with data insights using Excel | Power BI | SPSS | SQL | Public Health Professional.
2K Followers 585 Followingš@upwork Rising Talentš | Data Analyst + Data Scientist | I help founders and businesses predict growth, scale smart, and boost revenue š
2K Followers 1K FollowingCybersecurity Analystā”ļø| CCNA | NetClan Alumna | Cybergirl Alumna | Liverpool FC ā½ļø | Becoming the Best verison of myself Dailyš
182 Followers 61 FollowingData Analyst | Helping founders & businesses turn data into strategy | Viz Specialist | Excel ⢠BI ⢠Looker Studio ⢠Tableau ⢠Cognos | š¼ Open to projects | DM
2K Followers 303 FollowingData Analyst & Visualization Expert. I help business gain clarity through data mastery & compelling visual storytelling Exodus 14:14 [email protected]š„
665 Followers 89 FollowingAI Agent & Automation Expert, I help businesses save 15ā20 hrs/week by streamlining workflows, integrating CRMs, and building custom automations.