I created these notes today while solving
#Sql
projects and challenges!
Honestly, if I had to learn
#SqlJoins
all over again, I’d want to start with a note like this which is why I created this to help anyone who is struggling with joins!
What do you think?
#DataAnalytics
My
#DataAnalytics
personal study goal for the week is this SQL checklist that I put together.
Since Monday, I have been on my learning board to study and revise
#Sql
as well as challenge myself intensely.
Can you boast of anything here?
#AggregateFunctions
are my private detectives when it comes to solving problems in SQL and I'm so glad that on today's episode of the
#RedPenOnA4Paper
with Rosie series, I get to highlight the most commonly used aggregate functions in
#Sql
Memorize them 👀👀
‘USING GROUP BY WITH AGGREGATE FUNCTIONS’
I don't just have Private Detectives
#AggregateFunctions
I have a matchmaker too and her name is the
#GroupBy
clause!!!
#RedPenOnA4Paper
by Rosie series is presenting an episode on grouping!!
Hi! I am Rosemary John. I am a creative, a content writer with an enthralling effect. I don’t just write, I create and leave my words swimming in the soul of my readers.
To find out more about my services, do well to click the link:
‘INTRODUCTION TO CTEs(Common Table Expression)’
#RedPenOnA4Paper
by Rosie is introducing you to
#CTEs
I am happy about this one because the example discussed here is a combination of aggregate functions, group by, joins, and subqueries (everything we have discussed lately😉)
On today’s episode of the
#RedPenOnA4Paper
series by Rosie, let us discuss ‘WHERE vs HAVING’….
The
#GroupBy
clause isn't always going to get you what you're looking for, so what happens if you need further help filtering on aggregated data? Or maybe not? Hmm🤔
#Sql
Tip for Today:
When using COUNT, consider whether you want to include NULLs.
• Use COUNT(column_name) to avoid counting NULLs.
•Use COUNT(*) if you want to include NULLs.
The difference is that you’re Counting ‘Column Values Vs Rows’🤔🤔
What do you think?
#DataFam
The
#RedPenOnA4Paper
series by Rosie is back this week and we’re all going to be breaking through windows
#dataFam
How?🤔
By ‘Understanding Window Functions’
If I had to start learning
#WindowFunctions
again, I would appreciate being shown a note like this!!!
On today's episode of the
#RedPenOnA4Paper
series by Rosie, we are breaking through the window again and I'm especially proud of this note.
‘UNDERSTANDING WINDOW FUNCTIONS III’ + ‘COMMON AGGREGATE WINDOW FUNCTIONS’
There's an exercise for you to try💪
#Data
On today’s
#RedPenOnA4Paper
series by Rosie, we are finally breaking in through the window and we’ll definitely keep doing that this week😅
#DataFam
‘Understanding Window Functions II’
I want to believe you read the first note on Window Functions!!!👀👀
#DataAnalytics
LINKEDIN SQL INTERVIEW QUESTION:
Given a table of candidates and their skills, you're tasked with finding the candidates best suited for an open Data Science job.
You want to find candidates who are proficient in Python, Tableau, and PostgreSQL.
#DataFam
#Data
There's an intrinsic joy that comes from knowing that someone was impacted by something you put out.
#RedPenOnA4Paper
note did this and I am happy that so far, documenting my studies has proven useful in people's journey with data.
#DataAnalytics
#Sql
#DataFam
On today’s episode of the
#RedPenOnA4Paper
series by Rosie, I created easy-to-understand study notes on ‘
#CorrelatedSubqueries
’ just as I promised I would.
What is a Correlated Subquery?💻🖍️
What makes it different from the other subqueries?
#DataAnalytics
👇 👇 👇
Real-world scenarios Where Aggregate Functions Can be Utilized for Practical Insights:
🖍️Calculating total sales over a specific period to assess financial performance.
🖍️An e-commerce platform wants to showcase the average rating of products based on customer reviews.
I am so proud of my recent
#RedPenOnA4Paper
note on Window Functions. So proud of myself because it took sitting back to study over and over + trying out different tasks + discipline to get the note out!!
Teaching in the simplest way is truly a gift!
#DataAnalytics
On today's episode of the
#RedPenOnA4Paper
series by Rosie, we are breaking through the window again and I'm especially proud of this note.
‘UNDERSTANDING WINDOW FUNCTIONS III’ + ‘COMMON AGGREGATE WINDOW FUNCTIONS’
There's an exercise for you to try💪
#Data
Just realized that I haven't created notes on Aggregate Functions. I definitely will🤝
CTEs will be coming up too so stay tuned😉
#DataAnalytics
#Data
#Sql
I guess this is going to be the written version of bloopers for
#RedPenOnA4Paper
lol…
I realized that I made a huge mistake in my query here but I'm glad I spotted it out immediately…
Let’s have some fun😄
If I want to maintain the query, what will change in my result?
This meeting with
@tech_queen
organized by
@Digitaleydrive
and anchored by
@Roshethequeen
was one of the best ways I spent my evening yesterday as someone who is intentionally looking to step into the global scene.
Did I learn how to position myself better? Well YES!!
The
#RedPenOnA4Paper
series by Rosie is back this week and we’re all going to be breaking through windows
#dataFam
How?🤔
By ‘Understanding Window Functions’
If I had to start learning
#WindowFunctions
again, I would appreciate being shown a note like this!!!
If you cannot solve this after reading my
#RedPenOnA4Paper
notes on ‘AGGREGATE FUNCTIONS’ and ‘USING GROUP BY WITH AGGREGATE FUNCTIONS’ just know that we will fight😭👀👀
#SQL
Interview Question for
#DataScience
:
A company has provided sales data containing information about customer purchases, as shown in the table below.
Your task is to:
Calculate Total Revenue
Calculate Total Sales by Product
Find Top Customers by Revenue
Learn to solve it
‘USING GROUP BY WITH AGGREGATE FUNCTIONS’
I don't just have Private Detectives
#AggregateFunctions
I have a matchmaker too and her name is the
#GroupBy
clause!!!
#RedPenOnA4Paper
by Rosie series is presenting an episode on grouping!!
This is one of my favorite learning techniques and so far in my
#DataAnalytics
journey, my mode of transmitting (step 5) information is what I have been doing with the
#RedPenOnA4Paper
note!
Share your learning technique with me. I am curious 🤔👀
#DataFam
Several people have told me to create notes on Window Functions and I promise that I'm doing just that👀💃
#DataFam
#DataAnalytics
We are going to have FUN this week😅
Just solved this Advertiser Status[Facebook SQL Interview Question] from DataLemur and it felt like a lot at first glance. But I promise it was fun😂🤣!!
How would you approach solving a problem like this? Immediately I saw two tables, I just screamed ‘JOINS’😂
I think I need to post more practice questions on ‘Grouping’ because I love these conversations🫶
Let us interact, ask questions, and be curious together! ‘Why this’, ‘Why that’, ‘Why not this’, ‘How about this’, ‘Is this better’!
Friendly SQL banter🏃♀️➡️
#Data
Hi guys. I picked up my pen today and I am delighted to share this article with you because it marks the start of my contribution to the world of analytics.
The
#RedPenOnA4Paper
series by Rosie was on a mission this week and I can be sure that mission wasn't a failure if you can tick at least three of these boxes👀!!!
What was your favorite note this week?
As for me, I had so much fun with my private detectives😜
#DataAnalytics
Hey! I don’t mean to brag but there’s something so smoothing and thrilling about the way I write. I spit out fascinating content so effortlessly.
You’re not exactly going to find someone who writes as great as ROSEMARY JOHN.
Check out this link;
Few
#Sql
INTERVIEW QUESTIONS FROM DATACAMP
- What is a subquery?
-What types of SQL subqueries do you know?
-What types of joins do you know?
-What is the difference between nested and correlated subqueries?
If you've studied my notes, these questions are easy😭👀👀
Started sharing my skincare journey on Instagram a while back and I have decided to introduce this side of me to twitter today!!
So here we go! Remember to use your sunscreen. Always use sunscreen. As a dry skin girlie, these sunscreens are my fav😍
A few Questions on
#Sql
Window Functions inspired by the
#RedPenOnA4Paper
notes on Windowing so far….
1) Can you Query without Partitioning? Explain your reasons.
2) What happens when you use an ORDER BY in the OVER clause?
My observation from constantly studying and solving technical challenges in
#DataAnalytics
is that it has helped me build muscle memory.
There are connections between neurons in the brain that become more robust with practice so there's that
Let's keep practicing guys 💪👏
‘Vs’ here represents a relationship shared between these operations and it is interesting when you figure it out🤔
-JOINS Vs SUBQUERY
-WHERE Vs HAVING
-NATURAL JOIN Vs INNER JOIN Vs CROSS JOIN
-DISTINCT Vs GROUP BY
-LEFT JOIN Vs ANTI-JOIN Vs SEMI-JOIN
When all you ever wrote about was centered on a muse that’s not yours anymore
It leaves a void in a writer’s mind
It crashes a writer’s imagination and no matter how much you try, writing becomes such a task..
Even writers go through a healing process...it’s so humbling🌙
Excerpt from studying ‘Window Functions’
Once you understand the concept of grouping and using aggregates in SQL, understanding window functions is easier to grasp.
#Sql
#DataAnalytics
#DataFam
🧵
There’s a lasting joy that thrives when a writer brings a character to life by the rhythm of her ink and pad
You could almost feel your heart beat to the very life that you can create with your imagination...
#poetrycommunity
#WritingCommunity
It doesn’t always have to end with “HAPPILY EVER AFTER” because what if that’s not the end? Perhaps it is safe to say that even with the worst ending when all seems burnt to painful ash in our story, there lies another chapter. A beautiful chapter waiting to be read 🌙
#poetry
This litany of affirmations that I rub daily on my skin and pour in my heart will be for my sons to love the breathing in and out of kindness on a woman's body.
_RosemaryEkong
#poetry
Breaking news🔥🔥🔥: Meet Lateefa Abidoye, Zainab's mother, employed at Osun State University. They both enjoyed spending the Sugar daddy's money together. 😫
She’s 22 Twitter FBI Ilorin Mariam Cho Cho Cho Enugu Hijab Royz lexus My Queen
Can't wait to put out technical articles where I break down some of these concepts.
The comments from my last article on ‘A Brief and Fun Introduction to Data Analytics’ warmed my heart and there is so much more from where that came from🫶💁
My
#DataAnalytics
personal study goal for the week is this SQL checklist that I put together.
Since Monday, I have been on my learning board to study and revise
#Sql
as well as challenge myself intensely.
Can you boast of anything here?
#Sql
Interview Question: Consider 2 tables, TABLE-A and TABLE-B, what will be the ROW COUNT for the result table:
If you do an INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN.
TABLE-A
1
1
1
1
TABLE-B
1
1
1
🤔
Because this world is scary and humans are so unpredictable. I don’t want to feel alone here. God shields me and prayer is always a time of vulnerability, joy, tears, happiness, courage, hope, love, strength, and total surrender. It’s my healing piece.
And if I shall continue to live,
I’d beg the God of the entire universe to give parts of my body and sync my existence with the sun, moon and stars so that every time it finds its way to your flesh and bones, you are never without nature’s feeling of my love❣️
I’d rather not say that a concept is ‘Hard’ or ‘Difficult’ for me to grasp. I just say it is ‘Interesting’ while somehow fighting for my life💁😂
But hard? No, please…
If you listen to neurologists, you'll understand why this is important.